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.
A.The standby database is protected against write operations.
B.The primary database is protected against write operations.
C.The primary database is protected against data loss and data divergence.
D.The standby database is protected against data loss and data divergence.
最新试题
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?()
Which script must you to query to display the code associated with RMAN stored scripts?()
As A DBA, which of the following methods can you use to make a backup of your table?()
Which of the following roles must be granted to a user to perform a full database import?()
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation?()
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? ()
SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario?()
You are configuring the listener on your server. Which listener.ora parameter contains the information needed to detect session requests from different client types?()
Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file?()
Which data dictionary views displays the error information related to a data file, when an internal read fails on that file?()