1z1-116無料問題集「Oracle Database Security Administration」

質問 1

Which two does the master key encrypt with Transparent Data Encryption?

（A）encrypted tablespace keys

（B）encrypted column keys

（C）encryption wallet

（D）temporary segments

（E）encrypted columns

（F）encrypted tablespaces

正解：C、D 解答を投票する

質問 2

You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?

（A）CREATE CONTEXT global_hr USING hr_pkg;

（B）CREATE CONTEXT global_hr USING hr_pkg INITIALIZED GLOBALLY;

（C）CREATE CONTEXT global_hr USING hr_pkg INITIALIZED EXTERNALLY;

（D）CREATE CONTEXT global_hr USING hr_pkg ACCESSED GLOBALLY;

正解：A 解答を投票する

質問 3

Which two authorization rights does a Database Vault realm owner have that a realm participant does not have?

（A）Add or remove realm-secured database roles to or from the realm.

（B）Grant or revoke privileges on realm-protected objects to or from other users.

（C）Grant or revoke system privileges to access objects protected by the realm.

（D）Add or remove owners to or from the realm.

（E）Add or remove participants to or from the realm.

（F）Add or remove realm-protected objects to or from the reaim.

（G）Grant or revoke realm-secured database roles.

正解：A、C 解答を投票する

質問 4

You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?

（A）mkstore

（B）netmgr

（C）dbca

（D）owm

（E）netca

（F）orapki

正解：C 解答を投票する

質問 5

Oracle Database Vault is enabled In the database. You have these requirements:
1. Database administrator dbai must export and import data from and to a non-protected schema.
2. Database administrator dba2 must export and Import data from and to a protected schema.
Which three options together satisfy these requirements?

（A）Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.

（B）Grant imp_full_database and exp_full_database to dbai and dba2.

（C）Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.

（D）Grant sysdba to both users.

（E）Grant sysoper to both users.

（F）Grant become user to dbai.

（G）Grant become user to dba2.

正解：A、C、F 解答を投票する

質問 6

Which two statements are true about running the Oracle Database Security Assessment Tool (DBSAT) Collector?

（A）It must connect to the database using a SYSDBA connection.

（B）It runs only on UNIX/Linux systems.

（C）It runs only on Windows systems.

（D）It must be run by an OS user with read permissions on files and directories under ORACLE_HOME.

（E）It must be run on the server that contains the database.

正解：C、D 解答を投票する

質問 7

Database Vault Is configured and enabled In the Oracle database.
Three users are granted the dba, dv_omneb, and dv_acctmgb roles.
There is a requirement to create a user who can:
1. Connect to the database Instance
2. Select from dictionary views
Which users can complete the operation to meet the requirement?

（A）users granted DBA and DV_OWNER roles

（B）users granted DV_ACCTMGR and DV_OWNER roles

（C）users granted DV_ACCTMGR and DBA roles

（D）users granted DV_OWNER role

正解：C 解答を投票する

質問 8

You must disable OS authentication for database administrative users on a RAC database.
Which option must you use to do this?

（A）Set sqlnet.aothentication_sebvices=(NONe» In sqlnet.ora on the database server.

（B）Set REMOTE_OS_AUTHENT = FALSE In the init.ora file.

（C）Remove all OS users from OS groups: osdba, osoper, osbackupdba, osdgdba, osrmdba, OSASMADMIN, OSASMDBA.

（D）Set REMOTE_LOGIH_PASSWORDFILE = EXCLUSIVE In the init.ora file.

正解：B 解答を投票する

質問 9

As an Autonomous Transaction Processing (ATP) database administrator, you want to extend the storage capacity In the database.
Examine this command and output from the database:

What is the reason for the error?

（A）The create TABLESAPECE statement is not available in ATP.

（B）Database Vault prevents you from executing this command.

（C）You must be explicitly granted the create TABLESPACE privilege in ATP.

（D）There is not enough storage available in the ATP database.

（E）The storage quota has been reached for the ATP database.

正解：D 解答を投票する

質問 10

You check the Risk Matrix of the latest Critical Patch Update (CPU).
One of the " Common Vulnerability and Exposure'' reports (CVEs) has Base Score that is above 9 in the Risk Matrix.
Which one is not a supported method to address this CVE?

（A）Upgrade to a new Release.

（B）Install a new Release Update.

（C）Request a one off patch exception from Oracle Support.

（D）Implement a workaround recommended by Oracle Support.

（E）Install a new Release Update Revision.

正解：C 解答を投票する

1z1-116 無料問題集「Oracle Database Security Administration」

弊社を連絡する

関連リンク

トップ試験