(A) Create DB
(B) Create table
(C) Delete
(D) Drop
Author:
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
SQL is used for:
(A) Creating, managing and deleting tables and manage the relationships among the stored date
(B) Generating queries, organizing, managing and retrieving data stored in a database
(C) Maintaining data integrity and coordinate data sharing
(D) All of the above
A kind of expressions where the operator is present between two operands called __ expressions.
(A) Infix
(B) Postfix
(C) Prefix
(D) None of the above