Discussion
Home ‣ Database ‣ Advanced SQL Comments
- Question
Which of the following is true concerning triggers?
Options- A. You do not create them with SQL.
- B. They execute against only some applications that access a database.
- C. They have an event, condition, and action.
- D. They cannot cascade (cause another trigger to fire).
- Correct Answer
- They have an event, condition, and action.
- 1. When mapping a multivalued attribute into a relation which of the following is true?
Options- A. One relation is created.
- B. Two relations are created.
- C. Three relations are created.
- D. Four relations are created. Discuss
- 2. When mapping a supertype/subtype relationship which of the following is true?
Options- A. The supertype primary key is assigned to each subtype.
- B. The subtype primary key is assigned to each supertype.
- C. There is no link between the supertype/subtype entities.
- D. There is no primary key/foreign key relationship between a supertype/subtype. Discuss
- 3. When mapping a ternary relationship with an associative entity into a relation which of the following is true?
Options- A. One relation is created.
- B. Two relations are created.
- C. Three relations are created.
- D. Four relations are created. Discuss
- 4. When mapping a regular entity into a relation which of the following is true?
Options- A. One relation is created.
- B. Two relations are created.
- C. Three relations are created.
- D. Four relations are created. Discuss
- 5. A transitive dependency is which of the following?
Options- A. A functional dependency between two or more key attributes.
- B. A functional dependency between two or more nonkey attributes.
- C. A relation that is in first normal form.
- D. A relation that is in second normal form. Discuss
- 6. What type of join is needed when you wish to include rows that do not have matching values?
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. All of the above. Discuss
- 7. What type of join is needed when you wish to return rows that do have matching values?
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. All of the above. Discuss
- 8. Embedded SQL is which of the following?
Options- A. Hard-coded SQL statements in a program language such as Java.
- B. The process of making an application capable of generating specific SQL code on the fly.
- C. Hard-coded SQL statements in a procedure.
- D. Hard-coded SQL statements in a trigger. Discuss
- 9. Which of the following statements is true concerning subqueries?
Options- A. Involves the use of an inner and outer query.
- B. Cannot return the same result as a query that is not a subquery.
- C. Does not start with the word SELECT.
- D. All of the above. Discuss
- 10. 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
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. Cartesian join Discuss
Advanced SQL problems
Search Results
Correct Answer: Two relations are created.
Correct Answer: The supertype primary key is assigned to each subtype.
Correct Answer: Four relations are created.
Correct Answer: One relation is created.
Correct Answer: A functional dependency between two or more nonkey attributes.
Correct Answer: Outer join
Correct Answer: All of the above.
Correct Answer: Hard-coded SQL statements in a program language such as Java.
Correct Answer: Involves the use of an inner and outer query.
Correct Answer: Equi-join
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.