1Z0-060 무료 덤프문제 온라인 액세스

You upgrade your Oracle database in a multiprocessor environment. As a recommended you execute the following script:
SQL > @utlrp.sql
Which two actions does the script perform?

• A.Sequential recompilation of Java code
• B.Parallel recompilation of any stored PL/SQL code
• C.Sequential recompilation of any stored PL/SQL code
• D.Sequential recompilation of only the stored PL/SQL code
• E.Parallel recompilation of Java code
• F.Parallel compilation of only the stored PL/SQL code

You issue the following commands:

The directories '/u0l/app/oracle/oradata/orcl'and '/u0l/app/oracle/mydata' exist.
Which statement describes the outcome?

• A.The two tablespaces are created with the data file and temp file in their respective locations as specified in the CREATE commands.
• B.The TEMP101 tablespace is created with its temp file in the DB_CREATE_FILE_DEST location and the tablespace is created with its data file in the '/u01/app/oracle/mydata/ AUGUST_SALES location.
  mysales.dbf'
• C.Tablespace creation ignores the data file and temp file locations specified in the CREATE commands, and creates both the tablespaces in the DB_CREATE_FILE_DEST location.
• D.The AUGUST_SALES tablespace is created with its data file in the DB_CREATE_FILE_DEST location and the TEMP101 tablespace is created with its temp file in the '/u01/app/oracle/mydata' location.

Which three are true about the large pool for an Oracle database instance that supports shared server connections?

• A.Contains a cursor area for storing runtime information about cursors
• B.Contains a hash area performing hash joins of tables
• C.Contains stack space
• D.Allocates memory for shared and private SQL areas
• E.Allocates memory for RMAN backup and restore operations

To implement Automatic Management (AMM), you set the following parameters:

When you try to start the database instance with these parameter settings, you receive the following error message:

Identify the reason the instance failed to start.

• A.Both the SGA_TARGET and MEMORY_TARGET parameters are set.
• B.The SGA_MAX_SIZE and SGA_TARGET parameter values are not equal.
• C.The PGA_AGGREGATE_TARGET parameter is set to zero.
• D.The STATISTICS_LEVEL parameter is set to BASIC.

Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?

• A.numeric columns that will have invalid binary representation after converting to the chosen Unicode character set
• B.date columns that will have invalid binary representation after converting to the chosen Unicode character set
• C.alphanumeric columns that need no conversion
• D.alphanumeric columns that need conversion to a different binary representation before converging to the chosen Unicode character set
• E.alphanumeric columns that will have invalid binary representation after converting to the chosen Unicode character set
• F.numeric columns that will exceed the column size limit after converting to the chosen Unicode character set