1Z0-116 Exam Questions
88 real 1Z0-116 exam questions with expert-verified answers and explanations. Page 2 of 2.
- Question #53Using Virtual Private Database (VPD)
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?
VPD policy predicatepolicy function parametersschema namepolicy name - Question #54Using Oracle Database Vault
Which two statements are true about Database Vault rules and rule sets?
Database VaultRules and Rule SetsAccess ControlSecurity Policies - Question #55Configuring and Auditing User Security
Which three authentication methods are available with Centrally Managed Users (CMU)?
Centrally Managed UsersAuthentication methodsKerberosRemote Access Services - Question #56Configuring and Auditing User Security
Examine this security parameter and Its value: SEC_USER_ONAUTHORIZED_ACCESS_BANNER=/opt/oracla/admin/data/unauthwarnin q.txt In which file must you include this parameter?
listener.oraunauthorized access bannersecurity parametersnetwork configuration - Question #57Configuring and Auditing User Security
Examine these statements which execute successfully: Which are the two reasons that no rows Are returned from the query?
Application ContextSESSION_CONTEXTEnterprise User SecurityContext Initialization - Question #58Implementing Encryption
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?
Oracle walletSSL/TLS encryptionHTTPS configurationnetwork access control - Question #59Implementing Encryption
When querying the database view, VSECRYPTION_WALLET, the status Is OPEN_NO_MASTER _KEY. What does this mean?
encryption wallet statuskey store statesdatabase encryptionwallet management - Question #60Configuring and Auditing User Security
Which two are true about Database Privilege Analysis?
Database Privilege AnalysisPrivilege MonitoringGrant PathsUser Security Configuration - Question #61Configuring and Auditing User Security
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?
Role-Based AuthenticationDefiner's RightsDBMS_SESSION.SET_ROLEProcedure Security Privileges - Question #62Configuring and Auditing User Security
Database Vault is not used in your installation. Why is a conventional secure application role more secure than a normal role?
secure application rolesprivilege restrictionrole activationapplication security - Question #63Implementing Basic Database Security
The listener configuration contains these lines related to Valid Node Checking for Registration (VNCR); Which two statements are true?
Listener ConfigurationValid Node Checking for Registration (VNCR)Instance Registration ControlNetwork Security - Question #64
Which statement is true about Network ACLs?
- Question #65Configuring and Auditing User Security
You must disable OS authentication for database administrative users on a RAC database. Which option must you use to do this?
OS AuthenticationRAC Databaseinit.ora ParametersAdministrative Security - Question #66Introduction to Database Security
Which type of attack attempts to find data by repeatedly trying similar SQL with a modified predicate?
cache attacksside-channel attacksSQL predicatesdata inference - Question #67Implementing Basic Database Security
Which two statements are true about Valid Node Checking for Registration (VNCR)?
VNCRListener registrationIPC restrictionsCOST replacement - Question #68Implementing Basic Database Security
You are required to remove embedded passwords from scripts that connect to database instances. Which tool can be used to implement this requirement?
credential storagepassword managementsecure configurationdatabase tools - Question #69Configuring and Auditing User Security
You grant user JANE the SYSDBA administrative privilege. Which two are true?
SYSDBA privilegesystem administrationuser privilegesschema access control - Question #70Introduction to Database Security
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: Wh...
Autonomous Transaction ProcessingStorage Capacity ManagementTablespace CreationATP Constraints - Question #71Using Oracle Database Vault
Which two statements are true about Database Vault factors?
Database Vault FactorsSession EvaluationSchema FunctionsFactor Configuration - Question #72Configuring and Auditing User Security
Examine these commands and responses: User Karen is an enterprise user. Which two commands are used to allow this login?
external authenticationenterprise userCREATE SESSION privilegeuser creation - Question #73Implementing Basic Database Security
You develop an HR application that must allow multiple sessions to share application attributes. Which statement is executed while implementing the requirement?
Application ContextsSession AttributesContext CreationDatabase Security - Question #74Configuring and Auditing User Security
What is true about the client identifier?
client_identifiersql_net_layersession_managementnetwork_configuration - Question #75Introduction to Database Security
Which CVSS Version 3.1 metric indicates how close an attacker needs to be to the vulnerable component?
CVSS 3.1Attack VectorVulnerability MetricsRisk Assessment - Question #76Configuring and Auditing User Security
Examine this parameter In sqinet.ora: SQLNET.ADTHENTICATION_SEBVICES=(NONE) For which two cases do you need a password file?
password file authenticationremote database authenticationprivileged user accessSQLNET configuration - Question #77Configuring and Auditing User Security
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?
USERENV namespacesession contextSESSION_USERsession attributes - Question #78Implementing Encryption
The sqinet.oia file on the client contains this parameter setting: SQLNET.ENCRYPTION_CLIEKT = REQUESTED What value for the parameter sQLNET.ENCRYPTION _server in the sqlnet.ora fil...
SQL*Net encryptionEncryption negotiationENCRYPTION_SERVER parameterencryption modes - Question #79Using Virtual Private Database (VPD)
Which two configurations can be used to protect sensitive data In a database?
Virtual Private DatabaseRow-level securityVPD policiesSensitive data protection - Question #80Implementing Encryption
Examine this command: Which two statements are true?
Software KeystoreKeystore Access ControlKey ManagementRemote vs Local Administration - Question #81Using Oracle Database Vault
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...
Database Vault RolesDV_ACCTMGRUser ProvisioningDictionary Access - Question #82Managing Database Auditing
Examine this list: 1. You must monitor access to email column or salary column In the employees table. 2. If any activity is detected, the action must be audited and a notification...
Unified AuditingFine-Grained Auditing (FGA)Audit policiesEvent handlers - Question #83Implementing Data Protection
You must mask data consistently In three database copies such that data relations across the databases remain In place. Which Data Masking Format allows this?
Data Masking FormatsData ConsistencyReferential IntegrityDatabase Copies - Question #84Using Oracle Database Vault
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...
Database Vault Operations ControlCDB/PDB architecturedv_admin roleprivilege exceptions - Question #85Configuring and Auditing User Security
Which statement can be used to force password complexity in the password file?
orapwd utilitypassword file creationpassword complexityauthentication - Question #86Implementing Data Protection
Data Masking uses a combination of data patterns to discover sensitive data. Which three items are used?
Data MaskingSensitive Data DiscoveryData ProtectionOracle Security - Question #87Implementing Data Protection
Examine this command that Is executed: What is the result?
Data RedactionColumn-level ProtectionQuery Result MaskingData Protection - Question #88Implementing Data Protection
Examine this command: What masking definitions does it list?
Data MaskingMasking DefinitionsCommand SyntaxFilter Parameters - Question #89Implementing Encryption
What Is the first step when analyzing security within a database?
Transparent Data EncryptionSecurity MethodologyDatabase ProtectionEncryption - Question #90
Which two does the master key encrypt with Transparent Data Encryption?