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
22. Which of the following statements is used to create a table?
- CREATE TABLE
- MAKE TABLE
- COSNSTRUCT TABLE
- None of these
23. Which of the following is the result of a SELECT statement ?
- TRIGGER
- INDEX
- TABLE
- None of these
24. The SQL data definition language (DDL) provides command for:
- defining relation schemas
- deleting relations
- modifying relation schemas
- all of these.
25. Which of the following is a clause in SELECT statement ?
- GROUP BY and HAVING
- WHERE
- ORDERBY
- All of these
27. Which of the following statement is used to modify a table?
- MIDIFY TABLE
- UPDATE TABLE
- ALTER TABLE
- All of these.
28. DROP operation of SQL is used for:
- deleting tables from schemes
- changing the definition of table
- Both of these
- None of these.
29. ALTER operation of SQL is used for:
- deleting tables from schema
- changing the definition of table
- Both of these
- None of these
30. Which of the following clause specifies the table or tables from where the data has to be retrieved?
- WHERE
- TABLE
- FROM
- None of these.