Oracle认证 - 自考题库

出自:Oracle认证

Which statement is true about a whole consistent database backup on a database running in ARCHIVELOG mode（）
A:The backup will consist of used data blocks only.
B:The database must be shut down to accomplish the backup.
C:The backup can be accomplished without shutting down the database.
D:The backup will contain all database files that have never been backed up.

Which three statements about performance analysis by SQL Performance Analyzer are true? （）(Choose three.)
A:It detects changes in SQL execution plans.
B:It produces results that can be used to create the SQL plan baseline.
C:The importance of SQL statements is based on the size of the objects accessed.
D:It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
E:It shows only the overall impact on workload and not the net SQL impact on workload.

You have two database servers SEMP and SACCT. The database in the SEMP server maintains theemployee information and the database in the SACCT server maintains the accounts payable information.The employees submit the expense reports to the accounts payable department. A user of the accountspayable database wants to extract the employee information from the database in the SEMP server for cross-verification. Which schema object enables the user to access the information from the remote database（）
A:Cluster
B:Database link
C:Mapping table
D:Materialized view

Evaluate the following function code:

Which statement is true regarding the above function? （）
A:The cached result becomes invalid when any structural change is done to the EMPLOYEES table.
B:If the function execution results in an unhandled exception, the exception result is also stored in the cache.
C:Each time the function is invoked in a different session, the current result in the result cache gets overwritten.
D:If the function is invoked with a different parameter value, the existing result in the result cache gets overwritten by the latest value.

What recommendations does the SQL Access Advisor provide for optimizing SQL queries？（）
A: selection of SQL plan baselines
B: partitioning of tables and indexes
C: creation of index-organized tables
D: creation of bitmap， function-based，and B-tree indexes
E: optimization of materialized views for maximum query usage and fast refresh

What is the result？（）
A:An Exception is thrown with no other output
B:followed by an Exception
C:Compilation fails due to an error on line 9
D:Compilation fails due to an error on line 14

Oracle JRockit JVM uses -Xns option to set nursery size when the generational garbage collection mode is used. Which two JVM properties are affected by changing its size ？（）
A: compaction ratio limit
B: garbage collection frequency
C: garbage collection times
D: fragmentation heap size

Which of the following commands cannot be executed when the database open？（）
A:RECOVER DATABASE
B:RECOVER TABLESPACE
C:RECOVER DATAFILE
D:ALTER DATABASE RECOVER DATAFILE

Which two statements are true with respect to the maintenance window? （）
A:A DBA can enable or disable an individual task in all maintenance windows.
B:A DBA cannot change the duration of the maintenance window after it is created.
C:In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
D:A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

Which code， inserted at line 16， correctly retrieves a local instance of a Point object？（）
A:Point p = Line.getPoint（）；
B:Line.Point p = Line.getPoint（）；
C:Point p = （new Line（））.getPoint（）；
D:Line.Point p = （new Line（））.getPoint（）；

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);

Which statements are correct regarding indexes？（）
A: When a table is dropped， the corresponding indexes are automatically dropped.
B: For each DML operation performed， the corresponding indexes are automatically updated.
C: Indexes should be created on columns that are frequently referenced as part of an expression.
D: A non-deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a uniqueindex.

Which two statements about workload capture and replay operations are true?（）
A:The clients must be created manually on the test machines to perform more realistic testing.
B:Restart the database in RESTRICTED mode before beginning workload replay to enable a clean state for workload replay.
C:Restart the database in RESTRICTED mode before beginning workload capture to enable a clean state for capturing the workload.
D:The application state of the capture system must be identical to the application state of the replay system when the workload replay begins.

PL/SQL很容易检测和处理预定义和用户定义的错误条件，称为（）。
A:消息
B:错误
C:异常
D:溢出

登录isql*PLUS页面时使用的默认端口号为（）。
A:1433
B:5560
C:1158
D:3938

You executed the following commands in an RMAN session for your database instance that has failures： RMAN> LIST FAILURE； After some time， you executed the following command in the same session： RMAN> ADVISE FAILURE； But there are new failures recorded in the Automatic Diagnostic Repository （ADR） after the execution ofthe last LIST FAILURE command. Which statement is true for the above ADVISE FAILURE command in this scenario（）
A:It produces a warning for new failures before advising for CRITICAL and HIGH failures.
B:It ignores new failures and considers the failures listed in the last LIST FAILURE command only.
C:It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored
D:It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

You need to create a trigger to locate the Product report in the Rpt_Server, run the report, and test the status of the report. Which three built-ins would you use to accomplish this task?（）
A:RUN_PRODUCT
B:SET_REPORT_OBJECT_PROPERTY
C:RUN_REPORT_OBJECT
D:FIND_REPORT_OBJECT
E:REPORT_OBJECT_STATUS
F:COPY_REPORT_OBJECT_OUTPUT

