1Z0-528 | A Review Of Simulation 1Z0-528 exam dumps
Q21. 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.
A. Levels
B. Source database
C. Compartments
D. Groups
Answer: ACD
Q22. Sam works as a Database Administrator for ABC 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?
A. Real Application Cluster (RAC)
B. Label Security
C. Enhanced security features with execution context
D. Virtual Private Database (VPD)
Answer: D
Q23. 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?
A. Network Encryption
B. Transparent Data Encryption
C. TDE Tablespace Encryption
D. TDE Column Encryption
Answer: A
Q24. Which of the following roles or privileges is created during installation and used for creating newdatabase accounts?
A. SYSDBA
B. DV_OWNER
C. SYSOPER
D. DV_ACCTMGR
Answer: D
Q25. Which of the following packs has the Clone and Mask workflow feature?
A. Oracle Data Masking
B. Oracle Provisioning and Patch Automation
C. Oracle Tuning Pack
D. Oracle Change Management
Answer: A
Q26. Which of the following tasks is performed by using ALTER SYSTEM SET ENCRYPTION KEY certificate_ID IDENTIFIED BY password; SQL command?
A. Create table and encrypt column.
B. Set or Reset master encryption key
C. Set or Reset master encryption key to use PKI certificate
D. Encrypts unencrypted existing column
Answer: C
Q27. Which of the following security features are of Oracle Advanced Security that are used to solve the security challenges enhanced by Security in Enterprise Grid Computing Environments, Security in an Intranet or Internet Environment, and Common Security Threats?
Each correct answer represents a complete solution. Choose two.
A. Protecting Audit data from tampering
B. Separation of Duty
C. Strong Authentication
D. Data Encryption
Answer: CD
Q28. You work as a Database Administrator for ABC.Inc . The company uses Oracle 11g on its database server. During the management of company's database its required to add encrypted column to existing table for the protection of database files. Which of the following SQL commands will you use to accomplish the following task?
A. ALTER TABLE table_name MODIFY (column_name ENCRYPT);
B. ALTER SYSTEM SET ENCRYPTION WALLET OPEN IDENTIFIED BY password;
C. CREATE TABLE table_name (column_name datatype ENCRYPT);
D. ALTER TABLE table_name ADD (column_name datatype ENCRYPT);
Answer: D
Q29. 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.
A. The minimum password length required is of 8 characters.
B. The alphanumeric character mix is required.
C. The minimum password length required is of 6 characters.
D. The maximum password length is unlimited.
Answer: ABD
Q30. Which of the following encryption algorithms is used by transparent data encryption by default?
A. 3DES168
B. AES128
C. AES256
D. AES192
Answer: D