Which server houses the database partitions in the AIX BCU V2.1? ()
Identify the situations in which you use the alert log file in your database to check the detail.()
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario?()
You are working in a dedicated server environment. Your database is running in the automatic Program Global Area (PGA) memory management mode. Which two statements are correct in this scenario? ()
ote the following structures in your database server: 1:Extents 2:OS Blocks 3:Tablespace 4:Segments 5:Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
You configure your database Instance to support shared server connections.Which two memory areas that are part of PGA are stored in SGA instead, for shared server connection?()
Your network contains two Exchange Server 2010 Mailbox servers.You create a database availability group (DAG).You need to ensure that the Exchange servers can replicate mailbox databases.What should you do?()
Your database is configured in shared server mode. However, your senior DBA asks you to modify the value ofthe PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
You want to perform in incomplete recovery of your database. You plan to use these commands to recover your database: SET UNTIL TIME = ’2000-12-09:11:44:00’; RESTORE DATABASE; RECOVER DATABASE; How should the commands be executed? ()
Identify the two situations in which you use the alert log file in your database to check the details.()
In your multitenant container database (CDB) containing same pluggable databases (PDBs), you execute the following commands in the root container: Which two statements are true?()
You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace, UNDO_TBS1, in your database. Which two additional steps would you perform to achieve this?()
Your database is configured in shared server mode. However, your senior DBA asks you to modifythe value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this()
You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?()
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery?()
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
Examine the parameter setting in your database: https://assets.asklib.com/images/image2/2018080215045780340.jpg Which statement is correct about the database?()
You work as a database administrator for Certkiller .com. In your database server, the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve?()
Your database is running in NOARCHIVELOG mode. You want to put the database in ARCHIVELOG mode. Which two statements regarding archive log destinations are true?()
In your database, the Log Writer (LGWR) process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database?()
Note the following structures in your database server: 1.Extents 2.OS Blocks 3.Tablespace 4.Segments 5.Oracle Data Block Which option has the correct arrangement of these structures from the smallest to the largest()