PSC MSQ SQL Database Question Asnswer Set
1) DROP is a ................ statement in SQL.
A. Query
B. Embedded SQL
C. DDL
D. DCL
👉Ans:
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
👉Ans:
3) Which of the following aggregate function does not ignore nulls in its results?
A. COUNT
B. COUNT(*)
C. MAX
D. MIN
👉Ans:
4) In SQL, testing whether a subquery is empty is done using
A. DISTINCT
B. UNIQUE
C. NULL
D. EXISTS
👉Ans:
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
👉Ans:
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
👉Ans:
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
👉Ans:
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
👉Ans:
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
👉Ans:
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.
👉Ans:
11) Which of the following is a comparison operator in SQL?
A. =
B. LIKE
C. BETWEEN
D. All of the above
👉Ans:
12) To delete a particular column in a relation the command used is.
A. UPDATE
B. DROP
C. ALTER
D. DELETE
👉Ans:
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
👉Ans:
14) ............ function divides one numeric expression by another and returns the remainder.
A. POWER
B. MOD
C. ROUND
D. REMAINDER
👉Ans:
15) A data manipulation command the combines the record from one or more tables is called.
A) SELECT
B. PROJECT
C. JOIN
D. PRODUCT
👉Ans:
16) DDL stands for
A. Data definition language
B. Data description language
C. Data design languages
D. Database dictionary languages.
👉Ans:
17) The DDL is used to specify the ........
A. Conceptual schema
B. Internal schema
C. Both
D. None
👉Ans:
18) Which is used for data retrieval from the database?
A. DDL
B. DML
C. SDL
D. VDL
👉Ans:
19) Which is used to specify the user views and their mappings to the conceptual schema?
A. DDL
B. DML
C. SDL
D. VDL
👉Ans:
20) Which command are included in a general purpose programming languages?
A. DDL
B. DML
C. DSL
D. VDL
👉Ans:
