网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
Which two are prerequisites for performing a flashback transaction?()
A. Flashback Database must be enabled.B. Undo retention guarantee for the database must be configured.C. EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D. Supplemental logging must be enabled.E. Recycle bin must be enabled for the database.F. Block change tracking must be enabled tor the database.
考题
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?()
A.TableB.ColumnsC.Table and AliasD.Columns and Alias
考题
Which of the following is true of an index used to support a UNIQUE constraint?()
A.It must have the UNIQUE attribute.B.It cannot be created explicitly by the user.C.It must have the UNIQUE and CLUSTER attributes.D.It must have the UNIQUE WHERE NOT NULL attribute.
考题
Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A、The user must be granted the database administrator （DBA） privilege.B、The user must be listed in the password file for the authentication.C、No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.D、Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
考题
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
考题
The RVPC user can do which of the following？（）A、 Register databases if granted the register database privilegeB、 See all databases in the recovery-catalog schemaC、 See all database-related metadata in the recovery catalog if they are granted access to that databaseD、 Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with the grant commandE、 Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
考题
A user would like to have a roaming profile configured. Which of the following is necessary when setting up a roaming profile? （）(Select TWO).A、The user must configure the settings.B、Roaming profile must be stored on every client.C、The user must be on a domain.D、Roaming profile has to be stored on a network server.E、The user must have an IP address on their client.
考题
A user wants to be able to receive help from a coworker that is located outside the company’s local office. Which of the following MUST be enabled to allow the user to watch and interact with the coworker simultaneously?（）A、Remote DesktopB、TelnetC、Computer ManagementD、Remote Assistance
考题
Which of the following WebSphere Commerce user roles can create new customer care queues？（）A、Account RepresentativeB、Customer Service RepresentativeC、Logistics ManagerD、Customer Service Supervisor
考题
A user utilizing an alias to update a subset of columns in a table must have UPDATE privileges on which of the following DB2 objects?（）A、TableB、ColumnsC、Table and AliasD、Columns and Alias
考题
View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）A、The user must enable the role explicitly.B、The user can grant the role to other users.C、The user cannot use the role until the DBA enables it explicitly.D、The user can start using the role immediately without any changes
考题
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
考题
Which two are prerequisites for performing a flashback transaction?（）A、Flashback Database must be enabled.B、Undo retention guarantee for the database must be configured.C、EXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.D、Supplemental logging must be enabled.E、Recycle bin must be enabled for the database.F、Block change tracking must be enabled tor the database.
考题
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.
考题
Which of the following is true of an index used to support a UNIQUE constraint?（）A、It must have the UNIQUE attribute.B、It cannot be created explicitly by the user.C、It must have the UNIQUE and CLUSTER attributes.D、It must have the UNIQUE WHERE NOT NULL attribute.
考题
单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）A
The user must have been granted the DBA role.B
The user must have been granted the switch privilege as a part of a role.C
The user must have been granted the Resource Manager administrator privilege.D
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
考题
单选题Which of the following roles provides the privileges to maintain and query the recovery catalog schema？（）A
EXECUTE_CATALOG_ROLEB
CONNECTC
RESOURCED
RECOVERY_CATALOG_OWNERE
RECOVERY_CATALOG_USER
考题
单选题View the Exhibit to observe the roles assigned to the SL_REP user. Which statement is true about theassignment of the SELECT_CATALOG_ROLE role to the SL_REP user（）A
The user must enable the role explicitly.B
The user can grant the role to other users.C
The user cannot use the role until the DBA enables it explicitly.D
The user can start using the role immediately without any changes
考题
多选题Which two roles or privileges must you have to export tables owned by another user？（）ACREATE USERBCREATE SESSIONCCREATE ANY TABLEDIMP_FULL_DATABASEEEXP_FULL_DATABASE
考题
多选题Which three statements are true about the working of system privileges in a multitenant control database(CDB) that has pluggable databases (PDBs)?（）ASystem privileges apply only to the PDB in which they are used.BLocal users cannot use local system privileges on the schema of a common user.CThe granter of system privileges must possess the set container privilege.DCommon users connected to a PDB can exercise privileges across other PDBs.ESystem privileges with the with grant option container all clause must be granted to a common user before the common user can grant privileges to other users.
考题
多选题Which two are prerequisites for performing a flashback transaction?（）AFlashback Database must be enabled.BUndo retention guarantee for the database must be configured.CEXECUTE privilege on the DBMS_FLASHBACK package must be granted to the user flashing back transaction.DSupplemental logging must be enabled.ERecycle bin must be enabled for the database.FBlock change tracking must be enabled tor the database.
考题
单选题Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）A
The user must have been granted the DBA role.B
The user must have been granted the switch privilege as a part of a role.C
The user must have been granted the Resource Manager administrator privilege.D
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
考题
多选题Which are the prerequisites for performing flashback transactions on your database？（）AUndo retention guarantee for the database must be configured.BSupplemental log must be enabled for the primary key.CSupplemental log must be enabled.DExecute permission on the DBMS_FLASHBACK package must be granted to the user.
考题
多选题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.
考题
多选题A user would like to have a roaming profile configured. Which of the following is necessary when setting up a roaming profile? （）(Select TWO).AThe user must configure the settings.BRoaming profile must be stored on every client.CThe user must be on a domain.DRoaming profile has to be stored on a network server.EThe user must have an IP address on their client.
考题
多选题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.
考题
单选题Which step do you need to perform to enable a user with the SYSDBA privilege to log in as SYSDBA in iSQL*Plus？（）A
The user must be granted the database administrator （DBA） privilege.B
The user must be listed in the password file for the authentication.C
No special setup is needed for the user to connect as SYSDBA in iSQL*Plus.D
Set up a user in the Oracle Application Server Containers for J2EE （OC4J） user manager，and grant the webDba role to the user.
热门标签
最新试卷
