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
A. You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
B. You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
C. You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
D. You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
最新试题
You executed the following query in your database: FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
You lost the PRODSTD tablespace, which was read/write. The tablespace was readonly when the last backup was performed. How would you recover the tablespace?()
You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
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?()
The loss of the control file forced you to recreate the control file. After recreating it and opening the database, you find that some of the data files are named as MISSINGnnnnn, where nnnnn is a fivedigit number starting with 0. What could be the possible reason?()
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario?()
You performed a backup of the flash recovery area by using the following command for the first time:RMAN> BACKUP RECOVERY AREA; Which files in the flash recovery area are backed up?()
Consider the recovery steps in each of the cases given below: Case 1: Shut down the database and perform a backup. Restore all the data files. Mount the database. Recover the database. Without applying all the redo log files, open the database using the RESETLOGS option. Back up the database. Case 2: Shut down the database and perform a backup. Restore only the data files of the tablespace where user error damaged the data. Mount the database. Recover the database. Open the database with the RESETLOGS option. Back up the database. Case 3:Shut down the database Restore the data files Open the database Perform recovery to the current point in time. Which case has the correct steps for an incomplete recovery?()