Oracle认证 - 自考题库

出自:Oracle认证

Which exception or error will be thrown when a programmer attempts to run this code?（）
A:java.lang.StackOverflowError
B:java.lang.IllegalStateException
C:java.lang.ExceptionInInitializerError
D:java.lang.ArrayIndexOutOfBoundsException

当需要删除某个序列seq_customer_id，可以使用如下（）方式。
A:DROP SEQ_CUSTOMER_ID
B:DELETE SEQUENCE SEQ_CUSTOMER_ID
C:DROP SEQUENCE SEQ_CUSTOMER_ID
D:DELETE SEQ_CUSTOMER_ID

Given：

Which code， inserted at line 15， creates an instance of the Point class defined in Line？（）
A: Line l = new Line（）； l.Point p = new l.Point（）；
B: Line.Point p = new Line.Point（）；
C: The Point class cannot be instatiated at line 15.
D: Point p = new Point（）；

Given：

What is the result？（）
A:null
B:zero
C:some
D:Compilation fails.
E:An exception is thrown at runtime.

View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?（）

A:Accept the recommended SQL profile.
B:Collect statistics for the related objects.
C:Run the Access Advisor for the SQL statement.
D:Run the Segment Advisor for recommendations.

The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile，and statistics to diagnose the possible causes of the performance degradation？（）
A:by using the SQL access advisor
B:by using the Automatic Workload Repository report
C:by running the Automatic Database Diagnostic Monitor （ADDM）
D:by using the Automatic Workload Repository Compare Period report
E:by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

You work as a database administrator for Certkiller .com. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）
A:3 hours
B:6 months
C:until last year
D:until last commit
E:until the point when the undotablespacewas refreshed
F:until the database is shut down and the memory erased

An existing master-slave setup is currently using a delayed replication of one hour. The master has crashed and the slave must be "rolled forward" to provide all the latest data. The SHOW SLAVE STATUS indicates the following values: RELAY_LOG_FILE =hostname-relay-bin.00004 RELAY_LOG_POS = 1383 Which command set would make the slave current?（）
A:STOP SLAVE; CHANGE MASTER TO MASTER_DELAY =0, RELAY_LOG_FILE = 'hostnamerelay- bin.00004' , RELAY_LOG_POS= 1383
B:STOP SLAVE; CHANGE MASTER TO RELAY_LOG_FILE = 'hostname-relay-bin.00004', RELAY_LOG_POS = 1383
C:STOP SLAVE; CHANGE MASTER TO MASTER_DELAY=0; START SLAVE
D:STOP SLAVE; SET GLOBAL master_delay =0; START SLAVE

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN. You want to issue the following RMAN command: RMAN > BACKUP TABLESPACE hr_pdb:userdata; Which task should you perform before issuing the command?（）
A:Place the root container in ARHCHIVELOG mode.
B:Take the user data tablespace offline.
C:Place the root container in the nomount stage.
D:Ensure that HR_PDB is open.

Which commands are used for RMAN database recovery？（）
A: restore
B: repair
C: copy
D: recover
E: replace

Which statements are true regarding the Oracle Data Pump export and import operations（）
A:You cannot export data from a remote database.
B:You can rename tables during an import operation.
C:You can overwrite existing dump files during an export operation.
D:You can compress the data during export but not the metadata because it is not supported

The ORDERS table belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR.Which statement would create a synonym ORD so that HR can execute the following query successfully?（）
A:CREATE SYNONYM ord FOR orders; This command is issued by OE
B:CREATE PUBLIC SYNONYM ord FOR orders; This command is issued by OE
C:CREATE SYNONYM ord FOR oe.orders; This command is issued by the database administrator
D:CREATE PUBLIC SYNONYM ord FOR oe.orders; This command is issued by the database administrator

SGA是一块巨大的共享内存区域，被看成是Oracle数据库的一个大缓冲池，如果需要查看SGA的大小信息，可以使用如下（）语句。
A:SELECT SGA FROM V$DBA
B:SELECT * FROM V$DBA
C:SELECT * FROM V$SGA
D:SELECT size FROM V%DBA

You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）
A:Increasing the priority of the job class to which the job belongs
B:Increasing the job's relative priority within the Job class to which it belongs
C:Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
D:Moving the job to an existing higher priority scheduler window with the same schedule and duration
E:Increasing the value of the JOB_QUEUE_PROCESSES parameter
F:Increasing the priority of the scheduler window to which the job belongs

