Online Access Free 1z0-071 Practice Test

Which three statements are true about Structured Query Language (SQL)?

• A.It requires that data be contained in hierarchical data storage
• B.It guarantees atomicity, consistency, isolation, and durability (ACID) features
• C.It is the only language that can be used for both relational and object-oriented databases
• D.It provides independence for logical data structures being manipulated from the underlying physical data storage
• E.It is used to define encapsulation and polymorphism for a relational table
• F.It best supports relational databases

Examine the description of the CUSTOMERS table:
Which three statements will do an implicit conversion?

• A.SELECT * FROM customers WHERE customer_id='0001';
• B.SELECT * FROM customers WHERE insert_date=DATE'2019-01-01';
• C.SELECT * FROM customers WHERE TO_DATE(insert_date)=DATE'2019-01-01';
• D.SELECT * FROM customers WHERE customer_id=0001;
• E.SELECT * FROM customers WHERE TO_CHAR(customer_id)='0001';
• F.SELECT * FROM customers WHERE insert_date'01-JAN-19';

Which three statements are true about GLOBAL TEMPORARY TABLES?

• A.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• B.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• C.A TRUNCATE command issued in a session causes all rows In a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• D.GLOBAL TEMPORARY TABLE space allocation occurs at session start.
• E.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• F.A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

Examine the description of the BOOKS_TRANSACTIONS table:

Which two WHERE conditions give the same result?

• A.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' OR member_id IN ('A101','A102'));
• B.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND (member_id ='A101' OR member_id ='A102') );
• C.WHERE borrowed_date = SYSDATE AND transaction_type ='RM' OR member_id IN ('A101','A102');
• D.WHERE (borrowed_date = SYSDATE AND transaction_type ='RM') OR member_id IN ('A101','A102');
• E.WHERE borrowed_date = SYSDATE AND (transaction_type ='RM' AND member_id='A101' OR member_id ='A102'));

Examine the description of the PROMTIONS table:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used?

• A.SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;
• B.SELECT promo_cost, | pxomo_category FROM promotions ORDER BY 1;
• C.SELECT DISTINCT promo_category ||'has'|| promo_cost AS COSTS FROM promotions ORDER BY 1;
• D.SELECT promo_category, DISTINCT promo_cost PROM promotions ORDER BY 2:
• E.SELECT DISTINCT promo_cost ||' in' II DISTINCT promo_category FROM promotions ORDER BY 1;