1Z0-051 exam
Oracle Manufacturers subjects demo data
Question: 1
See the Exhibit:
You need to display all promo categories that do not have ‘discount’ in their subcategory. Which two SQL statements give the required result? (Choose two.)
A. SELECT promo_category FROM promotions MINUS SELECT promo_category FROM promotions WHERE promo_subcategory = ‘discount’
B. SELECT promo_category FROM promotions INTERSECT SELECT promo_category FROM promotions WHERE promo_subcategory = ‘discount’
C. SELECT promo_category FROM promotions MINUS SELECT promo_category FROM promotions WHERE promo_subcategory<> ‘discount’
D. SELECT promo_category FROM promotions
INTERSECT SELECT promo_category FROM promotions WHERE promo_subcategory<> ‘discount’
Answer: A,D
Question: 2
See the Exhibit:
Which two SQL statements would execute successfully? (Choose two.)
A. UPDATE promotions SET promo_cost = promo_cost+100 WHERE TO_CHAR(promo_end_date,’yyyy’>’2000′;
B. SELECT promo_begin_date FROM promotions WHERE TO_CHAR(promo_begin_date,’monddyy’)=’jul 01 98′;
C. UPDATE promotions SET promo_cost = promo_cost+100 WHERE promo_end_date> TO_DATE(SUBSTR(’01-JAN-200′,8));
D. SELECT TO_CHAR(promo_begin_date,’dd/month’) FROM promotions WHERE promo_begin_date IN (TO_DATE(‘JUN 01 98’,TO_DATE(‘JUL 01 98’));
Answer: A,B
Question: 3
Which two statements are true about sequences created in a single instance database? (Choosetwo.)
A. The numbers generated by a sequence can be used only for one table
B. DELETE <sequencename> would remove a sequence from the database
C. CURRVAL is used to refer to the last sequence number that has been generated
D. When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limitby using the ALTER SEQUENCE statement
E. When a database instance shuts down abnormally, the sequence numbers that have beencached but not used would be available once again when the database instance is restarted
Answer: C,D
Question: 4
The SQL statements executed in a user session as follows:
Which two statements describe the consequence of issuing the ROLLBACK TO SAVE POINT acommand in the session? (Choose two.)
A. The rollback generates an error
B. No SQL statements are rolled back
C. Only the DELETE statements are rolled back
D. Only the seconds DELETE statement is rolled back
E. Both the DELETE statements and the UPDATE statement are rolled back
Answer: A,B
Question: 5
Which three statements/commands would cause a transaction to end? (Choose three.)
A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
E. SAVEPOINT
Answer: A,C,D
http://www.exam1pass.org/1Z0-051-exam.html
http://www.exam1pass.org/pdf/1Z0-051.pdf
Processing your request, Please wait....
