DBMS MCQ questions with answers set 12. This dbms mcq online test set 12 has 30 mcq on sql queries. This sql multiple choice questions with answers set help you to prepare for your IT, computer science related jobs competitive exams. SQL mcq online test 12 also helpful to learn the basics of sql quries, its structure, clauses, keywords, and rules to write sql query.
DBMS MCQ Questions With Answers Set 12
1. In an SQL query, which SQL keyword is used to specify the names of tables to be joined?
2. In SQL, which SQL keyword is used to specify the condition for a join operation?
3. Regarding the interchangeability of subqueries and joins _____?
4. Which SQL keyword is used to add one or more rows to a table?
5. Which SQL keyword is used to change one or more rows in a table?
6. Which SQL keyword is used to change a column value?
7. Which keyword is used to remove one or more rows from a table?
8. WHERE clauses cannot refer to ranges and to partial values when _____?
9. Which of the following are the five built-in functions provided by SQL?
10. The SQL keyword GROUP BY instructs the DBMS?
11. To remove a relation from an SQL database, _____ is used.
12. A subquery must be _____?
13. Which is true about a 'join'?
14. An outer join _____?
15. Which is true of a "join"?
16. The following query have not any error. Which should be replaced to get the desired output?
SELECT ID, name, dept name, salary*10
WHERE instructor;
17. EXISTS and NOT EXISTS?
18. When using INSERT _____?
19. When using DELETE _____?
20. This is Employee table.
Which of the following employee_id will be displayed for the given query?
Employee_id | Name | Salary |
---|---|---|
1005 | Asad | 32000 |
1011 | Asim | 24000 |
1019 | Waqas | 28000 |
Which of the following employee_id will be displayed for the given query?
SELECT * FROM employee WHERE employee_id>1007;
21. Which is not true about modifying data?
22. Which of the following is not an SQL statement used on a single table?
23. Which of the following is not an operation used on two or more tables?
24. SQL commands can be classified into three types. Which is NOT an SQL command type?
25. In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1501,Ahmad,21000);
26. Three SQL DDL CREATE commands are _____?
27. Which keyword is NOT included in most data retrieval statements?
28. By default, the ORDER BY clause lists items in _____ order.
29. Which is not an advantage of using a View?
30. The union operation automatically _____ unlike the SELECT clause.
Read also>->>Database MCQs With Answers Set 1
Read also>->>Database MCQs With Answers Set 5
Read also>->>Database MCQs With Answers Set 2
Read also>->>Database MCQs With Answers Set 11