出自:Oracle认证

The telesales force requested additional ways to terminate the automated polling questionnaire. In addition to the default functionality, you provide a menu item and a button for this purpose. Adhering to efficient coding practices, which PL/SQL code do you use for the menu item and the button?（）
A:EXIT 
B:EXIT_FORM 
C:DO_KEY('Key-Exit') 
D:DO_KEY('EXIT_FORM')
Given： Which code fragment， inserted at the end of line 12， produces the output p is 420？（）
A:p.setWeight（420）；
B:p.changePayload（420）；
C:p = new Payload（420）；
D:Payload.setWeight（420）；
E:p = Payload.setWeight（420）；
In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）
A:heap table
B:object table
C:external table
D:clustered table
E:global temporary table
F:index­organized table （IOT）
Which two statements complete a transaction? （）
A:DELETE employees;
B:DESCRIBE employees;
C:ROLLBACK TO SAVE POINT C;
D:GRANT SELECT ON employees TO SCOTH
E:ALTER TABLE employees SET UNUSED COLUMN sal;
F:Select MAX(sal) FROM employees WHERE department _ id 20;
In which three situations is incomplete recovery required？（）
A:After a shutdown abort.
B:When recovering to an SCN.
C:When recovering until a specific time.
D:When a required archived log is missing.
You want to analyze a SQL Tuning Set (STS) using SQL Performance Analyzer in a test database. Which two statements are true regarding the activities performed during the test execution of SQLs in a SQL Tuning Set?（）
A:Every SQL statement in the STS is considered only once for execution
B:The SQL statements in the STS are executed concurrently to produce the execution plan and execution statistics
C:The execution plan and execution statistics are computed for each SQL statement in the STS
D:The effects of DDL and DML are considered to produce the execution plan and execution statistics
When you try to open your database， you receive the following error：  ORA-00205： error in identifying control file   Where would you find the details required to resolve this error？（）
A:audit trail
B:alert log file
C:user trace file
D:online trace file
E:background trace file
F:operating system event viewer
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）
A:V_CONTROLFILE_RECORD_SECTION 
B:V_CONTROLFILE 
C:V$PARAMETER 
D:init.ora file
You create a financial report to be represented to board of directors. The accounting manager has asked you to change the number format to show a thousand separator. What is the best method to make this change to the report quickly?（）
A:Open the property palette and set the format mask for all the numeric items in the report. 
B:Select the data to be free formatted in the life previewer and lick on the thousand separator icon on the style bar. 
C:Go to the layout model and change the field attributes for the data to be changed on the report. 
D:Rebuild the report using the report wizard setting this format on creation.
You work as a database administrator for Certkiller .com. You find that the database performance degrades while you backup the Certkiller database using Recovery Manager （RMAN）. The Certkiller database is running in shared server mode. The database instance is currently using 60% of total operating system memory. You suspect the shared pool fragmentation to be the reason.  Which action would you consider to overcome the performance degradation？（）
A:Configure Java Pool to cache the java objects.
B:Configure Streams Pool to enable parallel processing.
C:Increase Shared Pool size to cache more PL/SQL objects.
D:Increase Database Buffer Cache size to increase cache hits.
E:Configure Large Pool to be used by RMAN and shared server.
F:Increase the total System Global Area （SGA） size to increase memory hits.
You notice that your RMAN script used to copy the datafiles， control files， and archived redo log files is performing very slowly. Which two changes might you want to include in your RMAN script to speed up the COPY commands？（）
A:NOCHECKSUM
B:MAXCORRUPT
C:CHECK LOGICAL
D:BACKUP INCREMENTAL
E:CONFIGURE DEVICE TYPE ... PARALLELISM
Given： What is the result？（）
A:Compilation fails.
B:atom granite
C:granite granite
D:atom granite granite
E:An exception is thrown at runtime.
F:atom granite atom granite
Examine the data of the EMPLOYEES table. EMPLOYEES (EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID) Evaluate this SQL statement: What is its output?（）
A:
B:
C:
D:
E:  The SQL statement produces an error.
Examine the description of the EMPLOYEES table: Which statement shows the department ID, minimum salary, and maximum salary paid in that department, only of the minimum salary is less then 5000 and the maximum salary is more than 15000?（）
A:SELECT dept_id, MIN(salary(, MAX(salary)   FROM employees   WHERE MIN(salary) < 5000 AND MAX(salary) > 15000;
B:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   WHERE MIN(salary) < 5000 AND MAX(salary) > 15000   GROUP BY dept_id;
C:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
D:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   GROUP BY dept_id   HAVING MIN(salary) < 5000 AND MAX(salary) < 15000;
E:SELECT dept_id, MIN(salary), MAX(salary)   FROM employees   GROUP BY dept_id, salary   HAVING MIN(salary) < 5000 AND MAX(salary) > 15000;
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
A:SER_NO
B:ORDER_ID
C:STATUS
D:PROD_ID
E:ORD_TOTAL
F:composite index on ORDER_ID and ORDER_DATE
Which value is valid for the iterate parameter in SET_TIMER built-in procedure? （）
A:REUSE 
B:RECYCLE 
C:NO_CHANGE 
D:OCCURRENCE
在iBatis框架的配置文件中，使用（）属性定义缓存模型，可以很容易地缓存查询返回的数据集。
A:LRU
B:oscache
C:Cache Model
D:FIFO
Which naming method uses the tnsnames.ora file to store the connect descriptor used by the client while connecting to the database instance from a remote machine？（）
A:host naming method
B:local naming method
C:external naming method
D:directory naming method
Which three pieces of information are considered while deciding the size of the undo tablespace in your database？（）
A:the size of an undo block
B:the size of the redo log files
C:undo blocks generated per second
D:the size of the database buffer cache
E:the value of the UNDO_RETENTION parameter
In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file：  1.RESTORE CONTROLFILE；  2.RESTORE DATABASE；  3.ALTER DATABASE MOUNT；  4.SQL ALTER TABLESPACE temp ADD TEMPFILE  5.ALTER DATABASE OPEN RESETLOGS；  6.RECOVER DATABASE；  7.STARTUP NOMOUNT；  In what sequence would you use this process to perform the recovery？（）
A: 2， 7， 3， 5， 1， 6， 4
B: 2， 1， 7， 6， 3， 5， 4
C: 7， 1， 3， 2， 6， 5， 4
D: 7， 2， 3， 1， 4， 6， 5
Which two statements are true about Oracle Managed Files (OMF)?（）
A:OMF cannot be used in a database that already has data files created with user-specified directions.
B:The file system directions that are specified by OMF parameters are created automatically.
C:OMF can be used with ASM disk groups, as well as with raw devices, for better file management.
D:OMF automatically creates unique file names for table spaces and control files.
E:OMF may affect the location of the redo log files and archived log files.
You work as a database administrator for Supportcenter.cn. Client connection requests are failing because the listener is not responding. You want to forward client connect requests to another listener if one listener is not responding. How do you achieve this？（）
A:Enable instance failover
B:Configure shared server
C:Enable database failover
D:Enable connect-time failover
E:Enable Transparent Application Failover （TAF）
Given: Which statement is true?（）
A:Compilation succeeds.
B:Class A does not compile.
C:The method declared on line 9 cannot be modified to throw TestException.
D:TestA compiles if line 10 is enclosed in a try/catch block that catches TestException.
An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace threshold alerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBS tablespace does not include autoextensible data files?（）
A:TEST_TBS is a small file tablespace.
B:TEST_TBS is a bigfile tablespace (BFT).
C:TEST_TBS is the default temporary tablespace.
D:TEST_TBS is a dictionary-managed tablespace.
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?（）
A:An entry is created in the alert log file and the database instance continues to function normally
B:The log switch hangs occur for transactions until free space is available in the flash recovery area
C:The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area Oracle
D:The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented
在CREATE TABLESPACE语句中使用（）关键字可以创建临时表空间。
A:TEM
B:BIGFILE
C:TEMPORARY
D:EXTENT MANAGEMENT LOCAL
You work as a database administrator for Certkiller .com. You are working on Oracle Database 10g. To forward client connections to an instance， the listener must know information such as the name of the instance and where the instance’s ORACLE_HOME is located. How does the listener get this information？（）
A:It gets it from the parameter file.
B:The listener prompts for details on startup.
C:The listener gathers information from the control file.
D:The instance automatically registers with the default listener.
E:The listener gets this information through thelistener.orafile.
Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this statement have on the database？（）
A:The extents in undo tablespace retain data until the next full database backup.
B:The extents containing committed data in the undo tablespace are never overwritten.
C:The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
D:The extents containing committed data in the undo tablespace are not overwritten until the instance is shut down.
An important tablespace of your database is dropped by mistake. You use the Flashback Database feature to retrieve the tablespace. You perform the following steps to retrieve the tablespace：   1. You log on to Enterprise Manager as SYSDBA.    2. You select the maintenance screen.    3. You choose Perform Recovery option on the maintenance screen.    4. You choose Whole Database in the Object Type drop-down list Perform Recovery： Type screen. 5. You choose Recover to Current Time from the Operation Type on the Perform Recovery： Type screen.    6. You provide the Host Credentials for a database user. on the Perform Recovery： Type screen.    7. You click the continue button.    An information screen appears saying that the database is unavailable. What is this information screen？（）
A:Recovery Manager
B:Recovery Window
C:Recovery Wizard
D:Enterprise Manager Home Page
当JDBC程序提取SQL数据到Java中的时候，需要执行数据类型转换，例如，SQL数据类型CHAR将转换为标准java数据类型（）处理。
A:CHAR
B:STRING
C:RECORD
D:byte
首页 <上一页 134 135 136 137 138 下一页> 尾页