摘要：
NLS parameters can be set using the five methods listed. Put the methods in order from highest tolowest according to Oracles order of precedence:A. De 阅读全文
posted @ 2017-11-14 18:31
巴啦啦大魔王
阅读(105)
评论(0)
推荐(0)
摘要：
Which of the following are valid settings for the NLS_COMP parameter? (Choose all that apply.)A. ASCIIB. ANSIC. BINARYD. MONOLINGUALE. MULTILINGUAL Th 阅读全文
posted @ 2017-11-14 18:24
巴啦啦大魔王
阅读(133)
评论(0)
推荐(0)
摘要：
Which of the following datatypes store time-zone information in the database?A. TIMESTAMPB. DATEC. TIMESTAMP WITH TIME ZONED. TIMESTAMP WITH LOCAL TIM 阅读全文
posted @ 2017-11-14 18:21
巴啦啦大魔王
阅读(84)
评论(0)
推荐(0)
摘要：
Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?A. V$VALID_NLS_VALUESB. NLS_VALID_VAL 阅读全文
posted @ 2017-11-14 18:16
巴啦啦大魔王
阅读(95)
评论(0)
推荐(0)
摘要：
The NLS_SORT parameter sets the default sort method for which of the following operations?(Choose all that apply.)A. WHERE clauseB. ORDER BY clauseC. 阅读全文
posted @ 2017-11-14 17:53
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
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? (Choose all that appl 阅读全文
posted @ 2017-11-14 17:50
巴啦啦大魔王
阅读(76)
评论(0)
推荐(0)
摘要：
What elements of globalization can be explicitly defined using the NLS_LANG environment variable? (Choose all that apply.)A. NLS_LANGUAGEB. NLS_SORTC. 阅读全文
posted @ 2017-11-14 17:45
巴啦啦大魔王
阅读(105)
评论(0)
推荐(0)
摘要：
Globalization support is implemented through the text- and character-processing functions provided by which Oracle feature?A. RSTLNEB. NLSRTLC. LISTEN 阅读全文
posted @ 2017-11-14 17:41
巴啦啦大魔王
阅读(117)
评论(0)
推荐(0)
摘要：
If two windows overlap, which window attribute will determine whether one should be chosen over the other?A. WINDOW_PRIORITYB. PRIORITYC. PRIORITY_LEV 阅读全文
posted @ 2017-11-14 17:36
巴啦啦大魔王
阅读(84)
评论(0)
推荐(0)
摘要：
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. 阅读全文
posted @ 2017-11-14 17:33
巴啦啦大魔王
阅读(100)
评论(0)
推荐(0)
摘要：
When a job exceeds the date specified in its END_DATE attribute, which of the following will happen?(Choose all that apply.)A. The job will be dropped 阅读全文
posted @ 2017-11-14 17:31
巴啦啦大魔王
阅读(151)
评论(0)
推荐(0)
摘要：
If a job references a schedule that has been disabled, what will be the result?A. The job will be automatically disabled.B. The job will never execute 阅读全文
posted @ 2017-11-14 17:25
巴啦啦大魔王
阅读(123)
评论(0)
推荐(0)
摘要：
What is the danger associated with stopping a running job by using the STOP_JOB procedure?A. The job will need to be reenabled before it will execute 阅读全文
posted @ 2017-11-14 17:22
巴啦啦大魔王
阅读(144)
评论(0)
推荐(0)
摘要：
Which of the following Scheduler elements encourage object reuse? (Choose all that apply.)A. Schedule objectsB. Program argumentsC. Job classesD. Job 阅读全文
posted @ 2017-11-14 17:19
巴啦啦大魔王
阅读(100)
评论(0)
推荐(0)
摘要：
Which of the following is not a valid setting for the PROGRAM_TYPE parameter in a program object or the JOB_TYPE parameter in a job object?A. PLSQL_BL 阅读全文
posted @ 2017-11-14 17:13
巴啦啦大魔王
阅读(93)
评论(0)
推荐(0)
摘要：
Which of the following are valid program types for a lightweight job? (Choose all that apply.)A. PLSQL_BLOCKB. EXECUTABLEC. JAVA_STORED_PROCEDURED. ST 阅读全文
posted @ 2017-11-14 17:09
巴啦啦大魔王
阅读(113)
评论(0)
推荐(0)
摘要：
Which of the following objects can be directly referenced by a window object? (Choose all that apply.)A. Schedule objectB. Program objectC. Job object 阅读全文
posted @ 2017-11-14 17:07
巴啦啦大魔王
阅读(85)
评论(0)
推荐(0)
摘要：
Which of the following tasks is not performed by the job coordinator?A. Update job log when a job completesB. Spawn and remove job slavesC. Write/read 阅读全文
posted @ 2017-11-14 17:02
巴啦啦大魔王
阅读(70)
评论(0)
推荐(0)
摘要：
Which of the following calendaring syntax expressions would evaluate to the last day of every month?A. FREQ = MONTHLY; BYMONTHDAY = 31B. FREQ = MONTHL 阅读全文
posted @ 2017-11-14 16:59
巴啦啦大魔王
阅读(87)
评论(0)
推荐(0)
摘要：
Consider the following code snippet:BEGINDBMS_SCHEDULER.SET_ATTRIBUTE (name => ,,lne_job1,attribute => ,,job_priority,value => 1);END;/If this code we 阅读全文
posted @ 2017-11-14 16:54
巴啦啦大魔王
阅读(74)
评论(0)
推荐(0)
摘要：
To set the history retention period for either window logging or job logging individually, which parameters of the SET_SCHEDULER_ATTRIBUTE procedure n 阅读全文
posted @ 2017-11-14 16:51
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
What is the default value for the ENABLED attribute of a job or program when it is created? A. TRUEB. FALSEC. There is no default. It must be defined 阅读全文
posted @ 2017-11-14 16:47
巴啦啦大魔王
阅读(100)
评论(0)
推荐(0)
摘要：
Which DBMS_SCHEDULER procedure(s) can be used to alter an existing job? (Choose all that apply.)A. SET_ATTRIBUTE_NULLB. ALTER_JOBC. ALTER_JOB_PARAMETE 阅读全文
posted @ 2017-11-14 16:43
巴啦啦大魔王
阅读(88)
评论(0)
推荐(0)
摘要：
A schedule defined entirely within the confines of a Scheduler job object is known as a (n)________________.A. Fixed scheduleB. Inline scheduleC. Stor 阅读全文
posted @ 2017-11-14 16:38
巴啦啦大魔王
阅读(127)
评论(0)
推荐(0)
摘要：
Which Scheduler view(s) can be queried to see which jobs are currently executing? (Choose all that apply.)A. DBA_SCHEDULER_JOB_RUN_DETAILSB. DBA_SCHED 阅读全文
posted @ 2017-11-14 16:28
巴啦啦大魔王
阅读(97)
评论(0)
推荐(0)
摘要：
Which of the following is not a valid calendaring syntax element?A. FREQB. BYHOURC. RUNDATED. INTERVALE. BYMINUTE The calendaring syntax does not supp 阅读全文
posted @ 2017-11-14 16:25
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Which DBMS_SCHEDULER procedures can be used to enable a program? (Choose all that apply.)A. ENABLEB. ENABLE_PROGRAMC. VALIDATE_PROGRAMD. SET_ATTRIBUTE 阅读全文
posted @ 2017-11-14 16:21
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
摘要：
When setting arguments for a job, which procedure do you use for types that cannot be implicitly converted to and from a VARCHAR2 datatype?A. SET_JOB_ 阅读全文
posted @ 2017-11-14 16:18
巴啦啦大魔王
阅读(75)
评论(0)
推荐(0)
摘要：
Within a resource-plan definition, what differentiates a top-level plan from a subplan?A. A subplan has the PLAN_SUB parameter value set to SUB.B. A t 阅读全文
posted @ 2017-11-14 16:14
巴啦啦大魔王
阅读(78)
评论(0)
推荐(0)
摘要：
Which DBMS_RESOURCE_MANAGER procedure prioritizes consumer-group mappings?A. CREATE_MAPPING_PRIORITYB. SET_MAPPING_PRIORITYC. SET_MAPPING_ORDERD. PRIO 阅读全文
posted @ 2017-11-14 16:11
巴啦啦大魔王
阅读(60)
评论(0)
推荐(0)
摘要：
Every resource plan must contain an allocation to which consumer group?A. LOW_GROUPB. SYS_GROUPC. DEFAULT_GROUPD. BASE_GROUPE. OTHER_GROUPS The OTHER_ 阅读全文
posted @ 2017-11-14 16:08
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Which of these represent the main components of Database Resource Manager? (Choose all that apply.)A. Resource consumer groupsB. Resource plansC. Reso 阅读全文
posted @ 2017-11-14 16:05
巴啦啦大魔王
阅读(90)
评论(0)
推荐(0)
摘要：
When shrinking a table segment, you choose to shrink all the indexes for that table using the SHRINK SPACE command. Which clause should you use?A. INC 阅读全文
posted @ 2017-11-14 16:01
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
摘要：
For which of the following can you use Segment Shrink? (Choose all that apply.)A. Heap tablesB. Tables with function-based indexesC. IndexesD. Partiti 阅读全文
posted @ 2017-11-14 15:45
巴啦啦大魔王
阅读(67)
评论(0)
推荐(0)
摘要：
Which of the following options describes Segment Shrink?A. Reclaims space above and below the high-water mark without using additional spaceB. Moves r 阅读全文
posted @ 2017-11-14 15:42
巴啦啦大魔王
阅读(77)
评论(0)
推荐(0)
摘要：
Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?A. The database must be in read-write mode.B. The da 阅读全文
posted @ 2017-11-14 15:32
巴啦啦大魔王
阅读(77)
评论(0)
推荐(0)
摘要：
Which of the following supplied functions is used to identify external tables, directories, and BFILES?A. DBMS_TDB.CHECK_DIRECTORIESB. DBMS_TDB.CHECK_ 阅读全文
posted @ 2017-11-14 15:29
巴啦啦大魔王
阅读(101)
评论(0)
推荐(0)
摘要：
Which of the following are prerequisite steps to transport a database? (Choose all that apply.)A. Query the V$TRANSPORTABLE_PLATFORMS view in the sour 阅读全文
posted @ 2017-11-14 15:25
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?A. Export the tablespaces usin 阅读全文
posted @ 2017-11-14 15:19
巴啦啦大魔王
阅读(83)
评论(0)
推荐(0)
摘要：
The following query will provide what information about transportable tablespaces for the currentdatabase? (Choose all that apply.)select d.platform_n 阅读全文
posted @ 2017-11-14 15:09
巴啦啦大魔王
阅读(91)
评论(0)
推荐(0)
摘要：
Which of the following are included in a transportable tablespace set? (Choose all that apply.)A. The datafiles that make up a self-contained group of 阅读全文
posted @ 2017-11-14 15:07
巴啦啦大魔王
阅读(99)
评论(0)
推荐(0)
摘要：
Which of these components correctly identify the unique value of the NAME column in the DBA_RESUMABLE view?A. Username, instance number, session IDB. 阅读全文
posted @ 2017-11-14 15:03
巴啦啦大魔王
阅读(85)
评论(0)
推荐(0)
摘要：
Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the res 阅读全文
posted @ 2017-11-14 15:00
巴啦啦大魔王
阅读(87)
评论(0)
推荐(0)
摘要：
To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?A. RESUMABLE 阅读全文
posted @ 2017-11-14 14:55
巴啦啦大魔王
阅读(69)
评论(0)
推荐(0)
摘要：
When tuning Automatic PGA Memory Management, which of the following views will provide the information specified?A. The V$PGA_TARGET_ADVICE view shows 阅读全文
posted @ 2017-11-14 14:50
巴啦啦大魔王
阅读(122)
评论(0)
推荐(0)
摘要：
Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters? (Choose all that apply.)A. 阅读全文
posted @ 2017-11-14 14:42
巴啦啦大魔王
阅读(89)
评论(0)
推荐(0)
摘要：
In Oracle 11g, by default which one of the following conditions implicitly enables Automatic PGA Memory Management?A. Setting a nonzero value for SGA_ 阅读全文
posted @ 2017-11-14 14:38
巴啦啦大魔王
阅读(140)
评论(0)
推荐(0)
摘要：
Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following pools does Oracle EM offer advice to set the value appropr 阅读全文
posted @ 2017-11-14 14:17
巴啦啦大魔王
阅读(100)
评论(0)
推荐(0)
摘要：
When manually configuring the SGA, which of the following parameter changes requires an instance restart to take effect?A. DB_CACHE_SIZEB. SHARED_POOL 阅读全文
posted @ 2017-11-14 14:12
巴啦啦大魔王
阅读(147)
评论(0)
推荐(0)
摘要：
To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, you can set values for which of the following initialization 阅读全文
posted @ 2017-11-14 14:05
巴啦啦大魔王
阅读(146)
评论(0)
推荐(0)
摘要：
For Oracle 11g, Oracle strongly recommends that you configure your database to use which of thefollowing memory-management features?A. Automatic PGA M 阅读全文
posted @ 2017-11-14 14:00
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
By setting the value of MEMORY_TARGET to zero and setting the value of SGA_TARGET to anonzero value, you will enable which of the following memory-man 阅读全文
posted @ 2017-11-14 13:58
巴啦啦大魔王
阅读(120)
评论(0)
推荐(0)
摘要：
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter?A. Automatic PGA Memory Ma 阅读全文
posted @ 2017-11-14 13:47
巴啦啦大魔王
阅读(104)
评论(0)
推荐(0)
摘要：
Performance divergence indicated in the Workload Replay report is most likely due to what?A. DML and SQL statement results that do not match between t 阅读全文
posted @ 2017-11-14 11:38
巴啦啦大魔王
阅读(153)
评论(0)
推荐(0)
摘要：
Which is true concerning Database Replay in an Oracle Real Application Cluster (RAC) database?A. Workload capture is per instance.B. You only need to 阅读全文
posted @ 2017-11-14 11:26
巴啦啦大魔王
阅读(184)
评论(0)
推荐(0)
摘要：
Which of these recommendations should be followed before capturing a workload? (Choose all that apply.)A. Make sure your replay database has the same 阅读全文
posted @ 2017-11-14 11:17
巴啦啦大魔王
阅读(180)
评论(0)
推荐(0)
摘要：
Which of the following represents the correct sequence of events for Database Replay?A. Capture, analyze, preprocess, replayB. Capture, preprocess, an 阅读全文
posted @ 2017-11-14 11:11
巴啦啦大魔王
阅读(97)
评论(0)
推荐(0)
摘要：
Which statement most accurately describes the implementation of a SQL Access Advisor recommendation?A. SQL Access Advisor recommendations are automati 阅读全文
posted @ 2017-11-14 11:08
巴啦啦大魔王
阅读(151)
评论(0)
推荐(0)
摘要：
Which of the following is a potential performance tuning recommendation from the SQL Access Advisor?A. Create new indexes.B. Modify existing indexes.C 阅读全文
posted @ 2017-11-14 10:59
巴啦啦大魔王
阅读(116)
评论(0)
推荐(0)
摘要：
Which of these appropriately describes the results of a manual SQL Tuning Advisor task?A. A list of SQL statements and recommendations for tuningB. A 阅读全文
posted @ 2017-11-14 10:55
巴啦啦大魔王
阅读(94)
评论(0)
推荐(0)
摘要：
To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take?A. From the Advisor Central home page, select the tuning task 阅读全文
posted @ 2017-11-14 10:51
巴啦啦大魔王
阅读(107)
评论(0)
推荐(0)
摘要：
When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and valu 阅读全文
posted @ 2017-11-14 10:47
巴啦啦大魔王
阅读(88)
评论(0)
推荐(0)
摘要：
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 Supp 阅读全文
posted @ 2017-11-14 10:19
巴啦啦大魔王
阅读(74)
评论(0)
推荐(0)
摘要：
While querying the EMPLOYEES table, you receive an ORA-01578 message indicating blockcorruption in File# 1201 and Block# 1968. You analyze the table a 阅读全文
posted @ 2017-11-14 10:11
巴啦啦大魔王
阅读(132)
评论(0)
推荐(0)
浙公网安备 33010602011771号