Structured Query Language-First

Which of the following attribute can be considered as a choice for primary key?

• Name

• Street

• Rollno

• Subject

Which of the following attribute cannot be considered as a choice for primary key?

• id

• licenceno

• deptid

• street

An attribute in a relation is a foreign key if it is the ............... key in any other relation.

• candidate

• primary

• super

• sub

Consider the following statement. What type of statement is this?

create table employee(id int, name varchar(30));

• DML

• DDL

• DCL

• TCL

The data types char(n) and varchar(n) are used to create ............., and ............. types of string/text fields in a database.

• fixed, equal

• equal, variable

• fixed, variable

• variable, equal

In the given query which keyword has to be inserted?

insert into employee ............(1002,'Kausar',20000);

• table

• values

• relation

• field

Consider following SQL statement. What type of statement is this?

insert into instructor values(10211,'Shreya','Biology',66000);

• DDL

• DCL

• DML

• TCL

A table Table1 has two text fields defined as below:

.

.

name1 varchar(20),

name2 char(20),

.

.

If name1 stores value as 'Ana' and name2 stores value as 'Anuj', then name1 will consume ........... characters' space and name2 will consume ....... characters' space.

• 3, 20

• 20, 4

• 20,20

• 3, 4

Full form of DDL is ....................

Full form of DML is ....................