A.ALTER USER
B.ALTER DATABASE
C.ALTER SYSTEM
D.GRANT
您可能感兴趣的试卷
你可能感兴趣的试题
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
最新试题
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?()
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 creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?()
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 have implemented OMF for redo log management. Which of the following choices reflects a log filename that might be employed when OMF is enabled?()
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?()
In order to find out how many database objects a user has created, which view would the DBA query in the Oracle data dictionary? ()
You are attempting to clear an unarchived redo log file. In order to manually enact a log switch, which of the following statements is appropriate?()
To allocate another role to a user, which command is most appropriate?()
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?()