出自:Oracle认证

You executed the following command: RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf'; Which statement regarding the above command is correct?（）
A:The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy
B:The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup
C:  Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes up to incremental backup SCN. '/ u01/app/oracle/oradata/orcl/users01.dbf
D:Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above command if data file recovery fails
Management has asked you to calculate the value 12*salary* commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCNAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated columns for all employees? （）
A:SELECT last_name, 12*salary* commission_pct FROM emp;
B:SELECT last_name, 12*salary* (commission_pct,0) FROM emp;
C:SELECT last_name, 12*salary*(nvl(commission_pct,0)) FROM emp;
D:SELECT last_name, 12*salary*(decode(commission_pct,0)) FROM emp;
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement：   SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’；   What will be the result of issuing the above statement？（）
A: The statement will be executed successfully， and a new time zone will be set for the database.
B: The statement will be executed successfully， but a new time zone will not be set for the database.
C: The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
D: The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
Given: What is the result?（）
A:harrier
B:shepherd
C:retriever
D:Compilation fails.
E:retriever harrier
F:An exception is thrown at runtime.
Which two are advantages of using WLS JMS instead of using a third-party JMS Provider （Tibco， Sonic， etc.） ？ （）
A: JMS subsystem of WLS shares same JVM as core WLS application server， so application avoids the overhead of message serialization/de-serialization （necessary when using a 3rd party JMS provider with WLS）
B: WLS JMS ai always faster than 3rd party JMS providers
C: Unified operations and management tools across Application Server and JMS Provider will help with mangeability and diagnostics
D: WLS JMS more compliant with JMS spec than 3rd party vendors
Which of the following NLS_SORT parameter values would result in case-insensitive and accent-insensitive binary sorts?（）
A:NLS_SORT = BINARY
B:NLS_SORT = BINARY_AI
C:NLS_SORT = BINARY_CI
D:NLS_SORT = BINARY_AI_CI
E:Binary sorts are case insensitive and accent insensitive by default.
In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）
A:hash clusters
B:index clusters
C:partitioned tables
D:index­organized table （IOT）
The direct handoff connection method to an Oracle9i Shared Server involves fewer messages than in previous releases of the multithreaded architecture. Which type of message has been eliminated？（）
A:The initial request from the client to the listener.
B:Messages between the dispatcher and the shared server background processes.
C:A redirect message from the listener to the client during client connections.
D:Round-trip messages between the listener and the shared server background processes.
（）是由表和视图组成的、存储有关数据库结构信息的一些数据库对象，描述了实际数据是如何组织的。对它们可以像处理其他数据库表或视图一样进行查询，但不能进行任何修改。
A:数据字典
B:数据文件
C:控制文件
D:表空间
In your test database， you find that a user’s session is executing a lot of SQL statements， resulting in the generation of a large number of trace files. While investigating the reason， you find that SQL trace has been enabled at the instance level. You want to disable SQL trace， remotely， only for that user session to reduce the volume of trace data being generated.How do you achieve this objective？（）
A: by setting the SQL_TRACE parameter to FALSE in the parameter file
B: by using DBMS_MONITOR.SESSION_TRACE_DISABLE to disable the tracing for the user session
C: by setting the SQL_TRACE parameter to FALSE by using the ALTER SYSTEM command in the user session
D: by setting the SQL_TRACE parameter to FALSE by using the ALTER SESSION command in the user session
Given： Which statement is true？（）
A:The output could be 5-1 6-1 6-2 5-2
B:The output could be 6-1 6-2 5-1 5-2
C:The output could be 6-1 5-2 6-2 5-1
D:The output could be 6-1 6-2 5-1 7-1
Which three values are valid parameters for the DO_KEY built-in?（）
A:ENTER 
B:GO_ITEM 
C:VALIDATE 
D:EXIT_FORM 
E:EXECUTE_QUERY
You are working on an instance started using the SPFILE. You want to move the Flash Recovery Areaof your database to a new location. You want the Flashback log files to be stored in the new location. Given below are the steps to accomplish the task in random order：  1）Shut down the instance.  2）Change the value of the DB_RECOVERY_FILE_DEST initialization parameter to a new value.  3）Execute the ALTER DATABASE FLASHBACK OFF command.  4）Start up the instance and mount the database.  5）Execute the ALTER DATABASE FLASHBACKON command.  6）Open the database.  Select the correct order in which these tasks need to be performed. （）
A:2，1，4，3，5，6
B:1，4，3，2，6，5
C:1，4，2，6，3，5
D:3，2，1，4，5，6
Which three are true? （）
A:A MERGE statement is used to merge the data of one table with data from another.
B:A MERGE statement replaces the data of one table with that of another.
C:A MERGE statement can be used to insert new rows into a table.
D:A MERGE statement can be used to update existing rows in a table.
As an alternative to setting the Visible property to No for the ORDERS_WINDOW, which built-in could you use to achieve the same result? （）
A:HIDE_WINDOW 
B:CLOSE_WINDOW 
C:REPLACE_CONTENT_VIEW
D:GET_WINDOW_PROPERTY
Examine the following scenario: The target database instance is running. The most recent backup available for the target database was taken two days ago. Log files switches have occurred in last two days. The target database is duplicated on the same host, using the Recovery Manager (RMAN) duplicate command as follows: Which statement is true about the duplicate database in this scenario?（）
A:It contains data till the last backup
B:It contains all data from target database until the current time
C:It contains all data from only the committed transactions in the target database
D:It contains all data except that which is used by the transactions in the current online redo file of target database
In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries. Which option would you use with the ALTER TABLE command to achieve this objective？（）
A: REBUILD
B: CASCADE
C: TRUNCATE
D: ROW MOVEMENT
E: SHRINK SPACE COMPACT
F: SHRINK SPACE CASCADE
What does the Character Set Scanner command line utility do？（）
A:Reports only on any Unicode character conversions required.
B:Performs character set conversions to the new specified character set.
C:Scans on any character set conversion required， then converts the data.
D:Checks for any character definitions that will fail conversion to the new character set.
Which two statements are true about WHERE and HAVING clauses? （）
A:A WHERE clause can be used to restrict both rows and groups.
B:A WHERE clause can be used to restrict rows only.
C:A HAVING clause can be used to restrict both rows and groups.
D:A HAVING clause can be used to restrict groups only.
E:A WHERE clause CANNOT be used in a query of the query uses a HAVING clause.
F:A HAVING clause CANNOT be used in subqueries.
The database was started up using a text parameter file. What will be the default scope of changes made by using the SET clause of the ALTER SYSTEM statement？（）
A:Only MEMORY is updated.
B:Only SPFILE values are updated.
C:Only init.ora parameters are updated.
D:Both init.ora parameters and SPFILE values are updated.
Which step is required for recover from an instance failure？ （）
A:Start up only.
B:Restore needed data files， then start up.
C:Complete restore from backup， then start up.
D:Perform point in time recovery， then start up.
下面哪个操作会导致用户连接到ORACLE数据库，但不能创建表（）。
A:授予了CONNECT的角色，但没有授予RESOURCE的角色
B:没有授予用户系统管理员的角色
C:数据库实例没有启动
D:数据库监听没有启动
Which two are true about aggregate functions? （）
A:You can use aggregate functions in any clause of a SELECT statement.
B:You can use aggregate functions only in the column list of the SELECT clause and in the WHERE clause of a SELECT statement.
C:You can mix single row columns with aggregate functions in the column list of a SELECT statement by grouping on the single row columns.
D:You can pass column names, expressions, constants, or functions as parameters to an aggregate function.
E:You can use aggregate functions on a table, only by grouping the whole table as one single group.
F:You cannot group the rows of a table by more than one column while using aggregate functions.
Given： Which code， inserted at line 4， guarantees that this program will output [1， 2]？（）
A:Set set = new TreeSet（）；
B:Set set = new HashSet（）；
C:Set set = new SortedSet（）；
D:List set = new SortedList（）；
You have not configured Oracle Managed Files （OMF） in your database. You do not want to scan the entire datafile every time an incremental backup is performed. You decide to enable the block change tracking feature.  Which statement should you use to enable the block change tracking feature？（）  
A: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING
B: ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE 
C: ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE 
D: ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING
Given classes defined in two different files:What is required at line 5 in class SomeApp to use the process method of BitUtils?（）
A:process(bytes);
B:BitUtils.process(bytes);
C:util.BitUtils.process(bytes);
D:SomeApp cannot use methods in BitUtils.
E:import util.BitUtils.*; process(bytes);
Given：   12. NumberFormat nf = NumberFormat.getInstance（）；   13. nf.setMaximumFractionDigits（4）；   14. nf.setMinimumFractionDigits（2）；   15. String a = nf.format（3.1415926）；   16. String b = nf.format（2）；   Which two statements are true about the result if the default locale is Locale.US？（）
A: The value of b is 2.00.
B: The value of a is 3.141.
C: The value of a is 3.14.
D: The value of b is 2.0000.
E: The value of a is 3.1415.
F: The value of a is 3.1416.
G: The value of b is 2.
In a typical production environment， which server（s） hosts the application ？（）
A: Node Server
B: Administration Server
C: Managed Server
D: Configuration Server
You plan to use static database registration for a new listener when you create it.What could be the two reasons for this？（）
A:More than one database is to be registered with the listener.
B:The users will connect the database by using the host naming method.
C:The Oracle Enterprise Manager is to be used to monitor an Oracle9i database.
D:The database that is to be registered with the listener is configured in shared server mode.
E:The listener is not configured on the default port of 1521 and the instance is not configured to register with a nondefault port.
Which two requirements are critically important to implement for your database backup strategy if you require a 24 hours a day， 7 days a week production environment？（）
A:ARCHIVELOG mode.
B:NOARCHIVELOG mode.
C:Open database backups.
D:Consistent whole backups.
首页 <上一页 2 3 4 5 6 下一页> 尾页