出自:Oracle认证

Where can you add your own PL/SQL code in relation-handling triggers?（）
A:Before the "End default relation program section" comment. 
B:After the "Begin default relation program section" comment. 
C:Before the "Begin default relation program section" comment. 
D:It is not possible to modify the relation-handling code that Forms automatically creates for relations.
You are specifying French case-insensitive sorts by using the NSL_SORT parameter for the user session of the user， Scott. Which value will you set for the NLS_SORT parameter？（）
A: FRENCH_AI
B: FRENCH_CI
C: AI_FRENCH
D: CI_FRENCH
View the exhibit and examine the TRANS table's storage information. After a massive delete operation, you executed the following statement to shrink the TRANS table: SQL> ALTER TABLE trans SHRINK SPACE CASCADE; Which statement describes the outcome of the command?（）
A:An error is produced.
B:The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjusted
C:The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchanged
D:The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process
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*FROMemp_dept_vu；
B:SELECTdepartment_id，SUM（salary）FROMemp_dept_vuGROUPBYdepartment_id；
C:SELECTdepartment_id，job_id，AVG（salary）FROMemp_dept_vuGROUPBYdepartment_id，job_id；
D:SELECTjob_id，SUM（salary）FROMemp_dept_vuWHEREdepartment_idIN（10，20）GROUPBYjob_idHAVINGSUM（salary）>；20000；
E:Noneofthestatementsproduceanerror；allarevalid
You want to display the titles of books that meet these criteria: 1. Purchased before January 21, 2001 2. Price is less then $500 or greater than $900 You want to sort the results by their data of purchase, starting with the most recently bought book. Which statement should you use? （）
A:SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase_date;
B:SELECT book_title FROM books WHERE price IN (500,900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date ASC;
C:SELECT book_title FROM books WHERE price < 500 or > 900 AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
D:SELECT book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < '21-JAN-2001' ORDER BY purchase date DESC;
Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement？（）
A: SQL Repair Advisor
B: SQL Optimizer
C: SQL Access Advisor
D: SQL Tuning Advisor
You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor？（） 
A:DBMS_SERVER_ALERT
B:DBMS_ADVISOR
C:DBMS_RESOURCE_MANAGER
D:DBMS_REPAIR
Examine the structure of the EMPLOYEES table: Column name Data type Remarks EMPLOYEE_ID NUMBER NOT NULL, Primary Key LAST_NAME VARCNAR2(30) FIRST_NAME VARCNAR2(30) JOB_ID NUMBER SAL NUMBER MGR_ID NUMBER References EMPLOYEE_ID column DEPARTMENT_ID NUMBER You need to create an index called NAME_IDX on the first name and last name fields of the EMPLOYEES table. Which SQL statement would you use to perform this task?（）
A:CREATE INDEX NAME _IDX (first_name, last_name);
B:CREATE INDEX NAME _IDX (first_name, AND last_name)
C:CREATE INDEX NAME_IDX ON (First_name, last_name);
D:CREATE INDEX NAME_IDX ON employees (First_name, AND last_name);
E:CREATE INDEX NAME_IDX ON employees (First_name, last_name);
F:CREATE INDEX NAME_IDX FOR employees (First_name, last_name);
Given： A programmer is developing a class Key， that will be used as a key in a standard java.util.HashMap. Which two methods should be overridden to assure that Key works correctly as a key？（）
A:public int hashCode（）
B:public boolean equals（Key k）
C:public int compareTo（Object o）
D:public boolean equals（Object o）
E:public boolean compareTo（Key k）
A team of programmers is reviewing a proposed API for a new utility class. After some discussion， theyrealize that they can reduce the number of methods in the API without losing any functionality. If theyimplement the new design，which two OO principles will they be promoting？（）
A:Looser coupling
B:Tighter coupling
C:Lower cohesion
D:Higher cohesion
E:Weaker encapsulation
Given： What is the result？（）
A:81
B:82
C:91
D:92
EMPDET is an external table containing the columns EMPNO and ENAME.   Which command would work in relation to the EMPDET table？ （）
A:A
B:B
C:C
D:D
You created a view called EMP_DEPT_VU that contains three columns from the EMPLOYEES and DEPARTMENTS tables: EMPLOYEE_ID, EMPLOYEE_NAME AND DEPARTMENT_NAME. The DEPARTMENT_ID column of the EMPLOYEES table is the foreign key to the primary key DEPARTMENT_ID column of the DEPARTMENTS table. You want to modify the view by adding a fourth column, MANAGER_ID of NUMBER data type from the EMPLOYEES tables. How can you accomplish this task? （）
A:ALTER VIEW EMP_dept_vu (ADD manger_id NUMBER);
B:MODIFY VIEW EMP_dept_vu (ADD manger_id NUMBER);
C:ALTER VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employee e, departments d WHERE e.department _ id = d.department_id;
D:MODIFY VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
E:CREATE OR REPLACE VIEW emp_dept_vu AS SELECT employee_id, employee_name, department_name, manager_id FROM employees e, departments d WHERE e.department _ id = d.department_id;
F:You must remove the existing view first, and then run the CREATE VIEW command with a new column list to modify a view.
You are managing an Oracle Database 11g database. You want to take a backup on tape drives of the USERS tablespace that has a single data file of 900 MB. You have tape drives of 300 MB each. To accomplish the backup， you issued the following RMAN command：   RMAN>BACKUP SECTION SIZE 300M TABLESPACE users；   What configuration should be effected to accomplish faster and optimized backups by using the above command？（）
A: The SBT channel must be configured， with the default parallelism setting for the SBT device set to 1
B: The COMPATIBLE initialization parameter for the database instance must be set to at least 10.0
C: The SBT channel must be configured， with the parallelism setting for the SBT device set to 3
D: The SBT channel must be configured， with the MAXPIECESIZE set to 300 MB
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）
A:Use the DESCRIBE command in the EMP_DEPT VU view.
B:Use the DEFINE VIEW command on the EMP_DEPT VU view.
C:Use the DESCRIBE VIEW command on the EMP_DEPT VU view.
D:Query the USER_VIEWS data dictionary view to search for the EMP_DEPT_VU view.
E:Query the USER_SOURCE data dictionary view to search for the EMP_DEPT_VU view.
F:Query the USER_OBJECTS data dictionary view to search for the EMP_DEPT_VU view.
Which four are attributes of single row functions? （）
A:cannot be nested
B:manipulate data items
C:act on each row returned
D:return one result per row
E:accept only one argument and return only one value
F:accept arguments which can be a column or an expression
Given: Which statement is true?（）
A:420 is the output.
B:An exception is thrown at runtime.
C:All constructors must be declared public.
D:Constructors CANNOT use the private modifier.
E:Constructors CANNOT use the protected modifier.
While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）
A: Memory Advisor
B: Segment Advisor
C: Undo Advisor
D: SQL Tuning Advisor
Given： What is the result？（）
A:An exception is thrown at runtime.
B:Compilation fails because of an error in line 7.
C:Compilation fails because of an error in line 4.
D:Compilation succeeds and no runtime errors with class A occur.
数据处理技术通常分为以下（）类型。
A:人工处理
B:文件系统处理
C:字处理
D:数据库系统处理
You are performing a backup of your database across the network. While taking the backup， you want to save space on the storage media and reduce the network bandwidth. Which command will you issue to configure the required type of backup？（）
A: CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO BACKUPSET；
B: CONFIGURE DEVICE TYPE TO disk BACKUP TYPE TO COPY；
C: CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED BACKUPSET；
D: CONFIGURE DEVICE TYPE TO sbt BACKUP TYPE TO COMPRESSED COPY；
A customer is developing a custom application that involves a multistep provisioning process for a new account. There is a custom Java client application that is generating multiple JMS messages as part of the process and sending them to the WebLogic tier where they are processed.    Which three steps must you take to implement the solution to allow for scalability and parallel processing of multiple simultaneous provisioning requests while ensuring messages for an individual process are not delivered out of order?（）
A:Update the client application that is creating the JMS messages to use Unit of Work.
B:Configure a WebLogic Cluster for Distributed JMS.
C:Update the client application that is creating the JMS messages to use Unit of Order.
D:Enable XA Transactions on the JMS Connection Factory used by the client application.
E:Enable Load Balancing on the JMS connection factory used by the client application. 
Which two statements are true about encrypting RMAN backup?（）
A:The transparent encryption of backups uses the encryption wallet
B:The database uses the same encryption key for every encrypted backup
C:The password encryption of backups only uses the password while creating and restoring backup
D:If transparent encryption is configured, you cannot use the SET ENCRYPTION BY PASSWORD command to make password-protected backups.
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.
A company has a business application that provides its users with many different reports： receivables reports， payables reports， revenue projects， and so on. The company has just purchased somenew， state-of-the-art， wireless printers， and a programmer has been assigned the task of enhancing all ofthe reports to use not only the company’s old printers， but the new wireless printers as well. When the programmer starts looking into the application， the programmer discovers that because of the design of theapplication， it is necessary to make changes to each report to support the new printers. Which two designconcepts most likely explain this situation？ （）
A:Inheritance
B:Low cohesion
C:Tight coupling
D:High cohesion
E:Loose coupling
F:Object immutability
Given a class Repetition: Which code should be inserted at line 1 of Demo.java to compile and run Demo to print "pizzapizza"?（）
A:import utils.*;
B:static import utils.*;
C:import utils.Repetition.*;
D:static import utils.Repetition.*;
E:import utils.Repetition.twice();
F:import static utils.Repetition.twice;
G:static import utils.Repetition.twice;
You have lost all members of your current redo log file group. You issue this query： SQL> select * from v$log；  GROUP#    SEQ#     BYTES        ARC STATUS            FIRST_NAME  1                  60           153600        NO INACTIVE            01-03-09：19：34  2                  61           153600        NO CURRENT            01-03-09：19：50  You then perform an incomplete recover. You receive this message： ORA-00279：  change 309141...03/09/01 19：50：14 Needed for thread 1  ORA-00289： suggestion ： /disk1/archive/arch_61.rdo ORA-00280： change 309043 for thread 1 is in  sequence #61 Specify log： {=suggested | filename | AUTO | CANCEL} How should you respond to this message？（）
A:Enter the keyword AUTO.
B:Enter the keyword CANCEL.
C:Press the Enter or Return key.
D:Enter the filename ’/disk1/archive/log2a.rdo’.
Your organization decided to upgrade the existing Oracle 10g database to Oracle 11g database in a multiprocessor environment. At the end of the upgrade, you observe that the DBA executes the following script: SQL> @utlrp.sql What is the significance of executing this script?（）
A:It performs parallel recompilation of only the stored PL/SQL code.
B:It performs sequential recompilation of only the stored PL/SQL code.
C:It performs parallel recompilation of any stored PL/SQL as well as Java code.
D:It performs sequential recompilation of any stored PL/SQL as well as Java code.
What does it mean if a backup is expired？（）  
A: The backup set has exceeded the retention criteria set in RMAN and is eligible for removal. 
B: The backup set has one or more invalid blocks in it and is not usable for recovery.
C: The backup set contains one or more tablespaces no longer in the database.
D: The backup set contains one or more missing backup set pieces.
E: The backup set is from a previous version of RMAN and was not upgraded.
You executed this command to create a password file: $ orapwd file = orapworcl entries = 10 ignorecase = N Which two statements are true about the password file?（）
A:It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role.
B:It contains username and passwords of database users who are members of the OSOPER operating system group.
C:It contains usernames and passwords of database users who are members of the OSDBA operating system group.
D:It will permit the use of lowercase passwords for database users who have granted the SYSDBA role.
E:It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.
首页 <上一页 48 49 50 51 52 下一页> 尾页