出自:Oracle认证

You would like to display the system date in the format "Monday, 01 June, 2001". Which SELECT statement should you use? （）
A:SELECT TO_DATE(SYSDATE, 'FMDAY, DD Month, YYYY') FROM dual;
B:SELECT TO_CHAR(SYSDATE, 'FMDD, DY Month, 'YYYY') FROM dual;
C:SELECT TO_CHAR(SYSDATE, 'FMDay, DD Month, YYYY') FROM dual;
D:SELECT TO_CHAR(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
E:SELECT TO_DATE(SYSDATE, 'FMDY, DDD Month, YYYY') FROM dual;
Given： Which five methods， inserted independently at line 5， will compile？（）
A:public int blipvert（int x） { return 0； }
B:private int blipvert（int x） { return 0； }
C:private int blipvert（long x） { return 0； }
D:protected long blipvert（int x） { return 0； }
E:protected int blipvert（long x） { return 0； }
F:protected long blipvert（long x） { return 0； }
Which two statements are correct about database transportation？（） 
A: The source and target platforms must be the same
B: Redo logs，control files and temp files are also transported
C: The transported database must have the same database identifier （DBID） as the source database and cannot be changed
D: The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E: Recovery Manager （RMAN） is used to convert the necessary data files of the database if the target platform is different and has different endian format
ou are implementing control file multiplexing. Which of the following choices identifies the method you can use in order to generate the control file copies that Oracle will maintain?（）
A:Issue ALTER DATABASE BACKUP CONTROLFILE TO filename
B:Make a copy of the control file with the database shut down
C:Issue ALTER DATABASE BACKUP CONTROLFILE TO trace
D:Make a copy of the control file with the database still running 
Given： If some sort of exception is thrown at line 34， which output is possible？（）
A:a
B:b
C:c
D:ac
E:abc
User Scott has updated the salary of one of the employees in the EMPLOYEES table and has not committed the transaction. What are the two types of locks that this scenario would lead to？（）
A:null lock on the row being updated
B:null lock on the table containing the row
C:ROW SHARE lock for the row being updated
D:ROW EXCLUSIVE lock for the row being updated
E:shared row-exclusive lock for the row being updated
F:a shareable table lock for the table containing the row
G:exclusive table-level lock for the table containing the row
Which clause would you use in a SELECT statement to limit the display to those employees whose salary is greater then 5000?（）
A:ORDER BY SALARY > 5000
B:GROUP BY SALARY > 5000
C:HAVING SALARY > 5000
D:WHERE SALARY > 5000
Which is an /SQL*Plus command? （）
A:INSERT
B:UPDATE
C:SELECT
D:DESCRIBE
E:DELETE
F:RENAME
View the Exhibit and examine the parameters. User A executes the following command to update the TRANS table： SQL> UPDATE B.trans SET tr_amt=tr_amt+500 WHERE c_code=’C005’；  Before user A issues a COMMIT or ROLLBACK command， user B executes the following command onthe TRANS table：  SQL> ALTER TABLE trans MODIFY （tr_type VARCHAR2（3））；  What would happen in this scenario（）
A:The ALTER TABLE command modifies the column successfully.
B:The DDL operation gets higher priority and transaction for user a is rolled back.
C:The ALTER TABLE command waits indefinitely until user a ends the transaction.
D:The ALTER TABLE command fails after waiting for 60 seconds due to the resource being busy.
What are four benefits of recommended basic architecture?（）
A:Good load balancing between Presentation Tier and Object Tier
B:Easy administration
C:Flexible Load balancing
D:Optimal performance
E:Simple security
（）方式的导出会从指定的表中导出所有的数据。
A:分区
B:表
C:全部数据库
D:表空间
Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup？（）  
A: ASM_DISKMOUNT
B: ASM_DISKGROUP
C: ASM_DISKSTRING
D: ASM_MOUNTGROUP
Your database instance is running.You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）
A:Oracle Net Manager
B:Listener Control utility
C:Database Configuration Assistant
D:Oracle Net Configuration Assistant
Automatic Shared Memory Management （ASMM） has been enabled for your database instance.  Theinitialization parameters for the components that are managed by ASMM are not set. After observing theeffects of ASSM， you executed the following command： SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M；  Which statement is true in this scenario（）
A:The minimum memory size for the database buffer cache is set to 100 mb.
B:The maximum memory size that can be obtained by the database buffer cache during ASMM is set to100 mb
C:The minimum memory size allocated for a server process in the database buffer cache in dedicatedmode is set to 100 mb.
D:The maximum memory size from the database buffer cache that can be released for dynamicdistribution during ASMM is set to 100 mb
Consider this RMAN command：   RMAN> CONFIGURE RETENTION POLICY CLEAR；   What is the effect of this command？（）
A:Backups will never expire.
B:It removes any retention policy.
C:The DELETE OBSOLETE command will fail with an error.
D:It sets the retention policy to the default of REDUNDANCY 1.
Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.  What action would you take to achieve this task（）
A:Insert finding directives for ADDM tasks in the future.
B:Create a baseline on a pair of snapshots spanning the peak-load period.
C:Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
D:Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots
As an architect for ABC bank， you have been tasked to improve the performance of their online balance transfer application. Due to various margers and takeovers， the bank has heterogeneous systems. Some applications are based on Java while others on  either .net or C++. You would like to propose object serialization with Coherence to enable passing objects between these different language platforms.  Which of the following options provides the capability ？（）
A: Standard Java serialization
B: .Net Binary serialization
C: Coherence Portable Object Format
D: Coherence Externalizable Lite
Which two statements regarding a SQL profile are true?（）
A:It is built by Automatic Tuning Optimizer.
B:It cannot be stored persistently in the data dictionary.
C:It can be used by the query optimizer automatically.
D:It can be created manually by using the CREATE PROFILE command.
To reference existing ASM files， you need to use a fully qualified ASM filename. Your development database has a disk group named DG2A， the database name is DEV19， and the ASM file that you want to reference is a datafile for the USERS02 tablespace.  Which of the following is a valid ASM filename for this ASM file？（）
A: dev19/+DG2A/datafile/users02.701.2
B: +DG2A/dev19/datafile/users02.701.2
C: +DG2A/dev19/users02/datafile.701.2
D: +DG2A·701.2
E: +DG2A/datafile/dev19.users.02.701.2
Click the Exhibit button. Which statement is true about the set variable on line 12？（）
A:The set variable contains all six elements from the coll collection， and the order is guaranteed to be preserved.
B:The set variable contains only three elements from the coll collection， and the order is guaranteed to be preserved.
C:The set variable contains all six elements from the coll collection， but the order is NOT guaranteed to be preserved.
D:The set variable contains only three elements from the coll collection， but the order is NOT guaranteed to be preserved.
Data files of which three tablespaces can be recovered by performing an openrecovery？（）
A:TEMP
B:UNDO
C:INDEX
D:SYSAUX
E:SYSTEM
Which statement about windows and blocks is true?（）
A:Transaction management is block-oriented rather than window-oriented. 
B:Forms automatically navigates to an item located in an activated window. 
C:A window may contain multiple blocks, but each block can only span one window. 
D:A window can contain multiple canvases, and an item can be located on multiple canvases. 
Manually， you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective？（）
A: The user must have been granted the DBA role.
B: The user must have been granted the switch privilege as a part of a role.
C: The user must have been granted the Resource Manager administrator privilege.
D: The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）
A:RECOVER LOGFILE BLOCK GROUP 2；
B:ALTER DATABASE DROP LOGFILE GROUP 2；
C:ALTER DATABASE CLEAR LOGFILE GROUP 2；
D:ALTER DATABASE RECOVER LOGFILE GROUP 2；
E:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
执行特定任务的子程序是（）。
A:函数
B:过程
C:程序包
D:游标
You work as a database administrator for Supportcenter.cn. In a production environment， users complain about the slow response time when accessing the database. You have not optimized the memory usage of the Oracle instance and you suspect the problem to be with the memory. To which type of object would you refer to determine the cause of the slow response？（）
A:The trace file
B:The fixed views
C:The data dictionary views
D:The operating system log fields
E:The dynamic performance views.
You are the Database Administrator （DBA） of your company. You execute the following statement on an Oracle 10g instance：   SQL> ALTER SYSTEM SWITCH LOGFILE；   Which two tasks are performed when the statement is executed？ （）
A: The DBWn process writes to the datafile.
B: Changes in the background process are recorded.
C: The log file is updated with the current SCN number.
D: The System Change Number （SCN） is recorded in the control file.
E: The changes to the listener configuration in the listener.ora file are recorded.
You need to perform these tasks: 1. Create and assign a MANAGER role to Blake and Clark 2. Grant CREATE TABLE and CREATE VIEW privileges to Blake and Clark Which set of SQL statements achieves the desired results?（）
A:CREATE ROLE manager; GRANT create table, create view TO manager; GRANT manager TO BLACK, CLARK;
B:CREATE ROLE manager; GRANT create table, create voew TO manager; GRANT manager ROLE TO BLACK, CLARK;
C:GRANT manager ROLE TO BLACK, CLARK; GRANT create table, create voew TO BLACK CLARK; ***MISSING***
You create two resource plans，one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.  How would you achieve this？（）  
A: Implement job classes
B: Implement Scheduler windows
C: Implement the mapping rule for the consumer groups
D: Set the SWITCH_TIME resource plan directive for both the resource plans
Click the Exhibit button and examine the data in the EMPLOYEES and DEPARTMENTS tables. You want to retrieve all employees, whether or not they have matching departments in the departments table. Which query would you use?（）
A:SELECT last_name, department_name FROM employees NATURAL JOIN departments;
B:SELECT last_name, department_name FROM employees JOIN departments ;
C:SELECT last_name, department_name FROM employees e JOIN departments d ON (e.department_id = d.department_id);
D:SELECT last_name, department_name FROM employees e RIGHT OUTER JOIN departments d ON (e.department_id = d.department_id); 
E:SELECT last_name, department_name FROM employees FULL JOIN departments ON (e.department_id = d.department_id);
F:SELECT last_name, department_name FROM employees e LEFT OUTER JOIN departments d ON (e.department_id = d.department_id);
首页 <上一页 25 26 27 28 29 下一页> 尾页