出自:Oracle认证

Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday， client A drops a table at 8：00 a.m. as follows：  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9：00 a.m. on the same table as follows：  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1：  ORA/x7f00942： table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario， which action should you take？（）
A:retrieve the table by using the flashback feature
B:restore all the data files from last Sunday’s backup， and then perform a time­based recovery
C:restore all the data files from last Sunday’s backup， and then perform a log sequence recovery
D:restore all the data files from last Sunday’s backup， and then perform a cancel­based recovery
E:restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored， and then perform a complete recovery
Identify the two situations in which you use the alert log file in your database to check the details.（）
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."
What are the two proper locations of deployment descriptors files inside of archives deployed to WebLogic?（）
A:the WEB-INF subdirectory for a WAR file
B:the META-INF subdirectory for an EAR file, or EJB-JAR
C:the DD-INF subdirectory
D:the root of archive
E:any searchable location
用符号"->"表示组成关系，下面哪一个组成关系正确表示了ORACLE数据库的逻辑存储结构（）
A:块->段->区->表空间->数据库
B:块->区->段->表空间->数据库
C:块->表空间->区->段->数据库
D:块->段->表空间->区->数据库
E:块->区->表空间->段->数据库
A SELECT statement can be used to perform these three functions: 1. Choose rows from a table. 2. Choose columns from a table 3. Bring together data that is stored in different tables by creating a link between them. Which set of keywords describes these capabilities?（）
A:difference, projection, join
B:selection, projection, join
C:selection, intersection, join
D:intersection, projection, join
E:difference, projection, product
Which of the following tasks does the tool Incident Packaging Service （IPS） perform？（）  
A: Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
B: Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle Support.
C: Automatically opens a Service Request with Oracle Support for each critical error and sends all relevant files.
D: Displays a high-level view of critical errors on the database home page.
You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation（）
A:CHECK
B:UNIQUE
C:NOT NULL
D:PRIMARY KEY
E:FOREIGN KEY
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?（）
A:Open the database in NORMAL mode
B:Open the database in read-only mode
C:Open the database in RESTRICTED mode
D:Open the database with the RESETLOGS option
Which three statements are true about the privileged connection options available in Oracle9i？（）
A:The CONNECT INTERNAL is disallowed. 
B:The Server Manager tool is no longer supplied. 
C:The listener must be running to make a connection. 
D:The use of remote password login file (orapw) is unchanged.
Your database has the SRV1 service configured for an application that runs on middle-tier application server. The application has multiple modules. You enable tracing at the service level by executing the following command: SQL > exec DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE (‘SRV1’); The possible outcome and actions to aggregate the trace files are as follows: 1. The command fails because a module name is not specified. 2. A trace file is created for each session that is running the SRV1 service. 3. An aggregated trace file is created for all the sessions that are running the SRV1 service. 4. The trace files may be aggregated by using the trcess utility. 5. The trace files be aggregated by using the tkprof utility. Identify the correct outcome and the step to aggregate by using tkprof utility?（）
A:1
B:2 and 4
C:2 and 5
D:3 and 4
E:3 and 5
How many different calendars does Oracle 11g support?（）
A:22
B:7
C:6
D:15
E:2
You are maintaining the database of a company. The listener process， listener1， is configured for remote access. You have issued the following command：   LSNRCTL>STATUS listener1   Which information will NOT be displayed when you issue the above command？（） 
A: whether the password is set in the listener or a file or not
B: the number of client connections the service handler has refused
C: the information will be displayed whether the instance can accept connections or not
D: the protocol addresses on which the listener is configured to listen
Which SQL statement defines the FOREIGN KEY constraint on the DEPTNO column of the EMP table?（）
A:CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) NOT NULL CONSTRAINT emp_deptno_fk FOREIGN KEY deptno REFERENCES dept deptno);
B:CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) CONSTRAINT emp_deptno_fk REFERENCES dept (deptno));
C:CREATE TABLE EMP (empno NUMBER(4) ename VARCHAR2(35), deptno NUMBER(7,2) NOT NULL, CONSTRAINT emp_deptno_fk REFERENCES dept (deptno) FOREIGN KEY (deptno));
D:CREATE TABLE EMP (empno NUMBER(4), ename VARCNAR2(35), deptno NUMBER(7,2) FOREIGN KEY CONSTRAINT emp deptno fk REFERENCES dept (deptno));
You work as a database administrator for Certkiller .com. When you tried to connect to the database， you received the following error： ERROR：  ORA-12541：TNS：no_listener  You found that the listener is not running on the server， so you issued the following command in the Listener Control utility to start the listener.  lsnrctl>START  What statement is true？（）
A:It would attempt to start the default listener
B:It would start the most recently created listener.
C:It would display an error with a message asking for the listener name to be specified.
D:It would show you a list of listeners and prompts for the listener name that you want to start.
From the V$SESSION_LONGOPS view， you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database， who have much shorter queries. You would like to make sure that the users with large queries do not use all the CPU time， but you still do not want to terminate them with an error message. Which method would you follow to achieve this？（）
A: set the CPU time per call in the users profile
B: set the CPU time per session in the users profiles
C: set the TIMED_STATISTICS parameter to TRUE in the parameter file
D: set the CPU levels for the users’ group using Resource Manager
You installed WebLogic, SOA Suite, and Oracle Service Bus on a machine and want to use the  WebLogic Node Manager to start servers for each product. Which statement is true?（）
A:You need to install a separate node manager for each Middleware Home that has a unique and  minor WebLogic Version Number.
B:You need to install and configure only one instance of Node Manager for all products,  regardless of the WebLogic version number.
C:You need to install and configure a separate Node Manager for each domain of each product  want to run on the machine.
D:You need to install one Node Manager but use separate SSL certificates for each product when  securing the network communication to the machine.
Examine the data in the EMPLOYEES and DEPARTMENTS tables. EMPLOYEES LAST_NAME DEPARTMENT_ID SALARY Getz 10 3000 Davis 20 1500 Bill 20 2200 Davis 30 5000 Kochhar 5000 DEPARTMENTS DEPARTMENT_ID DEPARTMENT_NAME 10 Sales 20 Marketing 30 Accounts 40 Administration 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 , departments(+);
B:SELECT last_name, department_name FROM employees JOIN departments(+);
C:SELECT last_name, department_name ON (e. department_ id = d. departments_id); FROM employees(+) e JOIN departments d
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(+) , 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);
You work as a database administrator at Certkiller .com. Your database is open and running in ARCHIVELOGmode. You take RMANfull backups every Sunday night. On Monday morning， while querying the user1.employeestable， you receive the following error message：  01578： ORACLE data block corrupted （file # 5， block # 51）  ORA-01110： data file 5：’/u01/app/oracle/oradata/orcl/example01.dbf’  You need to rectify the corruption while ensuring the following：  The data file should remain online.  The mean time to recover （MTTR） should be minimal.  You are not using a backup control file and all the archived logs are accessible.  Which option would you choose？（）
A: flash back the corrupted blocks
B: use the DBMS_REPAIR package
C: use the RMAN TSPITR command
D: use the RMAN BLOCKRECOVER command
E: use the RESTORE DATABASE and RECOVER DATABASE commands
F: investigate the time at which the corruption occurred and perform a point-in-time recovery
DRAG DROP Click the Task button.
限制在数据库中创建的用户数，就要在数据库的初始化参数文件中设置（）初始化参数。
A:LICENSE_MAX_USERS
B:MAX_USERS
C:CONNECT_MAX_USERS
D:AVAILABLE_MAX_USERS
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;
Given that c is a reference to a valid java.io.Console object， and： 11.String pw = c.readPassword（"%s"， "pw： "）； 12.System.out.println（"got " + pw）； 13.String name = c.readLine（"%s"， "name： "）； 14.System.out.println（" got "， name）； If the user types fido when prompted for a password， and then responds bob when prompted for a name，what is the result？（）
A:An exception is thrown at runtime
B:pw： fido got fido name： bob got bob
C:pw： got fido name： bob got bob
D:Compilation fails.
Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?（）
A:Maximum Undo per consumer group
B:Maximum Idle time
C:Parallel server limit
D:CPU
E:Exadata I/O
F:Local file system I/O
A media failure has occurred. This has resulted in all the members of the next hop log group being rendered inaccessible to the log writer process （LGWR） at a log switch. How does this failure affect the operational database？（）
A: The database re-created the missing redo log files automatically.
B: The database continues to function normally with the existing files.
C: The database allows only queries， no other statements are allowed.
D: The database returns and error and the database instance shuts down.
E: The user sessions that generate redo logs are terminated automatically.
What type of Java EE application can be upgraded to WebLogic 12c using the Smart Upgrade tool?（）
A:GlassFish
B:iAS 
C:WebLogic Server 11g
D:JBoss
XYZ Corp. has shipped goods against purchase orders to ABC Corp. ABC Corp. now has topay for the goods received as also account and reconcile the transaction. Which are the 11i OracleApplication modules involved in these activities for ABC Corp? （）(Choose all that apply.)
A:Payables only
B:Purchasing only
C:Order Management, General Ledger, and Cash Management
D:Purchasing, Payables, General Ledger, and Cash Management
User SCOTT executes the following command on the EMP table but has not issued COMMIT， ROLLBACK，or any data definition language （DDL） command：  SQL> SELECT job FROM emp  2  WHERE job=’CLERK’ FOR UPDATE OF empno;  SCOTT has opened another session to work with the database. Which three operations would wait when issued in SCOTT’s second session？（）
A:LOCK TABLE emp IN SHARE MODE;
B:LOCK TABLE emp IN EXCLUSIVE MODE;
C:DELETE FROM emp WHERE job=’MANAGER’;
D:INSERT INTO emp（empno，ename） VALUES （1289，’Dick’）;
E:SELECT job FROM emp WHERE job=’CLERK’ FOR UPDATE OF empno;
Given： Which exception or error will be thrown when a programmer attempts to run this code？（）
A:java.lang.StackOverflowError
B:java.lang.IllegalStateException
C:java.lang.ExceptionInInitializerError
D:java.lang.ArrayIndexOutOfBoundsException
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
A: a list of files that require a backup within three days
B: a list of files that have not been backed up for three days
C: a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
D: a list of files for which a backup has already been performed and may need a backup after three days
Give; What is the result?（）
A:b3
B:b8
C:b13
D:f3
E:f8
F:f13
G:Compilation fails.
H:An exception is thrown at runtime.
首页 <上一页 24 25 26 27 28 下一页> 尾页