多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in
多选题
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
参考解析
解析：
暂无解析
相关考题：
在oracle数据库中,执行下面的命令 SQL> ALTER USER skd ACCOUNT LOCK; 有关执行结果下面那两项描述正确?() A.SKD 用户的对象不能被任何用户访问B.用户SKD 密码过期，在下次登陆时强制用户修改密码C.用户SKD 不能登陆数据库实例D.其它用户可以访问SKD 用户的对象，当用户已经在访问对象的时候
假设数据库中创建了一个用户test,状态为锁定状态,需要使用SQL语句解除锁定,可以使用如下()语句。 A.ALTER USER test ACCOUNTB.ALTER USER test NOLOCKC.ALTER USER test ACCOUNT NOLOCKD.ALTER test ACCOUNT NOLOCK
更改oracle用户HR，使其变为不可用（锁定）状态（）A、UPDATE USER HR ACCOUNT DISABLEB、UPDATE USER HR ACCOUNT LOCKC、ALTER USER HR ACCOUNT DISABLED、ALTER USER HR ACCOUNT LOCK
在oracle数据库中，执行下面的命令SQLALTER USER skd ACCOUNT LOCK；有关执行结果下面那两项描述正确？（）A、SKD用户的对象不能被任何用户访问B、用户SKD密码过期，在下次登陆时强制用户修改密码C、用户SKD不能登陆数据库实例D、其它用户可以访问SKD用户的对象，当用户已经在访问对象的时候
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
Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）A、The table created by SKD is not accessible and SKD cannot create new tables.B、The tables created by SKD and HR remain， but both cannot create new tables.C、The table created by HR remains and HR still has the CREATE TABLE system privilege.D、The table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
To allocate another role to a user, which command is most appropriate?（）A、ALTER USER B、ALTER DATABASE C、ALTER SYSTEM D、GRANT
假设数据库中创建了一个用户test，状态为锁定状态，需要使用SQL语句解除锁定，可以使用如下（）语句。A、ALTER USER test ACCOUNTB、ALTER USER test NOLOCKC、ALTER USER test ACCOUNT NOLOCKD、ALTER test ACCOUNT NOLOCK
Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）A、It cancels all pending disk drops within the disk groupB、It restores disks that are being dropped as the result of a DROP DISKGROUP operationC、It mounts disks in the disk group for which the drop-disk operation has already been completedD、It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE、It adds previously dropped disks back into the disk group
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）A、UPDATE pets…B、SELECT….FROM petsC、INSERT INTO pets…D、ALTER TABLE pets…
You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）A、a domain user accountB、a local user accountC、the NETWORK SERVICE accountD、the LOCAL SYSTEM account
单选题To make audit information more productive， the DBA executes the following command before startingan audit operation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting thedatabase（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it.
单选题Examine the following steps performed on a database instance： 1：The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2：The SKD usercreates a table. 3：The SKD user grants theCREATETABLE system privilege to the HR user. 4：The HR user creates a table. 5：The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 is performed（）AThe table created by SKD isnot accessibleand SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated. How do you achieve this objective？（）Aby setting the SQL_TRACE parameter to FALSE in the parameter fileBby using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user sessionCby setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user sessionDby setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
单选题View the Exhibit and examine the parameters. 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 onthe TRANS table： SQL ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））； What would happen in this scenario（）A The ALTER TABLE command modifies the column successfully.B The DDL operation gets higher priority and transaction for user a is rolled back.C The ALTER TABLE command waits indefinitely until user a ends the transaction.D The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
单选题To make audit information more productive， the DBA executes the following command before starting an auditoperation： SQL ALTER SYSTEM SET AUDIT_TRAIL=DB，EXTENDED SCOPE=SPFILE； Which statement is true regarding the audit record generated when auditing starts after restarting Thedatabase（）AIt contains only the plan for the SQL statement executed by the user.BIt contains the SQL text executed by the user and the bind variables used with it.CIt contains the plan and statistics associated with the SQL statement executed by the user.DIt contains the plan for the SQL statement executed by the user and the bind variables used with it
单选题Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs. You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands: SQL SHUTDOWN IMMEDIATE SQL STARTUP MOUNT SQL FLASHBACK DATABASE to TIME “TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”; Examine following commands: 1. ALTER PLUGGABLE DATABASE ALL OPEN; 2. ALTER DATABASE OPEN; 3. ALTER DATABASE OPEN RESETLOGS; Which command or commands should you execute next to allow updates to the flashback back schema?（）AOnly 1BOnly 2COnly 3D3 and 1E1 and 2
单选题Examine the following ALTER command: SQL ALTER DISKGROUP dgroup1 UNDROP DISKS; What is the purpose of the command?（）AIt cancels all pending disk drops within the disk groupBIt restores disks that are being dropped as the result of a DROP DISKGROUP operationCIt mounts disks in the disk group for which the drop-disk operation has already been completedDIt restores all the dropped disks in the disk group for which the drop-disk operation has already been completedEIt adds previously dropped disks back into the disk group
单选题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？（）Aexecute the command， ALTER SESSION KILL ..， to kill the blocking sessionBexecute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking sessionCexecute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking sessionDexecute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking sessionEexecute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
单选题View the Exhibit and examine the privileges granted to the MGR_ROLE role. The user SKD has been grantedthe CONNECT and RESOURCE roles only. The database administrator （DBA） grants MGR_ROLE to the userSKD by executing the command： SQL GRANT MGR_ROLE TO SKD WITH ADMIN OPTION； Which statement is true about the user SKD afterhe/she is granted this role（）A The user SKD can grant only the MGR_ROLE role to other users， but not the privileges in it.B The user SKD can revoke the MGR_ROLE only from the users for whom he/she is the grantor.C The user SKD can grant the privileges in the MGR_ROLE role to other users， but not with ADMIN OPTION.D The user SKD can grant the privileges in the MGR_ROLE role to other users， but cannot revoke privilegesfrom them
单选题You are planning the configuration of SQL1.You need to use the most appropriate Windows account for the SQL Server service. Which account should you use？（）Aa domain user accountBa local user accountCthe NETWORK SERVICE accountDthe LOCAL SYSTEM account
单选题Examine the following steps performed on a database instance： 1. The DBA grants the CREATE TABLE system privilege to the SKD user with ADMIN OPTION. 2. The SKD user creates a table. 3. The SKD user grants the CREATE TABLE system privilege to the HR user. 4. The HR user creates a table. 5. The DBA revokes the CREATE TABLE system privilege from SKD. Which statement is true after step 5 isperformed（）AThe table created by SKD is not accessible and SKD cannot create new tables.BThe tables created by SKD and HR remain， but both cannot create new tables.CThe table created by HR remains and HR still has the CREATE TABLE system privilege.DThe table created by HR remains and HR can grant the CREATE TABLE system privilege to other users.
单选题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？（）AThe transaction for user A is rolled back.BThe ALTER TABLE command modifies the column successfully.CThe ALTER TABLE command fails due to the resource being busy.DThe ALTER TABLE command waits until user A ends the transaction.
多选题You are configuring SQL1 so that the distributed query in the Sales database can access data in the CRM database on SQL2. You create a linked server for SQL2， and you create a linked server login that uses impersonation.Now， you need to ask the network administrator to configure SQL1. Which two tasks should you ask the administrator to perform？（）AAdd the user account that is used by the SQL Server service to the local Administrators group.BEnable the Do not trust this user for delegation Active Domain property for the user account that is used by the SQL Server service.CCreate a Service Principal Name （SPN） for the user account that is used by the SQL Server service.DEnable the Trusted for delegation Active Domain property for the user account that is used by the SQL Server service.
单选题Examine the following ALTER command： SQL ALTER DISKGROUP dgroup1 UNDROP DISKS； What is the purpose of the command？（）A It cancels all pending disk drops within the disk group.B It restores disks that are being dropped as the result of a DROP DISKGROUP operationC It mounts disks in the disk group for which the drop-disk operation has already been co pletedD It restores all the dropped disks in the disk group for which the drop-disk operation has already been completedE It adds previously dropped disks back into the disk group
多选题Examine the command： SQL ALTER USER skd ACCOUNT LOCK； Which two statements are true after the command is executed（）AThe SKD user cannot log in to the database instance.BThe objects owned by the SKD user are not accessible to any user.CThe other users can access the objects owned by the SKD user， on which they have access.DThe password for the SKD user expires and the user is forced to change the password at the next log in.
单选题User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）AUPDATE pets…BSELECT….FROM petsCINSERT INTO pets…DALTER TABLE pets…