1Z0-053 Online Practice Questions and Answers

The NLS_TERRITORY parameter specifies the default conventions to be used for which of the following globalization elements? (Choose all that apply.)

A. Date format

B. Decimal character

C. Group separator

D. First day of the month

E. None of the above

F. All of the above

Consider the following code snippet:

If this code were executed, which of the following statements would be true?

A. The priority of the lne_job1 job would be set to 1.

B. The lne_job1 job would be executed synchronously.

C. The lne_job1 job would run immediately in the users current session.

D. The lne_job1 job would retain its current priority.

E. The job will immediately take priority over all running jobs.

You want to schedule a job to rebuild all indexes on the SALES table after the completion of a bulk load operation.

The bulk load operation must also be a scheduled job that executes as soon as the first file that contains data arrives on the system.

How would you create these jobs?

A. Create both jobs by using events raised by the scheduler

B. Create both jobs by using events raised by the application

C. Create a job to rebuild indexes by using events raised by the application and then create another job to perform bulk load by using events raised by the scheduler

D. Create a job to rebuild indexes by using events raised by the Scheduler and then create another job to perform bulk load by using events raised by the application

View the Exhibit to examine the error obtained during the I/O calibration process. There are no data files on raw devices. What is the reason for this error?

A. The DISK_ASYNCH_IO parameter is set to TRUE.

B. The FILESYSTEMIO_OPTIONS parameter is set to NONE.

C. Another session runs the I/O calibration process concurrently.

D. The pending area has not been created before running the I/O calibration process.

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.

Which tasks can be accomplished using the DBMS_LOB.SETOPTIONS procedure?

A. only encryption and compression settings for all SecureFile LOBs

B. only encryption and deduplication settings for only SecureFile CLOBs

C. deduplication, encryption, and compression settings for all SecureFile LOBs

D. deduplication, encryption, and compression settings only for SecureFile CLOBs

Your company wants to upgrade the current production database to the RAC environment. To perform testing before migrating to the RAC environment, you performed the workload capture on the production database to record the peak

workload. You set up the test RAC database and want to replay the recorded workload on the testmachine. Note the following steps that you may require to replay the database workload:

1) Preprocess the captured workload.

2) Restart the database in RESTRICTED mode.

3) Set up the Replay Clients.

4) Restore the test database to the point when the capture started.

5) Remap connections.

Arrange the steps required in the correct sequence to accomplish this task on the test machine.

A. 1, 4, 5, 3 (2 is not required.)

B. 1, 4, 3, 5 (2 is not required.)

C. 1, 2, 4, 5 (3 is not required.)

D. 2, 1, 5, 3, 4

E. 1, 2, 4, 5, 3

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

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

Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)

A. SCN

B. Timestamp

C. Named recovery point

D. Transaction ID

E. Session ID

You plan to use Flashback Drop feature to recover a dropped table SALES_EMP. No other table with the same name exists in the schema.

You query RECYCLEBIN and find multiple entries for the SALES_EMP table as follows: You then issue the following statement to recover the table:

SQL> SELECT object_name, original_name, droptime FROM recyclebin;

What would be the outcome of the precedent statement?

A. It retrieves the latest version of the table from the recycle bin

B. It retrieves the oldest version of the table from the recycle bin

C. It retrieves the version of the table for which undo information is available

D. It returns an error because the table name is not specified as per the names in the OBJECT_NAME column

View the Exhibit and examine the data manipulation language (DML) operations that you performed on the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.

What could be the reason?

Exhibit:

A. The first two updated were not explicitly committed.

B. ALTER TABLE caused the recycle bin to release the space.

C. The data definition language (DDL) operation caused a log switch.

D. Flashback Versions Query stops producing versions of rows that existed before a change in the table structure.

You are working on a 24X7 database. You want to design a backup strategy for your database that uses user managed backups. You want to be able to perform all backups while the database remains online.

Which statement about performing user-managed backups in a 24x7 environment is true?

A. You must have change tracking enabled in your database

B. Your database must be running in NOARCHIVELOG mode

C. To back up a tablespace, it must be in backup mode

D. To back up a tablespace, it must first be taken offline

You can back up the RMAN recovery catalog with RMAN.

A. True

B. False

During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information? (Choose all that apply.)

A. V$LOGFILE

B. V$RECOVER_LOG

C. V$RECOVER_DATABASE

D. V$LOG_RECOVER

E. V$LOG