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