出自:Oracle认证

A subquery can be used to（）.
A:create groups of data
B:sort data in a specific order
C:convert data to a different format
D:retrieve data based on an unknown condition
At 5：30 PM， a database administrator， William， is informed that an important record of employee no E0025 is missing from the SCOTT.EMPLOYEE table. At 4：30 P.M， the table contained the record of employee no E0025. William issues the following command to find the SQL statements that are used to undo the deletion：    SELECT operation， undo_sql， logon_user   FROM FLASHBACK_TRANSACTION_QUERY  WHERE xid=   HEXTORAW（’0100043E23456’）；   where ’0100043E23456’ is the transaction ID of the transaction that deleted the row. Before issuing the above statement， which task did William perform to identify the transaction ID of the transaction that deleted the row？（）
A: William used the Flashback Version Query feature.
B: William issued the CROSSCHECK command at the RMAN prompt.
C: William viewed the alert log file.
D: William used the Flashback Table feature.
You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）
A:ASM_POWER_LIMIT
B:ASM_DISKSTRING
C:ASM_DISKGROUPS
D:INSTANCE_TYPE
You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 11g Release 2 (11.2.0.2.0) 64-bit -Character set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character Set: AL32UTF8 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（）
A:Transportable database
B:Transportable tablespace
C:Data Pump full export/import
D:The DBMS_PDB package
E:RMAN
You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）
A:Group 2 is the active group.
B:Group 2 is the current group.
C:Database is in the MOUNT state.
D:Group 2 has been already archived.
Given： What is the result？（）
A:2
B:24
C:234
D:246
E:2346
You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）
A:Run Segment Advisor
B:Run the SQL Tuning Advisor (STA)
C:Run the Automatic Workload Repository (AWR) report
D:Run the SQL Access Advisor with a hypothetical workload
Click the Exhibit button. What is the output if the main（　） method is run?（）
A:4
B:5
C:8
D:9
E:Compilation fails.
F:An exception is thrown at runtime.
G:It is impossible to determine for certain.
A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
A:Execute the query and view Active Session History (ASH) for information about the query.
B:Enable SQL trace for the query.
C:Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
D:Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.
What is the correct order of the following commands if you wanted to restore datafile 4， which was accidentally removed from the file system？（）   a. sql ’alter database datafile 4 online’ b. restore datafile 4 c. recover datafile 4  d. sql ’alter database datafile 4 offline’ e. startup  f. shutdown
A: a， c， b， d
B: d， b， c， a
C: f， d， b， c， a， e
D: c， a， b， d， f
E: a， b， d， e
You issue the following command in Oracle: CREATE TABLESPACE DAT_TBS DATAFILE "dat_tbs.dbf" SIZE 2M;. Later queries against the database reveal that the tablespace is located in the /u01/oradata/oracle directory. Which of the following choices identifies how Oracle likely determined what directory to place dat_tbs.dbf file in?（）
A:DB_CREATE_FILE_DEST 
B:DB_CREATE_ONLINE_LOG_1 
C:DB_CREATE_ONLINE_LOG_2
D:The directory is an operating system-specific default value in Oracle that can neigher be specified manually nor changed
DRAG DROP Click the Task button.
Evaluate these two SQL statements:SELECT last_name, salary, hire_dateFROM EMPLOYEES ORDRE BY salary DESC; SELECT last_name, salary, hire_dateFROM EMPOLYEES ORDER BY 2 DESC; What is true about them?（）
A:The two statements produce identical results.
B:The second statement returns a syntax error.
C:There is no need to specify DESC because the results are sorted in descending order by default.
D:The two statements can be made to produce identical results by adding a column alias for the salary column in the second SQL statement.
How are messages displayed when you use the SRW.MESSAGE packaged procedure? （）
A:Dialogue box that implicitly determines report execution. 
B:Message line that implicitly determines report execution. 
C:Message line that suppresses the default oracle message. 
D:Dialogue box that does not terminate report execution. 
E:Dialogue box that suppresses the default oracle message.
One of the users in the PROD database，Adams，complains that his update on the table，TRANS， is taking an unusually long time to complete. You find that the table gets locked by another database user before Adams starts his transactions，and you are unable to contact the user holding the table lock. As Adams is updating some crucial rows in the table， he should get the highest priority.  Which method would you use to overcome this problem？（）
A:execute the command， ALTER SESSION KILL ..， to kill the blocking session
B:execute the DBMS_SESSION.KILL_SESSION procedure to kill the blocking session
C:execute the command， ALTER SYSTEM KILL SESSION ..， to kill the blocking session
D:execute the command， ALTER SESSION UNLOCK ..， to release the lock for the blocking session
E:execute the command， ALTER SYSTEM UNLOCK SESSION ..， to release the lock for the blocking session
Click the Exhibit button to examine the data of the EMPLOYEES table. Which statement lists the ID, name, and salary of the employee, and the ID and name of the employee's manager, for all the employees who have a manager and earn more than 4000?（）
A:SELECT employee_id "Emp_id", emp_name "Employee", salary, employee_id "Mgr_id", emp_name "Manager" FROM employees WHERE salary > 4000; 
B:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m WHERE e.mgr_id = m.mgr_id AND e.salary > 4000;
C:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.employee_id "Mgr_id", m.emp_name "Manager" FROM employees e JOIN employees m ON (e.mgr_id = m.employee_id) AND e.salary > 4000;
D:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id", m.emp_name "Manager" FROM employees e SELF JOIN employees m WHERE e.mgr_id = m.employee_id AND e.salary > 4000;
E:SELECT e.employee_id "Emp_id", e.emp_name "Employee", e.salary, m.mgr_id "Mgr_id" m.emp_name "Manager" FROM employees e JOIN employees m USING (e.employee_id = m.employee_id) AND e.salary > 4000;
You create a package that contains PL/SQL variables that must be shared among several forms in the Travel application. You place the package in a library and attach the library to all the forms that need to share the data. Which parameter in the OPEN_FORM built-in must you set to ensure that changes made by one form are visible to the other forms in the application?（）
A:data_mode 
B:paramlist 
C:query_mode 
D:session_mode 
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 of the following is true about job chains？（）  
A: They consist of one or more Scheduler programs.
B: They are used to implement dependency scheduling.
C: They are used to implement time-based scheduling.
D: They are used to implement event-based scheduling.
E: None of the above.
You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）
A: The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
B: The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
C: The database instance starts，but Automatic Memory Management is disabled
D: The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?（）
A:to prevent the creation of an excessive number of scheduler job classes
B:to allow the Automated Maintenance Tasks to use system resources without any restriction
C:to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D:to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resources
View the following SQL statements：   Transaction T1 INSERT INTO hr.regions VALUES （5，’Pole’）；COMMIT；  Transaction T2 UPDATE hr.regions SET region_name=’Poles’ WHERE region_id = 5； COMMIT；  Transaction T3 UPDATE hr.regions SET region_name=’North and South Poles’ WHERE region_id = 5；   You want to back out transaction T2.  Which option would you use？（）
A: It is possible，but transaction T3 also backs out.
B: It is possible with the NOCASCADE_FORCE option.
C: It is possible with the NONCONFLICT_ONLY option.
D: It is not possible because it has conflicts with transaction T3.
DRAG DROP Click the Task button.
You are working on a test database where instance recovery takes a considerable amount of time.How can reduce the recovery time？（）
A:By multiplexing the control files
B:By multiplexing the redo log files
C:By decreasing the size of redo log files
D:By configuring mean time to recover （MTTR） to a lower value
E:By setting the UNDO_RETENTION parameter to a higher value
Your database is running in ARCHIVELOG mode,and the database is open. You execute an RMAN backup and 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
You are working as a DBA at NetFx Corporation. A user， Scott， is maintaining the records of all the employees in the EMPLOYEEtable. Initially， the salary of the employee， ’E0025’， was $1800. On 1 May 2004， the salary of the employee， ’E0025’， was increased by $200.   The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2000   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   On December 1， 2004， the salary of the employee， ’E0025’， was increased by $400. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’：   SQL>UPDATE EMPLOYEE  SET SALARY = 2400   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   On July 1， 2005， the salary of the employee， ’E0025’， was increased by $500. The user， Scott， issued the following statement to modify the record of the employee， ’E0025’   SQL>UPDATE EMPLOYEE  SET SALARY = 2900   WHERE EMPNO = ’E0025’；   SQL>COMMIT；   On July 5， 2005， the HR manager asked you to generate the increment report of the employee， ’E0025’， for the period between 1 May 2004 and 1 July 2005. Which flashback feature will you use to generate the increment report？（）
A: Flashback Drop
B: Flashback Table
C: Flashback Database
D:Flashback Version Query
Examine the following command that is used to duplicate a database on the same host: RMAN> RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)
A:The data files of the read-only tablespaces in the target database are not duplicated
B:The read-only tablespaces in the target database are still defined in new the database
C:The read-only tablespaces in the target database are changed to online after duplication
D:The data files of the read-only tablespaces in the target database get duplicated
E:The read-only tablespaces in the target database are not defined in the new database
Which two statements are true about the duplexing of the backups taken by RMAN? （）(Choose two.)
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
As a database administrator you spend a lot of time observing and setting various storage parameter values for your application tables in order to gain performance benefits. Which task would you perform to reduce this overhead？（）
A:Coalesce the application tables at a regular interval.
B:Export and Import the application tables a regular interval.
C:Drop and recreate the application tables at a regular interval.
D:Move the application tables to a tablespace with less space usage.
E:Distribute the application tables across multiple tablespaces depending on usage.
F:Move the application tables to automatic segment space management tablespace.
The current time zone for one of the user sessions is set to the database local time zone. For one application， the user session requires the time zone to be set to the local operating system time zone without affecting other user sessions. Which two solutions could the user implement to achieve this objective？ （）
A: use the ALTER SYSTEM command to change the time zone
B: use the ALTER SESSION command to change the time zone
C: use the ALTER DATABASE command to change the time zone
D: set the value for the operating system variable ORA_SDTZ on the client machine
E: set the value for the operating system variable ORA_SDTZ on the database server machine
首页 <上一页 79 80 81 82 83 下一页> 尾页