ALTER USER
ALTER DATABASE
ALTER SYSTEM
GRANT
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 ALLB、ALTER USER DEFAULT ROLE ALL EXCEPT ROLE_1C、ALTER USER DEFAULT ROLE NONED、ALTER USER DEFAULT ROLE NONE EXCEPT ROLE_1
点击查看答案
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
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
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
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;
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 ONB、 GRANT SELECT any transaction TO scottC、 GRANT EXECUTE ON dbms_flashback TO scottD、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATAE、 ALTER TABLESPACE undots1 RETENTION GUARANTEEF、 ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS