Oracle 1Z0-055 Online Practice Questions and Exam Preparation

Oracle 1Z0-055 Online Questions & Answers

• Question 121:

  You have the following requirements in relation to the detection of block corruption for your database instance:

  Check for logical self-consistency of data blocks when modified in memory Checksums are calculated before and after the block change Checks are performed for the lost writes to the physical standby database

  Which method would help you perform the above checks automatically?

  A. Set the DB_SECUREFILE parameter to PERMITTED
  B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY
  C. Set the DB_LOCK_CHECKSUM parameter to TYPICAL
  D. Set the DB_LOST _WRITE_PROTECT parameter to TYPICAL
  B. Set the DB_ULTRA_SAFE parameter to DATA_ONLY

• Question 122:

  To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SET_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL>ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop, 10; Whist the significance of this setting?

  A. It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance
  B. It terminates the client connection after 10 bad packets but the client can still reconnect and attempt the same operation again
  C. It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance
  D. It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes
  B. It terminates the client connection after 10 bad packets but the client can still reconnect and attempt the same operation again

• Question 123:

  You executed the following command to drop a user:

  DROP USER scott CASCADE;

  Which two statements regarding the above command are correct? (Choose two.)

  A. All the objects of scott are moved to the Recycle Bin
  B. Any objects in the Recycle Bin belonging to scott are purged
  C. All the objects owned by scott are permanently dropped from the database
  D. All the objects of scott in the Recycle Bin must be purged before executing the DROP command
  E. Any objects in the Recycle Bin belonging to scott will not be affected by the above DROP command
  B. Any objects in the Recycle Bin belonging to scott are purged
  C. All the objects owned by scott are permanently dropped from the database

• Question 124:

  See the Exhibit: As shown in exhibit examine the Data Pump architecture: Identify the numbered components:

  

  A. 1- Oracle Loader, 2 ?Oracle Data Pump, 3 ?Direct Path API
  B. 1 ?Oracle Data Pump, 2 ?Direct Path API, 3 ?Oracle Loader
  C. 1 ?Direct Path API, 2 ?Oracle Loader, 3 ?Oracle Data Pump
  D. 1 ?Oracle Loader, 2 ?Direct Path API, 3 ?Oracle Data Pump
  A. 1- Oracle Loader, 2 ?Oracle Data Pump, 3 ?Direct Path API

• Question 125:

  You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?

  A. Data Pump Export and Import
  B. Conventional export and import
  C. The CONVERT command of RMAN
  D. The BACKUP AS COPY..... command of RMAN
  D. The BACKUP AS COPY..... command of RMAN

• Question 126:

  The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?

  A. Create two custom ADDM tasks
  B. Modify the AWR snapshot time interval to two hours
  C. Create a new scheduler window for a time period to two hours
  D. Modify the Automatic Workload Repository(AWR) snapshot retention period to two hours
  B. Modify the AWR snapshot time interval to two hours

• Question 127:

  You have three temporary tablespace groups named G1, G3 and G3 in you database.

  You are creating a new temporary tablespace as follows:

  CREATE TEMPORARY TABLESAPCE TEMP1 TEMPFILE `/u1/data/temp1.dbf' SIZE 10M TABLESPACE GROUP";

  Which statement regarding the above command is correct?

  A. It will create the tablespace TEMP1 in group G1
  B. It will create the tablespace TEMP1 in group G3
  C. It will not add the tablespace TEMP1 to any group
  D. It will create the tablespace TEMP1 in the default group
  C. It will not add the tablespace TEMP1 to any group

• Question 128:

  The application tables ownedby the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump. Which option of Data Pump Import would you use to accomplish this?

  A. owner
  B. touser
  C. attach
  D. remap_schema
  D. remap_schema

• Question 129:

  The following databases are registered in the base recovery catalog: PROD1, PROD2 and PROD3. The database use CATOWNER owns the base recovery catalog. You want a new user VPC1 to have access to only the PROD1 database and create a virtual private catalog:

  Given below are some of the commands required to achieve this:

  

  What is the correct sequence in which the commands have to be executed?

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

• Question 130:

  See the following SQL statements and output:

  

  Which two statements correctly interpret the output? (Choose two.)

  A. FREE_SPACE indicates only the space that is currently unallocated
  B. ALLOCATED_SPACE indicates only the space currently allocated and in use
  C. FREE_SPACE indicates only the space that is currently allocated and available for reuse
  D. ALLOCATED_SPACE indicates both the space currently allocated and used and the space that is available for reuse
  E. FREE_SPACE indicates both the space that is currently allocated and available for reuse and the space that is currently unallocated
  D. ALLOCATED_SPACE indicates both the space currently allocated and used and the space that is available for reuse
  E. FREE_SPACE indicates both the space that is currently allocated and available for reuse and the space that is currently unallocated