Oracle 1Z0-050 Online Practice Questions and Exam Preparation

Oracle 1Z0-050 Online Questions & Answers

• Question 21:

  You issued the following command:

  CREATE GLOBAL TEMPORARY TABLE admin_work_area

  (startdate DATE,

  enddate DATE,

  class CHAR(20))

  ON COMMIT DELETE ROWS

  TABLESPACE tbs_t1;

  An index is then created on the ADMIN_WORK_AREA temporary table. Which two statements are true regarding the TBS_T1 tablespace in the above command? (Choose two.)

  A. It stores only the temporary table but not its indexes.
  B. It stores both the temporary table as well as its indexes.
  C. It must be a nondefault temporary tablespace for the database.
  D. It can be a default or nondefault temporary tablespace for the database.
  E. It must be the default temporary tablespace of the user who issues the command.
  B. It stores both the temporary table as well as its indexes.
  D. It can be a default or nondefault temporary tablespace for the database.

• Question 22:

  View the Exhibits exhibit1 and exhibit2.

  

  Both the processes use PROG_1 as the job template that is already available. The time taken by the jobs are recorded in the TEST_LOG table. While comparing the time taken to create the jobs, the process in exhibit1 takes less time than the process in exhibit2.

  What is the reason for this?

  A. It creates less metadata for the jobs.
  B. It creates jobs temporarily in memory only.
  C. It writes the job metadata to disk in compressed format.
  D. It updates several tables in the SYSTEM tablespace instead of creating new tables.
  A. It creates less metadata for the jobs.

• Question 23:

  View the Exhibit for the object interdependency diagram.

  

  The PRODUCTS table is used to create the PRODCAT_VW view. PRODCAT_VW is used in the GET_DATA procedure. GET_DATA is called in the CHECK_DATA function.

  A new column PROD_QTY is added to the PRODUCTS table. How does this impact the status of the dependent objects?

  A. All dependent objects remain valid.
  B. Only the procedure and function become invalid and must be recompiled.
  C. Only the view becomes invalid and gets automatically revalidated the next time it is used.
  D. Only the procedure and function become invalid and get automatically revalidated the next time they are called.
  A. All dependent objects remain valid.

• Question 24:

  Which two prerequisites are needed for performing workload capture and replay? (Choose two.)

  A. setting up the directory to capture the workload
  B. running the database in shared server mode
  C. Close all sessions performing queries using database links.
  D. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.
  A. setting up the directory to capture the workload
  D. The database on which the workload is replayed has to be a restore of the original database to a specific SCN.

• Question 25:

  Which statement is true regarding online redefinition for the migration of BasicFile LOBs to SecureFile LOBs?

  A. It cannot be done in parallel.
  B. It can be done at the table level or partition level.
  C. It does not require additional storage because the operation is done online.
  D. Local and global indexes are maintained automatically during the operation.
  B. It can be done at the table level or partition level.

• Question 26:

  View the Exhibit exhibit1 to examine the series of SQL commands.

  

  View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS. Which statement is true if the SQL query in exhibit1 is executed again when the value of OPTIMIZER_MODE is set to FIRST_ROWS?

  A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.
  B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.
  C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.
  D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.
  B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

• Question 27:

  Which statements are true regarding system-partitioned tables? (Choose all that apply.)

  A. Only a single partitioning key column can be specified.
  B. All DML statements must use partition-extended syntax.
  C. The same physical attributes must be specified for each partition.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.
  D. Unique local indexes cannot be created on a system-partitioned table.
  E. Traditional partition pruning and partitionwise joins are not supported on these tables.

• Question 28:

  Which two kinds of failures make the Data Recovery Advisor (DRA) generate a manual checklist? (Choose two.)

  A. failures because a data file is renamed by error
  B. failures when no standby database is configured
  C. failures that require no archive logs to be applied for recovery
  D. failures due to loss of connectivity-for example, an unplugged disk cable
  A. failures because a data file is renamed by error
  D. failures due to loss of connectivity-for example, an unplugged disk cable

• Question 29:

  You are managing the APPPROD database as a DBA which is not using the Oracle- managed files. You plan to duplicate this database in the same system with the name DUPDB.You want to create the same directory structure for duplicate database files as of the target database.

  You executed the following RMAN commands:

  RMAN> CONNECT TARGET sys/sys@APPPROD

  RMAN> CONNECT AUXILIARY sys/sys@DUPDB

  RMAN> DUPLICATE TARGET DATABASE TO dupdb FROM ACTIVE DATABASE PASSWORD FILE SPILE NOFILENAMECHECK;

  What are the implications of this command?

  A. It creates database files for the duplicate database under the Oracle base with a different directory for the duplicate database.
  B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.
  C. It creates database files for the duplicate database under the same Oracle home as that of the target database with the same directory structure.
  D. It creates database files for the duplicate database under the same Oracle home as that of the target but with a different directory for the duplicate database.
  B. It overwrites data files of the target database because a different location for data files is not mentioned for the duplicate database.

• Question 30:

  You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?

  A. Compute the baseline statistics.
  B. Take an immediate AWR snapshot.
  C. Decrease the window size for the baseline.
  D. Decrease the expiration time for the baseline.
  A. Compute the baseline statistics.