出自:Oracle认证

EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）
A:Exhibit A
B:Exhibit B 
C:The query returns no rows 
D:The query fails because the outer query is retrieving more than one column
E:The query fails because both the inner and outer queries are retrieving data from the same table.
Given： If an instance of class Beagle is created，then Serialized，then deSerialized， what is the result？（）
A:ad
B:ada
C:add
D:adad
Consider the following: Which statement best describes the meaning of the value for the key_len column?（）
A:It shows the total size of the index row
B:It shows how many columns in the index are examined
C:It shows the number of characters indexed in the key
D:It shows how many bytes will be used from each index row
Given: What is the result?（）
A:Canada
B:null Canada
C:Canada null
D:Canada Canada
E:Compilation fails due to an error on line 26.
F:Compilation fails due to an error on line 29.
Which two activities are NOT supported by the Data Recovery Advisor （DRA）（）
A:Recover from failures in the RAC environment.
B:Diagnose and repair a data file corruption online.
C:Diagnose and repair a data file corruption offline.
D:Diagnose and repair failures on a standby database
You want to migrate your application from the development environment to the production environment. While doing the task， you want the database objects owned by the user DEVUSER in the development environment to be moved to the user APPS in the production environment. Which option of Oracle Data Pump Import would you use to achieve this objective？（）
A:owner
B:touser
C:include
D:schemas
E:fromuser
F:transform
G:remap_schema
H:remap_datafile
I:reuse_datafiles
J:remap_tablespace
To view the results of the most recent Automatic SQL Tuning Advisor task，which sequence should you follow？（）  
A: EM Database home page，Software and Support，SQL Advisors，Automatic SQL Tuning Advisor
B: EM Database home page，Software and Support，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
C: EM Database home page，Software and Support，Support Workbench，Advisor Central，SQL Advisors，Automatic SQL Tuning Advisor
D: Either B or C
E: All of the above
Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）
A:120M
B:320M
C:480M
D:600M
Given: What is the result?（）
A:s14
B:s16
C:s10
D:Compilation fails.
E:An exception is thrown at runtime.
Consider the following scenario for your database: Which statement is true regarding the backup of the TOOLS tablespace?（）
A:The RMAN backup fails because the TOOLS tablespace is read-only
B:The RMAN skips the backup of the tablespace because backup optimization is enabled
C:The RMAN makes backup because optimization can be enabled only for backups to disk
D:The RMAN makes the backup because no backup of the tablespace exists within the seven day window
Click the Exhibit button and examine the data in the EMPLOYEES table. Which three subqueries work? （）
A:SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
B:SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
C:SELECT distinct department_id FROM employees WHERE salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
D:SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
E:SELECT last_name FROM employees WHERE salary > ANY (SELECT MAX(salary) FROM employees GROUP BY department_id);
F:SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));
Which statement is true regarding Dynamic Service Registration？（）
A:Dynamic service registration requires configuration in the listener .ora file.
B:Dynamic service registration can be used only with an Oracle9/instance.
C:Dynamic service registration cannot register a local listener that does not use TCP/IP or port 1521.
D:The PMON background process automatically registers each database instance if the necessary parameters have been set in the database initialization parameter file.
在SQL*PLUS中显示数据库例程的内存分配情况，可用命令（）
A:show all
B:show mem
C:show memory
D:show sga
E:show rel
You issue this SQL statement：  ALTER DATABASE RENAME FILE ’/ORADATA/u02/user_data01.dbf’ TO ’/ORADATA/u04/user_data01.dbf’；  What does this SQL statement do？（）
A:It updates the control file with the new location of the data file. 
B:It updates only the data dictionary with the new location of the data file. 
C:It changes the location of the user_data01.dbf file in the operating system. 
D:It changes the location of the user_data01.dbf file in the operating system and updates the control file with the new location of the data file.
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）
A:The online redo log files and archived redo log files are required to accomplish the recovery.
B:The uncommitted transaction will be committed at the next startup of the database instance.
C:The uncommitted transaction is rolled back automatically at the next opening of the database.
D:The DBA has to perform the recovery on the database to recover the uncommitted transaction
Which two statements are true？（）
A:It is possible for more than two threads to deadlock at once.
B:The JVM implementation guarantees that multiple threads cannot enter into a deadlocked state.
C:Deadlocked threads release once their sleep（） method’s sleep duration has expired.
D:Deadlocking can occur only when the wait（）， notify（）， and notifyAll（） methods are used incorrectly.
E:It is possible for a single-threaded application to deadlock if synchronized blocks are used incorrectly.
F:If a piece of code is capable of deadlocking， you cannot eliminate the possibility ofdeadlocking by insertinginvocations of Thread.yield（）.
数据库必须拥有至少几个重做日志组（）
A:1
B:2
C:3
D:4
E:由初始参数指定
Identify the situations in which you use the alert log file in your database to check the detail.（）
A:Running a query on a table returns "ORA-600： Internal Error."
B:Inserting a value in a table returns "ORA-01722： invalid number."
C:Creating a table returns "ORA-00955： name is already used by an existing object."
D:Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."
E:Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource."
Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens？（）
A: log writer
B: archival
C: process monitor
D: system monitor
E: change tracking writer
F: database writer
Click the Exhibit button. Given this code from Class B： 25.A a1 = new A（）； 26.A a2 = new A（）； 27.A a3 = new A（）； 28.System.out.println（A.getInstanceCount（））； What is the result？（）
A:Compilation of class A fails.
B:Line 28 prints the value 3 to System.out.
C:Line 28 prints the value 1 to System.out.
D:A runtime error occurs when line 25 executes.
E:Compilation fails because of an error on line 28.
Which one is a system privilege?（）
A:SELECT
B:DELETE
C:EXECUTE
D:ALTER TABLE
E:CREATE TABLE
Which statement is true about the PCTFREE setting for the table（）
A:It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
B:It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.
C:It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
D:It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
简单介绍OEM和OMS共同点和不同点？
Examine this statement: SELECT student_id, gpa FROM student_grades WHERE gpa >&&value; You run the statement once, and when prompted you enter a value of 2.0. A report is produced. What happens when you run the statement a second time?（）
A:An error is returned.
B:You are prompted to enter a new value.
C:A report is produced that matches the first report produced.
D:You are asked whether you want a new value or if you want to run the report based on the previous value.
Examine the structure of the EMP_DEPT_VU view: Column Name Type Remarks EMPLOYEE_ID NUMBER From the EMPLOYEES table EMP_NAME VARCHAR2(30) From the EMPLOYEES table JOB_ID VARCHAR2(20) From the EMPLOYEES table SALARY NUMBER From the EMPLOYEES table DEPARTMENT_ID NUMBER From the DEPARTMENTS table DEPT_NAME VARCHAR2(30) From the DEPARTMENTS table Which SQL statement produces an error?（）
A:SELECT * FROM emp_dept_vu;
B:SELECT department_id, SUM(salary) FROM emp_dept_vu GROUP BY department _ id;
C:SELECT department_id, job_id, AVG(salary) FROM emp_dept_vu GROUP BY department _ id, job_id;
D:SELECT job_id, SUM(salary) FROM emp_dept_vu WHERE department_id IN (10,20) GROUP BY job_id HAVING SUM (salary) > 20000
E:None of the statements produce an error; all are valid.
Which two operations can be flashed back using the Flashback technology？（）
A:DROP USER SMITH；
B:DROP TABLE EMPLOYEES；
C:DROP TABLESPACE USERS；
D:ALTER TABLE SALES_REP DROP PARTITION P1；
E:ALTER TABLE EMPLOYEES DROP COLUMN DESIG_ID；
The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates a plan for a SQL statement but does not find a matching plan in the SQL plan baseline. Which two operations are performed by the optimizer in this scenario?（）
A:The optimizer adds the new plan to the plan history.
B:The optimizer selects the new plan for the execution of the SQL statement.
C:The optimizer adds the new plan to the SQL plan baseline as an accepted plan.
D:The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state.
E:The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.
Which two statements are true about the duplexing of the backups taken by RMAN？（）  
A: It’s only supported for the backups performed on the tape
B: It is not supported for backup operations that produce image copies
C: Duplex backups need a parallelism for the device to be equal to number of copies
D: Duplex backups can be performed to either disk or tape， but cannot be performed on tape and disk simultaneously
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?（）
A:only the control file, the current SPFILE, and data files
B:only the current SPFILE and data files if autobackup is disabled
C:only the data files and the archived redo logs
D:the control file, current SPFILE file, data files, and archived redo logs
在创建序列的过程中，下列（）选项指定序列在达到最大值或最小值后，将继续从头开始生成值。
A:Cycle
B:Nocycle
C:Cache
D:Nocache
首页 <上一页 125 126 127 128 129 下一页> 尾页