What is the result？（）
A:Canada
B:null Canada
C:Canada null
D:Canada Canada
E:Compilation fails due to an error on line 26.

Mary has a view called EMP_DEPT_LOC_VU that was created based on the EMPLOYEES, DEPARTMENTS, and LOCATIONS tables. She granted SELECT privilege to Scott on this view. Which option enables Scott to eliminate the need to qualify the view with the name MARY .EMP_DEP_LOC_VU each time the view is referenced?（）
A:Scott can create a synonym for the EMP_DEPT_LOC_VU bus using the command: CREATE PRIVATE SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonymn.
B:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU FOR mary.EMP_DEPT_LOC_VU; then he can prefix the columns with this synonym.
C:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE LOCAL SYNONYM EDL_VU FOR mary.EMP DEPT_LOC_VU; then he can prefix the columns with this synonym.
D:Scott can create a synonym for the EMP_DEPT_LOC_VU by using the command: CREATE SYNONYM EDL_VU ON mary(EMP_DEPT_LOC_VU); then he can prefix the columns with this synonym.
E:Scott cannot create a synonym because synonyms can be created only for tables.
F:Scott cannot create any synonym for Mary's view. Mary should create a private synonym for the view and grant SELECT privilege on that synonym to Scott.

Your database contains two temporary tablespaces named TEMP and TEMP1. The TEMP tablespace is the default temporary tablespace for the database， and the TEMP1 tablespace was created at database creation. You want to increase the size of the tempfile for the TEMP tablespace and drop the TEMP1 tablespace from the database. The database is not using Oracle-Managed Files （OMF）. Which statement must you use to ensure that when you drop the TEMP1 tablespace from the database， its corresponding operating system file is also deleted？（）
A: DROP TABLESPACE temp1；
B: DROP TABLESPACE temp1 INCLUDING CONTENTS；
C: DROP TABLESPACE temp1 INCLUDING CONTENTS AND DATAFILES；
D: DROP TABLESPACE temp1 INCLUDING CONTENTS CASCADE CONSTRAINTS；

在下列各选项中，关于同义词的描述哪一项是不正确的？（）
A:同义词是数据库对象的一个替代名，在使用同义词时，Oracle会将其翻译为对应的对象名称
B:在创建同义词时，所替代的模式对象必须存在
C:Oracle中的同义词分为公有同义词和私有同义词
D:公有同义词在数据库中所有的用户都可以使用；私有同义词由创建它的用户所拥有

对于oracle数据库，设计用户表时，家庭住址字段最好采用下面的哪个数据类型进行存储（）
A:CHAR
B:CHAR2
C:VARCHAR
D:VARCHAR2
E:LONG

Which four are types of functions available in SQL? （）
A:string
B:character
C:integer
D:calendar
E:numeric
F:translation
G:date
H:conversion

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）
A:You should perform a log switch
B:You should make a backup of the database
C:You should switch the database to the NONARCHIVELOG mode
D:You should shut down the database instance and perform a complete database recovery

Given： 11.String test = "Test A. Test B. Test C."； 12.// insert code here 13.String[] result = test.split（regex）； Which regular expression， inserted at line 12，correctly splits test into "Test A"，"Test B"，and "Test C"？（）
A:String regex = ""；
B:String regex = " "；
C:String regex = ".*"；
D:String regex = "//s"；
E:String regex = "//.//s*"；

Which is the memory area that is created when a dedicated server process is started， and contains data and control information for that server process？（）
A:SGA
B:PGA
C:Shared Pool
D:Streams Pool

You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage，which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables. Which action would you take to delay the referential integrity checking until the end of thetransaction（）

A:Set the constraint to deferred before starting the transaction.
B:Alter the constraint to NOVALIDATE state before starting the transaction.
C:Enable the resumable mode for the session before starting the transaction.
D:Set the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transaction

What is the result？（）

A:A
B:B
C:C
D:D
E:E

Given two different character sets (A and B), which of the following must be true for A to be considered a strict superset of B?（）
A:A must contain all of the characters defined in B
B:A must be Unicode
C:The encoded values in A must match the encoded values in B for all characters defined in B
D:A must be a multibyte character set
E:The encoded values in A must match the encoded values in B for all numeric and alphabetic characters in B

Which of the following is true about job chains?（）
A:They consist of one or more Scheduler programs.
B:They are used to implement dependency scheduling.
C:They are used to implement time-based scheduling.
D:They are used to implement event-based scheduling.
E:None of the above.

首页 <上一页 91 92 93 94 95 下一页> 尾页