[2023] 1z1-116 PDF Questions – Perfect Prospect To Go With ActualTorrent Practice Exam [Q49-Q71]

NO.49 Examine this output:

Which three are true?

John must connect as system to perform backup and recovery operations.

John can query dba tables.

John can perform backup and recovery operations by using SQL.

John can perform backup and recovery operations by using RMAN.

John must connect as sys to perform backup and recovery operations.

John Is not able to perform startup and shutdown operations.

John can query other user’s data.

NO.50 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?

The storage quota has been reached for the ATP database.

The create TABLESAPECE statement is not available in ATP.

There is not enough storage available in the ATP database.

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

Database Vault prevents you from executing this command.

NO.51 Database Vault realm r protects all tables In the fin schema from DBA access User fin is configured as the owner in realm R.
You must also prevent access to realm r protected tables by user FIN. Which achieves this?

Revoke the select any table privilege from user FIN.

Make realm R a mandatory realm.

Remove the owner authorization of user fin in realm R.

Make user FIN participant In realm r. Instead of owner.

NO.52 Examine this command :
GRANT EXEMPT ACCESS POLICY TO PUBLIC;
Which Transparent Sensitive Data Protection functionality will be affected when this command is executed?

Data Redaction

Bind Masking

Virtual Private Database

Transparent Data Encryption

NO.53 Which two are true about auditing in an Oracle Database?

SYS logon operations are always audited In unified auditing.

All SYS operations are audited by default in unified auditing.

No SYS operations are audited by default In unified auditing.

SYS logon operations are always audited in mixed mode auditing.

No SYS operations are audited if audit_sys_operations is set on false in unified auditing.

No SYS operations are audited if audit_sys_operations is set on false in mixed mode auditing.

NO.54 You Issue this statement as user SYS:
audit, context namespace kilimanjaro attributes a, b;
Which is true?

The statement will audit all users.

The statement will not audit any users.

The statement will only audit sys.

The statement must be updated to specify which users to audit.

NO.55 Which two statements are true about column-level transparent data encryption?

It can bo used for tables in encrypted tablcspaces.

encrypted columns cannot have an Index.

All encrypted columns of a table use the same encryption key.

Column level encrypted data remains encrypted in the buffer cache.

Column-level encryption keys are not encrypted by the master key.

NO.56 Which statement is true about Network ACLs?

They ate used to control access by users to external network services and resources from the database through PL/SQL.

They are used to provide access to database packages.

They are used to control the usage of UTL_TCP, ITL_HTTP, and UTL_INADDR.

They are used to configure proxy for PL/SQL network utility packages.

NO.57 Which two privileges can be restricted at the column level?

SELECT

INSERT

REVOKE

UPDATE

GRANT

DELETE

NO.58 An audit administrator wants to log Client Context variables In the audit trail.
Examine this query and the output:

AUDIT CONTEXT NAMESPACE hr_Ct:x ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES ALL BY hr;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id NAMESPACE USERENV ATTRIBUTES current:_user( db_name BY hr;

CREATE AUDIT POLICY hr_omp_pol ACTIONS UPDATE ON hr.employoes;

AUDIT CONTEXT NAMESPACE hr_ctx ATTRIBUTES hr_app_id, current_user, db_name BY hr

AUDIT POLICY hr_emp_pol BY hr;

CREATE AUDIT POLICY hr_emp_pol ACTIONS SELECT ON hr. employees;

AUDIT POLICY hr_emp_pol EXCEPT hr;

NO.59 Using Unified Audit, you must determine who performed an pkan backup ot recovery operations on a database.
You are connected as sysdba.
Which statement(s) achieve this?
A)

B)

C)

D)

E)

Option A

Option B

Option C

Option D

Option E

NO.60 Examine this sqlnet.ora file used by a client application:

Which three are found in the wallet specified by the directory parameter?

the private key of the database service

the trusted certificates of the database service

