EXAMIANS
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
YOUR ANSWER : ?
YOUR ANSWER : ?
Outer join is the same as equi-join, except one of the duplicate columns is eliminated in the result table.
YOUR ANSWER : ?
A function returns one value and has only output parameters.
YOUR ANSWER : ?
A UNION query is which of the following?
YOUR ANSWER : ?
With the UNION clause, each query involved must output the same number of columns, and they must be UNION compatible.
YOUR ANSWER : ?
A correlated subquery is where the outer query depends on data from the inner query.
YOUR ANSWER : ?
The code to create triggers and routines is stored in only one location and is administered centrally.
YOUR ANSWER : ?
Which of the following is one of the basic approaches for joining tables?
YOUR ANSWER : ?
Which of the following is a correlated subquery?
YOUR ANSWER : ?
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 ;
YOUR ANSWER : ?