出自:Oracle认证

 You create a salary report to display employee salaries grouped by the dept column. You need to change the break order from ascending to descending using the model. How would you reverse the display order of the department? （）
A:Double click the dept column in the group to alter the property palette and change the break out order value. 
B:Double click the dept column in the group to open the property palette and change the set break order value. 
C:Double click the g_dept group object to change the break order. 
D:Click the dept column in the group to change the break order.
Given: What is the result?（）
A:Mr. John Doe
B:in exception is thrown at runtime.
C:Compilation fails because of an error in line 12.
D:Compilation fails because of an error in line 15.
E:Compilation fails because of an error in line 20.
Examine the following impdp command to import a database over the network from a pre-12c Oracledatabase (source): Which three are prerequisites for successful execution of the command?（）
A:The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role.
B:All the user-defined tablespaces must be in read-only mode on the source database.
C:The export dump file must be created before starting the import on the target database.
D:The source and target database must be running on the same platform with the same endianness.
E:The path of data files on the target database must be the same as that on the source database.
F:The impdp operation must be performed by the same user that performed the expdp operation.
You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
A:Run the SQL Access Advisor.
B:Run the SQL Tuning Advisor （STA）.
C:Run the Automatic Workload Repository （AWR） report.
D:Run the Automatic Database Diagnostic Monitor （ADDM）.
Given: What is the result?（）
A:Exception
B:A,B,Exception
C:Compilation fails because of an error in line 20.
D:Compilation fails because of an error in line 14.
E:A NullPointerException is thrown at runtime.
You need to change the definition of an existing table. The COMMERCIALS table needs its DESCRIPTION column changed to hold varying length characters up to 1000 bytes. The column can currently hold 500 bytes per value. The table contains 20000 rows. Which statement is valid?（）
A:ALTER TABLE commercials MODIFY (description CHAR2(1000));
B:ALTER TABLE commercials CHANGE (description CHAR2(1000));
C:ALTER TABLE commercials CHANGE (description VARCHAR2(1000));
D:ALTER TABLE commercials MODIFY (description VARCHAR2(1000));
E:You cannot increase the size of a column if the table has rows.
Click the Exhibit button. What is the result? （）
A:Value is: 8
B:Compilation fails.
C:Value is: 12
D:Value is: -12
E:The code runs with no output.
F:An exception is thrown at runtime.
Note the following statements that use flashback technology: 1. FLASHBACK TABLE TO SCN ; 2. SELECT * FROM
AS OF SCN 123456; 3. FLASHBACK TABLE
TO BEFORE DROP; 4. FLASHBACK DATABASE TO TIMESTAMP ; 5. SELECT * FROM
VERSIONS AS OF SCN 123456 AND 123999; Which of these statements will be dependent on the availability of relevant undo data in the undo segment?（）
A:1, 2, and 5
B:1, 3, and 4
C:2, 3, 4, and 5
D:1, 2, 3, 4, and 5
首页 <上一页 64 65 66 67 68 下一页> 尾页
自考题库- 赣ICP备18015106号-1