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
Next Tests: