You perform a ba

第1题：

第2题：

Which three are true regarding the use of outer joins? （）

• A、You cannot use IN operator in a condition that involves an outerjoin.
• B、You use (+) on both sides of the WHERE condition to perform an outerjoin.
• C、You use (*) on both sides of the WHERE condition to perform an outerjoin.
• D、You use an outerjoin to see only the rows that do not meet the join condition.
• E、In the WHERE condition, you use (+) following the name of the column in the table without matching rows, to perform an outerjoin.
• F、You cannot link a condition that is involved in an outerjoin to another condition by using the OR operator.

第3题：

第4题：

You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

• A、You must shut down the database instance to perform the backups.
• B、You must configure the Flash Recovery Area （FRA） for the database.
• C、You can perform complete database backups without closing the database.
• D、All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

第5题：

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)

• A、You must configure block change tracking file
• B、You must have first level 1 backups for RMAN to restore blocks
• C、You must ensure that the SALES database is mounted or open
• D、You must have full or level 0 backups for RMAN to restore blocks
• E、You must take the tools01.dbf data file offline before you start a block media recovery

第6题：

You are the network administrator at TestKing. You need to perform password recovery on Router TK1. What must you modify in the password recovery process?（）

• A、Configuration register
• B、NVRAM
• C、Boot flash
• D、CMOS
• E、Flash

第7题：

Server1 contains a folder named D:/Salesdata, which contains important company data. The hardware-monitoring software reports that the disk that contains volume D is in danger of imminent disk failure. You order a replacement disk, but you must wait at least one day for the disk to be delivered. You discover that you do not have a backup of the D:/Salesdata folder because a recent backup was configured incorrectly. You need to back up the D:/Salesdata folder so that you can restore the data if the disk fails. You need to achieve this goal as quickly as possible. What should you do? （）

• A、Perform a normal backup of the D:/Salesdata folder.
• B、Perform an incremental backup of the D:/Salesdata folder.
• C、Perform a differential backup of the D:/Salesdata folder.
• D、Perform a daily backup of the D:/Salesdata folder.
• E、Enable Shadow Copies on volume D:/Configure the shadow copy location as C:/.

第8题：

第9题：

Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?（）

• A、Perform Export before TSPITR and Import after TSPITR
• B、Move objects to another schema that has the same tablespace assigned
• C、Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
• D、Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)

第10题：

Your test database is running in NOARCHIVELOG mode. Which statement is true regarding the type ofbackups that can be performed on the database（）

• A、You can perform online whole database backups.
• B、You can performofflinewhole database backups.
• C、You cannot perform schema-level export/import operations.
• D、You can perform the backup of only the SYSTEM tablespace when the database is open.