网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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


参考答案

参考解析
解析: 暂无解析
更多 “多选题Which two roles or privileges must you have to export tables owned by another user?()ACREATE USERBCREATE SESSIONCCREATE ANY TABLEDIMP_FULL_DATABASEEEXP_FULL_DATABASE” 相关考题
考题 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.

考题 Which two roles or privileges must you have to export tables owned by another user?()A、CREATE USERB、CREATE SESSIONC、CREATE ANY TABLED、IMP_FULL_DATABASEE、EXP_FULL_DATABASE

考题 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 folderB、Open Microsoft Outlook and modify Read Receipt SettingsC、Open Microsoft Outlook and modify Delivery Receipt SettingsD、Open the ECP and select Organize E-Mail

考题 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.

考题 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

考题 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

考题 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、SYSDBAB、SYSOPERC、No system privileges are required for the RMAN user.D、Only SYS user can connect and execute RMAN commands on a target database.

考题 Which of the following roles must be granted to a user to perform a full database import?()A、CONNECTB、IMP_FULL_DATABASEC、FULL_EXPORT_PRIVSD、RESOURCEE、FULL_IMPORT_PRIVS

考题 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.

考题 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.

考题 What are two reasons to create synonyms? ()A、You have too many tables.B、Your tables are too long.C、Your tables have difficult names.D、You want to work on your own tables.E、You want to use another schema's tables.F、You have too many columns in your tables.

考题 Which of the following restrictions are not true with respect to tablespace point-in-time recovery?()A、 The target database must be in NOARCHIVELOG mode.B、 No backup is required of the database before you perform a TSPITR.C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.D、 If you rename a tablespace, you can not perform a TSPITR to any point in time before that rename operation occurred.E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2,then you must transport both tablespaces.

考题 Which two statements accurately describe a role?()A、A role can be given to a maximum of 1000 users.B、A user can have access to a maximum of 10 roles.C、A role can have a maximum of 100 privileges contained in it.D、Privileges are given to a role by using the CREATE ROLE statement.E、A role is a named group of related privileges that can be granted to the user.F、A user can have access to several roles, and several users can be assigned the same role.

考题 You executed the following command to drop a user: DROP USER scott CASCADE; Which two statements regarding the above command are correct?()A、All the objects of scott are moved to the Recycle Bin.B、Any objects in the Recycle Bin belonging to scott are purged.C、All the objects owned by scott are permanently dropped from the database.D、All the objects of scott in the Recycle Bin must be purged before executing the DROP command.E、Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command.

考题 Which two statements are true about the roles in the Oracle database?()A、A role can be granted to itself.B、Roles are owned by the SYS user.C、Roles can be granted to other roles.D、A role cannot be assigned external authentication.E、A role can contain both system and object privileges.

考题 You have two Exchange Server 2010 Mailbox servers named Server1 and Server2.You need to move a users mailbox from Server 1 to Server 2.Your solution must minimize down time for the user.Which cmdlet should you run?()A、Move-MailboxB、Export-MailboxC、Set-MoveRequestD、New-MoveRequest

考题 You have two Exchange Server 2010 Mailbox named Server1 and Server2.You need to move a user’s mailbox from Server1 to Server2.Your solution must minimize downtime for the user.Which cmdlet you run?()A、Move Mailbox.B、Export Mailbox.C、Set Moverequest.D、New Moverequest.

考题 单选题Which of the following roles must be granted to a user to perform a full database import?()A CONNECTB IMP_FULL_DATABASEC FULL_EXPORT_PRIVSD RESOURCEE FULL_IMPORT_PRIVS

考题 多选题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

考题 多选题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?()AEnsure that the stored procedure and the tables are owned by users that are associated with the same SQL Server login.BEnsure that the stored procedure and the tables are owned by the same database user.CEnsure that the stored procedure and the tables use the same database schema.DConfigure the multiuser database option on both databases.EConfigure the cross-database ownership chaining option on both databases.

考题 多选题You are decommissioning domain controllers that hold all forest-wide operations master roles.  You need to transfer all forest-wide operations master roles to another domain controller.  Which two roles should you transfer()ARID masterBPDC emulatorCSchema masterDInfrastructure masterEDomain naming master

考题 单选题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.

考题 多选题Which two statements are true about the roles in the Oracle database?()AA role can be granted to itself.BRoles are owned by the SYS user.CRoles can be granted to other roles.DA role cannot be assigned external authentication.EA role can contain both system and object privileges.

考题 多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery?()AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace, you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2,then you must transport both tablespaces.

考题 多选题Which two statements accurately describe a role?()AA role can be given to a maximum of 1000 users.BA user can have access to a maximum of 10 roles.CA role can have a maximum of 100 privileges contained in it.DPrivileges are given to a role by using the CREATE ROLE statement.EA role is a named group of related privileges that can be granted to the user.FA user can have access to several roles, and several users can be assigned the same role.

考题 多选题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.

考题 多选题Which two roles or privileges must you have to export tables owned by another user?()ACREATE USERBCREATE SESSIONCCREATE ANY TABLEDIMP_FULL_DATABASEEEXP_FULL_DATABASE

考题 多选题You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?()AEnable supplemental logging for the database.BSpecify undo retention guarantee for the database.CCreate a Flashback Data Archive in the tablespace where the tables are stored.DCreate a Flashback Data Archive in any suitable tablespace.EEnable Flashback Data Archiving for the tables that require tracking