Online Access Free 1Z0-055 Exam Questions

Examine the following values of the initialization parameters in the database having the SID ORCL:
BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump
USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump
CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump
DIAGNOSTIC_DEST=
The environment variables have the following value:
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1
What is the location of the Automatic Diagnostic Repository (ADR) home?

• A.$ORACLE_HOME/log
• B./u01/app/oracle
• C./u01/app/oracle/product/11.1.0/db_1
• D.$ORACLE_HOME/bdump

View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.
What is the reason for this error?

• A.The failure ID has not been mentioned in the command for data file 5.
• B.The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.
• C.There are new failures recorded in the Automatic Diagnostic Repository (ADR).
• D.Another repair session is running concurrently.

The application tables owned by 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.remap_schema
• B.touser
• C.owner
• D.attach

View the Exhibit exhibit1 to observe the maintenance window property.
View the Exhibit exhibit2 to examine the output of the query.
Which two statements describe the conclusions? (Choose two.)

• A.RESOURCE_PERCENTAGE should be decreased.
• B.The window duration should be increased.
• C.The repeat time for the window should be decreased.
• D.RESOURCE_PERCENTAGE should be increased.

View the Exhibit for some of the current parameter settings.
A user logs in to the HR schema and issues the following commands:
SQL> CREATE TABLE emp (empno NUMBER(3), ename VARCHAR2(20), sal NUMBER(8,2));
SQL> INSERT INTO emp(empno,ename) VALUES(1,'JAMES');
At this moment, a second user also logs in to the HR schema and issues the following command:
SQL> ALTER TABLE emp MODIFY sal NUMBER(10,2);
What happens in the above scenario?

• A.The second user's command executes successfully.
• B.A deadlock is created.
• C.The second user's session waits for a time period before producing the resource busy error.
• D.The second user's session immediately produces the resource busy error.