ALTER USER
ALTER DATABASE
ALTER SYSTEM
GRANT
单选题To allocate another role to a user, which command is most appropriate?()A ALTER USER B ALTER DATABASE C ALTER SYSTEM D GRANT
点击查看答案
单选题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 sessionB execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionC execute the command, ALTER SYSTEM KILL SESSION .., to kill the blocking sessionD execute the command, ALTER SESSION UNLOCK .., to release the lock for the blocking sessionE execute the command, ALTER SYSTEM UNLOCK SESSION .., to release the lock for the blocking session
单选题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 optionC 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
单选题Which is the correct command to put the database in ARCHIVELOG mode?()Aalter database archivelogBalter system enable archivelog modeCalter database enable archiveDalter database archivelog enableENone of the above
单选题Which command is used to open the database after an incomplete recovery?()Aalter database openBalter database open repairlogCalter database open resetlogsDalter database open resetlogEalter database resetlogs open
单选题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.
单选题If you issue the command shutdown abort prior to trying to put the database in ARCHIVELOG mode, what will be the result when you issue the command alter database archivelog?()AThe alter database archivelog command will failBThe alter database archivelog inconsistent command must be used to put the database in ARCHIVELOG modeCThe alter database archivelog command will succeedDThe alter database archivelog command will ask if you want to make the database consistent firstEThere is no alter database archivelog command. The correct command is alter database alterlogging