Oracle Database: SQL Fundamentals I 1Z0-051

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 “1Z0-052″ (Oracle Database 11g: Administrator I : 1z1-052 Exam) on your first attempt, send us the official result. We will give you a FULLY REFUND of your purchasing fee OR send you another same value product for free.

 

65. Which two statements are true about checkpointing? (Choose two.)

66. You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue? (Choose two.)
A.Disable automatic checkpoint tuning.
B.Check the size of the redo log file size and increase the size if it is small.
C.Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.
D.Decrease the number of redo log members if there are more than one redo log members available in each redo log group.
Answer: BC

killtest 11g 1Z0-052 Exam Downloadable.

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

 

 

 

61. You need to display the first names of all customers from the CUSTOMERS table that contain the character ‘e’ and have the character ‘a’ in the second last position.

Which query would give the required output?

A.SELECT cust_first_name

FROM customers

WHERE INSTR(cust_first_name, ‘e’)<>0 AND

SUBSTR(cust_first_name, -2, 1)=’a';

B.SELECT cust_first_name

FROM customers

WHERE INSTR(cust_first_name, ‘e’)<>” AND

SUBSTR(cust_first_name, -2, 1)=’a';

C.SELECT cust_first_name

FROM customers

WHERE INSTR(cust_first_name, ‘e’)IS NOT NULL AND

SUBSTR(cust_first_name, 1,-2)=’a';

D.SELECT cust_first_name

Answer: A

 

62. In the CUSTOMERS table, the CUST_CITY column contains the value ‘Paris’ for the CUST_FIRST_NAME ‘ABIGAIL’.

Evaluate the following query:

SQL> SELECT INITCAP(cust_first_name || ‘ ‘||

UPPER(SUBSTR(cust_city,-LENGTH(cust_city),2)))

FROM customers

WHERE cust_first_name = ‘ABIGAIL’;

What would be the outcome?

A.Abigail PA

B.Abigail Pa

C.Abigail IS

D.an error message

Answer: B