出自:Oracle认证

You are performing flashback of the ORDERS table in the Scott’s schema because some important data is deleted in the table by mistake. The SCN number was 771513 at the time of deletion. You issued the following statement to perform Flashback Table：  SQL> FLASHBACK TABLE ORDERS TO SCN 771513；   What is the prerequisite to perform Flashback Table？（）
A: You must configure OMF in your database.
B: You must enable block change tracking feature in your database.
C: You must enable ROW MOVEMENT feature on the ORDERS table.
D: You must use the Flashback Version Query before using the Flashback Table feature.
Flashback Database relies on which technologies to recover to a point in time？（）  
A: Flashback Data Archive
B: Flashback logs in the flash recovery area
C: FlashbUndo tablespace
D: RMAN command line
E: None of the above
Given 11.public interface Status { 12. int MY_VALUE = 10； 13.} Which three are valid on line 12？（）
A:final
B:static
C:native
D:public
E:private
A user executes the statement; PURGE BINARY LOGS TO 'mysql-bin.010'; What is the result?（）
A:It deletes all binary log files, except 'mysql-in.010'
B:It deletes all binary log files up to and including 'mysql-bin.010'
C:It deletes all binary log files before 'mysql-bin.010'
D:It deletes all binary log files after 'mysql-bin.010'
These are points that describe the contents of different memory components:  1: Descriptive information or metadata about schema objects that are queried by using SQL statements  2: The run-time area for data manipulation language (DML) or data definition language (DDL) statements  3: Results of SQL queries and PL/SQL functions  4: Executable forms of SQL cursors, PL/SQL programs, and Java classes  5: The information necessary to reconstruct changes made to the database by a transaction  Which of these will be stored in theShared Poolif the necessary configurations are done（）
A:1 and 2
B:2 and 5
C:1，3，and 4
D:3，4，and 5
E:1，2，3，and 4
Which three SELECT statements displays 2000 in the format "$2,000.00"? （）
A:SELECT TO CNAR(2000, '$#,###.##') FROM dual;
B:SELECT TO CNAR(2000, '$0,000.00') FROM dual;
C:SELECT TO CNAR(2000, '$9,999.00') FROM dual;
D:SELECT TO CNAR(2000, '$9,999.99') FROM dual;
E:SELECT TO CNAR(2000, '$2,000.00') FROM dual;
F:SELECT TO CNAR(2000, '$N,NNN.NN') FROM dual;
Connection Manager features cannot be used with which of the following naming method？ （）
A:Oracle names
B:Local Naming
C:Host Naming
D:Names Server
You have issued a SHUTDOWN ABORT command to bring down your database instance. Consider the stepsthat will be performed later when you open the database： 1. SGA is allocated. 2. Control file is read. 3. Redo log files are read. 4. Instance recovery is started. 5. Background processes are started. 6. Data files are checked for consistency. 7. Server parameter file or the initialization parameter file is read.  Which option has the correct order in which these steps occur（）
A:7， 1， 5， 2， 3， 6， 4
B:1， 2， 3，7， 5， 6， 4
C:7， 1， 4， 5， 2， 3， 6
D:1， 7， 5， 4， 2， 3， 6
You established access to menu modules using roles. You have allowed the sales role to access the menu module, but prevented access to the Update menu item. Which item property would you alter to gray out the menu option for the role?（）
A:Item Roles. 
B:Menu Item Roles. 
C:Display without Privilege. 
D:Use Security. 
E:Command Type.
You have a very large table that your users access frequently. Which of the following advisors will recommend any indexes to improve the performance of queries against this table?（）
A:The Automatic Memory Manager (AMM)
B:The SQL Tuning Advisor
C:The Segment Advisor
D:The SQL Access Advisor SQL
In a SELECT statement that includes a WHERE clause, where is the GROUP BY clause placed in the SELECT statement? （）
A:Immediately after the SELECT clause
B:Before the WHERE clause
C:Before the FROM clause
D:After the ORDER BY clause
E:After the WHERE clause
Which statement is true about mouse events? （）
A:The cursor style can be set to CAUTION. 
B:Double-clicking a mouse button can potentially fire six mouse event triggers. 
C:The values for the SYSTEM.MOUSE_BUTTON_PRESSED system variable can only be 1 or 2. 
D:Click and double-click button actions can only detect if the mouse is positioned in an item.
You are managing an Oracle Database 11g database with the following backup strategy：1） On Sunday， an incremental level 0 tape backup is performed.2） Monday through Saturday， a cumulative incremental level 1 tape backup is performed. Which twostatements are true regarding the backups performed（）
A:The backup performed in step 1 backs up all blocks that have ever been in use in the database.
B:The backup performed in step 2 copies all the blocks changed since the most recent level 0 backup.
C:The backup performed in step 1 backs up all the blocks changed since the most recent level 1 backup.
D:The backup performed in step 2 backs up all blocks that have changed since the most recent incrementalbackup at level 1
Examine the structure of the EMPLOYEES and DEPARTMENTS tables: EMPLOYEESColumn name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key EMP_NAME VARCHAR2 (30) JOB_ID VARCHAR2 (20) SALARY NUMBER MGR_ID NUMBER References EMPLOYEE_ID COLUMN DEPARTMENT ID NUMBER Foreign key to DEPARTMENT ID column of the DEPARTMENTS table DEPARTMENTSColumn name Data type Remarks DEPARTMENT_ID NUMBER NOT NULL, Primary Key DEPARTMENT_NAME VARCHAR2(30) MGR_ID NUMBER References MGR_ID column of the EMPLOYEES table Evaluate this SQL statement: SELECT employee_id, e.department_id, department_name, salary FROM employees e, departments d WHERE e. department_id = d.department_id; Which SQL statement is equivalent to the above SQL statement? （）
A:SELECT employee_id, department_id, department_name, salary FROM employees WHERE department_id IN (SELECT department_id FROM departments);
B:SELECT employee_id, department_id, department_name, salary FROM employees NATURAL JOIN departments;
C:SELECT employee_id, d.department_id, department_name, salary FROM employees e JOIN departments d ON e.department _ id = d. department_id;
D:SELECT employee_id, department_id, department_name, Salary FROM employees JOIN departments USING (e.department_id, d.department_id);
Given: What is the result?（）
A:foofoofoofoofoo
B:foobarfoobarbar
C:foobarfoofoofoo
D:foobarfoobarfoo
E:barbarbarbarbar
F:foofoofoobarbar
G:foofoofoobarfoo
When creating a SQL tuning set，which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values？（）
A: Filter versions
B: Filter loads
C: Filter tasks
D: Filter options
Examine the statement: Create synonym emp for hr. employees; What happens when you issue the statement? （）
A:An error is generated.
B:You will have two identical tables in the HR schema with different names.
C:You create a table called employees in the HR schema based on you EMP table.
D:You create an alternative name for the employees table in the HR schema in your own schema.
Which two tasks can you perform using only the TO_CHAR function? （）
A:convert 10 to 'TEN'
B:convert '10' to 10
C:convert 10 to '10'
D:convert 'TEN' to 10
E:convert a date to a character expression
F:convert a character expression to a date
You need to modify the STUDENTS table to add a primary key on the STUDENT_ID column. The table is currently empty.Which statement accomplishes this task?（）
A:ALTER TABLE students ADD PRIMARY KEY _ id;
B:ALTER TABLE students ADD CONSTRAINT PRIMARY KEY (student_id);
C:ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY student_id;
D:ALTER TABLE students ADD CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
E:ALTER TABLE students MODIFY CONSTRAINT stud_id_pk PRIMARY KEY (student_id);
当需要查询日志文件所有组及其成员的名称和文件位置，可以使用（）方式。
A:SELECT * FROM V$LOGFILE
B:SELECT * FROM V$LOG
C:SELECT * FROM V$LOGHISTORY
D:SELECT * FROM V$DBA
You work as a database administrator for Certkiller .com. In the middle of a transaction， a user session was abnormally terminated but the instance is still up and the database is open. Which two statements are true in this scenario？（）
A:Event Viewer gives more details on the failure.
B:The alert log file gives detailed information about the failure.
C:PMON rolls back the transaction and releases the locks.
D:SMON rolls back the transaction and releases the locks.
E:The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction.
F:Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.
A customer stores environmental settings in the deployment descriptors of an application. Whenever they promote the application version from testing to the production environment, they need to open the archive and modify the deployment descriptor. This process is against their security policy.    What approach should you recommend to leverage WebLogic features such that they do not have to modify the application archive for different environments?（）
A:Keep environmental data in the global settings of domain and the application can read it from the domain where it runs.
B:Keep environmental data in Deployment Plan XML files. It allows you to change parameters in the deployment descriptor without opening the archive file.
C:Keep environmental data in the database because it is the most effective way of parametrizing the environment.  
D:Keep archive in exploded format so the customer does not have to open the archive files.
E:Eliminate all environmental settings from the application. There should not to be any environmental settings in the application. 
Which are iSQL*Plus commands? （）
A:INSERT
B:UPDATE
C:SELECT
D:DESCRIBE
E:DELETE
F:RENAME
You dropped a schema of a user in an Oracle 10g by mistake. You decide to flash the database back to its previous state to restore the deleted schema.   Which process writes the before images of the physical database blocks to the flashback database logs？（）
A: LGWR
B: DBWR
C: MMON
D: RVWR
Given the following directory structure： bigProject |--source ||--Utils.java| |--classes |-- And the following command line invocation： javac -d classes source/Utils.java Assume the current directory is bigProject，what is the result？（）
A:If the compile is successful， Utils.class is added to the source directory.
B:The compiler returns an invalid flag error.
C:If the compile is successful， Utils.class is added to the classes directory.
D:If the compile is successful， Utils.class is added to the bigProject directory.
You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer （OUI） prompts you to enter the path of the inventory directory and also prompts you to specify an operating systemgroup name.  Which statement is true in this case（）
A:The ORACLE_BASE parameter is not set.
B:The installation is being performed by the root user.
C:The operating system group that will be specified should have root user as its member.
D:The installation is being performed without the "Create Starter Database" option selected.
E:The operating system group that will be specified must have permission to write to the inventory directory
Given: Which is true?（）
A:If line 10 is removed, the compilation succeeds.
B:If line 11 is removed, the compilation succeeds.
C:If line 12 is removed, the compilation succeeds.
D:If line 13 is removed, the compilation succeeds.
E:More than one line must be removed for compilation to succeed.
Which of the following steps is incorrect in the following sequence of enabling the ARCHIVELOG mode of a database？（）
A:Shut down the database.
B:Set the appropriate parameters in init.ora file.
C:Start the database in NOMOUNT state.
D:Issue the ALTER DATABASE ARCHIVELOG command.
E:Open the database.
F:Take a full closed backup.
How is block-change tracking enabled？（）  
A: With alter database enable block change tracking
B: With alter system enable block change tracking
C: With an init.ora parameter change
D: With an spfile parameter change
Evaluate the following statement：   Which statement is true regarding the evaluation of rows returned by the subquery in the INSERT statement？（）
A: They are evaluated by all the three WHEN clauses regardless of the results of the evaluation of any other WHEN clause.
B: They are evaluated by the first WHEN clause. If the condition is true， then the row would be evaluated by the subsequent WHEN clauses.
C: They are evaluated by the first WHEN clause. If the condition is false， then the row would be evaluated by the subsequent WHEN clauses.
D: The INSERT statement would give an error because the ELSE clause is not present for support in case none of the WHEN clauses are true.
首页 <上一页 13 14 15 16 17 下一页> 尾页