You Scored:
Ranking:
SQL MCQs Questions And Answers Test With Answers
1. Disadvantages of File systems to store data is?
Data redundancy and inconsistency
Difficulty in accessing data
Data isolation
All of the above (Answer)
2. The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match?
Join
Intersection
Cartesian product (Answer)
Set difference
3. A domain is atomic if elements of the domain are considered to be ------------ units?
Constant
Different
Indivisbile (Answer)
Divisible
4. Which of the following in not a function of DBA?
Schema Definition
Network Maintenance (Answer)
Routine Maintenance
Authorization for data access
5. A relational database consists of a collection of?
Tables (Answer)
Fields
Keys
Records
6. Which of the following is not an Schema?
Critical Schema (Answer)
Physical Schema
Logical Schema
Database Schema
7. Data Manipulation Language enables users to?
All of the above (Answer)
Insertion of new information into the database
Retrieval of information stored in database
Deletion of information from the database
8. Which of the following is not a Storage Manager Component?
Buffer Manager
Logical Manager (Answer)
File Manager
Transaction Manager
9. Which of the following is not a level of data abstraction?
Physical Level
View Level
Critical Level (Answer)
Logical Level
10. Department (dept name, building, budget) and Employee (employee-id , name, dept name,salary)
Here the dept-name attribute appears in both the relations .Here using common attributes in relation schema is one way of relating ----------- relations?
Tuple of common
Attributes of distinct
Tuple of distinct (Answer)
Attributes of common
.jpg)