DBMS-Relational Query Languages Questions and Answers

Practice Mode
Showing 10 of 45 questions
Q21
The first commercial RDBMS is:
  • A INGRESS
  • B DB2
  • C ORACLE
  • D None of these
Answer: Option A
Q22
Which of the following statements is used to create a table?
  • A CREATE TABLE
  • B MAKE TABLE
  • C COSNSTRUCT TABLE
  • D None of these
Answer: Option A
Q23
Which of the following is the result of a SELECT statement ?
  • A TRIGGER
  • B INDEX
  • C TABLE
  • D None of these
Answer: Option C
Q24
The SQL data definition language (DDL) provides command for:
  • A defining relation schemas
  • B deleting relations
  • C modifying relation schemas
  • D all of these.
Answer: Option D
Q25
Which of the following is a clause in SELECT statement ?
  • A GROUP BY and HAVING
  • B WHERE
  • C ORDERBY
  • D All of these
Answer: Option D
Q26
The first IBM'S RDBMS IS:
  • A DB2
  • B SQL/DS
  • C IMS
  • D None of these
Answer: Option D
Q27
Which of the following statement is used to modify a table?
  • A MIDIFY TABLE
  • B UPDATE TABLE
  • C ALTER TABLE
  • D All of these.
Answer: Option D
Q28
DROP operation of SQL is used for:
  • A deleting tables from schemes
  • B changing the definition of table
  • C Both of these
  • D None of these.
Answer: Option A
Q29
ALTER operation of SQL is used for:
  • A deleting tables from schema
  • B changing the definition of table
  • C Both of these
  • D None of these
Answer: Option B
Q30
Which of the following clause specifies the table or tables from where the data has to be retrieved?
  • A WHERE
  • B TABLE
  • C FROM
  • D None of these.
Answer: Option C

📚 More from Database

← All Topics 🎯 Practice ⏱️ Take Test 🔍 Search
Database
Back to Database
Other Subjects
Questions and Answers for Competitive Exams Various Entrance Test