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 execute the following command to start an Automatic Storage Management (ASM) instance: SQL>STARTUP;
In which of the following modes will the ASM instance start?()
A. OPEN
B. MOUNT
C. NORMAL
D. NOMOUNT
A. BACKUP AS BACKUPSET
B. BACKUP AS COPY
C. BACKUP AS COMPRESSED BACKUPSET
D. BACKUP INCREMENTAL LEVEL n CUMULATIVE
You have configured the ASM instance for the PROD database of iPod Corporation. You have specified the following parameter values in the initialization parameter file:
DB_CREATE_FILE_DEST=’devices/grp1/P’
DB_CREATE_ONLINE_LOG_DEST_1=’devices/d_grp2/Q’
DB_CREATE_ONLINE_LOG_DEST_2=’devices/d_grp3/R’
BACKGROUND_DUMP_DEST=’devices/d_grp1/S’
You have added a new redo log group that contains two redo log members. Where are the redo log members stored?()
A. Both the members will be stored in the ’devices/grp1/P’ directory.
B. Both the members will be stored in the ’devices/d_grp2/Q’ directory.
C. Both the members will be stored in the ’devices/d_grp3/R’ directory.
D. One member will be stored in the ’devices/d_grp2/Q’ directory and the other in the ’devices/d_grp3/R’ directory.
最新试题
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? ()
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 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?()
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?()
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?()
For an incomplete recovery, which four backup types can be used by Recovery Manager (RMAN) to restore data files? ()
You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?()
In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog. The following commands are used in the process of recovering the database by using the backup control file: In what sequence would you use this process to perform the recovery?()
You have a readonly tablespace on readonly media. You want to perform a media recovery on the existing data files, but using a backup control file. The backup control file indicates that the status of the readonly tablespace was read/write when the control file was backed up. What should you consider?()
A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file.Which method would you use for recovery?()