多项选择题Which two roles or privileges must you have to export tables owned by another user?()

A.CREATE USER
B.CREATE SESSION
C.CREATE ANY TABLE
D.IMP_FULL_DATABASE
E.EXP_FULL_DATABASE


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题In which three cases does a checkpoint occur? ()

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.

2.单项选择题What is true regarding direct-load insert?()

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.

3.多项选择题A web browser can connect directly to an Oracle server using which two?()

A.HTTP
B.IIOP
C.TCP/IP
D.Named Pipes
E.TCP/IP with SSL

5.多项选择题

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.

7.多项选择题Which two statements are true regarding the use of UTF-16 encoding? ()

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. 

8.单项选择题What is true regarding a shared, server-side parameter file for a Real Application Cluster database? ()

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.

9.单项选择题Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance?()

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?()

题型:单项选择题