DBMS-Relational Query Languages Questions and Answers
Relational Query Languages questions with answers test a candidate’s command over SQL and relational algebra, essential in database management system (DBMS) exams. From SELECT queries to JOIN operations and set-based functions, these concepts are heavily emphasized in placement tests by TCS, Wipro, and Infosys. This section offers detailed programming questions and answers with SQL query explanations, ensuring that learners understand both syntax and logic. Practicing these DBMS query-based MCQs strengthens problem-solving and prepares you for database-related technical interviews and coding challenges.
DBMS-Relational Query Languages
Showing 10 of
45 questions
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