A.ALTER DATABASE
B.ALTER SYSTEM
C.ALTER USER
D.ALTER REDO LOG
您可能感兴趣的试卷
你可能感兴趣的试题
A.Writes buffers to disk
B.Writes current redo log number to datafile headers
C.Writes redo log information to disk
D.Reads information into memory for users
A.ALTER USER DEFAULT ROLE ALL
B.ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1
C.ALTER USER DEFAULT ROLE NONE
D.ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
A.LOGICAL_READS_PER_SESSION
B.CONNECT_TIME
C.COMPOSITE_LIMIT
D.CPU_PER_SESSION
E.PRIVATE_SGA
A.Nothing happens
B.Oracle will automatically switch redo logs when detected
C.Oracle eventually won't allow new records to be added to the database
D.The instance crashes
A.Library cache
B.Row cache
C.Dictionary cache
D.Large area
E.Buffer cache
A.One tablespace has only one datafile
B.Many tablespaces can share one datafile
C.One tablespace can have many datafiles
D.One datafile can contain many tablespaces
A.DBW0
B.LGWR
C.ARCH
D.SMON
E.PMON
A.OPTIMAL
B.INITIAL
C.PCTINCREASE
D.NEXT
A.Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B.Make a copy of the control file with the database shut down
C.Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D.Make a copy of the control file with the database still running
A.V$DATABASE
B.DBA_TABLES
C.SYSAUD$
D.EMP
最新试题
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?（）
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? （）
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?（）
You are trying to alter the initial segment size given to a table in a dictionary-managed tablespace. Which of the following keywords would be used as part of this process?（）
Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? （）
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?（）
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）
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?（）
You have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?（）