databases Online Quiz - 170
|Description: databases Online Quiz - 170|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
You need to enforce these two business rules: 1. No two rows of a table can have duplicate values in the specified column. 2. A column cannot contain null values. Which type of constraint ensure that both of the above rules are 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 ?
You discover that a disk failure occured on DISK3 where the data file belonging to the USER_DATA table is stored. The database is currently open and you need to recover the data file. You will restore the data file to DISK2. what is the correct sequence RMAN commands to restore and recover the data file ?
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?
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
You have performed the first step in placing your database into ARCHIVELOG mode. The second step is deciding whether the online redo log files are to be archived automatically or manually. which action should you take to enable archiving an instance startup?
You issue this statement ALTER DATABASE BACKUP CONTROLFILE TO TRACE; What does the statment generate ?
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 ?