DBMS-Relational Query Languages
DBMS-Relational Query Languages
31. SELECT opeation of SQL is a;
- data query language
- data definition language
- data manipulation language
- data control language.
33. GRANT command of SQL is a:
- data query language
- data definition language
- data manipulation language
- data control language.
34. Which of the following is a comparison operator used in SELECT statement?
- LIKE
- BETWEEN
- IN
- None of these
35. How many tables can be joined to create a view/
- 1
- 2
- Database dependent
- None of these
36. Which of the following clause is usually used together with aggregate functions ?
- ORDER BY ASC
- GROUP BY
- ORDER BY DISC
- None of these
37. REVOKE command of SQL is a:
- data query language
- data definition language
- data manipulation language
- data control language
38. CREATE operation of SQL is a:
- data query language
- data definition language
- data manipulation language
- data control language
39. COMMIT statement of SQL TCS.
- ends the transaction successfully
- aborts the transaction
- Both of these
- None of these
40. ROLLBACK statement of SQL TCS
- ends the transaction successfully
- aborts the transaction
- Both of these
- None of these