单项选择题In a database with the database character set of US7ASCII and a national character set of UTF-8, which datatypes would be capable of storing Unicode data by default?()

A. VARCHAR2
B. CHAR
C. NVARCHAR2
D. CLOB
E. LONG


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题

What can you determine about the following linguistic sorts based only on their names?()  
1. GERMAN 
2. FRENCH_M  

A. 1 is a monolingual sort.
B. 2 is a monolingual sort.
C. 1 is case insensitive.
D. Both 1 and 2 are case insensitive.
E. Case sensitivity is unknown.

2.多项选择题Which of the following are valid settings for the NLS_COMP parameter?()

A. ASCII
B. ANSI
C. BINARY
D. MONOLINGUAL
E. MULTILINGUAL

3.单项选择题Which of the following datatypes store time-zone information in the database?()

A. TIMESTAMP
B. DATE
C. TIMESTAMP WITH TIME ZONE
D. TIMESTAMP WITH LOCAL TIME ZONE
E. DATETIME

4.单项选择题Which view shows all valid values for the NLS_LANGUAGE, NLS_SORT, NLS_TERRITORY, and NLS_CHARACTERSET parameters?()

A. V$VALID_NLS_VALUES
B. NLS_VALID_VALUES
C. NLS_VALUE_OPTIONS
D. V$NLS_VALUE_OPTIONS
E. V$NLS_VALID_VALUES

5.多项选择题The NLS_SORT parameter sets the default sort method for which of the following operations?()

A. WHERE clause
B. ORDER BY clause
C. BETWEEN clause
D. NLSSORT function
E. NLS_SORT function

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

7.多项选择题What elements of globalization can be explicitly defined using the NLS_LANG environment variable?()

A. NLS_LANGUAGE
B. NLS_SORT
C. NLS_CALENDAR
D. NLS_CHARACTERSET
E. NLS_TERRITORY

9.单项选择题If two windows overlap, which window attribute will determine whether one should be chosen over the other?()  

A. WINDOW_PRIORITY
B. PRIORITY
C. PRIORITY_LEVEL
D. WINDOW_PRIORITY_LEVEL
E. OVERLAP_RULE

10.单项选择题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.

最新试题

Identify the persistent configuration setting for the target database that can be set for the backup by using RMAN.()

题型:多项选择题

After you have restored and recovered a database to a new host by using a previously performed Recovery Manager (RMAN) backup, which is the best option you would consider for the new database?()  

题型:单项选择题

Examine the following ALTER command:  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;  What is the purpose of the command?()  

题型:单项选择题

Examine the following RMAN command:  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;  Which prerequisite must be met before accomplishing the backup?()

题型:单项选择题

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

题型:多项选择题

View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation:  RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8; BACKUP DATABASE FILESPERSET 4; }  What is the multiplexing level in the preceding backup process?()

题型:单项选择题

Which three tasks can be performed using a duplicate database?()

题型:多项选择题

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?()  

题型:单项选择题

In Recovery Manager (RMAN), you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task, you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this:  1) Mount the database 2) Take the data file offline 3) Bring the data file online 4) Use the RMAN SWITCH TO command to switch the image copy 5) Apply the archived redo logs 6) Open the database 7) Use the RMAN RESTORE TO command to switch to the image copy  Which two options illustrate the correct sequence of steps that you could follow?()

题型:多项选择题

Which two client requests are captured during database replay Capture?()

题型:多项选择题