11. Which of the following is not a query operator?
a. Union
b. Union All
c. Intersect
d. Minus
e. Minus All
Answer: e. Minus All
12. Which of the following is not a type of constraint?
- Primary key
- Unique
- Check
- Distinct
- Default
Answer: d. Distinct
13. What are the programs that execute automatically whenever DML operations are performed on tables called?
- Triggers
- Procedures
- Functions
- None of the above
Answer: a. Triggers
14. Which of the following can be used to uniquely identify a row?
- Primary key
- Unique key
- Foreign key
- All of the above
Answer: a. Primary key
15. Which of the following constraints cannot be applied at the table level?
- Primary key
- Foreign key
- Not null
- Check
- Unique
Answer: c. Not null
Column level constraints contain all types of constraints (like, not null, primary key, foreign key, unique). But table level except not null constraint its supports all constraints.
16. Which of the following is not a SQL operator?
- Between… and …
- Like
- In
- Is null
- Having
- Not in
Answer: e. Having
17. The level of data abstraction which describes how the data is actually stored is?
- Physical level
- Conceptual level
- Storage level
- File level
Answer: a. Physical level
18. The concept of data independence is similar to the concept of ________
- Data type
- Abstract data type
- Consolidation
- Isolation
Answer: b. Abstract data type
19. There are two tables A and B. You are retrieving data from both tables where all rows from B table and only matching rows from A table should be displayed. Which type of join you will apply between A and B tables?
- Inner join
- Left outer join
- Right outer join
- Self join
Answer: c. Right outer join
20. Which of the following statements are true?
- With DDL you can create and remove tables, schemas, domains, indexes and views
- Select, Insert and Update are DCL commands
- Grant and Revoke are DML commands
- Commit and Rollback are DCL commands
Answer: a