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.
A.An improved version of multithreaded server configuration.
B.A connection pooling configuration where several clients are connected to the same server process.
C.Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected.
D.A configuration of Real Application Cluster where the client connection is routed to the least busy instance.
最新试题
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 environment variables specifies a non-default location for the listener configuration file?()
If you CROSSCHECK the backup piece that was previously marked as EXPIRED but is now available, what would the status of this backup piece be in the RMAN repository?()
Which one of the following parameters must be specified when exporting objects that has integrity constraints referencing objects that are currently being accessed by other users?()
Which of the following dynamic view would you query to identify the online CURRENT redo log group?()
Which parameter allows SQL*Loader to load data into a table with the indexes in the unusable state, prior to the load operation?()
RMAN enables you to open the target database when it is already mounted. Which command must you execute at the RMAN prompt to open the database?()
Which one of the following files includes the parameter NAMES.DIRECTORY_PATH(hostname)?()
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?()