A.Until SCN
B.Until time
C.Until cancel
D.Recover using backup control file.
您可能感兴趣的试卷
你可能感兴趣的试题
A.CREATE USER
B.CREATE SESSION
C.CREATE ANY TABLE
D.IMP_FULL_DATABASE
E.EXP_FULL_DATABASE
A.Every three minutes.
B.When a log switch occurs.
C.When forces by an administrator.
D.When a tablespace is taken offline normal.
E.When the redo buffer is one-third full.
A.A direct-load insert can be invoked by suing the APPEND hint.
B.Inserting using the NOLOGGING option is the default for direct-load inserts.
C.All data loaded using direct-load insert is loaded below the high-water mark.
D.An object that is modifies using parallel direct-load can be queried within the same Transaction.
A.HTTP
B.IIOP
C.TCP/IP
D.Named Pipes
E.TCP/IP with SSL
A.LIST
B.CHANGE
C.CATALOG
D.CROSSCHECK
You issue this RMAN command:
RMAN> create script Level0Backup {
backup
incremental level 0
format ‘/u01/db01/backup/%d_%_Sp’
fileperset 5
(database include current controlfile);
sql ‘alter database archive log current’;
}
Which three statements are true about the Level0Backup script you just created?()
A.The script is stored only in the control file.
B.The script is stored only in the recover catalog.
C.The script can be executed only by using the RMAN RUN command.
D.The commands of the script can be displayed with the LIST command.
E.The commands of the script can be displayed with the PRINT command.
F.The commands of the script can be displayed with the REPORT command.
The Oracle Shared Server architecture reduces memory usage by reducing the number of server processes required. To process a request for a server process, the following tasks are performed:
1.A shared server picks up the request from the request queue and processes the
request.
2.The dispatcher retrieves the response from the response queue.
3.A user sends a request to its dispatcher.
4.The dispatcher returns the response to the user.
5.The shared sever places the response on the calling dispatcher’s response queue.
6.The dispatcher places the request into the request queue in the SGA.
Put the above task in the order in which they are performed.()
A.3,1,6,2,5,4
B.3,6,1,5,2,4
C.3,1,2,3,4,5
D.6,1,3,5,2,4
E.6,3,1,2,4,5
F.6,3,1,2,5,4
A.Enables easier loading of multinational data.
B.Uses a fixed-width Multibyte encoding sequence.
C.Asian characters are represented in three characters.
D.Used a variable-width Multibyte encoding sequence.
E.European characters are represented on one or two bytes.
A.It can contain parameters with distinct values for each distance.
B.It can contain only parameters with identical values for each instance.
C.It must contain an IFILE parameter for each instance’s individual parameter file.
D.It must be located in the default location for the primary instance’s parameter file.
A.Data blocks have to be written more frequently by DBWR.
B.Redo blocks have to be written more frequently by LGWR.
C.You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records.
D.You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
最新试题
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?()
Which Oracle background process frees SGA resources that were allocated to a user process that failed?()
Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()
The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
What is the maximum database block size supported for the Oracle9i database?()
Which of the following commands cannot be executed when the database open?()
After a number of days set by the parameter CONTROL_FILE_RECORD_KEEP_TIME, the information in the control file is overwritten by RMAN. What is this parameter’s default value?()
As a result of a media failure, the current online redo log group is corrupted. The database crashes, as the current online group is inaccessible. Which type of incomplete recovery are you most likely to perform? ()
Which script must you to query to display the code associated with RMAN stored scripts?()