多项选择题Which three components does the Scheduler use for managing tasks within the Oracle environment? ()(Choose three.)

A. a job
B. a program
C. a schedule
D. a PL/SQL procedure


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题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.

2.多项选择题Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()

A. Cursor cache
B. Stored outline
C. SQL Tuning Set
D. Automatic Workload Repository (AWR) snapshots

3.单项选择题Which of the following is not a valid linguistic sort element?()

A. Accent expansion
B. Canonical equivalence
C. Reverse secondary sorting
D. Ignorable characters
E. Character rearrangement

4.单项选择题What is the name of the file that identifies the set of available locale definitions?()

A. locale.def
B. lxdef.ora
C. lx1boot.nlb
D. lx1boot.ora
E. lang.def

6.单项选择题Which NLS parameter directly governs linguistic searches?()

A. NLS_SEARCH_L
B. NLS_SORT
C. NLS_SEARCH
D. NLS_SORT_L
E. None of the above

7.单项选择题How many different calendars does Oracle 11g support?()

A. 22
B. 7
C. 6
D. 15
E. 2

8.单项选择题Which is not a valid locale definition file type?()

A. Language
B. Linguistic sort
C. Calendar
D. Territory
E. Character set

9.单项选择题Which of the following would be affected by setting NLS_LENGTH_SEMANTICS=CHAR?()

A. All objects in the database
B. Tables owned by SYS and SYSTEM
C. Data dictionary tables
D. NCHAR columns
E. CHAR columns

最新试题

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()

题型:多项选择题

Which command creates an image copy?()

题型:单项选择题

Examine the CREATE DISKGROUP command used to create a disk group:  SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2;  In which situation would you use this method of disk group creation?()

题型:单项选择题

View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM). Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()

题型:单项选择题

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?() 

题型:多项选择题

What does the DB_FLASHBACK_RETENTION_TARGET parameter configure?()  

题型:单项选择题

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()

题型:多项选择题

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()

题型:多项选择题

Tape streaming is not happening while performing RMAN tape backup. On investigation, you find that it is not because of the incremental backup or the empty file backup and that RMAN is sending data blocks to the tape drive fast enough. What could be a solution to make tape streaming happen during the backup?()  

题型:单项选择题

Which two commands never trigger an implicit rebalancing within the disk group?() 

题型:多项选择题