Free 1Z0-053 Questions for Oracle Database 11g: Administration II 1Z0-053 Exam as PDF & Practice Test Engine
Which tasks are run automatically as part of the Automated Maintenance Task by default? (Choose all that apply.)
Correct Answer: C,D,E
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario? (Choose all that apply.)
Correct Answer: A,B,D
Vote an answer
Consider the following scenario for your database:
-Backup optimization is enabled in RMAN.
-The recovery window is set to 7 days in RMAN.
-The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
-The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk.
Which statement is true regarding the backup of the TOOLS tablespace?
-Backup optimization is enabled in RMAN.
-The recovery window is set to 7 days in RMAN.
-The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007.
-The TOOLS tablespace is read-only since November 4, 2007.
On November 23, 2007, you issue the RMAN command to back up the database to disk.
Which statement is true regarding the backup of the TOOLS tablespace?
Correct Answer: B
Vote an answer
The following command is executed to create the baseline template:
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(
START_TIME=> TO_TIESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4',
EXPIRATION=>NULL); Which statement is true about the effect of the above command?
SQL> EXECUTE DBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE(
START_TIME=> TO_TIESTAMP(SYSDATE+2),
END_TIME=>TO_TIMESTAMP(SYSDATE+10),
BASELINE_NAME=>'Mybase4',
TEMPLATE_NAME=>'Mytemp4',
EXPIRATION=>NULL); Which statement is true about the effect of the above command?
Correct Answer: B
Vote an answer
What are the two different types of database duplication? (Choose two.)
Correct Answer: C,D
Vote an answer
When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?
Correct Answer: E
Vote an answer
In order to perform Flashback Transaction Query operations, which of these steps are required? (Choose all that apply.)
Correct Answer: B,E
Vote an answer
Which two statements correctly describe the relationship among the Scheduler components: job, program, and schedule? (Choose two)
Correct Answer: B,C
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
Which three tasks can be performed using a duplicate database? (Choose three.)
Correct Answer: A,B,C
Vote an answer
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:
RMAN> RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;
BACKUP DATABASE FILESPERSET 4;
}
What is the multiplexing level in the preceding backup process?
RMAN> RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8;
BACKUP DATABASE FILESPERSET 4;
}
What is the multiplexing level in the preceding backup process?
Correct Answer: A
Vote an answer
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?
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?
Correct Answer: D
Vote an answer
Explanation: Only visible for ExamDiscuss members. You can sign-up / login (it's free).
What two statements are true regarding the recommendations received from the SQL Access Advisor? (Choose two.)
Correct Answer: C,D
Vote an answer
Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss.
To which point can you restore your database?
To which point can you restore your database?
Correct Answer: C
Vote an answer
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?
Exhibit:
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?
Exhibit:
Correct Answer: C
Vote an answer
0
0
0
10