RECOVERY_PARALLELISM
FAST_START_MTTR_TARGET
LOG_CHECKPOINT_INTERVAL
FAST_START_PARALLEL_ROLLBACK
第1题:
You work as a database administrator for Certkiller .com. Your database is in NOARCHIVELOG mode. The database has been configured with three redo logs groups, and there have been five log switches. You lost one non-system-critical data file from your database. Which method would you use to recover the data file?()
第2题:
You need to recover five data files that are spread across multiple disks. Which initialization parameter should you set to speed up redo application?()
第3题:
You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?()
第4题:
You are creating a Windows Forms application by using the .NET Framework 3.5.You have resource files in five different languages.You need to test the application in each language. What should you do?()
第5题:
You need to back up the existing data on a computer before you install a new application. You also need to ensure that you are able to recover individual user files that are replaced or deleted during the installation. What should you do?()
第6题:
Database datafiles
Control files
Archived redo logs
Online redo logs
Flashback logs
第7题:
the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
the column of the V$INSTANCE_RECOVERY view
the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY view
the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
第8题:
Create a System Restore point.
Perform an Automated System Recovery (ASR) backup and restore.
In the Backup and Restore Center window, click the Back up files button.
In the Backup and Restore Center window, click the Back up computer button.
第9题:
Restore the data file for the SYSTEM tablespace then open the database.
Restore all redo logs form last night's backup, then restart the database.
Perform a complete restore of all files from last night's backup. Data entered into the database today must be reentered.
Mount the instance, take the SYSTEM tablespace offline, open the database, and then restore the data file, recover it, and bring the tablespace online.
第10题:
Pass the object data in a hidden field.
Store the object instance in a session variable.
Use a cookie that contains the object data.
Encode the object data and pass it in a query string parameter.
第11题:
RECOVERY_PARALLELISM
FAST_START_MTTR_TARGET
LOG_CHECKPOINT_INTERVAL
FAST_START_PARALLEL_ROLLBACK
第12题:
restore the tablespace from the backup; there is no need to apply the redo information
restore the full database to recover the data up to the point when you performed the backup
restore the tablespace from the backup and then perform a recovery using the backup control file
restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
第13题:
You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()
第14题:
Your database is set in NOARCHIVELOG mode and is backed up every night. There are 10 redo log groups on the database, each with three members, making a total of 30 redo log files. At lunchtime the server unexpectedly gets shut down. Upon restarting you notice that the data file belonging to the SYSTEM tablespace has become corrupted. You also notice that there have been 15 log switches during the day. Which solution should you use to recover as much committed data as possible?()
第15题:
View the Exhibit.You executed the following command to perform a backup of the USERS tablespace: RMAN> BACKUP TABLESPACE USERS; Which three types of files are backed up? ()
第16题:
You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform?()
第17题:
all the data files belonging to the USERS tablespace
password file
online redo log files
the current control file
archived redo log files
the current server parameter file
data files belonging to the USERS tablespace and all the default tablespaces
第18题:
LOG_ARCHIVE_DEST was not set in the parameter file.
LOG_ARCHIVE_START was not set in the parameter file.
alter database archivelog; was not executed in MOUNT mode.
LOG_ARCHIVE_MAX processes were not set in the parameter file.
第19题:
Restore all the data files and open the database
Create the data file and perform tablespace recovery
No need to restore any file, just recover the database
Restore only the system data file and recover the database
Restore only lost date file and performtablespacerecovery
第20题:
You do not need to restore all the data files.
You do not need to open the database with the RESETLOGS operation
You do not need to perform a full backup after the RESETLOGS operation.
You do not need to recover all the data files to the same system change number (SCN).
第21题:
until SCN
until time
until cancel
using backup control file
第22题:
Oracle Enterprise Manager
The V$LOG view
The V$LOGFILE view
The V$FLASHBACK_DATABASE_LOGS view
第23题:
Create a new Data Collector Set.
Create a new Event Viewer Subscription.
Attach a new task to the Application event log.
Modify the properties of the mailbox database objects.
第24题:
An extent cannot spread across data files.
A segment cannot spread across data files.
A data file can belong to only one tablespace.
A data file can have only one segment created in it.
A data block can spread across multiple data files as it can consist of multiple operating system (OS)blocks