Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 231:

  You Execute the Following command to create a password file in the database server:

  $ orapwd file = `+DATA/PROD/orapwprod entries = 5 ignorecase = N format = 12'

  Which two statements are true about the password file? (Choose two.)

  A. It records the usernames and passwords of users when granted the DBA role.
  B. It contains the usernames and passwords of users for whom auditing is enabled.
  C. Is used by Oracle to authenticate users for remote database administration.
  D. It records the usernames and passwords of all users when they are added to the OSDBA or OSOPER operating system groups.
  E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.
  C. Is used by Oracle to authenticate users for remote database administration.
  E. It supports the SYSBACKUP, SYSDG, and SYSKM system privileges.

• Question 232:

  Your database instance is started by using a server parameter file (SPFILE). You execute the following command to change the value of the LOG_BUFFER initialization parameter:

  ALTER SYSTEM SET LOG_BUFFER=32 M;

  What is the outcome of this command?

  A. The parameter value is changed and it comes into effect as soon as space becomes available in the SGA.
  B. It returns an error because the value of this parameter cannot be changed dynamically.
  C. The parameter value is changed and it comes into effect at the next instance startup.
  D. It returns an error because SCOPE should be set to MEMORY.
  B. It returns an error because the value of this parameter cannot be changed dynamically.

• Question 233:

  You install a non-RAC Oracle Database. During Installation, the Oracle Universal Installer (OUI) prompts you to enter the path of the Inventory directory and also to specify an operating system group name.

  Which statement is true?

  A. The ORACLE_BASE base parameter is not set.
  B. The installation is being performed by the root user.
  C. The operating system group that is specified should have the root user as its member.
  D. The operating system group that is specified must have permission to write to the inventory directory.
  D. The operating system group that is specified must have permission to write to the inventory directory.

  ---

  Note:

  Providing a UNIX Group Name

  If you are installing a product on a UNIX system, the Installer will also prompt you to provide the name of the group which should own the base directory.

  You must choose a UNIX group name which will have permissions to update, install, and deinstall Oracle software. Members of this group must have write permissions to the base directory chosen.

  Only users who belong to this group are able to install or deinstall software on this machine.

• Question 234:

  Which three statements are true about Enterprise Manager Database Express? (Choose three.)

  A. It can be used to perform database backup operations.
  B. It can use the HTTP protocol.
  C. The same port number is used for multiple Database Express configurations on the same host.
  D. It can use the HTTPS protocol.
  E. It is available only when the database is open.
  B. It can use the HTTP protocol.
  D. It can use the HTTPS protocol.
  E. It is available only when the database is open.

• Question 235:

  You executed the following command to create a password file in the database server:

  $ orapwd file = orapworcl entries = 5 ignorecase=N

  Which statement describes the purpose of the above password file?

  A. It records usernames and passwords of users when granted the DBA role
  B. It contains usernames and passwords of users for whom auditing is enabled
  C. It is used by Oracle to authenticate users for remote database administrator
  D. It records usernames and passwords of all users when they are added to OSDBA or OSOPER operating groups
  A. It records usernames and passwords of users when granted the DBA role

• Question 236:

  The ORCL database is configured to support shared server mode. You want to ensure that a user connecting remotely to the database instance has a one-to-one ratio between client and server processes. Which connection method guarantees that this requirement is met?

  A. connecting by using an external naming method
  B. connecting by using the easy connect method
  C. creating a service in the database by using the dbms_service.create_service procedure and using this service for creating a local naming service
  D. connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service
  E. connecting by using a directory naming method
  D. connecting by using the local naming method with the server = dedicated parameter set in the tnsnames.ora file for the net service

• Question 237:

  In which two scenarios do you use SQL* Loader to load data? (Choose two.)

  A. Transform the data while it is being loaded into the database.
  B. Use transparent parallel processing without having to split the external data first.
  C. Load data into multiple tables during the same load statement.
  D. Generate unique sequential key values in specified columns.
  C. Load data into multiple tables during the same load statement.
  D. Generate unique sequential key values in specified columns.

• Question 238:

  Which three factors influence the optimizer's choice of an execution plan? (Choose three.)

  A. the optimizer_mode initialization parameter
  B. operating system (OS) statistics
  C. cardinality estimates
  D. object statistics in the data dictionary
  E. fixed baselines
  A. the optimizer_mode initialization parameter
  C. cardinality estimates
  D. object statistics in the data dictionary

• Question 239:

  Your database supports a DSS workload that involves the execution of complex queries: Currently, the library cache contains the ideal workload for analysis. You want to analyze some of the queries for an application that are cached in the library cache.

  What must you do to receive recommendations about the efficient use of indexes and materialized views to improve query performance?

  A. Create a SQL Tuning Set (STS) that contains the queries cached in the library cache and run the SQL Tuning Advisor (STA) on the workload captured in the STS.
  B. Run the Automatic Workload Repository Monitor (ADDM).
  C. Create an STS that contains the queries cached in the library cache and run the SQL Performance Analyzer (SPA) on the workload captured in the STS.
  D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.
  D. Create an STS that contains the queries cached in the library cache and run the SQL Access Advisor on the workload captured in the STS.

  ---

  *

  SQL Access Advisor is primarily responsible for making schema modification recommendations, such as adding or dropping indexes and materialized views. SQL Tuning Advisor makes other types of recommendations, such as creating SQL profiles and restructuring SQL statements.

  *

  The query optimizer can also help you tune SQL statements. By using SQL Tuning Advisor and SQL Access Advisor, you can invoke the query optimizer in advisory mode to examine a SQL statement or set of statements and determine how to improve their efficiency. SQL Tuning Advisor and SQL Access Advisor can make various recommendations, such as creating SQL profiles, restructuring SQL statements, creating additional indexes or materialized views, and refreshing optimizer statistics.

  Note:

  *

  Decision support system (DSS) workload

  *

  The library cache is a shared pool memory structure that stores executable SQL and PL/SQL code. This cache contains the shared SQL and PL/SQL areas and control structures such as locks and library cache handles.

• Question 240:

  Your database instance has started using an SPFILE. Examine the RMAN configuration settings:

  

  You execute the command:

  RMAN> BACKUP AS COPY TABLESPACE TEST;

  Which three types of files are backed up by using this command? (Choose three.)

  A. online redo log files
  B. control file
  C. SPFILE
  D. archived redo log files
  E. data file(s)
  F. PFILE
  B. control file
  C. SPFILE
  E. data file(s)

  ---

  References: http://www.juliandyke.com/Research/RMAN/BackupCommand.php