Database Management System Objective Questions - Set 03 - ObjectiveBooks
Database Management System Objective Questions - Set 03

Database Management System Objective Questions - Set 03

Edit

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?
    (A) ALTER TABLE
    (B) MODIFY TABLE
    (C) CHANGE TABLE
    (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:

    Blogger Comment
    Facebook Comment