You work as a database administrator for Certkiller .com. In the middle of a transaction, a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario?()
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens?()
Which is the correct description of a pinned buffer in the database buffer cache()
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? ()
Which options would you consider while configuring a flash recovery area fast recovery area in 11g Release 2 for your production database that is running in ARCHIVELOG mode?()
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()
The database is currently running in the NOARCHIVELOG mode. What would be the first step to configure Flashback Database?()
Assuming default setting,how can you erase the VTP database of VLANs on a CISCO IOS switch running in VTP server mode?()
Which options would you consider while configuring a flash recovery area (fast recovery area in 11g Release 2) for your production database that is running in ARCHIVELOG mode?()
ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation()
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) whileduplicating a running database? ()(Choose Two)
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
Your test database is running in NOARCHIVELOG mode. What are the implications of this? ()
Which view will you use to view information regarding the jobs that are currently running in a database?()
You are performing an incomplete recovery because a tablespace is dropped and purged from the Recycle Bin. In which mode will you execute the following code?() RMAN>RUN { SET UNTIL SEQUENCE THREAD ; RESTORE DATABASE; RECOVER DATABASE; }
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?()
A user wants to connect to the database instance from an application that is running on a remote machine. Which tools should the DBA use to establish the required configuration to ensure that the user is able to connect to the database instance?()
Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()https://assets.asklib.com/images/image2/201808020910242598.jpg
Your database interface is running. A user SCOTT starts a SQL *Plus session, and issues the following query: SQL> SELECT * FROM sales; Which process would retrieve the result from the database and return it to the client program?()
In a Database Replay workload capture, what client request information is gathered?()
______ is a query language for manipulating data in a relmional database.