Discussion
Home ‣ Database ‣ Advanced SQL Comments
- Question
Which of the following is one of the basic approaches for joining tables?
Options- A. Subqueries
- B. Union Join
- C. Natural join
- D. All of the above
- Correct Answer
- All of the above
- 1. A UNION query is which of the following?
Options- A. Combines the output from no more than two queries and must include the same number of columns.
- B. Combines the output from no more than two queries and does not include the same number of columns.
- C. Combines the output from multiple queries and must include the same number of columns.
- D. Combines the output from multiple queries and does not include the same number of columns. Discuss
- 2. 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
- 3. 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
- 4. 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
- 5. 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
- 6. Which of the following is true concerning a procedure?
Options- A. You do not create them with SQL.
- B. They do not need to have a unique name.
- C. They include procedural and SQL statements.
- D. They are the same thing as a function. Discuss
- 7. Which of the following is true concerning systems information in an RDBMS?
Options- A. RDBMS store database definition information in system-created tables.
- B. This information can be accessed using SQL.
- C. This information often cannot be updated by a user.
- D. All of the above. Discuss
- 8. A CASE SQL statement is which of the following?
Options- A. A way to establish an IF-THEN-ELSE in SQL.
- B. A way to establish a loop in SQL.
- C. A way to establish a data definition in SQL.
- D. All of the above. Discuss
- 9. Which of the following statements is true concerning routines and triggers?
Options- A. Both consist of procedural code.
- B. Both have to be called to operate.
- C. Both run automatically.
- D. Both are stored in the database. 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 ;
Options- A. Equi-join
- B. Natural join
- C. Outer join
- D. Cartesian join Discuss
Advanced SQL problems
Search Results
Correct Answer: Combines the output from multiple queries and must include the same number of columns.
Correct Answer: Equi-join
Correct Answer: Involves the use of an inner and outer query.
Correct Answer: Hard-coded SQL statements in a program language such as Java.
Correct Answer: All of the above.
Correct Answer: They include procedural and SQL statements.
Correct Answer: All of the above.
Correct Answer: A way to establish an IF-THEN-ELSE in SQL.
Correct Answer: Both consist of procedural code.
Correct Answer: Cartesian join
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.