Oracle Certification Exam

Q4. Which three actions will add a resource to an Oracle Restart configuration?

Q4. Which three actions will add a resource to an Oracle Restart configuration? A. Creating...

Q3. Examine these queries and their output After a system crash, an instance restart and an attempted opening of the PDBs result in

Q3. Examine these queries and their output: After a system crash, an instance restart and...

Q2. While backing up to an SBT channel, you determine that the read phase of your compressed Recovery Manager (RMAN) incremental level 0 backup is a bottleneck

Q2. While backing up to an SBT channel, you determine that the read phase of...

Q1. Which three are true about the tools for diagnosing Oracle Database failure situations?

Q1. Which three are true about the tools for diagnosing Oracle Database failure situations? A....

Q166 Which query produces output for CUST_LAST_NAME containing Oder for the first row and Aus for the second?

Q166 The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2. The table has...

Q165 Which three statements are true about multiple row subqueries?

Q165 Which three statements are true about multiple row subqueries? A. They can contain GROUP...

 Q164 As the DBA, you execute this command

Q164 As the DBA, you execute this command:  GRANT CREATE VIEW TO usr1 WITH ADMIN...

Q163 Which two statements are true regarding Oracle database space management within blocks managed by Automatic Segment Space Management (ASSM)?

Q163 Which two statements are true regarding Oracle database space management within blocks managed by...

Q162 You start your database instance in NOMOUNT state, Which two actions are performed?

Q162 You start your database instance in NOMOUNT state, Which two actions are performed? A)...

Q161 Examine this command Which two statements are true?

Q161 Examine this command: ALTER DATABSE MOVE DATAFILE ‘/u01/sales01.dbf’ TO      ‘/u02/sales02.dbf’; Which two statements are...

Q160 Examine the description of the BOOKS_TRANSACTIONS table

Q160 Examine the description of the BOOKS_TRANSACTIONS table: Name                                                                                                      Null?                       Type ================================== ===========       ========================== TRANSACTION_ID                                                                                ...

Q159 Which two statements are true about views?

Q159 Which two statements are true about views? A) Views can be updated without the...