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 q...
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. DDL2) 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
Related Posts:
Solved MCQ of Database Management System (DBMS) Set - 1
Solved MCQ of Database Management System (DBMS) Set - 2
Solved MCQ of Database Management System (DBMS) Set - 3
Solved MCQ of Database Management System (DBMS) Set - 4
Solved MCQ of Database Management System (DBMS) Set - 5
MCQ on Basic SQL Queries with Answers set-1
Solved MCQ of SQL With Answer Set -2
SQL MCQ Interview Questions With Answers set-3
SQL Interview Multiple Choice Questions and Answers set-4