Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SQL 2011 Quiz
- John Duncan
- 1. What does SQL stand for?
- A)Structured Question Language
- B)Strong Question Language
- C)Structured Query Language
- D)Structured Queue Language
- 2. What does the SQL FROM clause do?
- A)Specifies a search condition.
- B)Specifies the tables to retrieve rows from.
- C)Specifies the columns we are retrieving
- D)Specifies the attributes to retrieve rows from.
- 3. Which of the following SQL clauses is used to enter data into a SQL table?
- A)INSERT INTO
- B)WRITE
- C)ENTER
- D)SELECT
- 4. Which 2 SQL keywords specify the sorting direction of the result set retrieved with ORDER BY clause.
- A)ASC and DESC
- B)HIGH and LOW
- C)UP and DOWN
- D)Top and Bottom
- 5. We refer to a join as a self-join when…
- A)we are using left and right join together
- B)We are joining two tables only
- C)we are joining more than 2 tables
- D)we are joining table to itself
- 6. RDBMS stands for…
- A)Real Database Management System
- B)Relational Database Management System
- C)Read Database Master System
- D)Realtime Database Management System
- 7. The table rows are also known as…
- A)Attributes
- B)Fields
- C)Records
- D)Entity
- 8. If you join a table to itself, what kind of join are you using?
- A)Selective Join.
- B)Natural Joun
- C)You can't join a table to itself.
- D)Self Join
- 9. The UPDATE SQL clause can…
- A)update only one row at a time.
- B)update more than one row at a time.
- C)delete more than one row at a time.
- D)delete only one row at a time.
- 10. Which SQL statement selects all rows from table called Contest, with column ContestDate having values greater or equal to May 25, 20006?
- A)SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'
- B)SELECT * FROM Contest WHERE ContestDate < '05/25/2006'
- C)SELECT * FROM Contest GROUPBY ContestDate >= '05/25/2006'
- D)SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'
- 11. Which SQL keyword is used to retrieve a minimum value?
- A)DOWN
- B)LOW
- C)MIN
- D)LOWER
- 12. The INNER JOIN clause…
- A)returns all rows that have matching value in the field on which the 2 tables are joined.
- B)returns only the rows from the first table, which have non-matching values with the second table in the field on which the 2 tables are joined.
- C)returns all rows from 2 tables.
- D)returns all the matching rows from 2 tables.
- 13. Which SQL keyword is used to retrieve only unique values?
- A)DISTINCTIVE
- B)DIFFERENT
- C)DISTINCT
- D)UNIQUE
- 14. If you don't specify ASC or DESC after a SQL ORDER BY clause, the following is used by default:
- A)There is no default value.
- B)DESC
- C)ASC
- D)Random
- 15. What is an index?
- A)An index is a database table attribute, which speeds-up data search within a table.
- B)An index is the same as alias.
- C)An index is a special way to join 2 or more tables.
- D)An index is a database row attribute, which speeds-up data search within a table.
- 16. What does ACID stand for?
- A)Access. Consistency. Isolation. Data.
- B)Access. Constraint. Index. Data.
- C)Access. Constant. Information. Data.
- D)Atomicity. Consistency. Isolation. Durability.
- 17. Which of the following SQL statements is correct?
- A)TRUNCATE Sales TABLE
- B)TRUNCATE * FROM TABLE Sales
- C)TRUNCATE TABLE Sales
- D)TRUNCATE * FROM COLUMN Sales
- 18. The IN SQL keyword
- A)Is used with the DISTINCT SQL keyword only.
- B)Is used with the INSERT SQL keyword only.
- C)Determines if a value matches any of the values in a list or a sub-query.
- D)Defines the tables we are selecting or deleting data from.
- 19. Sub-queries can be nested in…
- A)UPDATE statements only.
- B)INSERT statements only.
- C)DELETE statements only.
- D)UPDATE, DELETE, INSERT and SELECT statements.
- 20. The LIKE SQL keyword is used along with ..
- A)WHERE clause.
- B)ORDER BY clause.
- C)JOIN clause.
- D)GROUP BY clause.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement