文档介绍：SQL exam
(Please wirte your answer in-line in red font)
You n eed to extract details of those products in the SALES table where the PROD_ID colu mn con ta ins the stri ng '_D123'. Which WHERE clause could be used in the SELECT stateme nt to
get the required output?
WHERE prod」d LIKE '%_D123%' ESCAPE '_'
WHERE prod」d LIKE '%\D123%' ESCAPE '\'
WHERE prod」d LIKE '%_D123%' ESCAPE '%_'
WHERE prod」d LIKE '%\_D123%' ESCAPE '\_'
Evaluate the follow ing two queries:
SQL> SELECT cust_last_ name, cust_city
FROM customers
WHERE cust_credit_limit IN (1000, 2000, 3000);
SQL> SELECT cust_last_ name, cust_city
FROM customers
WHERE cust_credit_limit = 1000
OR cust_credit_limit = 2000
OR cust_credit_limit = 3000;
Which stateme nt is true regard ing the above two queries?
Performa nee would improve in query 2.
Performa nce would degrade in query 2.
There would be no cha nge in performa nce.
Performa nce would improve in query 2 only if there are null values in the CUST CREDIT LIMIT colum n.
Which three statements/commands would cause a transaction to end? (Choose three.)
COMMIT
SELECT
CREATE
ROLLBACK
SAVEPOINT
There are two table:
T_A (n ame VARCHAR2(100))
T_B (n ame VARCHAR2(100), name_a VARCHAR2(100));
The values are:
T A
T B
n ame
n ame
n ame_a
Jane
Apple
Jane
Leo
Orange
Jane
David
Apple
Leo
Orange
Leo
Banana
Jane
Banana
Da