Question 1 of 25
Hints left: 3
Q1
Subqueries can be nested multiple times.
Q2
The code to create triggers and routines is stored in only one location and is administered centrally.
Q3
A CASE SQL statement is which of the following?
Q4
Which of the following is true concerning a procedure?
Q5
Which of the following is a correlated subquery?
Q6
What type of join is needed when you wish to include rows that do not have matching values?
Q7
Which of the following statements is true concerning subqueries?
Q8
Which of the following statements is true concerning routines and triggers?
Q9
The joining technique is useful when data from several relations are to be retrieved and displayed and the relationships are not necessarily nested.
Q10
How many tables may be included with a join?
Q11
There should be one condition within the WHERE clause for each pair of tables being joined.
Q12
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Q13
Well-structured relations encourage anomalies of data.
Q14
What type of join is needed when you wish to return rows that do have matching values?
Q15
A candidate key must uniquely identify each row.
Q16
Which of the following is one of the basic approaches for joining tables?
Q17
Which of the following is true concerning systems information in an RDBMS?
Q18
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Q19
The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
Q20
Embedded SQL is which of the following?
Q21
Which of the following is true concerning triggers?
Q22
A foreign key may be null and still adhere to the referential integrity constraint.
Q23
If a relation is in third normal form, it does not need to be in second normal form.
Q24
A UNION query is which of the following?
Q25
Triggers are stored blocks of code that have to be called in order to operate.