Exercise: Advanced Sql

Questions for: Advanced Sql

Embedded SQL is which of the following?
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.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
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
A:
Equi-join
B:
Natural join
C:
Outer join
D:
Cartesian join
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is true concerning systems information in an RDBMS?
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.
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following is one of the basic approaches for joining tables?
A:
Subqueries
B:
Union Join
C:
Natural join
D:
All of the above
Answer: D
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Which of the following statements is true concerning routines and triggers?
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.
Answer: A
No answer description is available. Let's discuss.
📖
📝
💬
👁️
Ad Slot (Above Pagination)
Quiz