出自:Oracle认证

Which constraint can be defined only at the column level? （）
A:UNIQUE
B:NOT NULL
C:CHECK
D:PRIMARY KEY
E:FOREIGN KEY
在iBatis框架中，（）关联不需要额外的表字段。
A:主键关联
B:惟一外键关联
C:外键关联
D:约束关联
When performing incomplete recovery using UNTIL SEQUENCE with RMAN， which two pieces of information are required？（）
A:Thread number.
B:Log Sequence number.
C:Control file sequence number.
D:Name of the last archived log.
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;
You can control instance recover performance by setting parameters to define targets for（）
A:The size of the redo buffer in SGA. 
B:The instance that will perform recovery in Real Application Cluster database. 
C:The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. 
D:The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
A schedule defined entirely within the confines of a Scheduler job object is known as a （n） （）
A: Fixed schedule
B: Inline schedule
C: Stored schedule
D: Hard-coded schedule
E: None of the above
You work as a database administrator for Supportcenter.cn. While granting a role， SELECT_CATALOG_ROLE， to a user， SupportCenter， using Oracle Enterprise Manager 10g Database Control， you have cleared the DEFAULT check box. What will be the result？（）
A:The user cannot use the role at all.
B:The role would not be granted to the user.
C:The user needs to enable the role explicitly.
D:The user can start using the role immediately.
E:The user would have the admin option for the role.
Which two code fragments correctly create and initialize a static array of int elements?（）
A:
B:
C:
D:
You want a record of all queries that are not using indexes. How would you achieve this?（）
A:By enabling the Slow Query Log because all queries that are not using indexes will be logged automatically
B:By enabling the Error Log because not using indexes is an error
C:By enabling the Slow Query Log and using the – log-queries-not-using-indexes option
D:By enabling the Error Log and using the – log-queries-not-using-indexes option
User A issues the command: LOCK TABLES pets READ; Which command can User B execute against the pets table?（）
A:UPDATE pets…
B:SELECT….FROM pets
C:INSERT INTO pets…
D:ALTER TABLE pets…
You need to quickly obtain the physical and logical device names for the disks attached to the server.  Which command achieves this？ （）
A:A
B:B
C:C
D:D
Given： And the following five fragments： public static void main（String...a） { public static void main（String.* a） { public static void main（String... a） { public static void main（String[]... a） { public static void main（String...[] a） { How many of the code fragments， inserted independently at line 2， compile？（）
A:0
B:1
C:2
D:3
E:4
What is true about joining tables through an equijoin? （）
A:You can join a maximum of two tables through an equijoin.
B:You can join a maximum of two columns through an equijoin.
C:You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.
D:To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.
E:You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.
In WebLogic, the development feature to automatically load/refresh the changes of a Java classes  at run time is called（）.
A:HotSwap
B:FastSwap
C:HotDeploy
D:FastDeploy
E:FastReload
Given: What is the result?（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The code executes normally and prints "bar".
D:The code executes normally, but nothing prints.
You deploy more than one application to the same WebLogic container. The security is set on JavaEE level and all deployed JavaEE applications use the same security roles.    What is your recommendation for an architecture with those requirement?（）
A:Combine all applications into a single one.
B:Define global roles on the WebLogic Domain level.
C:Use Ms Active Directory to keep the roles there. 
D:Use Oracle Identity and Access Management solution to simplify the management.
E:Keep role mapping in the external WebLogic Role Mapped developed for that solution.
When youre performing active database duplication，a backup of what kind is required？（）  
A: A current RMAN backup-set backup is required.
B: No backup is required.
C: An RMAN image backup is required.
D: A manual backup is required.
E: A "duplicate" preparatory backup is required.
Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)
A:Segment Advisor
B:SQL Access Advisor
C:Optimizer statistics gathering
D:Automatic SQL Tuning Advisor
E:Automatic Database Diagnostics Monitor
Which statement is true about the loss of system-critical data files in ARCHIVELOG mode？（）
A:The data files can be recovered till the last committed transaction.
B:The data files can be recovered without shutting down the database.
C:The data file is taken offline automatically； the database remains open.
D:The data files can be recovered to the time of the most recent backup.
Given： What creates the appropriate DateFormat object and adds a day to the Date object？（）
A:35. DateFormat df = DateFormat.getDateFormat（）；42. d.setTime（ （60 * 60 * 24） + d.getTime（））；
B:35. DateFormat df = DateFormat.getDateInstance（）；42. d.setTime（ （1000 * 60 * 60 * 24） + d.getTime（））；
C:35. DateFormat df = DateFormat.getDateFormat（）；42. d.setLocalTime（ （1000*60*60*24） + d.getLocalTime（））；
D:35. DateFormat df = DateFormat.getDateInstance（）；42. d.setLocalTime（ （60 * 60 * 24） + d.getLocalTime（））；
Evaluate the following SQL statements that are issued in the given order： What would be the status of the foreign key EMP_MGR_FK？（）
A: It would be automatically enabled and deferred.
B: It would be automatically enabled and immediate.
C: It would remain disabled and has to be enabled manually using the ALTER TABLE command.
D: It would remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
为了减少表中的链接记录和迁移记录，应当增大表的哪一个存储参数？（）
A:PCTFREE
B:PCTUSED
C:MAXEXTENTS
D:PCTINCREASE
Your system performs heavy transaction processing between 8：00 A.M. and 5：00 P.M. but runs batch processing and reports after that. You decide to create a separate resource plan to govern resource allocation for each time period. Which scheduler object will you use to switch automatically between the two resource plans？（）  
A: Window
B: Program
C: Job_Class
D: Window group
What is true regarding a transaction executed in Automatic Undo Management mode？（）
A:A
B:B
C:C
D:D
客户端用于网络连接的两个配置文件文件是（）
A:TNSNAMES.ORA和SQLNET.ORA
B:TNSNAMES.ORA和LISTENER.ORA
C:TNSNAMES.ORA和INIT.ORA
D:SQLNET.ORA和LISTENER.ORA
E:INIT.ORA和LISTENER.ORA
Which three statements correctly describe the features of the I/O calibration process?（）
A:Only one I/O calibration process can run at a time.
B:It automates the resource allocation for the Automated Maintenance Tasks.
C:It improves the performance of the performance-critical sessions while running.
D:It can be used to estimate the maximum number of I/Os and maximum latency time for the system.
E:The latency time is computed only when the TIMED_STATISTICS initialization parameter is set to TRUE.
The SAVE_AMT column in the ACCOUNTS table contains the balance details of customers in a bank. As part of the year-end tax and interest calculation process， all the rows in the table need to be accessed. The bank authorities want to track access to the rows containing balance amounts exceeding $200，000， and then send an alert message to the administrator. Which method would you suggest to the bank for achieving this task？（）
A:implementing value-based auditing by using triggers
B:implementing fine-grained auditing with audit condition and event handler
C:performing standard database auditing to audit object privileges by setting the AUDIT_TRAIL parameter to EXTENDED
D:performing standard database auditing to audit SQL statements with granularity level set to ACCESS
The STUDENT_GRADES table has these columns: STUDENT_ID NUMBER(12) SEMESTER_END DATE GPA NUMBER(4,3) The registrar requested a report listing the students' grade point averages (GPA) sorted from highest grade point average to lowest. Which statement produces a report that displays the student ID and GPA in the sorted order requested by the registrar?（）
A:SELECT student_id, gpa FROM student_grades ORDER BY gpa ASC;
B:SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa ASC;
C:SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa;
D:SELECT student_id, gpa FROM student_grades ORDER BY gpa;
E:SELECT student_id, gpa FROM student_grades SORT ORDER BY gpa DESC;
F:SELECT student_id, gpa FROM student_grades ORDER BY gpa DESC;
You create the sales report and run it in the live previewer. After which change would the live previewer require the data? （）
A:Removing column from the available list in the report wizard. 
B:Removing the column from the displayed list in the report wizard. 
C:Changing the display width of a column in the report wizard. 
D:Adding a column to both the available list and displayed list in the report wizard. 
E:Removing a column in the live previewer. 
（）是一个小型的二进制文件，可以记录数据库的物理结构。
A:参数文件
B:数据文件
C:控制文件
D:配置文件
首页 <上一页 32 33 34 35 36 下一页> 尾页