1Z0-528 - Oracle Database 11g Security Essentials

Go back to Oracle

Example Questions

Which of the following components includes Oracle Container for J2EE (OC4J) and Oracle Database Client components, and is deployed within its own directory? Which of the following components involves command rule granularity? Andrew works as a Database Administrator for Business Software Solutions Ltd. The company uses Oracle 11g as the database. Andrew applied Oracle Data Masking Pack to the database so that to put back the fictitious data in place of sensitive data. Which of the following other benefits can this mask provides to the database? Each correct answer represents a complete solution. Choose all that apply. Streams engine decrypt the encrypted data to allow data transformation (character sets, database versions, platforms, etc.) and it is not encrypted at the time it is made transmitted to the other databases. Which of the following types of encryption is needed to resolve this issue? Which of the following tasks is performed by using ALTER SYSTEM SET ENCRYPTION KEY certificate_ID IDENTIFIED BY password; SQL command? Streams engine decrypt the encrypted data to allow data transformation (character sets, database ersions, platforms, etc.) and it is not encrypted at the time it is made transmitted to the other atabases. Which of the following types of encryption is needed to resolve this issue? You are a Database Administrator in Dolliver Inc. Oracle 11g is installed as the database server in the company. You want to protect data from privileged users through some preventive controls and also secure the database transparently. Which of the following security options will you adopt to accomplish the task? Your customer wants to move some of their DBA work offshore. Which of the following is the best reason to use Oracle's security features and options? From which four databases can audit records be collected by Oracle Audit Vault agents? Which method should be adopted to retrieve all those rows whose sensitive columns have a null value and which are restricted by Virtual Private Database security? Which of the following Enterprise Manager Packs supports masking and script generation? You work as a Database Administrator for Infotech Inc. The company uses Oracle 11g as its database. The company is required to increase efficiency and lower costs, to automate business processes for which it has to face some security challenges. Which of the following security challenges the company has to face in today's enterprise computing environments? Which of the following utilities is used to obtain Kerberos tickets that are cached in the user's credential cache from the key distribution center (KDC)? You work as a Database Administrator for uCertify Inc. The company uses Oracle 11g on its database server. The server contains a database named "Company_Project_Details". The database is shared among multiple departments of the company for regular updation. Looking at the security issues of the database, you have been assigned the task to apply some security solution to the database. To accomplish the task, you plan to apply Database Label Security on this database. Which of the following components of the Database Label Security should you apply in order to secure this database? Each correct answer represents a complete solution. Choose all that apply. Which of the following tasks is assigned to the database administrator while using database vault? Which of the following are the guidelines of Password Management Policy that enhances the wallet password management module? Each correct answer represents a complete solution. Choose all that apply. You work as a Database Administrator for uCertify Inc. The company uses Oracle 11g on its atabase server. During the management of company's database its required to add encrypted olumn to existing table for the protection of database files. Which of the following SQL commands ill you use to accomplish the following task? Which of the following statements is true about the relationship between an Oracle wallet and an HSM device? Which testing can help customers to implement database changes with minimum risk? Which of the following database options provides multi-level security? Which of the following is NOT a feature of the Data Masking Pack? Why would a merger or acquisition lead to the need for Oracle Audit Vault? Sam works as a Database Administrator for uCertify Inc. The company is using Oracle 11g as the database server. Sam wants to adopt a security feature on the database that enforces the security rules, regardless of the way the data is accessed. Which of the following security features should he adopt to accomplish the task? Which of the following features is supported by Oracle Audit Vault? Which security feature should be used in the environment where multiple users access the same database and only specific information is available to each group? You work as a Database Administrator for ABC.Inc . The company uses Oracle 11g on its database server. The server contains a database named "Company_Project_Details". The database is shared among multiple departments of the company for regular updation. Looking at the security issues of the database, you have been assigned the task to apply some security solution to the database. To accomplish the task, you plan to apply Database Label Security on this database. Which of the following components of the Database Label Security should you apply in order to secure this database? Each correct answer represents a complete solution. Choose all that apply. Which of the following is the container in which transparent data encryption stores the master key? Which of the following features of Oracle Advanced Security Option protects the operating system data files? Andrew works as a Database Administrator for Tech Mart Inc. The company uses Oracle 11g as the database server. Andrew has been assigned the task to apply a security feature to the database of the organization to protect the database from insiders. This security feature should also mitigate several security risks. Which of the following security features should he adopt to accomplish the task? Your customer wants to use encryption to protect the data in their database. In what three states must their data be encrypted to provide adequate protection? Which two of the following benefits of enhanced data security can increase the opportunities for your solution? Which of the following security options provides easy compliance by automating access control? Sam works as a Database Administrator for Gentech Inc. The company is using Oracle 11g as the database server. Sam wants to protect the company's data by encrypting the physical data files created on the operating system. Which of the following types of encryption should he use to accomplish the task? When is Transparent Data Encryption envoked? Which of the following is NOT an AVORCLDB command? Andrew works as a Database Administrator for Dolliver Inc. The company uses Oracle 11g as its database. Andrew applied the Oracle Audit Vault security to the database so that alteration or modification of the data is not allowed. Which of the following features are supported by this security option? Which of the following is a functional grouping of database schemas and roles that must be secured for a given application? Which of the following packs has the Clone and Mask workflow feature? Which of the following authentication methods supported by Oracle Advanced Security provides the benefit of single sign-on (SSO) capability, to enable users to access multiple accounts and applications with a single password? Each correct answer represents a complete solution. Choose all that apply. Comparing Transparent Data Encryption (TDE) column-based encryption and Transparent Data Encryption (TDE) tablespace-based encryption, which of the following statements is true? Andrew works as a Database Administrator for Tech Mart Inc. The company uses Oracle 11g as the database server and deals with the development of various database applications. During such developments, production data is copied into other non-production environments. This leads to several confidential risks. Andrew has been assigned the task to minimize the risk of handling such sensitive information. Which pack of Enterprise Manager should he adopt to accomplish the task? Which two of the following are reasons to use Oracle Audit Vault? Which of the following is an Oracle Audit Vault Server component? Which of the following features are required to mask data by making use of Oracle Data Masking Pack ? Andrew works as a Database Administrator in Infotech Inc. The company uses Oracle 11g as its database. Andrew applied the Oracle Advanced Security for the protection of the database. Its also required to apply authentication methods to authenticate users for the database protection. Which of the following authentication methods should he adopt to accomplish the following task? Each correct answer represents a complete solution. Choose all that apply. Which of the following tasks is the first task to perform when implementing Oracle Database Vault? David works as a Database Administrator for Gentech Inc. The company is using Oracle 11g as the database server. David wants to adapt such a security option that will provide no application changes to the database, built-in key management, and high performance to the database. Which security option should he adopt to accomplish the task? The data in the primary database is encrypted using TDE. With which type of Data Guard standby must you have a wallet open on the standby server? Sam works as a Database Administrator for Tech-Mart Inc. The company uses an Oracle 11g database server. Andrew wants to secure the data on the network from unauthorized users by encrypting it. Which of the following security option should he use to accomplish the following task? David works as a Database Administrator for uCertify Inc. The company is using Oracle 11g as the database server. David wants to adopt security options so as to protect the database of the company. Which of the following security options should he adopt to accomplish the task? Each correct answer represents a complete solution. Choose all that apply.