What is the net effect of the following command？（）   alter d

第1题：

Your database is started by using the server parameter file （SPFILE）. You issued this command to change the value of the LOG_BUFFER initialization parameter：  ALTER SYSTEM SET LOG_BUFFER=24M SCOPE=BOTH;  What would be the outcome of this command？（）

• A、The command would return an error because LOG_BUFFER is a static parameter.
• B、The parameter value would be changed and it would come into effect immediately.
• C、You need to restart the database so that parameter changes can come into effect.
• D、The command would succeed only if initialization parameter LOG_ARCHIVE_MAX_PROCESS is set to value 2.

第2题：

You just issued the following statement: ALTER TABLE SALES DROP COLUMN PROFIT. Which of the following choices identifies when the column will actually be removed from Oracle?（）

• A、Immediately following statement execution 
• B、After the ALTER TABLE DROP UNUSED COLUMNS command is issued 
• C、After the ALTER TABLE SET UNUSED COLUMN command is issued 
• D、After the ALTER TABLE MODIFY command is issued

第3题：

What are the basic configuration steps to enable IS - IS?（）

• A、Configure the net system - id command under routerisis and enable IS - IS on each interface with the ip router isis command.
• B、Configure the net sy stem - id and the network net - id commands under routerisis.
• C、Configure the network net - id command(s) under routerisis and enable IS - IS on each interface with the ip router isis command.
• D、Configure the network net - id command(s) and the is - type level -1- 2 command under routerisis.
• E、Configure the net system - id and the network net - id commands under routerisis and enable ISIS on each interface with the ip router isis command.

第4题：

You issued the following statement：   SQL>ALTER DATABASE ENABLE RESUMABLE TIMEOUT n；   What will be the result of issuing the above statement？（）

• A、The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command.
• B、 The command will not execute successfully because resumable space allocation is enabled at the session level.
• C、 The command will execute successfully and resumable space will be allocated at the session level.
• D、 The command will execute successfully and resumable space will be allocated at the instance level.

第5题：

When performing an online backup，what is the proper order of the following steps？（）   a. Issue the alter database end backup command. b. Back up the archived redo logs. c. Issue the alter database begin backup command.  d. Back up the database files.  e. Determine the beginning log sequence number. f. Determine the ending log sequence number.  g. Force a log switch with the alter system switch logfile command.

• A、a， b， c， d， e， f， g
• B、c， d， a， b， e， g， f
• C、f， d， b， g， a， c， e
• D、e， c， d， a， g， f， b
• E、a， f， b， g， e， c， d

第6题：

You executed the following command to back up the control file： ALTER DATABASE BACKUP CONTROLFILE TO TRACE； What do you find in the trace file？（）

• A、Image of the control file
• B、Location of the control file
• C、Contents of the control file in text format
• D、SQL command to re-create the database
• E、SQL command to re-create the control file
• F、Contents of the control file in binary format

第7题：

You execute the following command in your Certkiller .com production database to change the width of the CUST_NAME column of the CUSTOMERS table： ALTER TABLE customers  MODIFY （cust_nameVARCHAR2 （40）） /  When you execute the command， it displays the following error message：  ERROR at line 1：  ORA-00054： resource busy and acquire with NOWAIT specified  What could be the reason for the error message？（）

• A、The database instance is not available.
• B、The ALTER TABLE command does not have WAIT option
• C、The table or a row in the table is currently locked by another user session.
• D、The database instance is busy processing other user sessions commands.
• E、The CUSTOMERS table has no long running query active at the time when this request is made.
• F、The server process executing the ALTER TABLE command is busy with another command execution

第8题：

You execute the following command to change the status of the SALES tablespace：  SQL> ALTER TABLESPACE sales OFFLINE；  Which statements describe the effect of the command（）

• A、The tablespace would require recovery to go back online.
• B、A checkpoint is taken on all data files that are associated with the SALES tablespace.
• C、The sessions that subsequently try to access the objects in the SALES tablespace receive an error.
• D、The new status of the SALES tablespace is recorded in the control file when the database instance is closed.

第9题：

our database instance is started using the server parameter file （SPFILE）. You executed a command tochange the value of the LOG_BUFFER initialization parameter：ALTER SYSTEM SET LOG_BUFFER=32M SCOPE=BOTH； What would be the outcome of this command（）

• A、The command succeeds only if Automatic Memory Management is not enabled.
• B、The command succeeds， but you need to restart the database for changes to take effect.
• C、The command returns an error because the size of the redo log buffer cannot be changed dynamically.
• D、The parameter value is changed and it comes into effect as soon as space becomes available in theSystem Global Area （SGA）

第10题：

our database is in the MOUNT state and you execute the following command to open it：  ALTER DATABASE OPEN  What two actions are performed as a result of this command？（）

• A、All control files are opened.
• B、All redo log files are opened
• C、The password file is opened.
• D、The parameter file is opened.
• E、All online data files are opened.