Oracle 1Z0-053 Online Practice Questions and Exam Preparation

Oracle 1Z0-053 Online Questions & Answers

• Question 191:

  You work with a newly created database. Presently, there is no application load on the database instance.

  You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.

  What action must you take to achieve this?

  A. Run Segment Advisor
  B. Run the SQL Tuning Advisor (STA)
  C. Run the Automatic Workload Repository (AWR) report
  D. Run the SQL Access Advisor with a hypothetical workload
  D. Run the SQL Access Advisor with a hypothetical workload

• Question 192:

  You are managing an ASM instance. You previously issued the following statement

  ALTER DISKGROUP dg1 DROP DISK disk2;

  ALTER DISKGROUP dg1 DROP DISK disk3;

  ALTER DISKGROUP dg1 DROP DISK disk5;

  You want to cancel the disk drops that are pending for the DG1 disk group.

  Which statement should you issue?

  A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5;
  B. ALTER DISKGROUP dg1 UNDROP;
  C. ALTER DISKGROUP dg1 UNDROP DISKS;
  D. You cannot cancel the pending disk drops.
  C. ALTER DISKGROUP dg1 UNDROP DISKS;

• Question 193:

  Identify the activities performed as part of the Automatic SQL Tuning process in the maintenance window? (Choose all that apply.)

  A. generating the SQL profile
  B. testing and accepting the SQL profile
  C. generating a list of candidate SQLs for tuning
  D. adding tuned SQL plans into the SQL plan baseline
  E. tuning each SQL statement in the order of importance
  F. generating baselines that include candidate SQLs for tuning
  A. generating the SQL profile
  B. testing and accepting the SQL profile
  C. generating a list of candidate SQLs for tuning
  E. tuning each SQL statement in the order of importance

• Question 194:

  To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode:

  SQL> ALTER TABLESPACE users BEGIN BACKUP;

  While copying the file to the backup destination a power outage caused the instance to terminate abnormally.

  Which statement is true about the next database startup and the USERS tablespace?

  A. The database will open, and the tablespace automatically comes out of the backup mode.
  B. The database will be mounted, and recovery must be performed on the USERS tablespace.
  C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.
  D. The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
  C. The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.

• Question 195:

  Which statements about the MEMORY_TARGET initialization parameter are true? (Choose all that apply.)

  A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
  B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
  C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.
  D. MEMORY_TARGET is static and cannot be modified without shutting down the instance
  A. MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET, if MEMORY_MAX_TARGET is set to a value greater than zero
  B. MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not set
  C. MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.

• Question 196:

  What methods of point-in-time recovery are available? (Choose all that apply.)

  A. Change-based
  B. Cancel-based
  C. Time-based
  D. Sequence number-based
  E. Transaction number-based
  A. Change-based
  B. Cancel-based
  C. Time-based
  D. Sequence number-based

• Question 197:

  The EMP table has some discrepancy in data entry with a particular employee ID. You execute the query as shown in the Exhibit to retrieve all versions of the row that exist between two SCNs.View the Exhibit.

  Which two statements about the results of the query shown in the Exhibit are correct? (Choose two.)

  Exhibit:

  

  A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
  B. The LAST_SCN value in the second row in NULL, which means that the version of the row still exists at SCN 6636300.
  C. The LAST_SCN value in the third row is 6636280, which means that the version of row exists above SCN 6636280.
  D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.
  A. The LAST_SCN value in the first row is NULL, which means that the versions of the row still exist at SCN 6636300.
  D. The LAST_SCN value in the second row is NULL, which means that the version of the row no longer exists because it was deleted.

• Question 198:

  Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects.

  Which option must you use to perform TSPITR and preserve the object?

  A. Perform Export before TSPITR and Import after TSPITR
  B. Move objects to another schema that has the same tablespace assigned
  C. Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)
  D. Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
  A. Perform Export before TSPITR and Import after TSPITR

• Question 199:

  True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode.

  A. True
  B. False
  B. False

• Question 200:

  Which statement describes the information returned by the DBMS_SPACE.SPACE_USAGE procedure for LOB space usage?

  A. It returns space usage of only BasicFile LOB chunks.
  B. It returns space usage of only SecureFile LOB chunks.
  C. It returns both BasicFile and SecureFile LOB space usage for only nonpartitioned tables.
  D. It returns both BasicFile and SecureFile LOB space usage for both partitioned and nonpartitioned tables.
  B. It returns space usage of only SecureFile LOB chunks.