Objective Questions On SQL And Embedded SQL Set-4

This set of solved objective questions on SQL and Embedded SQL includes MCQ questions about different DDL, DML, and DCL commands. It also includes objective questions on the different keywords used on SQL and embedded SQL commands such as Drop, Unique, Count, Exists, Like, After, Between, Mode, Join, etc.

1) DROP is a ……………. statement in SQL.
A. Query
B. Embedded SQL
C. DDL
D. DCL

2) The keyword to eliminate duplicate rows from the query result in SQL is.
A. DISTINCT
B. NO DUPLICATE
C. UNIQUE
D. None of the above

3) Which of the following aggregate function does not ignore nulls in its results?
A. COUNT
B. COUNT(*)
C. MAX
D. MIN

4) In SQL, testing whether a subquery is empty is done using
A. DISTINCT
B. UNIQUE
C. NULL
D. EXISTS

5) ……………. operator is used to compare a value to a list of literals values that have been specified.
A. Like
B. Compare
C. Between
D. In

6) The language used in application programs to request data from the DBMS is referred to as the
A. DML
B. DDL
C. VDL
D. SDL

7) The DBMS language component which can be embedded in a program is
A. The data definition language(DDL)
B. The data manipulation language(DML)
C. The database administrator(DBA)
D. A query language

8) A DBMS query language is designed to
A. Support end users who use English-like commands.
B. Support in the development of complex applications software.
C. Specify the structure of a database.
D. All of the above

9) It is possible to define a schema completely using.
A. VDL and DDL
B. DDL and DML
C. SDL and DDL
D. VDL and DML

10) Which of the following is correct.
A. a SQL query automatically eliminates duplicates.
B. SQL permits attribute names to be repeated in the same relation.
C. a SQL query will not work if there are no indexes on the relations.
D. None of these.

11) Which of the following is a comparison operator in SQL?
A. =
B. LIKE
C. BETWEEN
D. All of the above

12) To delete a particular column in a relation the command used is.
A. UPDATE
B. DROP
C. ALTER
D. DELETE

13) The ………… operator is used to compare the value to a list of literals values that that have been specified.
A. BETWEEN
B. ANY
C) IN
D) ALL

14) ………… function divides one numeric expression by another and returns the remainder.
A. POWER
B. MOD
C. ROUND
D. REMAINDER

15) A data manipulation command the combines the record from one or more tables is called.
A) SELECT
B. PROJECT
C. JOIN
D. PRODUCT

16) DDL stands for
A. Data definition language
B. Data description language
C. Data design languages
D. Database dictionary languages.

17) The DDL is used to specify the ……..
A. Conceptual schema
B. Internal schema
C. Both
D. None

18) Which is used for data retrieval from the database?
A. DDL
B. DML
C. SDL
D. VDL

19) Which is used to specify the user views and their mappings to the conceptual schema?
A. DDL
B. DML
C. SDL
D. VDL

20) Which command are included in a general purpose programming languages?
A. DDL
B. DML
C. DSL
D. VDL

Answers:

1) C. DDL
2) C. UNIQUE
3) B. COUNT(*)
4) D. EXISTS
5) A. Like
6) A. DML
7) B. The data manipulation language(DML)
8) D. All of the above
9) B. DDL and DML
10) D. None of these.
11) D. All of the above
12) C. ALTER
13) A. BETWEEN
14) B. MOD
15) C. JOIN
16) A. Data definition language
17) A.Conceptual schema
18) B.DML
19) D.VDL
20) B.DML