Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer

a. The logical design of the database system

b. The entire set of attributes of the Database put together in a single relation

c. The state of the database system at any given point of time

d. The initial values inserted into the Database immediately after its creation

a. A foreign key is a primary key of a relation which is an attribute in another relation

b. A foreign key is a superkey of a relation which is an attribute in more than one other relations

c. A foreign key is an attribute of a relation that is a primary key of another relation

d. A foreign key is the primary key of a relation that does not occur anywhere else in the schema

a. Output specified attributes from all rows of the input relation. Remove duplicate tuples from the output

b. Output pairs of rows from the two input relations that have the same value on all attributes that have the same name

c. Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)

d. Returns the rows of the input relation that satisfy the predicate

a. Row

b. Column

c. Value

d. Tuple

a. By writing it in bold letters

b. By underlining it using a dashed line

c. By writing it in capital letters

d. By underlining it using a bold line

a. True

b. False

c. none

d. all

a. Both the statements are true

b. Statement 1 is correct but Statement 2 is false

c. Statement 1 is false but Statement 2 is correct

d. Both the statements are false

a. The schema for each relation

b. The integrity constraints

c. The operations on the tuples

d. The security and authorization information for each relation

a. char(n)

b. String(n)

c. varchar(n)

d. float(n)

a. create table( , …)

b. create relation( , …)

c. new table( , …)

d. new relation( , …)

a. primary key(a1, a2, a3)

b. primary key(a1)

c. foreign key(a1, a2) references S

d. foreign key(a1, a2)

a. enter into D (a, b, C:);

b. insert into D values (a, b, C:);

c. insert into D (a, b, C:);

d. insert (a, b, C:) values into D;

a. drop table R

b. drop relation R

c. delete table R

d. delete from R

a. delete table R

b. drop table R

c. delete from R

d. drop from R

a. alter table R delete A

b. alter table R drop A

c. alter table drop A from R

d. delete A from R