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.
最新试题
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 data dictionary views displays the error information related to a data file, when an internal read fails on that file?()
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 dynamic performance view displays the information about the files associated with the locally managed temporary tablespaces in Oracle9i?()
Which of the following options would you choose to implement controlled access using remote authentication for your networks?()
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?()
The three tasks shown have been completed in order to configure a naming method: Task 1: Installed on server and client: Oracle Net Services, TCP/IP, TCP/IP protocol adaptor Task 2: Started default listener on port 1521 Task 3: Added global database name to the listener.ora file. Which naming method was configured?()
Where can you obtain information about full database backup set created using RMAN, if the control file was used as the repository?()
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 commands must be issued to remove a stored script from the recovery catalog?()