出自:Oracle认证

Examine the data from the ORDERS and CUSTOMERS tables. Evaluate the SQL statement: What is the result when the query is executed?（）
A:
B:
C:
D:The query fails because the subquery returns more than one row.
E:The query fails because the outer query and the inner query are using different tables.
Which statement is true concerning dropping a pluggable database (PDB)?（）
A:The PDB must be open in read-only mode.
B:The PDB must be in mount state.
C:The PDB must be unplugged.
D:The PDB data files are always removed from disk.
E:A dropped PDB can never be plugged back into a multitenant container database (CDB).
Which three types of information does the control file contain？（）
A:Current log sequence.
B:Recover tuning parameters.
C:Redo log names and locations.
D:Data file names and locations.
E:Undo segment names and locations.
View the Exhibit and examine the recommendation graph provided for a test database by the Undo Advisor.The graph recommends that the size of undo tablespace should be set to（）.
A:1 MB 
B:6 MB 
C:10 MB 
D:15 MB 
E:11 MB
You are configuring a JMS server with a need for load balancing the messages. To achieve the  load balance you should （）.
A:use regular queues and topics  
B:use distributed queues and topics
C:not use subdeployments
D:disable server affinity
E:use message paging
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.
You are using the Block Media Recovery feature to recover the blocks that are marked corrupt since the last backup. Which view will you query to display information about the data blocks that are marked corrupt since the last backup？（）
A: V$BACKUP_CORRUPTION
B: V$COPY_CORRUPTION
C: V$DATABASE_BLOCK_CORRUPTION
D: RC_BACKUP_CORRUPTION
Examine the SQL statement that creates ORDERS table: CREATE TABLE orders (SER_NO NUMBER UNIQUE, ORDER_ID NUMBER, ORDER_DATE DATE NOT NULL, STATUS VARCHAR2(10) CHECK (status IN ('CREDIT', 'CASH')), PROD_ID NUMBER REFERENCES PRODUCTS(PRODUCT_ID), ORD_TOTAL NUMBER, PRIMARY KEY (order_id, order_date)); For which columns would an index be automatically created when you execute the above SQL statement? （）
A:SER_NO
B:ORDER_ID
C:STATUS
D:PROD_ID
E:ORD_TOTAL
F:composite index on ORDER_ID and ORDER_DATE
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 SQL
For which two situations would you use functionality provided by the Resource Manager？（）
A: setting idle timeout limits on resource plans
B: saving storage space by using compressed backup sets
C: creating jobs that will run automatically at a scheduled time
D: assigning priorities to jobs to manage access to system resources
E: creating alerts to perform notification when tablespaces are low on available space resources
You are a Database Administrator with WonderWeb. You use a password file to establish connections to the Sales database located on the server. You created the password file using the following command：        ORAPWD file=d：/oracle/ora9i/orapwU01 password=admin entries=4   You erroneously deleted the password file while the database was running. You re-create the password file using the following command：   ORAPWD file=d：/oracle/ora9i/orapwU01 password=change_on_install entries=4   However， when you try to connect as the SYS user， you receive the following error：        ORA-01031： insufficient privileges   What should you do to resolve this error？（）
A: Delete the newly created password file and re-create another password file with the password admin， without shutting down the database.
B: Enable the operating system authentication， shut down the database， disable the operating system authentication， and restart the database using the password file.
C: Enable the operating system authentication， shut down the database， re-create the password file using the same ORAPWD command， and restart the database using the password file.
D: Delete the newly created password file， enable operating system authentication and shut down the database. Then， re-create another password file using the same ORAPWD command and restart the database using this password file.
You performed the RMAN database backup with the KEEP option. Which two statements are true regarding this backup？（）
A: The backup contains data files， the server parameter file，and the control file even if the control file  autobackup is disabled.
B: The KEEP option overrides the configured retention policy.
C: The backup contains only data files and archived redo log files.
D: The KEEP option is an attribute of an individual backup piece.
Evaluate the following command: SQL>ALTER SYSTEM SET db_securefile = 'IGNORE'; What is the impact of this setting on the usage of SecureFiles?（）
A:It forces BasicFiles to be created even if the SECUREFILE option is specified to create the LOB
B:It forces SecureFiles to be created even if the BASICFILE option is specified to create the LOB
C:It does not allow the creation of SecureFiles and generates an error if the SECUREFILE option is specified to create the LOB
D:It ignores the SECUREFILE option only if a Manual Segment Space Management tablespace is used and creates a BasicFile
Which statement about Automatic Memory Management with Oracle 11g is true?（）
A:You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file.
B:Oracle can reallocate memory between the SGA and PGA automatically as needed.
C:To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file.
D:You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size
You issued the RMAN> SHOW ALL； command. The output of this command is as follows：   After analyzing the output， which conclusion will you draw？（）
A: The backups consist of backup pieces.
B: The datafiles can be multiplexed within the backup.
C: The backups can be stored only on the disk.
D: While performing the backup across a network， the network bandwidth is reduced.
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES 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.
You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  
A: ASMB
B: ARBn
C: RBAL in the ASM instance
D: RBAL in the database instance
假设emp表包含一个婚姻状况的字段，则应该在该字段上创建（）索引。
A:B树唯一索引
B:B树不唯一索引
C:基于函数的索引
D:位图索引
You execute the following command to enable a session in resumable mode：  SQL> ALTER SESSION ENABLE RESUMABLE TIMEOUT 60；  What is the impact of a timeout on the statements being suspended？（）
A: The statements remain suspended for at least 60 seconds.
B: The statements are suspended for 60 seconds and then they are executed.
C: The suspended statements error out if the problem is not rectified within 60 seconds.
D: The statements are automatically suspended 60 seconds after an error is received， and then attempt to execute normally again.
游标变量的类型是（）。
A:隐式游标
B:显示游标
C:REF游标
D:循环游标
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
Given： 1.package test； 2. 3.class Target { 4.public String name = "hello"；5.} What can directly access and change the value of the variable name？（）
A:any class
B:only the Target class
C:any class in the test package
D:any class that extends Target
You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns: CUST_ID NUMBER(4) NOT NULL CUST_NAME VARCHAR2(100) NOT NULL CUST_ADDRESS VARCHAR2(150) CUST_PHONE VARCHAR2(20) Which SELECT statement accomplishes this task?（）
A:SELECT* FROM customers;
B:SELECT name, address FROM customers;
C:SELECT id, name, address, phone FROM customers;
D:SELECT cust_name, cust_address FROM customers;
E:SELECT cust_id, cust_name, cust_address, cust_phone FROM customers;
You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）
A:The instance would hang.
B:The instance needs to be shut down.
C:The instance would be in the open state.
D:The instance would abort in such cases.
E:The instance would be in the open and invalid state.
F:The instance would in the open state， but all the background processes will be restarted.
Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）
A: Backup of offline tablespaces.
B: Backup of read-only tablespaces.
C: Backup of system-critical tablespaces.
D: Backup of online， locally managed tablespaces.
E: Backup of read/write dictionary-managed tablespaces.
Which three statements are true regarding persistent lightweight jobs？（）
A: Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo.
B: The user cannot set privileges on persistent lightweight jobs.
C: Persistent lightweight jobs are useful when users need to create a large number of jobs in a short time.
D: Persistent lightweight jobs are useful when users need to create a small number of jobs that run infrequently.
E: The use of a template is mandatory to create persistent lightweight jobs.
How can you change the cursor style in your form? （）
A:Open the form module property palette and set the Cursor Style property. 
B:From the Tools menu, select Preferences-->Runtime Settings. 
C:Use the GET_APPLICATION_PROPERTY and SET_APPLICATION_PROPERTY built-ins. 
D:You cannot change the cursor style.
Given： String[] elements = { "for"， "tea"， "too" }； String first = （elements.length > 0） ？ elements[0] ： null； What is the result？（）
A:Compilation fails.
B:An exception is thrown at runtime.
C:The variable first is set to null.
D:The variable first is set to elements[0].
What does the minimize load database parameter mean when backing up a database?（）
A:RMAN will attempt to make the backup run as fast as possible without any IO limitations. 
B:RMAN will automatically restrict the number of channels in use to one. 
C:RMAN will spread the backup IO over the total duration stated in the backup command.
D:RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up. 
E:Datafiles will be backed up; those having the lowest current number of IO operations will be backed up first. 
You execute the following command to audit the database activities：  SQL> AUDIT DROP ANY TABLE BY scott BY SESSION WHENEVER SUCCESSFUL;  What is the effect of this command？（）
A:One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session.
B:One audit record is created for every session when any user successfully drops a table owned by SCOTT.
C:One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT.
D:One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session.
E:One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.
首页 <上一页 98 99 100 101 102 下一页> 尾页