EXAMIANS
When AUTOCOMMIT is set on, changes will be made automatically at the end of each SQL statement.
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 : ?
ROLLBACK WORK asks SQL to empty the log file.
YOUR ANSWER : ?
How many tables may be included with a join?
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 WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
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 : ?
Subqueries can be nested multiple times.
YOUR ANSWER : ?
Embedded SQL is which of the following?
YOUR ANSWER : ?
A function returns one value and has only output parameters.
YOUR ANSWER : ?
Which of the following is one of the basic approaches for joining tables?
YOUR ANSWER : ?