出自:Oracle认证

Given: What is the result?（）
A:abc
B:123
C:a1b2c3
D:a1
E:Compilation fails.
F:The code runs with no output.
G:An exception is thrown at runtime
Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: EMPLOYEES EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) HIRE_DATE DATE NEW_EMPLOYEES EMPLOYEE_ID NUMBER Primary Key NAME VARCHAR2(60) Which UPDATE statement is valid?（）
A:UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180）WHEREemployee_id=180；
B:UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployees）WHEREemployee_id=180；
C:UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=180）   WHEREemployee_id=（SELECTemployee_idFROMnew_employees）；
D:UPDATEnew_employeesSETname=（SELECTlast_nameFirst_nameFROMemployeesWHEREemployee_id=（SELECTemployee_idFROMnew_employees）   WHEREemployee_id=180；
关于SQL*PLUS的叙述正确的是（）
A:SQL*PLUS是ORACLE数据库的专用访问工具
B:SQL*PLUS是标准的SQL访问工具，可以访问各类关系型数据库
C:SQL*PLUS是所有ORACLE应用程序的底层API
D:SQL*PLUS是访问ORACLE数据库的唯一对外接口
E:以上所述都不正确
Which three are the valid statements in relation to SQL plan baselines?（）
A:The plans can be manually loaded to the SQL plan baseline.
B:The plans in the SQL plan baseline are verified and accepted plans.
C:The plans generated for every SQL statement are stored in the SQL plan baseline by default.
D:The plan baselines are stored temporarily in the memory as long as the database instance is running.
E:  For the SQL plan baselines to be accessible to the optimizer, the SYSAUX tablespace must be online.
Examine the structure of the EMPLOYEES, DEPARTMENTS, and TAX tables. For which situation would you use a nonequijoin query?（）
A:To find the tax percentage for each of the employees.
B:To list the name, job id, and manager name for all the employees.
C:To find the name, salary, and department name of employees who are not working with Smith.
D:To find the number of employees working for the Administrative department and earning less then 4000.
E:To display name, salary, manager ID, and department name of all the employees, even if the employees do not have a department ID assigned.
Why does performance degrade when many UPDATE， INSERT， or DELETE statements are issued on a tablethat has an associated Bitmap index（）
A:The DML operations re-create the Bitmap index blocks.
B:The Bitmap index is rebuilt automatically after a DML operation.
C:The smallest amount of a bitmap that can be locked is a bitmap segment.
D:Additional time is taken to remove NULL values from the Bitmap index after a DML operation.
You are performing backup and recovery operations by using RMAN. You are using a recovery catalog for the RMAN repository. You are planning to migrate to ASM disk storage to enable new disks to be added to the database without shutting down the database.   Which information is NOT required during the migration process？（）
A: Database Identifier （DBID）
B: names and location of datafiles
C: names and location of control files
D: names and location of online redo log files
Users in your production database complain that they are getting the following error message while trying to insert rows into the ORDERS table： ERROR at line 1：  ORA-01654： unable to extend index USERS.ORDERS_IND by 8 in tablespace INDEXES  While investigating， you find that the INDEXES tablespace has run out of space and there is no more free space on the disk where the data files are available.  Which two actions could you perform to overcome this error without affecting the queries that are currently being executed？（）
A:drop and re-create the index
B:coalesce the ORDERS_IND index
C:coalesce the INDEXES tablespace
D:drop and re-create the ORDERS table
E:rebuild the index online and move it to another tablespace
Your database is running on the automatic Program Global Area （PGA） memory management and Shared Memory Management mode. You want to increase the memory available for the SQL work areas. What would you do？（）
A: modify the HASH_AREA_SIZE initialization parameter
B: modify the PGA_AGGREGATE_TARGET initialization parameter
C: modify the WORK_AREASIZE_POLICY initialization parameter
D: increase the value of the SGA_TARGET initialization parameter
E: increase the value of the SGA_MAX_SIZE initialization parameter
F: increase the value of the SORT_AREA_SIZE initialization parameter
You execute the following command to audit database activities： SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL； What is the effect of this command（）
A:One audit record is created for every successful DROP TABLE command executed in the session of SCOTT.
B:One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers.
C:One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session.
D:One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully.
E:One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT
Your alert log file has the following information： Tue May 25 17：43：38 2004  ORA-00060： Deadlock detected. More info in file  /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc.  What would you do to ensure that database is still running correctly？（）
A:examine the trace file and kill the session that caused the deadlock
B:examine the trace file and kill both the sessions responsible for the deadlock
C:examine the trace file for details and ask the user who caused the deadlock to roll back the transaction
D:examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
E:examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock
Which statement creates a new user?（）
A:CREATE USER susan;
B:CREATE OR REPLACE USER susan;
C:CREATE NEW USER susan    DEFAULT;
D:CREATE USER susan    IDENTIFIED BY blue;
E:CREATE NEW USER susan   IDENTIFIED by blue;
F:CREATE OR REPLACE USER susan   IDENTIFIED BY blue;
What is the purpose of the RMAN recovery catalog？（） 
A: It must be used because all RMAN-related backup and recovery metadata information is contained in it.
B: It provides a convenient， optional， repository of backup- and recovery-related metadata.
C: It provides the ability to store RMAN scripts for global use by any database that has access to the repository.
D: It provides a means of storing all RMAN backup sets physically in an Oracle database server. 
E: It provides the ability to store backup records for more than a year.
Given: Which code, inserted at line 16, correctly retrieves a local instance of a Point object?（）
A:Point p = Line.getPoint();
B:Line.Point p = Line.getPoint();
C:Point p = (new Line()).getPoint();
D:Line.Point p = (new Line()).getPoint();
Click the Exhibit button. Which three statements are true？（）
A:Compilation fails.
B:The code compiles and the output is 2.
C:If lines 16， 17 and 18 were removed， compilation would fail.
D:If lines 24， 25 and 26 were removed， compilation would fail.
E:If lines 16， 17 and 18 were removed， the code would compile and the output would be 2.
F:If lines 24， 25 and 26 were removed， the code would compile and the output would be 1.
Consider the following code snippet：   BEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE （ name => ，，lne_job1， attribute => ，，job_priority， value => 1）；  END；  /   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 users current session.
D: The lne_job1 job would retain its current priority.
E: The job will immediately take priority over all running jobs.
Given: Which two statements are true about the result if the default locale is Locale.US?（）
A:The value of b is 2.
B:The value of a is 3.14.
C:The value of b is 2.00.
D:The value of a is 3.141.
E:The value of a is 3.1415.
F:The value of a is 3.1416.
G:The value of b is 2.0000.
SQL语言中用来创建、删除及修改数据库对象的部分被称为（）。
A:数据库控制语言（DCL）
B:数据库定义语言（DDL）
C:数据库操纵语言（DML）
D:数据库事务处理语言
You performed an incomplete recovery on your Oracle Database 10g database using the following command：   SQL> RECOVER DATABASE  2 UNTIL TIME ’2004-08-05：12：10：03’ 3 USING BACKUP CONTROLFILE；  In which situation would the above recovery be required？（）
A: A user table was lost at the specified time.
B: A redo log file was lost at the specified time.
C: The backup control file is on a faster disk than the current one.
D: The current control file has a different path compared with the intended time of recovery.
E: The current control file does not match the physical structure of the database at the intended time of recovery.
A programmer must create a generic class MinMax and the type parameter of MinMax must implementComparable. Which implementation of MinMax will compile？（）
A:
B:
C:
D:
Given： What is the result？（）
A:Mr. John Doe
B:An exception is thrown at runtime.
C:Compilation fails because of an error in line 12.
D:Compilation fails because of an error in line 15.
E:Compilation fails because of an error in line 20.
You are using Enterprise Manager to schedule backups for your database.  Which type of script would begenerated by the backup scheduler（）
A:XML script
B:PL/SQL script
C:Operating system scriptThis document was downloaded from =>> http：//www.amaderforum.com
D:Recovery Manager （RMAN） script
Every Sunday， consistent backups are performed on your database. Because of a user error， you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday， which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario？（）
A:recovery cannot be performed because a backup was not performed after the last incomplete recovery
B:restore all the files from Sunday’s backup， and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
C:restore all the files from Sunday’s backup， and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
D:restore all the files from Sunday’s backup， and open the database to reset the database to the point in time when the backup was performed on Sunday
View the Exhibit and note the contents of V$DIAG_INFO. Which statement is true about the ADR?（）
A:The text alert log file will be available in Diag Trace
B:A copy alert log file will be kept in Diag Incident for every incident.
C:The XML version of the alert log file will be available in Diag Trace.
D:An Automatic Database Diagnostic Management (ADDM) report is generated and stored in the Health Monitor whenever an incident occurs.
Which statement is true about the loss of system/x7fcritical 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.
Which WebLogic optimization allows one non-XA resource to participate in a distributed transaction?（）
A:enabling Pinned to Thread
B:enabling Logging Last Resource
C:increasing the Statement cache size
D:setting the statement cache type to LRU
E:setting the initial and maximum capacity to the same number
Given： What is the result？（）
A:5，6
B:5，5
C:6，5
D:6，6
Which statement is FALSE regarding WebLogic Server 12c?（）
A:supports Java EE 6.0
B:supports WebLogic Web Services 8.1 Application Environment
C:includes a new Maven plug-in
D:supports use of annotations in resource adapter class files
Given： Which code， inserted at line 16， will cause a java.lang.ClassCastException？（）
A:Alpha a = x；
B:Foo f = （Delta）x；
C:Foo f = （Alpha）x；
D:Beta b = （Beta）（Alpha）x；
In a situation where no multiplexing of redo logs takes place, what happens when Oracle cannot read data from the online redo log group for archiving?（）
A:Nothing happens
B:Oracle will automatically switch redo logs when detected 
C:Oracle eventually won't allow new records to be added to the database 
D:The instance crashes
首页 <上一页 128 129 130 131 132 下一页> 尾页