Oracle Certification Exam

Q14. Which two statements are true about the SET VERIFY ON command?

Q14. Which two statements are true about the SET VERIFY ON command? (Choose two.) (A)....

Q13. Which is the default column or columns for sorting output from compound queries using SET operators such as intersect In a SQL statement?

Q13. Which is the default column or columns for sorting output from compound queries using...

Q12. Why does the DB01.abc.com service show unknown status?

Q12. Examine this command and some partial output: Why does the DB01.abc.com service show unknown...

Q11. Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace?

Q11. Examine this command: CREATE UNDO TABLESPACE undotbs01 DATAFILE 'undotbs_01.dbf' SIZE 100M AUTOEXTEND ON; Which...

Q10. Which three statements are true regarding single row subqueries?

Q10. Which three statements are true regarding single row subqueries? (A). They must be placed...

Q9. Which three statements are true about connection strings and service names used to connect to an Oracle database instance?

Q9. Which three statements are true about connection strings and service names used to connect...

Q8. Which query requires explicit data type conversion?

Q8. Examine the description of the EMPLOYEES table: NLS_DATE_FORMAT is set to DD-MON-YY. Which query...

Q7. Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

Q7. Which three Oracle database space management features will work with both Dictionary and Locally...

Q6. Which two statements are true about segment types in an Oracle Database?

Q6. Which two statements are true about segment types in an Oracle Database? (A). Table...

Q5. Which two statements are true about table data storage in an Oracle database?

Q5. Which two statements are true about table data storage in an Oracle database? A)...

Q4. Which three statements are true about table data storage in an Oracle Database?

Q4. Which three statements are true about table data storage in an Oracle Database? (Choose...

Q3. Which two statements are true about views used for viewing tablespace and datafile information?

Q3. Which two statements are true about views used for viewing tablespace and datafile information?...