.png)
SQL Quiz 2
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'
where is answer?
ReplyDelete