DBMS MCQ Questions With Answers Set 12

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?

A). HAVING
B). FROM
C). JOIN
D). SELECT

2. In SQL, which SQL keyword is used to specify the condition for a join operation?

A). FROM
B). SELECT
C). HAVING
D). WHERE

3. Regarding the interchangeability of subqueries and joins _____?

A). A join can sometimes be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.
B). A join can always be used as an alternative to a subquery, and a subquery can sometimes be used as an alternative to a join.
C). Join can always be used as an alternative to a subquery, and a subquery can always be used as an alternative to a join.
D). A join can sometimes be used as an alternative to a subquery, and subquery can always be used as an alternative to a join.

4. Which SQL keyword is used to add one or more rows to a table?

A). MODIFY
B). ALTER
C). INSERT
D). SELECT

5. Which SQL keyword is used to change one or more rows in a table?

A). SELECT
B). UPDATE
C). INSERT
D). MODIFY

6. Which SQL keyword is used to change a column value?

A). CHANGE
B). UPDATE
C). INSERT
D). SET

7. Which keyword is used to remove one or more rows from a table?

A). CHANGE
B).SELECT
C). DELETE
D). Erase

8. WHERE clauses cannot refer to ranges and to partial values when _____?

A). The keyword ALSO is used
B). The keyword IS NULL is used
C). The keyword LIKE is used
D). Keyword BETWEEN is used

9. Which of the following are the five built-in functions provided by SQL?

A). SUM, AVG, MULT, DIV, MIN
B). SUM, AVG, MIN, MAX, MULT
C). SUM, AVG, MIN, MAX, NAME
D). COUNT, SUM, AVG, MAX, MIN

10. The SQL keyword GROUP BY instructs the DBMS?

A). To physically group together rows meeting the specified criteria
B). To group together those rows that have the same value of a column
C). Both A and B
D). Neither A nor B

11. To remove a relation from an SQL database, _____ is used.

A). Purge
B). Delete
C). Drop table
D). Remove

12. A subquery must be _____?

A). In Parentheses
B). In bold
C). In italics
D). In capital letters

13. Which is true about a 'join'?

A). A join is the combination of the WHERE and SELECT clauses.
B). A join is the combination of a product operation, followed by a selection, followed usually by a projection.
C). A join can only be used for two tables.
D). A join is the product of the SELECT FROM WHERE clauses.

14. An outer join _____?

A). Is supported by many DBMS products
B). Is not supported by ANSI standard SQL
C). Both A and B
D). Neither A nor B

15. Which is true of a "join"?

A). A join can be used as an alternative way of expressing many subqueries.
B). A join expression can be substituted for EXISTS and NOT EXISTS.
C). Subqueries can be substituted for all joins.
D). A join expression can be substituted for all subquery expressions.

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;

A). Salary * 10
B). Instructor
C). ID
D). WHERE

17. EXISTS and NOT EXISTS?

A). Only work with one or two tables.
B). Can return values other than true or false if rows meet the qualifying conditions.
C). Are logical operators whose value is either true or false depending on the presence or absence Of rows that fit the qualifying conditions.
D). None of the above

18. When using INSERT _____?

A). Rows can be inserted into a table one at a time or in groups.
B). Rows cannot be copied in mass from one table to another.
C). Rows cannot be copied in mass from one table to another.
D). Rows can be modified according to criteria.

19. When using DELETE _____?

A). It will not cause integrity problems.
B). Order of operations is not important.
C). Rows can be deleted one at a time or in groups.
D). Rows can be deleted only one at a time.

20. This is Employee table.

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;

A). 1005, 1011, 1019
B). 1011, 1019
C). 1011
D). 1019

21. Which is not true about modifying data?

A). Rows can be modified one at a time or in groups.
B). The keyword SET is used to change a column value.
C). After SET, the name of the column to be changed and then the new value or way of computing the new value is specified.
D). Mass updates are fast, easy, and cause few problems.

22. Which of the following is not an SQL statement used on a single table?

A). SELECT with WHERE
B). SELECT with GROUP BY
C). SELECTION
D). SELECT with GROUP BY and HAVING

23. Which of the following is not an operation used on two or more tables?

A). SELECT with GROUP BY & HAVING
B). Subqueries
C). Joins
D). EXISTS

24. SQL commands can be classified into three types. Which is NOT an SQL command type?

A). DDL
B). DML
C). DCL
D). DGL

25. In the given query which of the keyword has to be inserted?

INSERT INTO employee _____ (1501,Ahmad,21000);

A). Field
B). Table
C). Values
D). Relation

26. Three SQL DDL CREATE commands are _____?

A). Schema, Base, and Table
B). Key, Base, and Table
C). Schema, Table, and View
D). Base, Table, and Schema

27. Which keyword is NOT included in most data retrieval statements?

A). Where
B). Select
C). From
D). As

28. By default, the ORDER BY clause lists items in _____ order.

A). Descending
B). Ascending
C). Same
D). Any

29. Which is not an advantage of using a View?

A). Provide data security
B). Simplify query commands
C). Enhance programming productivity
D). Decrease system overhead

30. The union operation automatically _____ unlike the SELECT clause.

A). Eliminates duplicate
B). Eliminates unique tuples
C). Adds common tuples
D). Adds tuples

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