多选题Which two roles or privileges must you have to export tables owned by another user？（）ACREATE USERBCREATE SESSIONCCREATE ANY TABLEDIMP_FULL_DATABASEEEXP_FULL_DATABASE

第1题：

You have an Organization 2010.Internal user named User1 sends a confidential message to another internal user named User2.User1 does not have any administrative privileges in theory. You need to ensure User1 can identify whether the message was successfully delivered？. What should you instruct User1 to do？（）

• A、View the message headers in the sent item folder
• B、Open Microsoft Outlook and modify Read Receipt Settings
• C、Open Microsoft Outlook and modify Delivery Receipt Settings
• D、Open the ECP and select Organize E-Mail

第2题：

You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）

• A、One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
• B、One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
• C、One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
• D、One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
• E、One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

第3题：

第4题：

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.

第5题：

You are ready to implement RMAN in the backup and recover strategy for your company. Which system privilege must the RMAN user have to be able to connect and execute RMAN commands on a target database？（）

• A、SYSDBA
• B、SYSOPER
• C、No system privileges are required for the RMAN user.
• D、Only SYS user can connect and execute RMAN commands on a target database.

第6题：

You need to ensure that the stored procedure that inserts new loan requests can access data in tables that are stored in another database on the same SQL Server instance. Which two actions should you perform?（）

• A、Ensure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.
• B、Ensure that the stored procedure and the tables are owned by the same database user.
• C、Ensure that the stored procedure and the tables use the same database schema.
• D、Configure the multiuser database option on both databases.
• E、Configure the cross-database ownership chaining option on both databases.

第7题：

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

第8题：

Which two roles or privileges must you have to export tables owned by another user？（）

• A、CREATE USER
• B、CREATE SESSION
• C、CREATE ANY TABLE
• D、IMP_FULL_DATABASE
• E、EXP_FULL_DATABASE

第9题：

Which of the following roles must be granted to a user to perform a full database import？（）

• A、CONNECT
• B、IMP_FULL_DATABASE
• C、FULL_EXPORT_PRIVS
• D、RESOURCE
• E、FULL_IMPORT_PRIVS

第10题：

What is necessary for your query on an existing view to execute successfully? （）

• A、The underlying tables must have data.
• B、You need SELECT privileges on the view.
• C、The underlying tables must be in the same schema.
• D、You need SELECT privileges only on the underlying tables.