You have not configured Oracle Managed Files （OMF) in your database. You do not want to sc

You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature. Which statement should you use to enable the block change tracking feature?（）

A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;

D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING;

YouhavenotconfiguredOracleManagedFiles（OMF）inyourdatabase.Youdonotwanttoscantheentiredatafileeverytimeanincrementalbackupisperformed.Youdecidetoenabletheblockchangetrackingfeature.Whichstatementwillyouusetoenabletheblockchangetrackingfeature？（）

A.ALTERSYSTEMENABLEBLOCKCHANGETRACKING；

B.ALTERDATABASEENABLEBLOCKCHANGETRACKING；

C.ALTERSYSTEMENABLEBLOCKCHANGETRACKINGUSINGFILE；

D.ALTERDATABASEENABLEBLOCKCHANGETRACKINGUSINGFILE；

If you don't want to miss the Redbirds, you must spare some time on ______.

A．Saturday morning

B．Sunday night

C．Sunday morning

D．Saturday night

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.Which statement about performing user-managed backups in a 24x7 environment is true?（）

A. You must have change tracking enabled in your database

B. Your database must be running in NOARCHIVELOG mode

C. To back up a tablespace, it must be in backup mode

D. To back up a tablespace, it must first be taken offline

If you don't want to talk to him, I'll speak to him_____.

A．on your account

B．on your behalf

C．for your part

D．in your interest

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it.Identify the two events that can occur in the event of a log switch?（）

A.An entry is created in the alert log file and the database instance continues to function normally

B.The log switch hangs occur for transactions until free space is available in the flash recovery area

C.The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle

D.The database instance statusis implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:ALTER TABLESPACE data1 BEGIN BACKUP;While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.

D. If you restart the database, the database will not be opened.

A. meet

B. meeting

C. to meet

D. to meeting

You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.

You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?

A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed

B．Use the sp_who stored procedure to discover who is logged in as spid 52

C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52

D．Use System Monitor to log the locks that are granted in the database