(A) Physical data independence
(B) Concurrency control
(C) Logical data independence
(D) Functional dependency
Category: Database Mcqs
Database Mcqs for Screening tests, Interviews, Viva and Other competitive exams. Database Mcqs section will help users to prepare mcqs of Database for various exams. Aspirants of Lecturer Computer Science, SST Computer Science, Subject Specialist Computer Science, Data Entry operator, Computer Programmer, Computer Operator, System administrator, Database Administrator and all other Exams can prepare their Database portion from here.
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