Which four occur during the processing of a request using Oracle Shared Server？（）
A:The dispatcher returns the response to the user.
B:The dispatcher places the request into the request queue.
C:The shared server places the response in the response queue.
D:The response is handed off to the next available dispatcher.
E:A shared server picks up the request from the request queue and processes the request.

Identify three key features of ASM.（）
A: file striping
B: allocation unit mirroring
C: automatic disk rebalancing
D: automatic file size increment
E: automatic undo management

Which of the following statements is true regarding the VERSIONS BETWEEN clause？（）
A: The VERSIONS BETWEEN clause may be used in DML statements.
B: The VERSIONS BETWEEN clause may be used in DDL statements.
C: The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
D: The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.

Examine the description of the EMPLOYEES table: EMP_ID NUMBER(4) NOT NULL LAST_NAME VARCHAR2(30) NOT NULL FIRST_NAME VARCHAR2(30) DEPT_ID NUMBER(2) Which statement produces the number of different departments that have employees with last name Smith?（）
A:SELECT COUNT(*) FROM employees WHERE last_name='Smith';
B:SELECT COUNT(dept_id) FROM employees WHERE last_name='Smith';
C:SELECT DISTINCT(COUNT(dept_id)) FROM employees WHERE last_name='Smith';
D:SELECT COUNT(DISTINCT dept_id) FROM employees WHERE last_name='Smith';
E:SELECT UNIQUE(dept_id) FROM employees WHERE last_name='Smith';

Which data dictionary views displays the error information related to a data file， when an internal read fails on that file？（）
A:V$DATAFILE
B:V$DATAFILE_HEADER
C:DBA_DATA_FILES
D:V$DBFILE
E:V$DATAFILE_ERRORS

In which situations does the Oracle Data Pump use external tables and not the direct path load whileexporting a table（）
A:if a table is not in a cluster
B:if a table has an active trigger
C:if a table has an encrypted
D:if a table has a column of data type LONG defined on it
E:if a table has a referential integrity constraint defined on it

Given：

Which statement is true？（）
A:This code can throw an InterruptedException.
B:This code can throw an IllegalMonitorStateException.
C:This code can throw a TimeoutException after ten minutes.
D:Reversing the order of obj.wait（） and obj.notify（） might cause this method to complete normally.
E:A call to notify（） or notifyAll（） from another thread might cause this method to complete normally.

You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（）
A: The audit trail is stored in an operating system file.
B: Auditing is disabled for all privileges.
C: The audit trail is stored in the database.
D: Auditing is enabled for all privileges.
E: Auditing is enabled for certain privileges related to database security.

为了监视索引的空间使用效率，可以首先分析该索引的结构，使用（）语句，然后查询INDEX_STATE视图。
A:SELECT INDEX … VALIDATE STRUCTURE
B:ANALYZE INDEX … VALIDATE STRUCTURE
C:UPDATE INDEX … VALIDATE STRUCTURE
D:REBUILD INDEX … VALIDATE STRUCTURE

Using the LIST command in Recovery Manager （RMAN），which two pieces of information in the RMAN repository can be listed？（）
A: stored scripts in the recovery catalog
B: backups that can be deleted from disk
C: backup sets and image copies are obsolete
D: backups that do not have the AVAILABLE status in the RMAN repository

Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）
A:ROWS
B:SKIP
C:LOAD
D:BINDSIZE

In which scenario will you use the Flashback Version Query feature？（）
A: when you want to restore a table that has been dropped from the Recycle Bin
B: when you want to identify the transaction ID of the transaction that deleted some important records from a table
C: when you want to recover the schema of a dropped user
D:when you want to restore a dropped tablespace

You have 100 segments in the USERS tablespace. You realize that the USERS tablespace is running low on space. You can use Segment Advisor to （）
A: identify the segments that you should shrink
B: modify the storage parameters for the tablespace
C: automatically shrink the segments with unused space
D: check the alerts generated for the tablespace that is running low on space

You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:

What is the outcome of the above commands?（）
A:They execute and create a virtual catalog for pre-Oracle 11g clients.
B:They produce an error because PROD1 and PROD2 databases belong to the older version.
C:They produce an error because you need to connect as CATOWNER to execute this packaged procedure.
D:They produce an error because you need to connect to the target database to execute this packaged procedure.

ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）
A:parallel image copy backup
B:backup with MAXPIECESIZE configured for the channel
C:parallel backup with MAXPIECESIZE configured for the channel
D:intrafile parallel backup

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:

What is the multiplexing level in the preceding backup process（）
A:4
B:8
C:7
D:0

首页 <上一页 140 141 142 143 144 下一页> 尾页