Top 1000+ Solved DataBase Management System (DBMS) MCQ Questions Answer
Q. _______ allow us to identify uniquely a tuple in the relation.
a. superkey
b. domain
c. attribute
d. schema
Q. Which of the following is not Modification of the Database
a. deletion
b. insertion
c. sorting
d. updating
Q. Which of the following is Relation-algebra Operation
a. select
b. union
c. rename
d. all of the above
Q. Which of the following in not Outer join?
a. left outer join
b. right outer join
c. full outer join
d. all of the above
Q. Who proposed the relational model?
a. bill gates
b. e.f. codd
c. herman hollerith
d. charles babbage
Q. Logical design of database is called
a. database instance
b. database snapshot
c. database schema
d. all of the above
Q. Snapshot of the dta in the database at a given instant of time is called
a. database schema
b. database instance
c. database snapshot
d. all of the above
Q. Which of the following is not binary operation?
a. union
b. project
c. set difference
d. cartesian product
Q. Which of the following is correct regarding Aggregate functions?
a. it takes a list of values and return a single values as result
b. it takes a list of values and return a list of values as result
c. it takes a single value and returns a list of values as result
d. it takes a single value and returns a single value as result
Q. A command to remove a relation from an SQL database
a. delete table
b. drop table
c. erase table
d. alter table
Q. The attribute that can be divided into other attributes is called
a. simple attribute
b. composite attribute
c. multi-valued attribute
d. derived attribute