1Z0-062 Free Practice Test

Which two statements are true about Oracle Managed Files (OMF)? (Choose two.)

1. A. OMF cannot be used in a database that already has data files created with user-specified directions.
2. B. The file system directions that are specified by OMF parameters are created automatically.
3. C. OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
4. D. OMF automatically creates unique file names for table spaces and control files.
5. E. OMF may affect the location of the redo log files and archived log files.

Correct Answer: DE
D: The database internally uses standard file system interfaces to create and delete files as needed for the following database structures:
Tablespaces Redo log files Control files Archived logs
Block change tracking files Flashback logs
RMAN backups Note:
* Using Oracle-managed files simplifies the administration of an Oracle Database. Oracle-managed files eliminate the need for you, the DBA, to directly manage the operating system files that make up an Oracle Database. With Oracle- managed files, you specify file system directories in which the database automatically creates, names, and manages files at the database object level. For example, you need only specify that you want to create a tablespace; you do not need to specify the name and path of the tablespace\'s datafile with the DATAFILE clause.
http://www.oracle-base.com/articles/9i/oracle-managed-files.php
http://docs.oracle.com/cd/B10500_01/server.920/a96521/omf.htm References:

Which three are activities performed by SMON? (Choose three.)

1. A. cleaning up the database buffer cache and freeing resources that a client process was using
2. B. applying online redo during instance recovery
3. C. cleaning up temporary segments that are no longer needed
4. D. performing database services registration with the default listener
5. E. restarting a server or a dispatcher process that terminated abnormally
6. F. recovering failed transactions that were skipped during instance recovery because of file-read or tablespace offline errors

Correct Answer: BCF

Which statement is true about the Oracle central inventory directory (oraInventory)?

1. A. oraInventory must not be shared by all Oracle software installations on a single system.
2. B. If ORACLE_BASE is set to /u01/app/oracle for the oracle user during an installation, OUI creates the Oracle Inventory directory in the /u01/app/oracle/ oraInventory path.
3. C. lf an OFA-compliant path is not created and the ORACLE_BASE environment variable is not set during an Oracle Database installation, the Oracle Inventory directory is placed in the home directory of the user that is performing the installation.
4. D. Oracle software owners must be members of the same central oraInventory group, but they need not have this group as their primary group.

Correct Answer: D
References https://docs.oracle.com/database/121/CWLIN/usrgrps.htm#CWLIN483

You install “Oracle Grid Infrastructure for a standalone server” on a host on which the ORCL1 and ORCL2 databases both have their instances running.
Which two statements are true? (Choose two.)

1. A. All databases subsequently created by using the Database Configuration Assistant (DBCA) are automatically added to the Oracle Restart configuration.
2. B. The srvctl add database command must be used to add ORCL1 and ORCL2 to the ORACLE Restart configuration.
3. C. Both ORCL1 and ORCL2 are automatically added to the Oracle Restart configuration.
4. D. All database listeners running from the database home are automatically added to the Oracle Restart configuration.
5. E. The crsctl start has command must be used to start software services for Oracle Automatic Storage Management (ASM) after the “Oracle Grid Infrastructure for a standalone server” installation is complete.

Correct Answer: AB

Examine the parameter settings in your local ORCL database:
< ><>>< ><>>CREATE PUBLICDATABASE LINK sales.us.example.com USING ‘sales1’; The sales1 tnsnames entry points to the sales database instance.
Which two are requirements to ensure that you can successfully connect by using this database link? (Choose two.)

1. A. The GLOBAL_NAMES initialization parameter should be set to FALSE in the ORCL database.
2. B. The SALES1 net service name should be known to both the local and remote databases.
3. C. Local database users who use this database link should have accounts and the required privileges in the remote database.
4. D. The REMOTE_OS_AUTHENT initialization parameter should be set to FALSE in the remote database.
5. E. Only the user creating the database link must have an account and the required privileges in the remote databas

Correct Answer: AC