出自:Oracle认证

You are working on an online transaction processing （OLTP） system. You notice that a PL/SQL procedure got executed twice at 2） 00 p.m. This has incorrectly updated the EMP_SAL table. How would you revert the table to its state at 2） 00 p.m.？（）
A:Perform point-in-time recovery to 2： 00 p.m.
B:Use Flashback Table feature to revert the changes.
C:Restore the entire database from the recent backup and open it.
D:Issue the rollback statement with system change number （SCN）.
Examine the data from the ORDERS and CUSTOMERS tables. ORDERS ORD_ID ORD_DATE CUST_ID 12-JAN- 100 15 10000 09-MAR- 101 40 8000 09-MAR- 102 35 12500 15-MAR- 103 15 12000 25-JUN- 104 15 6000 18-JUL- 105 20 5000 106 18-JUL- 35 7000 21-JUL- 107 20 6500 04-AUG- 109 10 8000 CUSTOMERS CUST_ID CUST_NAME CITY 10 Smith Los Angeles 15 Bob San Francisco 20 Martin Chicago 25 Mary New York 30 Rina Chicago 35 Smith New York 40 Lind New York Evaluate the SQL statement: SELECT * FROM orders WHERE cust_id = (SELECT cust_id FROM customers WHERE cust_name = 'Smith'); What is the result when the query is executed?（）
A:ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000 04-AUG- 108 10 8000
B:ORD_ID ORD_DATE CUST_ID ORD_TOTAL 09-MAR- 102 35 12500 18-JUL- 106 35 7000
C:ORD_ID ORD_DATE CUST_ID ORD_TOTAL 04-AUG- 108 10 8000
D:The query fails because the subquery returns more than one row.
E:The query fails because the outer query and the inner query are using different tables.
Which three statements concerning the use of the java.io.Serializable interface are true？（）
A:Objects from classes that use aggregation cannot be serialized.
B:An object serialized on one JVM can be successfully deserialized on a different JVM.
C:The values in fields with the volatile modifier will NOT survive serialization and deserialization.
D:The values in fields with the transient modifier will NOT survive serialization and deserialization.
E:It is legal to serialize an object of a type that has a supertype that does NOT implement java.io.Serializable.
In your multitenant container database (CDB) containing pluggable database (PDBs), you granted theCREATE TABLE privilege to the common user C # # A_ADMIN in root and all PDBs. You execute thefollowing command from the root container:SQL > REVOKE create table FROM C # # A_ADMIN;What is the result?（）
A:It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root only.
B:It fails and reports an error because the CONTAINER=ALL clause is not used.
C:It excludes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in root and all PDBs.
D:It fails and reports an error because the CONTAINER=CURRENT clause is not used.
E:It executes successfully and the CREATE TABLE privilege is revoked from C # # A_ADMIN in all PDBs.
Which substitution variable would you use if you want to reuse the variable without prompting the user each time?（）
A:&
B:ACCEPT
C:PROMPT
D:&&
You configured the flash recovery area in the database. Which two files would you expect to find in the flash recovery area？（）
A: backup pieces
B: copies of all the parameter files
C: trace file generated using BACKUP CONTROLFILE TO TRACE
D: control file autobackups
Given： 10.interface Data { public void load（）； } 11.abstract class Info { public abstract void load（）； }  Which class correctly uses the Data interface and Info class？（）
A:
B:
C:
D:
When does Oracle9i flag an index as being used in the V$OBJECT_USAGE view？（）
A:During a query’s parse time only. 
B:During a query’s execution time only. 
C:During any kind of DML statement execution. 
D:During the execution of an INSERT statement only.
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management （ASM）.  Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size？（）
A: Because the FRA disk group will not support dynamic rebalancing
B: Because the FRA disk group is not configured to support mirroring
C: Because disks in the FRA disk group are not formatted at this stage
D: Because the FRA disk group will support only a single size of allocation unit
A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member.  A LGWR Input/output （I/O） fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow.   1） Restore the corrupted redo log group. 2） Restore from a whole database backup.  3） Perform incomplete recovery.  4） Relocate by renaming the member of the damaged online redo log group to a new location.  5） Open the database with the RESETLOGS option.  6） Restart the database instance.  7） Issue a checkpoint and clear the log.   Identify the option with the correct sequential steps to accomplish the task efficiently（）.  
A: 1，3，4，and 5
B: 7，3，4. and 5
C: 2，3，4，and 5
D: 7，4，3，and 5
E: Only 6 is required
You have a large amount of historical data in a flat file. Some analysts in your organization need toquery this data in the file. The file is too large to load the data in it into your current database.  Which is the most effective method to access this data in your database（）
A:Use the database link.
B:Use the SQL*Loader utility.
C:Use the Oracle Data Pump utility.
D:Create an external table and leave the data in the flat file
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)
A:Reregistering the target database in recovery catalog
B:Transporting the new tablespaces to the recovery catalog database
C:Syncronizing the recovery catalog with the target database control file
D:Performing a fresh backup of the target database to include the new data files in the catalog database
写出ORACLE的四种文件。（从物理存储结构分析）
Click the Exhibit button. Which code， inserted at line 14， will allow this class to correctly serialize and deserialize？（）
A:s.defaultReadObject（）；
B:this = s.defaultReadObject（）；
C:y = s.readInt（）； x = s.readInt（）；
D:x = s.readInt（）； y = s.readInt（）；
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database.  What steps did Bill perform to recover the database and in what order？（）   a. Restored the control file with the RMAN restore controlfile command.  b. Mounted the DSL instance with the alter database mount command.  c. Restored the datafiles for the DSL database with the RMAN restore command. d. Opened the DSL database with the alter database open resetlogs command. e. Recovered the datafiles for the DSL database with the RMAN recover command. f. Started the DSL instance.  g. Connected to the recovery catalog with RMAN. 
A:  a， b， c， d， e， f， g
B: b， c， d， g， f， e， a
C: g， f， a， b， c， e， d
D: c， a， d， b， f， e， g
E: g， f， a， b， e， c， d
delete from system.table1与truncate table system.table1区别是什么？
Examine the description of the EMPLOYEES table: Which statement shows the maximum salary paid in each job category of each department?（）
A:SELECT dept_id, job_cat, MAX(salary)   FROM employees   WHERE salary > MAX(salary);
B:SELECT dept_id, job_cat, MAX(salary)   FROM employees   GROUP BY dept_id, job_cat;
C:SELECT dept_id, job_cat, MAX(salary)   FROM employees;
D:SELECT dept_id, job_cat, MAX(salary)   FROM employees   GROUP BY dept_id;
E:SELECT dept_id, job_cat, MAX(salary)   FROM employees   GROUP BY dept_id, job_cat, salary;
假设用户user1的temp1表分区为PART1、PART2和PART3，需要导出整个表及其分区，可以使用如下（）命令。
A:EXP SYSTEM/MANAGER FILE=EXPDAT.DMP TABLES=（user1.temp1,part1,part2,part3）
B:EXP SYSTEM/MANAGER FILE=EXPDAT.DMP
C:EXP SYSTEM/MANAGER FILE=EXPDAT.DMP TABLES=（user1.temp1）
D:EXP SYSTEM/MANAGER FILE=EXPDAT.DMP TABLES=（user1.temp1,full）
You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）
A: mount the new disk group in the ASM instance
B: restart the ASM instance and the production database instance
C: register the new disk groups in the production database instance
D: restart the ASM instance without restarting the production database instance
E: include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance
While designing your database， you have created the EMPLOYEES table as an index/x7forganized table （IOT）. You want to create a bitmap index on the JOB_ID column to make queries faster. Which task must have been completed so that you are able to create the bitmap index？（）
A:A primary key must have been created.
B:A mapping table must have been created.
C:An overflow tablespace must have been specified.
D:The PCTTHRESHOLD option must have been specified.
Your archive-log destination directory runs out of space. What is the impact of this on the database?（）
A:None. The database will switch over to the stand-by archive-log destination directory. 
B:A warning message will be written to the alert log of the database, but no adverse impacts to the database will be experienced. 
C:The database will shut down, and will not restart until you correct the out-of-space situation. 
D:The database will continue to try to write to the archive-log destination directory for one hour. After one hour, the database will shut down normally. 
E:Once Oracle has cycled through all online redo logs, it will stop processing any DML or DDL until the out-of-space condition is corrected.
You enabled Automatic Shared Memory Management. The initialization parameters are set as shown below：  SGA_TARGET = 10GB SGA_MAX_SIZE = 14GB  STREAMS_POOL_SIZE = 1GB  SHARED_POOL_SIZE = 3GB  Which two statements are correct in this scenario？ （）
A: A total of 14 GB memory will be allocated to the automatically tuned memory components
B: Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB
C: The value for SGA_TARGET can be increased up to a maximum of 14 GB
D: A maximum of 3 GB can be allocated to shared pool
E: Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters
F: Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE
The EMP table contains these columns: LAST_NAME VARCHAR2 (25) SALARY NUMBER (6,2) DEPARTMENT_ID NUMBER (6) You need to display the employees who have not been assigned to any department. You write the SELECT statement: SELECT LAST_NAME, SALARY, DEPARTMENT_ID FROM EMP WHERE DEPARTMENT_ID = NULL; What is true about this SQL statement ?（）
A:The SQL statement displays the desired results.
B:The column in the WHERE clause should be changed to display the desired results.
C:The operator in the WHERE clause should be changed to display the desired results.
D:The WHERE clause should be changed to use an outer join to display the desired results.
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);
Your database is in NOARCHIVELOG mode. After which two operations you should take the backup of control file？（）
A:adding a new user to the database
B:dropping a user from the database
C:dropping a table from the database
D:dropping a data file from a tablespace
E:adding a new tablespace to the database
Which two statements about views are true? （）
A:A view can be created as read only.
B:A view can be created as a join on two or more tables.
C:A view cannot have an ORDER BY clause in the SELECT statement.
D:A view cannot be created with a GROUP BY clause in the SELECT statement.
E:A view must have aliases defined for the column names in the SELECT statement.
Evaluate the set of SQL statements: CREATE TABLE dept (deptno NUMBER(2), dname VARCNAR2(14), 1oc VARCNAR2 (13)); ROLLBACK; DESCRIBE DEPT What is true about the set?（）
A:The DESCRIBE DEPT statement displays the structure of the DEPT table.
B:The ROLLBACK statement frees the storage space occupies by the DEPT table.
C:The DESCRIBE DEPT statement returns an error ORA-04043: object DEPT does not exist.
D:The DESCRIBE DEPT statement displays the structure of the DEPT table only if there is a COMMIT statement introduced before the ROLLBACK statement.
You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）
A:The source database backup must be copied over the net for test database.
B:The source database must be run in ARCHIVELOG mode if the database is open.
C:The source database must be shut down cleanly if the database is in mounted state.
D:A net service name should be set up and a listener configured with the target as well as the source database.
Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) JOB_CAT VARCHARD2(30) SALARY NUMBER(8,2) Which statement shows the maximum salary paid in each job category of each department?（）
A:SELECT dept_id, job_cat, MAX(salary) FROM employees WHERE salary > MAX (salary);
B:SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id,job_cat;
C:SELECT dept_id, job_cat, MAX(salary) FROM employees;
D:SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept_id;
E:SELECT dept_id, job_cat, MAX(salary) FROM employees GROUP BY dept _ id job _ cat salary;
（）是具有只读类型的表和视图集，存储了数据库的物理和逻辑结构信息。
A:表空间
B:盘区
C:数据字典
D:方案
首页 <上一页 5 6 7 8 9 下一页> 尾页