单项选择题You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?()

A.SYSTEM 
B.OUTLN 
C.INTERNAL 
D.SYS


您可能感兴趣的试卷

你可能感兴趣的试题

3.单项选择题You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()

A.When the instance is started 
B.When the database is mounted 
C.When the database is opened 
D.When the database is closed

4.单项选择题 A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?()

A.Acquire locks on table queried 
B.Generate redo for statement 
C.Fetch data from disk into memory 
D.Write changes to disk

6.单项选择题Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?()

A.One runs faster than the other
B.A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C.A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D.The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE

9.单项选择题In order to enable remote administration of users and tablespaces on an Oracle database, which of the following types of files must exist in the database?()

A.Password file 
B.Initialization file 
C.Datafile 
D.Control file 
E.Nothing - SYSDBA privileges are not required for these actions

最新试题

You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?()

题型:单项选择题

You are configuring your index to be stored in a tablespace. Which of the following storage parameters are NOT appropriate for indexes?()

题型:单项选择题

You are using the Database Configuration Assistant to configure your Oracle database. Which of the following terms pertains to the creation of an object from which creation of the other database can be based? ()

题型:单项选择题

In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?()

题型:单项选择题

You are managing the Oracle database. Which of the following choices correctly identifies when Oracle reads the contents of the init.ora file?()

题型:单项选择题

You are analyzing how Oracle processes user statements. SQL and PL/SQL parse information is stored in which of the following database memory areas? ()

题型:单项选择题

ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?()

题型:单项选择题

Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?()

题型:单项选择题

Which of the following datatypes are used in situations where you want an ordered set of data elements, where every element is the same datatype, and where you predefine the number of elements that appear in the set?()

题型:单项选择题

 A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?()

题型:单项选择题