出自:Oracle认证

When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?（）
A:The job will be dropped automatically if the value of the AUTO_DROP attribute is TRUE
B:The job will only be disabled if the value of the AUTO_DROP attribute is FALSE
C:The STATE attribute of the job will be set to COMPLETED if the value of the AUTO_DROP attribute is FALSE
D:All objects referenced by the job will be dropped if the value of the AUTO_DROP attribute is TRUE and the value of the CASCADE attribute is TRUE
E:The STATE column of the job table will be set to COMPLETED for the job
You observed the following output for a user session: What do you infer from the preceding output?（）
A:Resumable set for session with sid 18
B:The user session has entered into a deadlock
C:The database instance is enabled to use asynchronous commit
D:The threshold warning limit is exceeded for the tablespace that is used by the user session
In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?（）
A:VARCHAR2
B:CHAR
C:NVARCHAR2
D:CLOB
E:LONG
Consider the following code snippet: If this code were executed, which of the following statements would be true?（）
A:The priority of the lne_job1 job would be set to 1.
B:The lne_job1 job would be executed synchronously.
C:The lne_job1 job would run immediately in the user‟s current session.
D:The lne_job1 job would retain its current priority.
E:The job will immediately take priority over all running jobs.
View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?（）
A:Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.
B:The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.
C:Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.
D:The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.
Given： What is the result？（）
A:test end
B:Compilation fails.
C:test runtime end
D:test exception end
E:A Throwable is thrown by main at runtime.
You are creating the DEPT_SAL data block from the PAYHIST form. Users should be able to enter a valid department ID number, which will then display the employee salary information for that department. This data block could potentially retrieve a large number of records. Since users will probably only view a small number of these records, only 10 records should be fetched at one time. How would you create the data block?（）
A:Select The Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, enter the procedure name in the Query Data Source Columns property, and the procedure code in the Query Data Source Arguments property. 
B:Choose Tools -> Data Block Wizard, select Table as the data source type, and base the block on the columns from the tables. 
C:Choose Tools -> Data Block Wizard, select, View as the data source type, and base the block on the columns from the tables. 
D:Select the Data Blocks node in the Object Navigator and click the Create button. Choose to build the data block manually, alter the Query Data Source Type property to 'FROM clause query', and enter the SELECT statement in the Query Data Source Name property. 
E:Select the Data Block node in the Object Navigator and click the Create button. Alter the Query Data Source Type, Query Data Source Name, Query Data Sources Columns, and Query Data Source Arguments properties to create a stored procedure that uses a red cursor.
以下关于ORACLE的安装的叙述正确的是（）
A:ORACLE的同一安装程序，可以安装到各种操作系统上
B:ORALCE FOR WINDOWS也可以被安装到UNIX系统上
C:ORALCE FOR WINDOWS服务器可以安装到WINDOWS 2000 Professional版上
D:ORALCE FOR WINDOWS服务器只能安装到WINDOWS 2000 Server版上
E:以上所述都不正确
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database， you find that the log switch occurs more than once for every 20 minutes， affecting the database performance. Which factor is responsible for frequent log switches？（）  
A:the value of the UNDO_RETENTION initialization parameter
B:the value of the optimal redo log file size provided by the Redo Logfile Size Advisor
C:the online redo log files size
D:the number of redo log members in a group
Which feature is enabled when you start a WebLogic server with the ¨CDserverType=wlx option?（）
A:JDBC
B:JCA
C:JMS
D:EJB
E:Java EE
After performing a clean shut down of the database instance for maintenance， you mount the database andthen execute a command to open the database：SQL> ALTER DATABASE OPEN； Which two statements are true（）
A:The online redo log files and online data files are opened.
B:All the online data file headers are checked for consistency.
C:Instance recovery is performed before opening the database.
D:The path and existence of all the log file members are checked
You need to calculate the total of all salaries in the accounting department. Which group function should you use? （）
A:MAX
B:MIN
C:SUM
D:COUNT
E:TOTAL
F:LARGEST
Which three statements are true when the listener handles connection requests to an Oracle 12cdatabase instance with multithreaded architecture enabled In UNIX?（）
A:Thread creation must be routed through a dispatcher process
B:The local listener may spawn a now process and have that new process create a thread
C:Each Oracle process runs an SCMN thread.
D:Each multithreaded Oracle process has an SCMN thread.
E:The local listener may pass the request to an existing process which in turn will create a thread.
You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY/x7fMM/x7fDD. The default format of which two data types would be affected by this setting？（）
A:DATE
B:TIMESTAMP
C:INTERVAL YEAR TO MONTH
D:INTERVAL DAY TO SECOND
E:TIMESTAMP WITH LOCAL TIME ZONE
Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1 tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement: ALTER TABLESPACE data1 BEGIN BACKUP; While you are performing the backup, an error occurs that causes the instance to terminate abnormally. Which statement about the DATA1 tablespace is true?（）
A:The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.
B:If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is opened.
C:If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the database is mounted.
D:If you restart the database, the database will not be opened.
（）是Oracle维护数据库中其他文件的列表、数据库名称和系统改变号（SCN）的文件。
A:控制文件
B:参数文件
C:数据文件
D:可执行文件
You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）
A: V$DATABASE
B: V$FLASHBACK_DATABASE_STAT
C: V$FLASHBACK_DATABASE_LOG
D: V$RECOVERY_FILE_DEST
Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）
A:It does not allow you to change the moving window size.
B:Adaptive threshold functionalities use it by default to compute statistics.
C:It is created by default with the window size being equal to the AWR retention time.
D:It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
The database Is configured in ARCHIVELOG mode. The database needs to be up 24 X 7. You want to perform user managed backup for the data files of the HR_DATA tablespace. To accomplish the task， you issued the following command：  SQL> ALTER TABLESPACE hi_data BEGIN BACKUP；   Which two statements are true in this scenario？（）  
A: No transaction on the tablespace is allowed but you can perform queries.
B: The tablespace will automatically come out of backup mode when the file copy is complete.
C: The checkpoint change number is frozen in headers of the data files until the file is removed from backup mode.
D: The database writes the before image of an entire block to the redo stream before modifying. block tor the first time.
View the Exhibit. The DBA creates a new user as follows：  SQL> CREATE USER manfus IDENTIFIED BY manfus TEMPORARY TABLESPACE temp；  User manfus creates a table as follows：  SQL> CREATE TABLE material（id NUMBER（3））；  In which tablespace will the material table be created？（）
A:SYSTEM
B:USERS
C:PROD
D:SYSAUX
E:TEMP
You created the ORDERS table in your database by using the following code：   SQL> CREATE TABLE ORDERS （ORDER_DATE TIMESTAMP（0） WITH TIME ZONE）；   Then， you inserted data in the ORDERS table and saved it by issuing the following statements：SQL> INSERT INTO ORDERS VALUES（’18-AUG-00 10：26：44 PM America/New_York’）；   SQL> INSERT INTO ORDERS VALUES（’23-AUG-02 12：46：34 PM America/New_York’）；   SQL> COMMIT；   Next， you issued the following statement to change the time zone for the database：   SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’；   What will be the result of executing the above statement？（）  
A: The statement will fail.
B: The statement will be executed successfully， and the new time zone will be set for the database.
C: The statement will be executed successfully， but the new time zone will be set for the current session.
D:The statement will be executed successfully， but the new time zone will neither be set for the database nor for a specific session.
The sales report needs to display the sales person with the highest order total. Which build report builder component would you use to create a place holder column to display the value?（）
A:Report wizard. 
B:Layout model. 
C:Data model. 
D:Life previewer.
You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario？（）
A: The disk is immediately dropped from the disk group.
B: The ASM tracks the extents that are modified during the outa
C: The ASM migrates the extents from the unavailable disk to the remaining disks.
D: The disk automatically goes offline.
You execute a command to resize a data file， sales.dbf， of size 200 MB in your database： ALTER DATABASE DATAFILE ’/remorse/sales.dbf’ RESIZE 150M；  Which statement is true about this command（）
A:The command must be issued in MOUNT state.
B:The command succeeds only if the data file is offline.
C:The command must be issued when the database is in the archivelog mode.
D:The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.
In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager.  For which three resources can you enable usage restrictions by using Resource Manager？（）
A:CPU usage
B:degree of parallelism
C:number of open cursors
D:number of sorts performed
E:idle time for blocking sessions
F:number of disk I/O operations performed
G:number of memory I/O operations performed
A data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）
A: Flash back all the tables in the data file， one by one.
B: Restore the data file to a new location and perform a media recovery.
C: Flash back the database， there is no need to restore the data file.
D: Restore the data file from the most recent backup and flash the database.
Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files?（）
A:2, 4, 3
B:1, 4, 3, 2
C:2, 5, 4, 3, 6
D:5, 2, 4, 3, 6
E:1, 5, 4, 3, 6, 2
Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every  Sunday night. On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE；  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord；  SELECT * FROM cust_ord  *ERROR at line 1：ORA-00942： table or view does not exist  Client B needs the dropped table and reports the problem to you.With reference to this scenario， which action should you take？（）
A: retrieve the table by using the flashback feature
B: restore all the data files from last Sunday’s backup and then perform a time-based recovery
C: restore all the data files from last Sunday’s backup and then perform a log sequence recovery
D: restore all the data files from last Sunday’s backup and then perform a cancel-based recovery
E: restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored and then perform a complete recovery
Which two statements are true regarding the USING clause in table joins?（）
A:It can be used to join a maximum of three tables 
B:It can be used to restrict the number of columns used in a NATURAL join 
C:It can be used to access data from tables through equijoins as well as nonequijoins 
D:It can be used to join tables that have columns with the same name and compatible data types
Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? （）
A:It releases the storage space used by the table.
B:It does not release the storage space used by the table.
C:You can roll back the deletion of rows after the statement executes.
D:You can NOT roll back the deletion of rows after the statement executes.
E:An attempt to use DESCRIBE on the DEPT table after the TRUNCATE statement executes will display an error.
F:You must be the owner of the table or have DELETE ANY TABLE system privileges to truncate the DEPT table
首页 <上一页 6 7 8 9 10 下一页> 尾页