You issued the following statement:
SQL> ALTER SESSION SET NLS_LANG=FRENCH_CANADA.WE8ISO8859P1;
Which parameter is NOT overridden by using the above statement?()
A. the value of the NLS_LANGUAGE variable
B. the value of the NLS_TERRITORY variable
C. the value of the NLS_CURRENCY variable
D.the character encoding scheme used by the client application
您可能感兴趣的试卷
你可能感兴趣的试题
Your Oracle10g database contains a table with a TIMESTAMP TO LOCAL TIME ZONE column. There are about two hundred column values for the column. You issued the following statement:
SQL> ALTER DATABASE SET TIME_ZONE =’Europe/London’;
What will be the result of issuing the above statement?()
A. The statement will be executed successfully, and a new time zone will be set for the database.
B. The statement will be executed successfully, but a new time zone will not be set for the database.
C. The statement will not be executed successfully because the SET TIME_ZONE clause can be used only with the ALTER SESSION statement.
D. The statement will not be executed successfully because the ALTER DATABASE SET TIME_ZONE statement is used only when the database contains no table with the TIMESTAMP TO LOCAL TIME ZONE column.
You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.
How will you migrate your database from UTF8 to AL16UTF16?()
A. by using the RMAN utility
B. by using the export/import utility
C. by using the ALTER DATABASE command
D. by enabling the change tracking feature
Click the Exhibit(s) button to view the EMPLOYEES table.
The EMPLOYEE table contains thousands of rows. The EMP_CODE column is the primary key column. At the end of every month, you are required to perform search queries based on the BASIC_SAL+COMM column values. Which type of index will you create?()
A. B-tree Index
B. Bitmap Index
C. Function-based Index
D. Partitioned Index
You issued the following command at the UNIX environment:
% setenv ORA_SDTZ ’OZ_TZ’
What will be the impact of issuing the above command?()
A. The operating system local time zone will be set for a user session using the operating system environment variable.
B. The database local time zone will be set for a user session using the operating system environment variable.
C. The operating system local time zone will be set for the database using the operating system environment
D. The database local time zone will be set for the database using the operating system environment variable.
A. setenv ORA_SDTZ ’DB_TZ’
B. setenv ORA_SDTZ ’+10:00’
C. setenv ORA_SDTZ ’OS-TZ’
D. setenv ORA_SDTZ ’Europe/London’
A. FRENCH_AI
B. FRENCH_CI
C. AI_FRENCH
D. CI_FRENCH
You created the ORDERS table in your database by using the following code:
SQL> CREATE TABLE ORDERS (ORDER_DATE TIMESTAMP(0) WITH TIME ZONE);
Then, you inserted data in the ORDERS table and saved it by issuing the following statements:SQL> INSERT INTO ORDERS VALUES(’18-AUG-00 10:26:44 PM America/New_York’);
SQL> INSERT INTO ORDERS VALUES(’23-AUG-02 12:46:34 PM America/New_York’);
SQL> COMMIT;
Next, you issued the following statement to change the time zone for the database:
SQL> ALTER DATABASE SET TIME_ZONE=’Europe/London’;
What will be the result of executing the above statement?()
A. The statement will fail.
B. The statement will be executed successfully, and the new time zone will be set for the database.
C. The statement will be executed successfully, but the new time zone will be set for the current session.
D.The statement will be executed successfully, but the new time zone will neither be set for the database nor for a specific session.
A. ALTER SYSTEM KILL SESSION
B. ALTER SYSTEM DISCONNECT SESSION
C. ALTER SYSTEM QUIESCE RESTRICTED
D. ALTER SYSTEM ENABLE RESTRICTED SESSION
A. If the SHUTDOWN IMMEDIATE command is issued to the ASM instance, the ASM instance immediately shuts down.
B. If the SHUTDOWN ABORT command is issued to the ASM instance, the ASM instance will shut down all the database instances and then shut down immediately.
C. If the SHUTDOWN NORMAL command is issued to the ASM instance, before shutting down, the ASM instance waits for the dependent database instances to shut down.
D. If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance, the ASM instance passes the same SHUTDOWN command to the dependent database instances, but does not wait for any active transactions to complete before it shuts down.
A. INSTANCE_TYPE
B. DB_UNIQUE_NAME
C. ASM_DISKSTRING
D. ASM_POWER_LIMIT
最新试题
You are working on an Oracle Database 10g database. Because of data loss, you decided to perform a Flashback Database operation using the following command: SQL> FLASHBACK DATABASE TO TIMESTAMP(SYSDATE 5/24); Which two statements are true? ()
View the Exhibit and examine the Flashback Database architecture. Identify the missing component (shown with a "?") in the Flashback Database architecture.()
Your database operates in ARCHIVELOG mode. The redo log files are not multiplexed and one of the online redo logs is missing. The missing redo log sequence, 230, is not archived, and it contained information from 10:35 a.m. onwards. The current time is 11:00 a.m. Because of a disk crash, you executed the following command to perform an incomplete recovery: RMAN> RUN { 2> SET UNTIL SEQUENCE 230 THREAD 1; 3> ALTER DATABASE MOUNT; 4> RESTORE DATABASE; 5> RECOVER DATABASE; 6> ALTER DATABASE OPEN RESETLOGS;7> }; With reference to this scenario, which statement is true?()
Your database operates in ARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Tuesday, at 9:00 a.m. the current log sequence number was 369. Also, on Tuesday you lost the data file belonging to the SYSTEM tablespace and an archivelog file (sequence number 356) that contained redo entries between 8:00 a.m. and 8:30 a.m. With reference to this scenario, what would you do to recover the database?()
You decided to change the location of the flash recovery area. You executed the following command: Which statement is true?()
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancelbased recovery?()
You are connected to Recovery Manager (RMAN) without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup,you need the database ID (DBID). In which two sources would you find the DBID? ()
You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to recreate the indexes in a new tablespace. Which two options would you use to reduce the time it takes to recreate the indexes?()
You are using Oracle Database 10g. The LOG_ARCHIVE_FORMAT parameter is set to ’LOG%t_%s_%r.dbf’. Why is %r used in the file name format?()
You used the following command in Recovery Manager (RMAN) as part of the recovery process: RESTORE CONTROLFILE FROM AUTOBACKUP; How does RMAN find the control file autobackup?()