1Z0-116 by Oracle Actual Free Exam Questions And Answers

Question 1

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?

A. on client side of server B

B. on client side of server A

C. on server side of server A

D. on server side of server B

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which statement is true about Network ACLs?

A. They are used to provide access to database packages.

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

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

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

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Fast2test members. You can sign-up / login (it's free).

Question 3

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?

A. SQLNET.ALLOWED_LOGON_VERSION_sebveb = 8 In the aqlnec.ora of the new database homo.

B. SQLNET.ALLOWED_LOGON_VERSION_SERVER = 12a in the sqlnet.ora of the new database home

C. SQLNET.ALLOWED_LOGON_VERSION_client = 8 in the sqlnec.ora file of the client application.

D. Client net. allowed_lLOGON_VERSION_client must be set to a lower value than the server SQLNET.ALLOWED LOGON. VEBSION .SERVER.

Discussion 0

Correct Answer: A Vote an answer

Question 4

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?

A. Configure access control lists using DBMS_NETWORK_ACL._ADMIN

B. Configure an Oracle wallet using mkstore or Wallet Manager

C. Configure liscener.oia with an endpolnt for tcps

D. Configure sqlnet. ora with parameter tcp . invited_nodes

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

F. Configure sqinet.ora with parameter sq.lnet.encrypt70N_server

G. Download the root certificate from the Certificate Authority In Base64 format

Discussion 0

Correct Answer: B,D,F Vote an answer

Question 5

Which two statements are true about Valid Node Checking for Registration (VNCR)?

A. It can only be used with Oracle RAC.

B. It restricts specific instances from registering with the Listener.

C. It denies Instance registration through IPC.

D. It is a replacement for Class of Secure Transport (COST).

E. It enforces the Listener connectivity through TCPS.

Discussion 0

Correct Answer: C,D Vote an answer

Question 6

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

A. Transparent Data Encryption

B. Virtual Private Database

C. Data Redaction

D. Bind Masking

Discussion 0

Correct Answer: A Vote an answer

Question 7

You must restrict execution of the alter system checkpoint command to certain conditions, specified in a rule set used by a command rule.
Which two parameters must be specified In the dbms_macadm.create_command_rule procedure to do this?

A. COMMANI>=>' ALTER SYSTEM'

B. OBJECT_OWNER=>'SYS

C. OBJECT_NAME=>'CHECKPOINT'

D. CLAUSE_NAME=>'CHECKPOINT'

E. COMMAND=>'ALTER'

F. CLAUSE_NAME=>'SYSTEM'

G. PARAMETER_NAM£=>'CHECKPOINT'

Discussion 0

Correct Answer: D,F Vote an answer

Question 8

For which two are Oracle Label Security policies not applied?

A. direct path exports

B. objects in the SYS schema

C. users with the SYSDA privilege other than sys

D. partitioned tables

E. conventional path exports

Discussion 0

Correct Answer: B,D Vote an answer

Question 9

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

A. Add or remove realm-protected objects to or from the reaim.

B. Add or remove realm-secured database roles to or from the realm.

C. Grant or revoke realm-secured database roles.

D. Grant or revoke privileges on realm-protected objects to or from other users.

E. Grant or revoke system privileges to access objects protected by the realm.

F. Add or remove owners to or from the realm.

G. Add or remove participants to or from the realm.

Discussion 0

Correct Answer: B,E Vote an answer

Question 10

What Is the first step when analyzing security within a database?

A. Mask nonproduction data using Data Masking & Subsetting

B. Execute Database Security Assessment Tool (DBSAT)

C. Deploy Oracle Key Vault

D. Create a Data Redaction Policy for your most sensitive tables

E. Configure and enable Database Vault

F. Encrypt tablespaces using Transparent Data Encryption

Discussion 0

Correct Answer: F Vote an answer

Oracle Database Security Administration - 1Z0-116 Exam Practice Test

Contact Us

Useful Links

Latest Updated