Online Access Free 1Z0-050 Practice Test

You have the following requirements in relation to the detection of block corruption for your database instance:
1.Check for logical self-consistency of data blocks when modified in memory.
2.Checksums are calculated before and after the block change.
3.Checks are performed for the lost writes to the physical standby database.
Which method would help you perform the above checks automatically?

• A.Set the DB_SECUREFILE parameter to PERMITTED.
• B.Set the DB_ULTRA_SAFE parameter to DATAJDNLY.
• C.Set the DB_LOCK_CHECKSUM parameter to TYPICAL.
• D.Set the DB_LOST_WRITE_PROTECT parameter to TYPICAL.

In your database, the LDAP_DIRECTORY_SYSAUTH initialization parameter has been set to YES and the users who need to access the database as DBAs have been granted SYSDBA enterprise role in Oracle Internet Directory (OID). SSL and the password file have been configured. A user SCOTT with the SYSDBA privilege tries to connect to the database instance from a remote machine using the command:
$ SQLPLUS scott/tiger@DB01 AS SYSDBA where DB01 is the net service name. Which authentication method would be used first?

• A.authentication by using certificates over SSL
• B.authentication by using the local OS of the database server
• C.authentication by password file
• D.authentication by using the Oracle Internet Directory

Which steps are mandatory to enable Direct NFS?
1.Mount all required file systems using the kernel NFS driver.
2.Create an oranfstab file containing the attributes for each NFS server to be accessed using Direct NFS.
3.Replace the ODM library libodm11 .so_stub with libodm11 .so.

• A.1, 2 and 3
• B.1 and 3
• C.1 and 2
• D.2 and 3

You are managing an Oracle Database 11 g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps. What configuration would you effect to achieve your objective? (Choose all that apply.)

• A.Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
• B.Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.
• C.Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
• D.Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.

View the Exhibit to observe the error.

You receive this error regularly and have to shut down the database instance to overcome the error. What can the solution be to reduce the chance of this error in future, when implemented?

• A.setting the PRE_PAGE_SGA parameter to TRUE
• B.increasing the value of SGA_MAX_SIZE
• C.locking the SGA in memory
• D.automatic memory management