Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. Which of the following can be used as a primary key entry of the instructor relation.
a. dept_name
b. name
c. id
d. all of the mentioned
Q. In the section relation which of the following is used as a foreign key?
a. course_id
b. course_id,sec_id
c. room_number
d. course_id,sec_id,room_number
Q. To replace the relation section with some other relation the initial step to be carried out is
a. delete section;
b. drop section;
c. delete from section;
d. replace section new_table ;
Q. Select distinct Dept_name from instructor ; How many row(s) are displayed ?
a. 4
b. 3
c. 5
d. error
Q. Which function is used to identify the title with Least scope?
a. min(credits)
b. max(credits)
c. min(title)
d. min(salary)
Q. A domain is if elements of the domain are considered to be indivisible units.
a. atomic
b. subatomic
c. substructure
d. subset
Q. If every non-key attribute is functionally dependent primary key, then the relation will be in
a. first normal form
b. second normal form
c. third form
d. fourth normal form
Q. The term for information that describes what type of data is available in a database is:
a. data dictionary
b. data repository
c. index data
d. metadata
Q. A data type that creates unique numbers for key columns in Microsoft Access is:
a. autonumber
b. boolean
c. sequential key
d. sequential number
Q. A dependency exist between two columns when
a. together they constitute a composite key for the table
b. knowing the value in one column determines the value stored in another column
c. the table is in 3nf
d. together they constitute a foreign key
Q. In the normal form, a composite attribute is converted to individual attributes.
a. first
b. second
c. third
d. fourth
Q. Functional Dependencies are the types of constraints that are based on
a. key
b. key revisited
c. superset key
d. none of the mentioned