Posts Tagged ‘1z1-052’

Oracle Database 11g: Administrator I : cExam

Sunday, March 8th, 2009

26. Which two statements are true regarding undo tablespaces? (Choose two.)
A.The database can have more than one undo tablespace.
B.The UNDO_TABLESPACE parameter is valid in both automatic and manual undo management.
C.Undo segments automatically grow and shrink as needed, acting as circular storage buffer for their assigned transactions.
D.An undo tablespace is automatically created if the UNDO_TABLESPACE parameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.
Answer: AC

27. Which two statements are true regarding transactions in an Oracle database? (Choose two.)
A.Multiple transactions can use the same undo segment.
B.A transaction is assigned an undo segment when it is started.
C.More than one transaction cannot share the same extent in the undo tablespace.
D.The transactions use system undo segment to store undo data if all the segments in the undo tablespace are used.
Answer: AB

Tags:
Posted in Uncategorized | Comments Off

Oracle Database 11g: Administrator I 1z1-052 exam

Friday, January 9th, 2009

Killtest Practice Exams for 1z1-052 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.100% Guarantee to Pass Your 11g exam and get your 11g Certification.
We guarantee your success in the first attempt. If you do not pass the 11g 1z1-052 (Oracle Database 11g: Administrator I) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

killtest 1z1-052 Downloadable.
Printable Exams (in PDF format) Our Exam 1z1-052 Preparation Material provides you everything you will need to take your 11g exam. The 11g Certification details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get 11g exam questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first 11g exam try, but also save your valuable time .

  • Comprehensive questions with complete details about 1z1-052 exam.
  • 1z1-052 exam questions accompanied by exhibits.
  • Verified Answers Researched by Industry Experts and almost 100% correct.
  • Drag and Drop questions as experienced in the Real 11g exam.
  • 1z1-052 exam questions updated on regular basis.
  • Like actual 11g Certification exams, 1z1-052 exam preparation is in multiple-choice questions (MCQs).
  • Tested by many real 11g exams before publishing.
  • Try free 11g exam demo before you decide to buy it in http://www.Killtest.com.

96. View the Exhibits and examine the structures of the PROMOTIONS and SALES tables.

Evaluate the following SQL statement:

SQL>SELECT p.promo_id, p.promo_name, s.prod_id

FROM sales s RIGHT OUTER JOIN promotions p

ON (s.promo_id = p.promo_id);

Which statement is true regarding the output of the above query?

A.It gives the details of promos for which there have been sales.

B.It gives the details of promos for which there have been no sales.

C.It gives details of all promos irrespective of whether they have resulted in a sale or not.

D.It gives details of product IDs that have been sold irrespective of whether they had a promo or not.

Answer: C

Tags:
Posted in 1Z0-051 | Comments Off