Database Management System Set 2
Computer Science Engineering (CSE),
Bachelor of Science in Computer Science FY (BSc CS),
Bachelor of Science in Computer Science SY (BSc CS),
Bachelor of Science in Information Technology SY (BSc IT),
Bachelor of Computer Applications (BCA),
Bachelor of Business Administration in Computer Applications (BBA [CA]),
Bachelor of Science in Information Technology (BSc IT),
On This Page
This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 2
Q1 | Which of the following is not Modification of the Database
- updating
- sorting
- deletion
- insertion
Q2 | Which of the following in not Outer join?
- left outer join
- full outer join
- all of the options
- right outer join
Q3 | Set of premitted values of each attribute is called
- tuple
- schema
- domain
- relation
Q4 | Which of the following is true regarding Null Value?
- null<0
- null=0
- null<>0
- null>0
Q5 | Logical design of database is called
- all of the options
- database schema
- database instance
- database snapshot
Q6 | Snapshot of the data in the database at a given instant of time is called
- database instance
- all of the options
- database schema
- database snapshot
Q7 | Which of the following is not Unary operation?
- rename
- union
- select
- project
Q8 | Which of the following is not binary operation?
- union
- set difference
- cartesian product
- project
Q9 | Which of the following is correct regarding Aggregate functions?
- it takes a single value and returns a single value as result
- it takes a list of values and return a single values as result
- it takes a list of values and return a list of values as result
- it takes a single value and returns a list of values as result
Q10 | The Primary key must be
- non null
- unique
- option a or b
- option a and b
Q11 | A command to remove a relation from an SQL database
- delete table
- erase table
- alter table
- drop table
Q12 | which of the following is not an Aggregate function?
- select
- avg
- min
- max
Q13 | The attribute that can be divided into other attributes is called
- composite attribute
- derived attribute
- simple attribute
- multi-valued attribute
Q14 | What is ACID properties of Transactions?
- atomicity, consistency, isolation, database
- automatically, concurrency, isolation, durability
- atomicity, consistency, isolation, durability
- atomicity, consistency, inconsistent, durability
Q15 | If every non-key attribute is functionally dependent on the primary key, the relation will be in
- fourth formal form
- third normal form
- first normal form
- second normal form
Q16 | Database locking concept is used to solve the problem of
- inconsistent data
- all of the options
- lost update
- uncommitted dependency
Q17 | UML is stands for
- universal modeling language
- united modeling language
- uni modeling language
- unified modeling language
Q18 | Data Manipulation Language (DML) is not to
- insertion of new information into the database
- modification of information in the database
- create information table in the database
- deletion of information in the database
Q19 | Which of the following in true regarding Referential Integrity?
- every primary-key value must match a primary-key value in an associated table
- every primary-key value must match a foreign-key value in an associated table
- every foreign-key value must match a foreign-key value in an associated table
- every foreign-key value must match a primary-key value in an associated table
Q20 | Which of the following option is use to retrieval of data?
- stack
- data structure
- linked list
- query
Q21 | ODBC stands for ______
- none of above
- open database connection
- offline database connection
- oriented database connection
Q22 | Which of the following is an unary operation?
- selection operation
- primitive operation
- projection operation
- generalized selection
Q23 | Which SQL Query is use to remove a table and all its data from the database?
- none of these
- drop table
- create table
- alter table
Q24 | In precedence of set operators the expression is evaluated from:
- left to right
- right to left
- left to left
- right to right
Q25 | In DBMS, FD stands for _______
- facilitate data
- functional data
- facilitate dependency
- functional dependency