1Z1-052 무료 덤프문제 온라인 액세스

You have issued a SHUTDOWN ABORT command to bring down your database instance.
Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are opened.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data file headers are checked for consistency.
7. Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

• A.1, 2, 3, 7, 5, 6, 4
• B.1, 7, 5, 4, 2, 3, 6
• C.7, 1, 5, 2, 3, 6, 4
• D.7, 1, 4, 5, 2, 3, 6

You are working on an instance started using the SPFILE. You want to move the Flash Recovery Area of your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order:
1) Shut down the instance.
2) Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.
3) Execute the ALTER DATABASE FLASHBACK OFF command.
4) Start up the instance and mount the database.
5) Execute the ALTER DATABASE FLASHBACK ON command.
6) Open the database.
Select the correct order in which these tasks need to be performed.

• A.2, 1, 4, 3, 5, 6
• B.1, 4, 3, 2, 6, 5
• C.3, 2, 1, 4, 5, 6
• D.1, 4, 2, 6, 3, 5

User SCOTT wants to perform a bulk insert operation in the EMP_DEP table. SCOTT receives the following error after the INSERT statement is issued and few rows are inserted:
INSERT INTO EMP_DEP (emp_id,name,salary,dep_name,mgr_id)
* ERROR at line 1:
ORA-01653: unable to extend table SCOTT.EMP_DEP by 128 in tablespace USERS Identify two actions either of which will help you resolve this problem. (Choose two.)

• A.Add data files to the USERS tablespace.
• B.Grant the RESOURCE role to SCOTT.
• C.Grant the CREATE ANY TABLE privilege to SCOTT.
• D.Increase the size of the data file associated with the USERS tablespace.
• E.Increase the space for SCOTT on the USERS tablespace.

In your database instance, the STATISTICS_LEVEL initialization parameter is set to BASIC.
What is the impact of this setting?

• A.The snapshots for the Automatic Workload Repository (AWR) are not generated automatically.
• B.Snapshots cannot be collected manually by using the
  DBMS_WORKLOAD_REPOSITORY package.
• C.Only timed operating system (OS) statistics and plan execution statistics are collected.
• D.Optimizer statistics are collected automatically.
• E.The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.

You used the IMMEDIATE option to shutdown your database instance. Consider the steps that will be performed later when you open the database:
1 . SGA is allocated.
2 . Control file is read.
3 . Redo log files are read.
4 . Instance recovery is started.
5 . Background processes are started.
6 . Data files are checked for consistency.
7 . Server parameter file or the initialization parameter file is read.
Which option has the correct order in which these steps occur?

• A.1, 5, 7, 2, 3, 6; step 4 is not required
• B.1, 2, 3, 5, 6, 4; step 7 is not required
• C.7, 1, 5, 2, 3, 6, 4
• D.7, 1, 5, 2, 3, 6 step 4 is not required