1Z0-052章節(jié)練習(2018.11.16)

You are installing Oracle Database 11g on a machine. When you run the installer， the Oracle Universal Installer（OUI） shows the message that says one of the product-specific prerequisite checks has failed：Checking available swap space requirements ...Expected result： 1512MBActual Result： 1018MB
Check complete. The overall result of this check is： Failed <<<< Problem： The system does not have therequired swap space.
What happens to the installation in this situation（）

You are working on a new Oracle Database 11g server， where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant （DBCA）.Some of the requirements set for your database creation task are：
1.Configure the database to operate in shared server mode.
2.Disable automatic maintenance tasks such as optimizer statistics collection.
3.Configure a naming method to help the remote user connect to the database instance.
4.Use Automatic Storage Management （ASM） for storing the database files.
5.Configure daily database backup to flash recovery area.
6.Configure Enterprise Manager Database Control to manage the database. 
Which of these requirements can be met while creating the database（）

View the Exhibit.

What would happen if Oracle Home is not empty（）

Given below is a list of scenarios： 
1）A user terminates his session abnormally. 
2）The connection between the server and the client application terminates because of a network failure. 
3）A schema is accidentally dropped. 
4）The tablespace is accidentally dropped from the database. 
5）The hard disk gets corrupted and the data files in the disk are lost. 
6）The database instance abnormally shuts down because of power failure. 
Which scenarios require DBA intervention to perform recovery（）

You are managing an Oracle Database 11g database. You want to ensure the recovery of thedatabase to the point of failure. 
Which configuration will you do to accomplish the task（）

View the Exhibit to examine the output produced by the following query at three different times sincethe database instance started and has experienced workloads of different capacities： 
SQL> SELECT substr（component， 0， 10） COMP， current_size CS，user_specified_size USFROM v$memory_dynamic_componentsWHERE current_size!=0； 
What do you infer from this（）

The table contains a million rows for zonewise analysis in the DSS system. DML operations areperformed very rarely on the table. You decide to prepare an index on the ZONE column to enhance theperformance of the queries on the ZONE column. 
Which type of index would you select in this scenario（）

View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes, youexecuted the following command:
SQL> SELECT reason,metric_value FROM dba_outstanding_alerts; REASON METRIC_VALUE------------------------------ ---------------------- Tablespace [TEST] is [28 perce 28.125 nt] fullWhat could be the reason for the elimination of the other rows in the output（）

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effectsof ASMM, you executed the following command: SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario()

Your database instance is functional for the past one month. The Automatic Workload Repository（AWR） snapshot retention is set to 7 and the STATISTICS_LEVEL initialization parameter is set to TYPICAL. 
You receive a complaint about the poor performance of the database between 7 PM and 9 PM of theprevious day. 
Choose two actions any of which can be referred to first to diagnose the problem. （）