the user certificate used to uniquely Identify the database service

the private key of the client application

the username, password, and service name required to connect to the database

the user certificate used to uniquely Identify the client application

the trusted certificates of the Certification Authority

NO.61 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?

Grant become user to dbai.

Grant sysoper to both users.

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

Grant imp_full_database and exp_full_database to dbai and dba2.

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

Grant become user to dba2.

Grant sysdba to both users.

NO.62 You configured Kerberos authentication for databases running on servers A and B.
However a database link connecting the database on server A to the database on server B fails with ORA-12638 Credential retrieval failed.
Where must you make a change to sqlnet.ora to allow the database link to use its stored credentials Instead of trying to use Kerberos?

on client side of server B

on client side of server A

on server side of server B

on server side of server A

NO.63 If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?

none of the columns

foreign key columns only

the primary and foreign key columns

columns with any type of constraint

the primary key column only

NO.64 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?

Configure liscener.oia with an endpolnt for tcps

Configure sqinet.ora with parameter sq.lnet.encrypt70N_server

Download the root certificate from the Certificate Authority In Base64 format

Configure sqlnet. ora with parameter tcp . invited_nodes

Download the trusted certificate of the web server in Base64 format a

Configure an Oracle wallet using mkstore or Wallet Manager

Configure access control lists using DBMS_NETWORK_ACL._ADMIN

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

application

host Infrastructure

network

data

physical

guest OS

virtualization

database

NO.66 Which four products, features, or methods can help facilitate compliance with various privacy-related regulatory requirements such as PCI-DSS and the EU GDPR?

Data Redaction

Data Guard

Real Application Clusters

Transparent Data Encryption

Data Masking & Subsetting

Table Partitioning

Database Vault

GoldenGate

Oracle Sharding

Real Application Testing

NO.67 Which two statements are true about Database Vault factors?

A factor can reference a function In another schema to compute its value, provided execute privilege Is granted to the sys user.

Changing a factor type can change how factors are evaluated.

You can configure a factor to be evaluated only once per session.

You get an error at the time of factor creation If the retrieval method function you have specified does not exist.

You can use a factor to enforce conditions for a command rule.

NO.68 When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?

You do not have select privileges on this database view.

The master key has been corrupted.

The key store is not open.

The master key has not been created.

This is expected behavior for this view.

NO.69 Examine this command:

What masking definitions does it list?

All with the name credit and the commands to deploy them on all databases with names starting with test.

All with names starting with credit and created on databases with names starting with test.

All with the name credit and created on databases with name starting with teat.

All with names starting with credit and created on any database.

All with the name credit and the commands to deploy them on a database with the name test.

NO.70 User jane must report on who has done RMAN backups on a database that has Unified Auditing enabled.
What is the minimum that must be done to allow JANE to generate these reports?

Use create audit policy.

Use grant audit_admin to Jane;

Use grant audit_viewer to Jane;

Use alter system set AUDIT_SYS_OPERATION= TRUE;

NO.71 Examine this configuration and requirement:
1. The hr user created a private database link in the pdb2 pluggable database linking to the hr schema In the PDBl pluggable database.
2. Other users in pdb2 must query the remote HR.EMPLOYEES table In PDBI using this database link.
Which two operations together ensure that the database link provides access only to the HR.EMPLOYEES table in the PDBI pluggable database?

Only grant other users access to the HR.EMPLOYEES table In the pdb2 pluggable database.

Grant other users access to the database link in the PDBI pluggable database.

Grant access to the view of the remote HR.EMPLOYEES table In the PDB2 pluggable database.

Grant other users access to the database link In the PDB2 pluggable database.

Create a view In the HR schema for the remote hr. employees table of the pdb2 pluggable database .

[2023] 1z1-116 PDF Questions – Perfect Prospect To Go With ActualTorrent Practice Exam [Q49-Q71]

Be the first to reply

Leave a Reply Cancel reply