Oracle 1Z0-062 Online Practice Questions and Exam Preparation

Oracle 1Z0-062 Online Questions & Answers

• Question 371:

  Which four statements are true about the components of the Oracle Scheduler? (Choose four.)

  A. A schedule can be specified to a single job only.
  B. A scheduler job can point to a chain instead of pointing to a single program object.
  C. A job may get started automatically when a window opens.
  D. A program and job can be specified as part of a schedule definition.
  E. A job is specified as part of a program specification.
  F. A program can be used in the definition of multiple jobs.
  G. A program and schedule can be specified as part of a job definition.
  B. A scheduler job can point to a chain instead of pointing to a single program object.
  C. A job may get started automatically when a window opens.
  F. A program can be used in the definition of multiple jobs.
  G. A program and schedule can be specified as part of a job definition.

  ---

  References: https://docs.oracle.com/cd/B19306_01/server.102/b14231/schedover.htm

• Question 372:

  Which three naming methods or connection types enable clients to connect to database instances successfully without client or server side configuration in sqlnet.ora or tnsnames.ora? (Choose three.)

  A. using the easy connect method from a remote terminal
  B. using CONNECT / AS SYSDBA from a local terminal
  C. using the easy connect method from a local terminal
  D. using the directory naming method from a remote terminal
  E. using the local naming method from a local terminal
  F. using CONNECT / AS SYSDBA from a remote terminal
  G. using the directory naming method from a local terminal
  C. using the easy connect method from a local terminal
  E. using the local naming method from a local terminal
  F. using CONNECT / AS SYSDBA from a remote terminal

• Question 373:

  Which three activities are supported by the Data Recovery Advisor? (Choose three.)

  A. Advising on block checksum failures
  B. Advising on inaccessible control files
  C. Advising on inaccessible block change tracking files
  D. Advising on empty password files
  E. Advising on invalid block header field values
  A. Advising on block checksum failures
  B. Advising on inaccessible control files
  E. Advising on invalid block header field values

  ---

  *

  Data Recovery Advisor can diagnose failures such as the following: / (B) Components such as datafiles and control files that are not accessible because they do not exist, do not have the correct access permissions, have been taken offline, and so on / (A, E) Physical corruptions such as block checksum failures and invalid block header field values / Inconsistencies such as a datafile that is older than other database files / I/O failures such as hardware errors, operating system driver failures, and exceeding operating system resource limits (for example, the number of open files)

  *

  The Data Recovery Advisor automatically diagnoses corruption or loss of persistent data on disk, determines the appropriate repair options, and executes repairs at the user's request. This reduces the complexity of recovery process, thereby reducing the Mean Time To Recover (MTTR).

• Question 374:

  You executed this command to create a password file:

  $ orapwd file = orapworcl entries = 10 ignorecase = N

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

  A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
  B. It contains username and passwords of database users who are members of the OSOPER operating system group.
  C. It contains usernames and passwords of database users who are members of the OSDBA operating system group.
  D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
  E. It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
  A. It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
  D. It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.

  ---

  *

  You can create a password file using the password file creation utility, ORAPWD.

  *

  Adding Users to a Password File When you grant SYSDBA or SYSOPER privileges to a user, that user's name and privilege information are added to the password file. If the server does not have an EXCLUSIVE password file (that is, if the initialization parameter REMOTE_LOGIN_PASSWORDFILE is NONE or SHARED, or the password file is missing), Oracle Database issues an error if you attempt to grant these privileges.

  A user's name remains in the password file only as long as that user has at least one of these two privileges. If you revoke both of these privileges, Oracle Database removes the user from the password file.

  *

  The syntax of the ORAPWD command is as follows:

  ORAPWD FILE=filename [ENTRIES=numusers] [FORCE={Y|N}] [IGNORECASE={Y|N}] [NOSYSDBA={Y|N}]

  *

  IGNORECASE

  If this argument is set to y, passwords are case-insensitive. That is, case is ignored when comparing the password that the user supplies during login with the password in the password file.

