单项选择题During the installation of Oracle Database 11g, you do not set ORACLE_BASE explicitly. You selected the option to create a database as part of the installation. How would this environment variable setting affect the installation?()

A. The installation terminates with an error.
B. The installation proceeds with the default value without warnings and errors.
C. The installation proceeds with the default value but it would not be an OFA-compliant database.
D. The installation proceeds with the default value but a message would be generated in the alert log file.


您可能感兴趣的试卷

你可能感兴趣的试题

1.多项选择题Which two statements are true regarding the functionality of the remap command in ASMCMD?()

A. It repairs blocks that have read disk I/O errors.
B. It checks whether the alias metadata directory and the file directory are linked correctly.
C. It repairs blocks by always reading them from the mirror copy and writing them to the original location.
D. It reads the blocks from a good copy of an ASM mirror and rewrites them to an alternate location on disk if the blocks on the original location cannot be read properly.

2.多项选择题

Examine the following RMAN command:

Which two statements are true regarding the backup taken by using the above RMAN command?()

A. Only data files and the control file are backed up.
B. Archived redo logs are backed up only I f the database is open during the backup.
C. The backup is deleted after one day, regardless of the default retention policy settings.
D. The backup becomes obsolete after one day, regardless of the default retention policy settings.

3.单项选择题

You want to perform the following operations for the DATA ASM disk group:

Which command accomplishes these tasks?()

A. ALTER DISKGROUP data CHECK;
B. ALTER DISKGROUP data CHECK DISK;
C. ALTER DISKGROUP data CHECK FILE;
D. ALTER DISKGROUP data CHECK DISK IN FAILURE GROUP 1;

4.多项选择题Which two statements are correct about database transportation? ()

A. The source and target platforms must be the same
B. Redo logs, control files and temp files are also transported
C. The transported database must have the same database identifier (DBID) as the source database and cannot be changed
D. The COMPATIBLE parameter must be set to 10.0.0.0 or higher and the database must be opened in readonly mode before being transported
E. Recovery Manager (RMAN) is used to convert the necessary data files of the database if the target platform is different and has different endian format

5.多项选择题Which two statements are true with respect to the maintenance window? ()

A. A DBA can enable or disable an individual task in all maintenance windows.
B. A DBA cannot change the duration of the maintenance window after it is created.
C. In case of a long maintenance window, all Automated Maintenance Tasks are restarted every four hours.
D. A DBA can control the percentage of the resource allocated to the Automated Maintenance Tasks in each window.

8.单项选择题You enabled Flashback Data Archive on the INVENTORY table.Which DDL operation is supported on the table after enabling Flashback Data Archive?()

A. Drop the table.
B. Partition the table
C. Truncate the table.
D. Add a column to the table.
E. Rename a column in the table.

9.多项选择题Which of the following information will be gathered by the SQL Test Case Builder for the problems pertaining to SQL-related problems?()

A. ADR diagnostic files
B. all the optimizer statistics
C. initialization parameter settings
D. PL/SQL functions, procedures, and packages
E. the table and index definitions and actual data

10.单项选择题Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?()

A. only encryption and compression settings for all SecureFile LOBs
B. only encryption and deduplication settings for only SecureFile CLOBs
C. deduplication, encryption, and compression settings for all SecureFile LOBs
D. deduplication, encryption, and compression settings only for SecureFile CLOBs

最新试题

You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database.Which two statements are true about this backup operation?()

题型:多项选择题

Examine the parameter setting in your database:Which statement is correct about the database?()

题型:单项选择题

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

题型:多项选择题

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

题型:多项选择题

The database is currently open and the temp03.dbf tempfile belonging to the default temporary tablespace TEMP has been corrupted. What steps should you take to recover from this tempfile loss in an efficient manner?()

题型:单项选择题

You executed the following commands in a database session:What could have caused the recycle bin to clean up?()

题型:单项选择题

Which three functions are performed by the SQL Tuning Advisor? ()

题型:多项选择题

Examine the CREATE DISKGROUP command used to create a disk group:In which situation would you use this method of disk group creation?()

题型:单项选择题

Which two statements are true about the Automatic Diagnostic Repository (ADR)?()

题型:多项选择题

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

题型:单项选择题