1.Which of the following is a valid SQL statement?
A) SELECT column1, column2 FROM table_name;
2. Which of the following arithmetic operators is not valid?
A) @ : Raise to power of
3. Which of the following is not performed as a task of natural join?
A) If there are common attributes, returns the relational product of the two tables
4. Which of the following statements best defines outer join?
A) An outer join returns not only the rows matching the join condition, but it also returns the rows with unmatched values.
5. Which of the following is NOT a valid outer join?
A) ALL OUTER JOIN
6. Repeating group is defined as
A) SELECT columnlist FROM tablelist [WHERE conditionlist ] [ORDER BY columnlist [ASC | DESC];
7. Which of the following is not a characteristic of a subquery?
A) The inner query is executed last
8. Which of the following is a valid multirow subquery operator?
A) ALL
9. Which of the following is not a valid relational set operator?
A) CONCAT
10. Which of the following suggestions is the least useful when writing a SQL query?
A) Know the business.