(A) Physical data independence
(B) Concurrency control
(C) Logical data independence
(D) Functional dependency
Tag: DBMS Mcqs
Which of the following function falls in the category of Aggregate functions?
(A) SUM
(B) MIN
(C) MAX
(D) All of the above
Which of the following is NOT a DDL command?
(A) Create DB
(B) Create table
(C) Delete
(D) Drop
Data Manipulation Language (DML) is the set of commands used to maintain and query a database including updating, inserting, modifying and retrieving data.
(A) True
(B) False
Which of the following SQL statements used to control access to the data and to the database?
(A) GRANT
(B) REVOKE
(C) SELECT
(D) Both GRANT and REVOKE
Truncate is an alternative of Delete command.
(A) True
(B) False
Which of the following is a String function in SQL?
(A) COUNT
(B) LEN
(C) SQRT
(D) SIN
Which language is used to permit or prohibit access to a table?
(A) DDL
(B) DCL
(C) DML
(D) All of the above