• Question 375:

  In your Oracle 12c database, you plan to execute the command:

  SQL> CREATE TABLESPACE tbs1 DATAFILE `/u02/oracle/data/tbs01.dbf' SIZE 50M;

  The u02 file system has 1 GB of free space available.

  What is the outcome?

  A. It creates a locally managed tablespace with manual segment space management enabled.
  B. It raises an error because extent management is not specified.
  C. It creates a locally managed tablespace with automatic segment space management enabled.
  D. It creates a dictionary-managed tablespace with manual segment space management enabled.
  C. It creates a locally managed tablespace with automatic segment space management enabled.

  ---

  References: https://docs.oracle.com/cd/B28359_01/server.111/b28310/tspaces002.htm#ADMIN11359

• Question 376:

  One of your databases runs in ARCHIVELOG mode. Examine this command:

  

  Now examine these steps executed from RMAN:

  1) SHUTDOWN IMMEDIATE 2) STARTUP MOUNT 3) BACKUP DATABASE; 4) BACKUP ARCHIVELOG ALL; 5) ALTER DATABASE OPEN; 6) STARTUP

  Identify the minimum required steps in the correct order needed to perform a whole consistent database backup.

  A. 1, 2, 3, 5
  B. 1, 6, 3, 4
  C. 1, 6, 3
  D. 1, 2, 3, 4, 5
  E. 3, 4
  A. 1, 2, 3, 5

  ---

  Reference: https://community.oracle.com/thread/451341

• Question 377:

  Identify two situations in which the alert log file is updated.

  A. Running a query on a table returns ORA-600: Internal Error.
  B. Inserting a value into a table returns ORA-01722: invalid number.
  C. Creating a table returns ORA-00955: name us already in used by an existing object.
  D. Inserting a value into a table returns ORA-00001: unique constraint (SYS.OK_TECHP) violated.
  E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.
  A. Running a query on a table returns ORA-600: Internal Error.
  E. Rebuilding an index using ALTER INDEX . . . REBUILD fails with an ORA-01578: ORACLE data block corrupted (file # 14, block # 50) error.

  ---

  The alert log is a chronological log of messages and errors, and includes the following items:

  *All internal errors (ORA-600), block corruption errors (ORA-1578), and deadlock errors (ORA-60) that occur

  *

  Administrative operations, such as CREATE, ALTER, and DROP statements and STARTUP, SHUTDOWN, and ARCHIVELOG statements

  *

  Messages and errors relating to the functions of shared server and dispatcher processes

  *

  Errors occurring during the automatic refresh of a materialized view

  *

  The values of all initialization parameters that had nondefault values at the time the database and instance start Note:

  *

  The alert log file (also referred to as the ALERT.LOG) is a chronological log of messages and errors written out by an Oracle Database. Typical messages found in this file is: database startup, shutdown, log switches, space errors, etc. This file should constantly be monitored to detect unexpected messages and corruptions.

• Question 378:

  Which two services may you see on the My Service Dashboard page? (Choose two.)

  A. Network Cloud Service
  B. User Cloud Service
  C. Compute Cloud Service
  D. Database Cloud Service
  C. Compute Cloud Service
  D. Database Cloud Service

• Question 379:

  Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command:

  SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (`SRV1');

  The possible outcome and actions to aggregate the trace files are as follows:

  1.

  The command fails because a module name is not specified.

  2.

  A trace file is created for each session that is running the SRV1 service.

  3.

  An aggregated trace file is created for all the sessions that are running the SRV1 service.

  4.

  The trace files may be aggregated by using the trcess utility.

  5.

  The trace files be aggregated by using the tkprof utility.

  Identify the correct outcome and the step to aggregate by using tkprof utility?

  A. 1
  B. 2 and 4
  C. 2 and 5
  D. 3 and 4
  E. 3 and 5
  B. 2 and 4

  ---

  Tracing information is present in multiple trace files and you must use the trcsess tool to collect it into a single file.

  Incorrect:

  Not 1: Parameter service_name

  Name of the service for which tracing is enabled.

  module_name

  Name of the MODULE. An optional additional qualifier for the service.

  Note:

  *

  The procedure enables a trace for a given combination of Service, MODULE and ACTION name. The specification is strictly hierarchical: Service Name or Service Name/MODULE, or Service Name, MODULE, and ACTION name must be specified. Omitting a qualifier behaves like a wild-card, so that not specifying an ACTION means all ACTIONs. Using the ALL_ACTIONS constant achieves the same purpose.

  *

  SERV_MOD_ACT_TRACE_ENABLE Procedure

  This procedure will enable SQL tracing for a given combination of Service Name, MODULE and ACTION globally unless an instance_name is specified.

  *

  DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE(

  service_name IN VARCHAR2,

  module_name IN VARCHAR2 DEFAULT ANY_MODULE,

  action_name IN VARCHAR2 DEFAULT ANY_ACTION,

  waits IN BOOLEAN DEFAULT TRUE,

  binds IN BOOLEAN DEFAULT FALSE,

  instance_name IN VARCHAR2 DEFAULT NULL);

• Question 380:

  Examine these two statements:

  

  Which three are true about the MRKT tablespace? (Choose three.)

  A. The MRKT tablespace is created as a small file tablespace, because the file size is less than the minimum required for big file files.
  B. The MRKT tablespace may be dropped if it has no contents.
  C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
  D. No more data files can be added to the tablespace.
  E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.
  C. Users who were using the old default tablespace will have their default tablespaces changed to the MRKT tablespace.
  D. No more data files can be added to the tablespace.
  E. The relative file number of the tablespace is not stored in rowids for the table rows that are stored in the MRKT tablespace.