databases Online Quiz - 139
|Description: databases Online Quiz - 139
|Number of Questions: 20
|Created by: Aliensbrain Bot
The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover ? (Choose two)
Which three attributes of the LOG_ARCHIVE_DEST_n initialization parameter control the data availability mode of a Data Guard standby database? (Choose three)
CREATE TABLESPACE user_data DATAFILE '/u01/oradata/user_data_01.dbf' SIZE 100M LOCALLY MANAGED UNIFORM SIZE 1M AUTOMATIC SEGMENT SPACE MANAGEMENT; Which part of the tablespace will be of a uniform size of 1 MB?
An Oracle instance is executing in a nondistributed configuration. The instance fails because of an operating system failure. Which background process would perform the instance recovery when the atabase is reopened ?
To increase the availability of an Advanced Replication environment, you can add a new master to a replication group without quiescing the group. This is achived _________________.
Consider this syntax MERGE INTO t1 USING t2 ON (join predicate) .... What does the MERGE syntax do ?
Which modifier is used to change listener parameters in the Listener Control utility environment?
You have used the CROSSCHECK BACKUP command to verify that the backups recorded in the RMAN repository actually exist. Which command should you now use to check if any of the files were missing?
You want to drop the TBSI tablespace from your database. You also want to delete corresponding data files automatically, and not have to do it manually. What should you do ?
The ORDERS table has a constant transaction load 24 hours a day, so down time is not allowed. The index become fragmented. Whic statment is true ?
You omit the UNDO tablespace clause in your CREATE DATABASE statment. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement ?
To answer this question, we need to understand the role of the UNDO tablespace in Oracle databases and the impact of different UNDO_MANAGEMENT settings.
In Oracle databases, the UNDO tablespace is used to store undo information, which is necessary for database transactions to maintain data consistency and enable rollback operations. The UNDO_MANAGEMENT parameter specifies how the undo records are managed in the database.
When the UNDO_MANAGEMENT parameter is set to "AUTO", the Oracle server automatically manages the undo records using Automatic Undo Management (AUM). In this case, the database creates and manages one or more undo tablespaces based on the workload and configuration.
Now, let's analyze each option to understand the result of the CREATE DATABASE statement in this scenario:
Option A) The Oracle server creates no undo tablespace. This option is incorrect because when UNDO_MANAGEMENT is set to AUTO, the Oracle server will create and manage one or more undo tablespaces.
Option B) The Oracle server creates an undo segment in the system tablespace. This option is incorrect because when UNDO_MANAGEMENT is set to AUTO, the undo data is not stored in the system tablespace. Instead, it is stored in dedicated undo tablespaces.
Option C) The Oracle server creates one undo tablespace with the name SYS_UNDOTBS. This option is correct. When the UNDO_MANAGEMENT parameter is set to AUTO, and the UNDO tablespace clause is omitted in the CREATE DATABASE statement, the Oracle server will create a default undo tablespace named "SYS_UNDOTBS".
Option D) Database creation fails because you did not specify an undo tablespace on the create database statement. This option is incorrect. When the UNDO_MANAGEMENT parameter is set to AUTO, and the UNDO tablespace clause is omitted, the Oracle server will create a default undo tablespace.
Therefore, the correct answer is C) The Oracle server creates one undo tablespace with the name SYS_UNDOTBS.
John has created a procedure named SALARY_CALC. Which SQL query allow him to view text of procedure?
The employees table is stored in the SAMPLE tablespace. The corresponding IPK_EMP index for the EMPLOYEES table's primary key is stored in INDX tablespace. Out of 12 partitions, only partition P1 of the SALES table is stored in the SAMPLE tablespace. Which object will be exported by this command ? exp system/manager tablespace=SAMPLE
In user-managed backup and recover procedure, how are data files backed up ?