Oracle认证考试 题目列表
Which two statements about subqueries are true?（）A、A single row subquery can retrieve data from only one table.B、A SQL query statement cannot display data from table B that is referred to in its subquery, unless table B is included in the main query's FROM clause.C、A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause.D、A single row subquery can retrieve data from more than one table.E、A single row subquery cannot be used in a condition where the LIKE operator is used for comparison.F、A multiple-row subquery cannot be used in a condition where the LIKE operator is used for comparison.
Which two are attributes of /SQL*Plus? （）A、/SQL*Plus commands cannot be abbreviated.B、/SQL*Plus commands are accesses from a browser.C、/SQL*Plus commands are used to manipulate data in tables.D、/SQL*Plus commands manipulate table definitions in the database.E、/SQL*Plus is the Oracle proprietary interface for executing SQL statements.
he DBA is about to enable auditing on the Oracle database in an attempt to discover some suspicious activity. Audit trail information is stored in which of the following database object names?（）A、SYS.SOURCE$ B、SYS.AUD$ C、DBA_SOURCE D、DBA_AUDIT_TRAIL
Which two statements are true regarding single row functions?（）A、They accept only a single argument B、They can be nested only to two levels C、Arguments can only be column values or constants D、They always return a single result row for every row of a queried table E、They can return a data type value different from the one that is referenced
How would you default the layout of a parameter form? （）A、Use the default layout tool in the parameter form editor. B、Select menu item tool-parameter form builder. C、Open the parameter form editor and select menu items tool-default layout. D、You cannot default the layout of the parameters.
In WebLogic 10.3.6 and WebLogic 12c on ExaLogic, performance of JMS is further improved through （）.A、Web Session AffinityB、Concurrent Request ManagerC、CoherenceD、Elastic Message Overflow
You work as a database administrator for Supportcenter.cn. You enabled tracing while creating a listener to your database. What additional information is available to you when you enable tracing？（）A、Information about each Oracle Net connection.B、Information about each entry in theLinstener.orafileC、Information about the changed done in the databaseD、Information about the different listeners in your systemE、Information about all thenondatabasefiles required to operate the database
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.
Which statement describes the ROWID data type?（）A、Binary data up to 4 gigabytes.B、Character data up to 4 gigabytes.C、Raw binary data of variable length up to 2 gigabytes.D、Binary data stored in an external file, up to 4 gigabytes.E、A hexadecimal string representing the unique address of a row in its table.
You have a listener process， L1， currently listening for the connections to the PROD and ADMIN databases. You create a new database， PAY， using CREATE DATABASE.. command. You have not enabled dynamic instance registration. You modified the LISTENER.ORA file manually to include PAY database for L1 listener process. Which command of Listener control utility （LSNRCTL） would you use to enable L1 process to start listening for the connections to the PAY database without disrupting any existing database communications？（）A、STARTB、RELOADC、RESTARTD、REFRESHE、START L1F、RELOAD L1G、RESTART L1H、REFRESH L1
In user-managed backup and recover procedures， how are data files backed up？ （）A、Using SQL commands.B、Using SQL*Plus commands.C、Using operating system commands.D、Using Recover Manager commands.
You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager （RMAN）. The most recent backup of the TOOLStablespace to disk was taken on January 3. The TOOLStablespace is read-only.On February 21， when you execute a command to back up all the tablespaces to disk， you find that RMAN backs up the TOOLS tablespace also， even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLStablespace， you decide that the tablespace should not be backed up by RMAN. What can you do to skip backing up the TOOLStablespace without changing the current backup optimization setting？（）A、 configure a default device for RMAN backupsB、 temporarily disable the retention policy for RMAN backupsC、 configure automatic channel allocation for RMAN backupsD、 use the CONFIGURE command to reconfigure the recovery window to 60 days
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.
根据不同的需要，可对数据库服务器进行相应的启动方式，当以STARTUP MOUNT方式启动时，以下说法正确的是（）A、仅仅创建一个数据库实例B、创建了数据库实例并且挂载了数据库C、创建了数据库实例，同时也创建了数据库D、打开了数据库，但只能供系统用户访问E、创建了数据库实例，并且以只读方式打开了数据库