SQL mcq questions and answers

sql mcq:

11 . In SQL, which of the following is not a data definition language commands?

  • RENAME
  • REVOKE
  • UPDATE
  • GRANT

12 . In SQL, which command is used to SELECT only one copy of each set of duplicable rows
  • SELECT DISTINCT
  • SELECT UNIQUE
  • SELECT DIFFERENT
  • All of the above

13 . A command that lets you change one or more fields in a record is
  • Modify
  • Insert
  • Look-up
  • All of the above

14 . Which of the SQL statements is correct?
  • SELECT Username AND Password FROM Users
  • SELECT Username, Password FROM Users
  • SELECT Username, Password WHERE Username = 'user1'
  • None of these

15 . The FROM SQL clause is used to?
  • specify what table we are selecting or deleting data FROM
  • specify range for search condition
  • specify search condition
  • None

16 . Which of the following SQL commands can be used to add data to a database table?
  • ADD
  • UPDATE
  • APPEND
  • INSERT

17. Which of the following join is also called as an 'inner-join'?
  • Non-Equijoin
  • Self-Join
  • Equijoin
  • None

18 . Which of the following is NOT a type of SQL constraint?
  • PRIMARY KEY
  • ALTERNATE KEY
  • FOREIGN KEY
  • UNIQUE

19 . What is an SQL virtual table that is constructed from other tables?
  • Just another table
  • A relation
  • view
  • Query results

20 . When using the SQL INSERT statement:
  • rows cannot be copied in mass from one table to another only
  • rows can be modified according to criteria only
  • rows can either be inserted into a table one at a time or in groups
  • rows can be inserted into a table only one at a time only


























Post a Comment

0 Comments