You need to turn on Tracing for a page that is not performing well. You must store the trace information in a database for reporting and trending. Which two actions should you perform?()
You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true? ()
You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE ?5/24); Which two statements are true? ()
You decided to configure the flash recovery area in your database to centralize the storage of all the recovery files in a certain location on disk. Which two parameters will you specify in the init.ora file?()
The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. Which two statements are true regarding the outcome of this action?()
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()https://assets.asklib.com/images/image2/2018080214062464323.png
You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform?()
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema. Which two statements are true regarding the outcome of this action? ()(Choose two)
You are the Database Administrator (DBA) of your company. You execute the following statement on an Oracle 10g instance: SQL> ALTER SYSTEM SWITCH LOGFILE; Which two tasks are performed when the statement is executed? ()
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?()
Which two changes and their effect on the system can be tested by using the Database Replay feature?()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The database isconfigured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
You perform differential incremental level 1 backups of your database on each working day and level 0 backup on Sundays, to tape. Which two statements are true about differential incremental backups()
You perform differential incremental level 1 backups of your database on each working day and level 0 backupon Sundays, to tape. Which two statements are true about differential incremental backups()
You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN. Which two statements are correct in this scenario?()
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? ()(Choose two)
The RECYCLEBIN parameter is set to ON for your database. You drop a table, PRODUCTS, from the SCOTT schema.Which two statements are true regarding the outcome of this action?()
You lost a data file that belongs to an index tablespace in your database, which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem? ()
On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?()
You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?()
You are working on a database that must be functioning 24 hours a day, 7 days a week. The databaseis configured in ARCHIVELOG mode. Which two options do you have for performing user-managed backups()
Examine the following command that is used to duplicate a database on the same host: https://assets.asklib.com/images/image2/2018080214260721422.jpg Which two statements describe the effect after the database is duplicated successfully? ()