出自:Oracle认证

What is the new Oracle Shared Server?（）
A:An improved version of multithreaded server configuration. 
B:A connection pooling configuration where several clients are connected to the same server process. 
C:Two more database servers, which share data by means of database links; the client software is unaware to which server it is connected. 
D:A configuration of Real Application Cluster where the client connection is routed to the least busy instance. 
以下关于%ROWTYPE的作用说法正确的是（）。
A:使用%ROWTYPE来定义一个表示表中一行记录的变量
B:使用%ROWTYPE的变量不能实现将一行记录的部分字段赋值
C:使用%ROWTYPE将一个变量的数据类型与一张表中记录的各个列的数据类型保持一致
Given: What is the result?（）
A:null
B:finally
C:null finally
D:Compilation fails.
E:finally exception
You want to provide a tool that allows users quick access to form modules, by listing them in an Explorer-style interface. Which reusable component do you use?（）
A:ActiveX controls 
B:Calendar Class 
C:Standard Object Library 
D:Picklist Class 
E:Wizard Class 
F:Navigator Class
ORACLE客户端定义与服务器连接的配置文件的路径通常为（）
A:$ORACLE_HOME/bin
B:$ORACLE_HOME/admin/
C:$ORACLE_HOME/network/
D:$ORACLE_HOME/network/admin/
E:以上所述都不正确
The persistent configuration settings for RMAN have default for all parameters.Identify four RMAN commands that produce a multi-section backup.（）
A:BACKUP TABLESPACE SYSTEM SECTION SIZE 100M;
B:BACKUP AS COPY TABLESPACE SYSTEM SECTION SIZE 100M;
C:BACKUP ARCHIVELOG ALL SECTION SIZE 25M;
D:BACKUP TABLESPACE "TEMP" SECTION SIZE 10M;
E:BACKUP TABLESPACE "UNDO" INCLUDE CURRENT CONTROLFILE SECTION SIZE 100M;
F:BACKUP SPFILE SECTION SIZE 1M;
G:BACKUP INCREMENTAL LEVEL 0 TABLESPACE SYSAUX SECTION SIZE 100M;
Given: What is the result?（）
A:Compilation succeeds.
B:Compilation fails due to multiple errors.
C:Compilation fails due to an error only on line 20.
D:Compilation fails due to an error only on line 21.
E:Compilation fails due to an error only on line 22.
F:Compilation fails due to an error only on line 12.
You want to configure the Flashback Database feature and retain flashback logs for three days.  Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this：   1. Set the retention target：  SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320；  2. Enable Flashback Database：  SQL> ALTER DATABASE FLASHBACK ON；  3. Mount the database：  SQL> STARTUP MOUNT EXCLUSIVE  4. Shutdown the instance： SQL> SHUTDOWN IMMEDIATE  5. Open the database：  SQL> ALTER DATABASE OPEN；   Choose the correct sequence.（）
A: 4， 1， 3， 2， 5
B: 4， 3， 1， 2， 5
C: 2， 4， 3， 5， 1
D: 4， 2， 5， 3， 1
The operating system file cratab in the Linux platform gets updated whenever you create a new database on the same host machine. What kind of information is stored is stored in this file？（）
A:OracleSIDsonly
B:Oracle homes only
C:Oracle install timestamp
D:Oracle inventory pointer files
E:Oracle database creation timestamp
F:OracleSIDsand Oracle homes only
G:OracleSIDs， Oracle homes and flag for auto startup
View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans SHRINK SPACE CASCADE; Which statement describes the outcome of the command?（）
A:An error is produced.
B:The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C:The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D:The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
在查询中执行数据过滤是通过查询语句的（）子句来完成的，通过过滤数据，可以只查询满足要求的数据，减少数据查询的量，提高查询性能。
A:WHERE
B:FROM
C:SUQUERY
D:JOIN
View the Exhibit. What would happen if Oracle Home is not empty（）
A:The installation will not be continued until the location is empty.
B:The installation will proceed without overwriting the existing files.
C:The installation can be continued， but the existing files will be overwritten.
D:The installation terminates automatically after showing an error message
In your database， the Log Writer （LGWR） process is unable to write to a member of a current redo log group due to read/write failure. Which two effects would you see in your database？（）
A:The database instance aborts.
B:The database operation temporarily halts till the member becomes available.
C:Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members.
D:The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file.
E:The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.
Oracle的数据操纵包括（）。
A:数据查询操作
B:数据更新操作
C:数据删除操作
D:数据插入操作
Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）
A:It produces an error because data already exists in the table.
B:It produces an error because compression can be enabled at table creation only.
C:It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
D:It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.
Which constraint can be defines only at the column level?（）
A:UNIQUE
B:NOT NULL
C:CHECK
D:PRIMARY KEY
E:FOREIGN KEY
Given： What is the result？（）
A:Compilation fails.
B:pi is bigger than 3.
C:An exception occurs at runtime.
D:pi is bigger than 3. Have a nice day.
E:pi is not bigger than 3. Have a nice day.
You need to give the MANAGER role the ability to select from, insert into, and modify existing rows in the STUDENT_GRADES table. Anyone given this MANAGER role should be able to pass those privileges on to others.Which statement accomplishes this?（）
A:GRANT select, insert, update ON student_grades TO manager
B:GRANT select, insert, update ON student_grades TO ROLE manager
C:GRANT select, insert, modify ON student_grades TO manager WITH GRANT OPTION;
D:GRANT select, insert, update ON student_grades TO manager WITH GRANT OPTION;
E:GRANT select, insert, update ON student_grades TO ROLE manager WITH GRANT OPTION;
F:GRANT select, insert, modify ON student_grades TO ROLE manager WITH GRANT OPTION;
You configured the Flash Recovery Area （FRA） for your database. The database instance is running inARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which twofiles are removed automatically if the space is required in the FRA as per the retention policy（）
A:Flashback log files
B:Backups that have become obsolete
C:User managed backups of the data files and control files
D:Archived redo log files that have multiple copies in a different archive location and not backed up
Examine the data from the ORDERS and CUSTOMERS table. ORDERS ORD_ID ORD_DATE CUST_ID ORD_TOTAL 100 12-JAN-2000 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 104 25-JUN-2000 15 6000 105 18-JUL-2000 20 5000 106 18-JUL-2000 35 7000 107 21-JUL-2000 20 6500 04-AUG- 108 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Linda New York Which SQL statement retrieves the order ID, customer ID, and order total for the orders that are placed on the same day that Martin places his orders?（）
A:SELECT ord_id, cust_id, ord_total FROM orders, customers WHERE cust_name='Mating' AND ord _ date IN ('18-JUL-2000','21-JUL-2000');
B:SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'MARTIN'));
C:SELECT ord_id, cust_id, ord_total FROM orders Where ord_date IN (SELECT ord_date FROM orders, customers Where cust _ name = 'Martin');
D:SELECT ord_id, cust_id, ord_total FROM orders WHERE cust_id IN (SELECT cust_id FROM customers WHERE cust name = 'Martin');
When you use the Oracle Net Configuration Assistant to specify the naming method， which file is updated？（）
A:INIT.ORA
B:SQLNET.ORA
C:LISTENER.ORA
D:TNSNAMES.ORA
Consider the MySQL Enterprise Audit plugin. On attempting to start the MySQL service after a crash, notice the following error: [ERROR] Plugin ‘audit_log’ init function returned error. In the audit log file, you notice the final entry: … What action should you take to fix the error and allow the service to start?（）
A:Re-install the audit plugin
B:Execute the command FLUSH LOGS
C:Execute the command SET GLOBAL audit_log_fiush= ON
D:Move or rename the existing audit.log file
以下关于数据库包的叙述正确是的（）
A:包是由包头和包体组成的，在定义包头时，必须也要同时定义好包体
B:包是由包头和包体组成的，包头和包体是可以分别创建的
C:包是由包头和包体组成的，包头和包体可以写在一起，也可以分别定义
D:包是由包头和包体组成的，包头是包体中所有变量的定义区，而包体则只是执行代码部分
You are identifying dictionary objects in the Oracle database. Which of the following is a view in the data dictionary?（） 
A:V$DATABASE 
B:DBA_TABLES 
C:SYSAUD$ 
D:EMP
Oracle Net Services is composed of several communication layers， known as a stack，which enables clients and database severs to share，modify，and manipulate data. Which reveals the correct architecture，in hierarchical order，of the client-side stack？（）
A:A
B:B
C:C
D:D
What is the purpose of the RMAN recovery catalog？（）
A: Make backups faster
B: Store RMAN metadata
C: Store RMAN scripts
D: Provide the ability to do centralized backup reporting
E: Make recovery faster
Which two statements are true when when a Coherence cluster member is lost ？ （）
A: Remaining members recover by repartitioning the data across the remainig cluster members in parallel with normal request processing
B: Some latencies may be experienced due to higher priority of recovery
C: In flight operations may be lost
D: A system administrator must manually assist recovery of the lost data
Which statements are true regarding the USERS tablespace（）
A:A bitmap is used to record free extents.
B:Free extents information is managed within the tablespace.
C:Free extents information is managed in the SYSAUX tablespace.
D:The data dictionary tables are updated when extents are allocated or deallocated
You are managing an Oracle Database 11g database with this backup strategy：  - Every Sunday night， level 0 backup is performed.  - On Monday night and subsequent days， level 1 incremental backup is performed.  The backups are not cumulative incremental.  Which statement about Monday’s backup is true（）
A:The backup contains all the used blocks.
B:The backup contains all the used and unused blocks.
C:The backup contains blocks that have changed since the last level 0 backup.
D:The backup contains blocks that have changed since the last level 1 backup taken last week.
You executed this command to create a temporary table： SQL> CREATE GLOBAL TEMPORARY TABLE report_work_area （startdate DATE， enddateDATE， class CHAR（20）） ON COMMIT PRESERVE ROWS； Which statement is true about the rows inserted into the REPORT_WORK_AREA table during a transaction（）
A:The rows stay in the table only until session termination.
B:The rows stay in the table only until the next transaction starts on the table.
C:The rows are visible to all current sessions after the transaction is committed.
D:The rows stay available for subsequent sessions after the transaction is committed
首页 <上一页 12 13 14 15 16 下一页> 尾页