Questions and answers for exam Preparation

MCQs

Total Questions : 18 | Page 1 of 2 pages

Question 1. Which one of the following is used to define the structure of the relation ,deleting relations and relating schemas ?

DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema

Discuss Question

Answer: Option B. -> DDL(Data Definition Langauge)

DDL(Data Definition Langauge)Data Definition language is the language which performs all the operation in defining structure of relation.

Question 2. Select * from employee
What type of statement is this?

DML
DDL
View
Integrity constraint

Discuss Question

Answer: Option A. -> DML

DMLSelect operation just shows the required fields of the relation. So it forms a DML

Question 3. Create table employee (name varchar ,id integer) What type of statement is this ?

DML
DDL
View
Integrity constraint

Discuss Question

Answer: Option B. -> DDL

DDLData Definition language is the language which performs all the operation in defining structure of relation.

Question 4. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database ?

DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema

Discuss Question

Answer: Option A. -> DML(Data Manipulation Langauge)

DML(Data Manipulation Langauge)DML performs change in the values of the relation .

Question 5. The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

Fixed, equal
Equal, variable
Fixed, variable
Variable, equal

Discuss Question

Answer: Option C. -> Fixed, variable

Fixed, variableVarchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces .

Question 6. An attribute A of datatype varchar(20) has the value "Avi . The attribute B of datatype char(20) has value Reed .Here attribute A has ____ spaces and attribute B has ____ spaces .