[2022年12月23日]1z1-116練習試験問題集で試験99%合格率があります [Q40-Q62]

質問40、 You are the Service Consumer In the Cloud Shared Responsibility Model.
Which three are your responsibility when using the Infrastructure as a Service (IaaS)?

質問41、 Examine the statement:
CREATE BOLE hr_admin IDENTIFIED USING pac_mgr.hr_admin_rola_ch9ck;
Which three are true about the sec_mgr. hr_admin_role_check procedure?

質問42、 To avoid hard coding passwords in scripts, you have elected to create an external password store-Examine this list of steps:
1. Set the external password store wallet location.
ALTER SYSTEM SET EXTERNAL_KEYSTORE_CREDENTIAL_LOCATION = “/*tc/ORACLE/WALLETS/orcl/external_Btore” SCOPE c SPFILE;
2. Log in as a user who has syskm privileges.
3. Create an auto-logln keystore that contains the keystore password including the add secret clause.
ADMINISTER KEY MANAGEMENT ADD SECRET ‘password’
FOR CLIENT ‘TDE_WALLET’
TO LOCAL AUTO_LOGIH KEYSTORE ‘/etc/0RACLE/WALLETS/orcl/extemal_store’;
4. Restart the database instance as sysdba.
SHUTDOWN IMMEDIATE STARTUP
5. Create an auto-logln keystore that contains the keystore password.
ADMINISTER KEY MANAGEMENT
FOR CLIENT ‘TDE_WALLET’
TO LOCAL AUTO_L0GIN KEYSTORE ‘ /etc/ORACLE/WALLETS/orcl/external_store’ ;
6. Set an Encryption Key.
ADMINISTER KEY MANAGEMENT SET ENCRYPTION KEY IDENTIFIED BY keystore_password WITH BACKUP Identify the minimum number of steps in the correct order that must be performed to create the external password store.

質問43、 Which three authentication methods are available with Centrally Managed Users (CMU)?

質問44、 A DBA user created and configured this secure application role:

Why does the error occur?

質問45、 You are Implementing a security policy that makes use of the USERENV namespace.
Which USERRENV value does not change for the duration of a session?

質問46、 You are connected to an Oracle database Instance as a user with privileges to query the hr.employees table.
You are not exempt from any reduction policies.
Examine this query and result:

You implement this Data Redaction policy:

You re-execute the select statement.
What is the result?
A)

B)

C)

D)

E)

質問47、 Which statement can be used to force password complexity in the password file?

質問48、 Which three are true concerning command rules?

質問49、 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?

質問50、 Which two configurations can be used to protect sensitive data In a database?

質問51、 Which two statements are true about Database Vault factors?

質問52、 Examine these steps:
1. Run the DBSAT Collector
2. Run the DBSAT Discoverer
3. Run the DBSAT Reporter
Identify the minimum required steps for producing a report of schemas with sensitive data.

質問53、 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?

質問54、 Users and applications must be able to access a web server of type https using database package UTL_HTTP.
Which three are part of the configuration to make this possible?

質問55、 A policy predicate function Is associated with an enabled Virtual Private Database (VPD) policy for a table.
Which two arguments are passed to the function?

質問56、 Database Vault is configured and enabled in the database. You create a rule set to enforce security on the hr. employees table.
Examine these requirements:
1. Users working In hr department are allowed to view all rows In HR.EMPLOYEES.
2. hr managers are allowed to view, update, and delete data in In HR.EMPLOYEES.
3. Audit records are to be collected for every evaluation of the rule set.
Which two options are true when creating the rule set?

質問57、 While upgrading your Oracle database server from 10g to 19c, you want to ensure that the users can still connect with their current passwords after the upgrade.
What do you need to set explicitly for this purpose?

質問58、 Examine this list of capabilities:
1. You can automatically restrict common users from accessing pluggable database (PDB).
2. Enabling Database Vault Operations Control In cdbsroot does not automatically enable It In PDBs.
3. Any common user granted the dv_admin role can enable Database Vault Operations Control.
4. To enable Database Vault Operations Control, use the dbms_macadm.enable_app_protection.
5. Common users’ and Invokers’ right procedures that must access PDB local data can be added to an exception list.
6. To disable Database Vault Operations Control, use the dbms_macadm.disable_app_protection.
Which statements describe Database Vault Operations Control?

質問59、 Which two statements are true about Database Vault rules and rule sets?

質問60、 What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?

質問61、 Which type of masking directly masks and subsets data In a nonproduction database with minimal or no Impact on production environments?

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