单选题To allocate another role to a user, which command is most appropriate?（）A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT

第1题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in

第2题：

Examine the command： SQL> ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）

• A、The SKD user cannot log in to the database instance.
• B、The objects owned by the SKD user are not accessible to any user.
• C、The other users can access the objects owned by the SKD user， on which they have access.
• D、The password for the SKD user expires and the user is forced to change the password at the next log in.

第3题：

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

第4题：

To allocate another role to a user, which command is most appropriate?（）

• A、ALTER USER 
• B、ALTER DATABASE 
• C、ALTER SYSTEM 
• D、GRANT

第5题：

After the recovery is complete， which command should you execute？（）

• A、ALTER DATABASE OPEN；
• B、ALTER DATABASE CLEAR LOGFILE；
• C、ALTER DATABASE OPEN RESETLOGS；
• D、ALTER DATABASE OPEN NORESETLOGS；

第6题：

Which command will result in a trace file being created with the create controlfile command contained in it？（）  

• A、 alter database backup controlfile
• B、 alter database backup controlfile to trace
• C、 alter database controlfile backup
• D、 alter database controlfile backup to ’/ora01/oracle/ctrl_backup.ctl’
• E、 alter database begin controlfile backup

第7题：

User A executes the following command to update the TRANS table）  SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command on the TRANS table：   SQl> ALTER TABLE trans MODIFY （tr_type VARCHAR2 （3））；  What would happen in this scenario？（）

• A、The transaction for user A is rolled back.
• B、The ALTER TABLE command modifies the column successfully.
• C、The ALTER TABLE command fails due to the resource being busy.
• D、The ALTER TABLE command waits until user A ends the transaction.

第8题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, whichcommands must you execute to enable SCOTT to flash back the transactions? （）(Choose four.)

• A、ALTER DATABASE FLASHBACK ON;
• B、GRANT SELECT any transaction TO scott;
• C、GRANT EXECUTE ON dbms_flashback TO scott;
• D、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
• E、ALTER TABLESPACE undots1 RETENTION GUARANTEE;
• F、ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

第9题：

第10题：

第11题：

第12题：

第13题：

Which RMAN backup command is used to create the block-change tracking file？（）  

• A、 alter database create block change tracking file
• B、 alter database enable block change file
• C、 alter database enable block change tracking using file ，/ora01/opt/ block_change_tracking.fil
• D、 alter system enable block change tracking using file ’/ora01/opt/block_ change_tracking.fil’
• E、 alter system block change tracking on

第14题：

The DBA is defining role for users. Which of the following is not an acceptable method for defining a default role?（）

• 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

第15题：

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?（）

• A、ALTER DATABASE 
• B、ALTER SYSTEM 
• C、ALTER USER 
• D、ALTER REDO LOG

第16题：

One of the users in the PROD database， Adams， complains that his update on the table， TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions， and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority. Which method would you use to overcome this problem？（）

• A、execute the command， ALTER SESSION KILL ..， to kill the blocking session
• B、execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
• C、execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
• D、execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
• E、execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session

第17题：

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA， which commands must you execute to enable SCOTT to flash back the transactions？（）

• A、 ALTER DATABASE FLASHBACK ON
• B、 GRANT SELECT any transaction TO scott
• C、 GRANT EXECUTE ON dbms_flashback TO scott
• D、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA
• E、 ALTER TABLESPACE undots1 RETENTION GUARANTEE
• F、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA （PRIMARY KEY） COLUMNS

第18题：

You have been asked to create three users， PUB1， PUB2 and PUB3， for three newly hired employees and to allocate unlimited quota on their default tablespace PUBLISHER_TBS with no other privileges. After creating the users， which method can you use for granting the required privileges？（）

• A、grant CONNECT role to all of the three users
• B、grant RESOURCE role to all of the three users
• C、grant both CONNECT and RESOURCE role to all of the three users
• D、execute ALTER USER .. QUOTA UNLIMITED ON publisher_tbs command for all of the three users
• E、create role with UNLIMITED TABLESPACE system privilege and assign the role to all of the three users

第19题：

The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）

• A、 use the ALTER SYSTEM command to change the time zone
• B、 use the ALTER SESSION command to change the time zone
• C、 use the ALTER DATABASE command to change the time zone
• D、 set the value for the operating system variable ORA_SDTZ on the client machine
• E、 set the value for the operating system variable ORA_SDTZ on the database server machine

第20题：

Which is the correct command to put the database in ARCHIVELOG mode？（）  

• A、 alter database archivelog
• B、 alter system enable archivelog mode
• C、 alter database enable archive
• D、 alter database archivelog enable
• E、 None of the above

第21题：

第22题：

第23题：