DBMS-Relational Query Languages Questions and Answers

Practice Mode
Showing 10 of 45 questions
Q31
SELECT opeation of SQL is a;
  • A data query language
  • B data definition language
  • C data manipulation language
  • D data control language.
Answer: Option A
Q32
Which of the following is used to get all the columns of a table?
  • A *
  • B @
  • C %
  • D #
Answer: Option A
Q33
GRANT command of SQL is a:
  • A data query language
  • B data definition language
  • C data manipulation language
  • D data control language.
Answer: Option D
Q34
Which of the following is a comparison operator used in SELECT statement?
  • A LIKE
  • B BETWEEN
  • C IN
  • D None of these
Answer: Option D
Q35
How many tables can be joined to create a view/
  • A 1
  • B 2
  • C Database dependent
  • D None of these
Answer: Option D
Q36
Which of the following clause is usually used together with aggregate functions ?
  • A ORDER BY ASC
  • B GROUP BY
  • C ORDER BY DISC
  • D None of these
Answer: Option B
Q37
REVOKE command of SQL is a:
  • A data query language
  • B data definition language
  • C data manipulation language
  • D data control language
Answer: Option D
Q38
CREATE operation of SQL is a:
  • A data query language
  • B data definition language
  • C data manipulation language
  • D data control language
Answer: Option B
Q39
COMMIT statement of SQL TCS.
  • A ends the transaction successfully
  • B aborts the transaction
  • C Both of these
  • D None of these
Answer: Option A
Q40
ROLLBACK statement of SQL TCS
  • A ends the transaction successfully
  • B aborts the transaction
  • C Both of these
  • D None of these
Answer: Option B

📚 More from Database

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