20:00

PDF|

Guide for Oracle Database Security Administration

Quiz Oracle Database Security Administration

Free Test
/ 10

Quiz

1/10
What does the Application Data Modeling module of the Oracle Data Masking and Subsetting Pack search for?
Select the answer
1 correct answer
A.
data redaction policies
B.
data masking transformations
C.
parent/child relationships between the columns holding sensitive information
D.
encrypted columns

Quiz

2/10
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?
Select the answer
2 correct answers
A.
One rule set contains two rules OR'ed together.
B.
The rule set parameter audit_options must be set to dbms_macutl.g_ruleset_audtt_fail.
C.
The rule set must be defined as is_static.
D.
The rule set parameter eval_options must be set to dbms_macutl.g_ruleset_eval_all.
E.
The rule set parameter audit_options must be set to dbms_macutl.g_buleset_audit_fail + DBMS MACUTL.G RULESET AUDIT SUCCESS.

Quiz

3/10
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.
Select the answer
1 correct answer
A.
2,1,3,4
B.
1,2,5,4
C.
1,2,3,6,4
D.
1,2,6,3,5
E.
2,3,6,4
F.
1,2,3,4

Quiz

4/10
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?
Select the answer
3 correct answers
A.
Grant become user to dbai.
B.
Grant sysoper to both users.
C.
Run d3ms_macadm.authorize_datapump_user procedure granting dbai privileges to impdp and expdp utilities.
D.
Grant imp_full_database and exp_full_database to dbai and dba2.
E.
Run dbms_macadm.authobize_datapump_useb procedure granting dba2 privileges to impdp and expdp utilities.
F.
Grant become user to dba2.
G.
Grant sysdba to both users.

Quiz

5/10
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?
Select the answer
2 correct answers
A.
PARAMETER_NAM£=>'CHECKPOINT'
B.
OBJECT_OWNER=>'SYS
C.
CLAUSE_NAME=>'CHECKPOINT'
D.
CLAUSE_NAME=>'SYSTEM'
E.
COMMANI>=>' ALTER SYSTEM'
F.
OBJECT_NAME=>'CHECKPOINT'
G.
COMMAND=>'ALTER'

Quiz

6/10
If a column is not specified in a Data Redaction Policy, to which column(s) is it applied?
Select the answer
1 correct answer
A.
none of the columns
B.
foreign key columns only
C.
the primary and foreign key columns
D.
columns with any type of constraint
E.
the primary key column only

Quiz

7/10
Which three are part of an access control list (ACL) when using Real Application Security?
Select the answer
3 correct answers
A.
privileges
B.
schemas
C.
data realms
D.
column constraints
E.
policies
F.
data realm constraints
G.
roles

Quiz

8/10
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) Certification Exam Oracle Database Security Administration Oracle Oracle-1z0-116 2-2564895021 B) Certification Exam Oracle Database Security Administration Oracle Oracle-1z0-116 3-1015600322 C) Certification Exam Oracle Database Security Administration Oracle Oracle-1z0-116 4-1756991347 D) Certification Exam Oracle Database Security Administration Oracle Oracle-1z0-116 5-1007490812 E) Certification Exam Oracle Database Security Administration Oracle Oracle-1z0-116 6-2969282557
Select the answer
1 correct answer
A.
Option A
B.
Option B
C.
Option C
D.
Option D
E.
Option E

Quiz

9/10
When creating labels using Oracle Label Security, which is required?
Select the answer
1 correct answer
A.
level and group
B.
level, compartment, and group
C.
compartment
D.
group
E.
level
F.
compartment and group
G.
level and compartment

Quiz

10/10
Examine this command : GRANT EXEMPT ACCESS POLICY TO PUBLIC; Which Transparent Sensitive Data Protection functionality will be affected when this command is executed?
Select the answer
1 correct answer
A.
Data Redaction
B.
Bind Masking
C.
Virtual Private Database
D.
Transparent Data Encryption
Looking for more questions?Buy now

Oracle Database Security Administration Practice test unlocks all online simulator questions

Thank you for choosing the free version of the Oracle Database Security Administration practice test! Further deepen your knowledge on Oracle Simulator; by unlocking the full version of our Oracle Database Security Administration Simulator you will be able to take tests with over 90 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 90 questions.

BUY NOW

What to expect from our Oracle Database Security Administration practice tests and how to prepare for any exam?

The Oracle Database Security Administration Simulator Practice Tests are part of the Oracle Database and are the best way to prepare for any Oracle Database Security Administration exam. The Oracle Database Security Administration practice tests consist of 90 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The Oracle Database Security Administration database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with Oracle Database Security Administration Simulator will also give you an idea of the time it will take to complete each section of the Oracle Database Security Administration practice test . It is important to note that the Oracle Database Security Administration Simulator does not replace the classic Oracle Database Security Administration study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the Oracle Database Security Administration exam.

BUY NOW

Oracle Database Security Administration Practice test therefore represents an excellent tool to prepare for the actual exam together with our Oracle practice test . Our Oracle Database Security Administration Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our Oracle Database Security Administration Simulator and how our unique Oracle Database Security Administration Database made up of real questions:

Info quiz:

  • Quiz name:Oracle Database Security Administration
  • Total number of questions:90
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the Oracle Database Security Administration exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our Oracle Database Security Administration Simulator.

Use our Mobile App, available for both Android and iOS devices, with our Oracle Database Security Administration Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all Oracle Database Security Administration practice tests which consist of 90 questions and also provide study material to pass the final Oracle Database Security Administration exam with guaranteed success. Our Oracle Database Security Administration database contain hundreds of questions and Oracle Tests related to Oracle Database Security Administration Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW