Database Management System Objective Questions - Set 03 - ObjectiveBooks

Database Management System Objective Questions - Set 03

Practice Test: Question Set - 03

1. Which of the following is not characteristic of a relational database model?
    (A) Tables
    (B) Treelike structure
    (C) Complex logical relationships
    (D) Records

2. A Database Management System (DBMS) is
    (A) Collection of interrelated data
    (B) Collection of programs to access data
    (C) Collection of data describing one particular enterprise
    (D) All of the above

3. Data Manipulation Language enables users to
    (A) Retrieval of information stored in database
    (B) Insertion of new information into the database
    (C) Deletion of information from the database
    (D) All of the above

4. Which of the following represents a relationship among a set of values?
    (A) A Row
    (B) A Table
    (C) A Field
    (D) A Column

5. Minimal Superkeys are called
    (A) Schema keys
    (B) Candidate keys
    (C) Domain keys
    (D) Attribute keys

6. Logical design of database is called
    (A) Database Instance
    (B) Database Snapshot
    (C) Database Schema
    (D) All of the above

7. Which of the following is correct regarding Aggregate functions?
    (A) It takes a list of values and returns a single values as result
    (B) It takes a list of values and returns 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

8. What are ACID properties of Transactions?
    (A) Atomicity, Consistency, Isolation, Database
    (B) Atomicity, Consistency, Isolation, Durability
    (C) Atomicity, Consistency, Inconsistent, Durability
    (D) Automatically, Concurrency, Isolation, Durability

9. Which of the following option is use to retrieval of data?
    (A) Stack
    (B) Data Structure
    (C) Linked list
    (D) Query

10. Which SQL Query is use to remove a table and all its data from the database?
    (A) Create Table
    (B) Alter Table
    (C) Drop Table
    (D) None of these

11. A relation that has no partial dependencies is in which normal form
    (A) First
    (B) Second
    (C) Third
    (D) BCNF

12. A lock that allows concurrent transactions to access different rows of the same table is known as a
    (A) Field-level lock
    (B) Row-level lock
    (C) Table-level lock
    (D) Database-level lock

13. In SQL, which command(s) is(are) used to change a table's storage characteristics?
    (D) All of the above

14. The way a particular application views the data from the data base that the application uses is a:
    (A) Module
    (B) Relational model
    (C) Schema
    (D) Subschema

15. Database management systems are intended to:
    (A) Eliminate data redundancy
    (B) Establish relationships among records in different files
    (C) Manage file access
    (D) All of the above

Show and hide multiple DIV using JavaScript View All Answers

 Next Tests: