sql mcq:
11 . In SQL, which of the following is not a data definition language commands?
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