出自:Oracle认证

Examine the structure of the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. Which two SQL statements produce the name, department name, and the city of all the employees who earn more then 10000?（）
A:
B:
C:
D:
Which is a valid CREATE TABLE statement?（）
A:CREATE TABLE EMP9$# AS (empid number(2));
B:CREATE TABLE EMP*123 AS (empid number(2));
C:CREATE TABLE PACKAGE AS (packid number(2));
D:CREATE TABLE 1EMP_TEST AS (empid number(2));
Given：   11. public void genNumbers（） {   12. ArrayList numbers = new ArrayList（）；   13. for （int i=0； i<10； i++） { 14. int value = i * （（int） Math.random（））；   15. Integer intObj = new Integer（value）；   16. numbers.add（intObj）；   17. }   18. System.out.println（numbers）；   19. }   Which line of code marks the earliest point that an object referenced by intObj becomes a  candidate for garbage collection？（）
A: Line 19
B: The object is NOT a candidate for garbage collection.
C: Line 17
D: Line 16
E: Line 18
Which two statements are true regarding listeners（）
A:Listeners use only the TCP/IP protocol.
B:Multiple listener processes can run simultaneously on a host.
C:Multiple database instances can be registered with a single listener.
D:The listener-related errors can be traced only at the administrative level.
E:Only one database instance can be registered with a single listener at any time.
Which one of the following files includes the parameter NAMES.DIRECTORY_PATH（hostname）？（）
A:Listener.ora
B:Tnsnames.ora
C:Cman.ora
D:Sqlnet.ora
当在WINDOWS平台上安装并运行ORACLE9i服务器后，可通过WINDOWS服务窗口来查看其服务情况，以下哪一个是数据库服务项（假定服务器的SID为ORA92）（）
A:OracleORA92ManagementServer
B:OracleORA92Agent
C:OracleORA92HTTP
D:OracleORA92TNSListener
E:OracleServiceORA92
Given： What is the appropriate definition of the hashCode method in class Person？（）
A:return super.hashCode（）；
B:return name.hashCode（） + age * 7；
C:return name.hashCode（） + comment.hashCode（） / 2；
D:return name.hashCode（） + comment.hashCode（） / 2 - age * 3；
Which of the following tasks is not performed by the job coordinator?（）
A:Update job log when a job completes
B:Spawn and remove job slaves
C:Write/read job info to/from memory cache
D:Query job table
E:Pass job information to job slaves
While selecting files during an interactive restore with ufsrestore， you are interrupted by a junior  administrator before you can complete the file selection process and start the restore. After answering the administrator’s question， you realize that you have forgotten which files you had already selected for the restore.  How can you determine which files are already marked for extraction and restore？ （）
A: You can use the ls subcommand of ufsrestore.
B: You can use the add subcommand of ufsrestore.
C: You can use the select subcommand of ufsrestore.
D: You can view the selected files as they are marked with a plus sign （+） in the list that is permanently displayed in the upper half of the interactive ufsrestore screen view.
You have created a job class， CUST_JOB_1， with two jobs， CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true？ （）
A: The member jobs would get dropped when the job class is dropped.
B: Both the jobs would be executed concurrently.
C: The member jobs would get disabled when the job class is dropped.
D: The attributes defined at the class level would be applied to both the jobs.
E: Jobs in the job class must have been assigned the same priority.
To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow?（）
A:EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor.
B:EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
C:EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor.
D:Either B or C
E:All of the above
（）代表了数据库中最小粒度的逻辑数据存储层次。
A:盘区
B:表空间
C:数据块
D:数据文件
Which three statements are true?（）
A:A final method in class X can be abstract if and only if X is abstract.
B:A protected method in class X can be overridden by any subclass of X.
C:A private static method can be called only within other static methods in class X.
D:A non-static public final method in class X can be overridden in any subclass of X.
E:A public static method in class X can be called by a subclass of X without explicitly referencing the class X.
F:A method with the same signature as a private final method in class X can be implemented in a subclass of X.
G:A protected method in class X can be overridden by a subclass of X only if the subclass is in the same package as X.
You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）
A: Memory Advisor
B: Segment Advisor
C: SQL Tuning Advisor
D: SQL Access Advisor
E: Automatic Database Diagnostic Monitor （ADDM）
Which tool in the layout model could you use to create an external boiler plate object?（）
A:Field 
B:Frame 
C:Button 
D:Rectangle
E:Link file
What kind of ports do Oracle Web Cache and Oracle Http Server come pre-configured with ？ （）
A: Non-SSL only
B: SSL only
C: both
D: none
Given： Which four statements are true？（）
A:Raccoon is-a Mammal.
B:Raccoon has-a Mammal.
C:BabyRaccoon is-a Mammal.
D:BabyRaccoon is-a Raccoon.
E:BabyRaccoon has-a Mammal.
F:BabyRaccoon is-a BabyRaccoon.
What does the Web Session Affinity feature of Active GridLink for RAC provide?（）
A:It mandates that HTTP sessions must be stored in an Oracle RAC database for the highest  throughput and availability.
B:It pins a connection to the thread associated with a web session such that subsequent  connection reservations are significantly faster.
C:It stores a reference to the connection associated with an HTTP session in the session object.
D:It allows developers to modify how their web application reserves and releases database  connections to allow enhanced performance.
E:It provides improved performance by associating a database connection with an HTTP session. 
Mysqldump was used to create a single schema backup; Shell> mysqldump –u root –p sakila > sakila2013.sql Which two commands will restore the sakila database without interfering with other running database?（）
A:Mysql＞ USE sakila; LOAD DATA INFILE 'sakila2013.sql';
B:Shell＞ mysql –u root –p sakila sakila2013.sql
C:Shell＞ mysql import –u root –p sakila sakila2013.sql
D:Shell＞ mysql  –u root -p  –e 'use sakila; source sakila2013.sql'
E:Shell＞ mysql  –u root  –p  –silent ＜ sakila2013.sql
While performing the backup of the flash recovery area, you notice that one of the archived redo log files is missing. You have multiple destinations for archived redo log files. What implications does it have on the backup of the flash recovery area?（）
A:The backup fails because one of the archived redo log files is missing. 
B:The backup succeeds but it would be without the missing archived log. 
C:During backup, you are prompted for the alternative destination for the missing archived redo log file. 
D:The backup succeeds because it fails over to one of the alternative archived redo log destinations. 
Given: What is the output?（）
A:42
B:420
C:462
D:42042
You realize that the control file is damaged in your production database.After restoring the control file from autobackup, what is the next step that you must do to proceed with the database recovery?（）
A:Mount the database
B:Open the database in NORMAL mode
C:Open the database in RESTRICTED mode
D:Open the database with the RESETLOGS option
Which two kinds of failures make the Data Recovery Advisor (DRA)generate a manual checklist? （）
A:failures because a data file is renamed by error
B:failures when no standby database is configured
C:failures that require no archive logs to be applied for recovery
D:failures due to loss of connectivity-for example, an unplugged disk cable
The PRODUCTS table has these columns: PRODUCT_ID NUMBER(4) PRODUCT_NAME VARCHAR2(45) PRICE NUMBER(8,2) Evaluate this SQL statement: SELECT * FROM PRODUCTS ORDER BY price, product _ name; What is true about the SQL statement?（）
A:The results are not sorted.
B:The results are sorted numerically.
C:The results are sorted alphabetically.
D:The results are sorted numerically and then alphabetically.
Examine the structure of the EMPLOYEES table: EMPLOYEE_ID NUMBER Primary Key FIRST_NAME VARCHAR2(25) LAST_NAME VARCHAR2(25) DEPARTMENT_ID NUMBER SALARY NUMBER What is the correct syntax for an inline view?（）
A:SELECT a.last_name, a.salary, a.department_id,
B:maxsal FROM employees a, (SELECT department_id, max(salary)maxsal FROM employees GROUP BY department_id) b WHERE a.department_id = b.department_id AND a.salary < b.maxsal;
C:SELECT a.last name, a.salary, a.department_id FROM employees a WHERE a.department_id IN (SELECT department_id FROM employees b GROUP BY department_id having salary = (SELECT max(salary) from employees))
D:SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE a.salary = (SELECT max(salary) FROM employees b WHERE a.department _ id = b.department _ id);
E:SELECT a.last_name, a.salary, a.department_id FROM employees a WHERE (a.department_id, a.salary) IN (SELECT department_id, a.salary) IN (SELECT department_id max(salary) FROM employees b GROUP BY department_id ORDER BY department _ id);
By using the transaction identifier provided by （） for a particular row change， you can use the Flashback Transaction Query to see the operation performed by the transaction. 
A:Flashback Table
B:Flashback Database
C:Flashback Versions Query
D:the RMAN REPORT command
E:the DBA_PENDING_TRANSACTIONS view
View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
A: The statement would not execute because table aliases are not allowed in the JOIN clause.
B: The statement would not execute because the table alias prefix is not used in the USING clause.
C: The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.
D: The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.
You issue the following RMAN command to set a retention policy on a database：   RMAN>CONFIGURE RETENTION POLICY TO REDUNDANCY 2；   What will be the outcome of issuing this command？（）  
A: After two days，a backup will be marked obsolete
B: After two days，a backup will be deleted from the media
C: If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media.
D: If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.
You are currently located in Singapore and have connected to a remote database in Chicago. You issue the following command:SQL> SELECT ROUND (SYSDATE-promo_begin_date, 0) FROM promotions WHERE (SYSDATE-promo_begin_date)/365 >2;PROMOTIONS is the public synonym for the public database link for the PROMOTIONS table. What is the outcome?（） 
A:an error because the ROUND function specified is invalid 
B:an error because the WHERE condition specified is invalid 
C:number of days since the promo started based on the current Chicago date and time 
D:number of days since the promo started based on the current Singapore date and time 
You configured the Flash Recovery Area （FRA） for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy（）
A:flashback log files
B:backups that have become obsolete
C:copies of the data files and control files
D:archived redo log files that have multiple copies in a different archive location and not backed up
首页 <上一页 68 69 70 71 72 下一页> 尾页