For which constraint does the Oracle Server implicitly create a unique index?

a)PRIMARY KEY

b)NOT NULL

c)FOREIGN KEY

d)CHECK

Which tablespace can NOT be recovered with the database open?

a)USERS

b)TOOLS

c)DATA

d)SYSTEM


Which file can be used to manually configure the Oracle names server?

a)Onames.ora

b)Oranames.ora

c)names.ora

d)namesrv.ora


Which statement is TRUE if you configured a database in the ARCHIVELOG mode that was previously running in the NOARCHIVELOG mode?

a)You must perform a log switch after setting the ARCHIVELOG configuration.

b)You cannot take any datafile offline in this mode.

c)You can perform only partial backups.

d)You can back up the database while it is open and being accessed by users


How do you generate warnings automatically when more than 100 sessions are opened with your database instance?

a)Set the TRACE_ENABLED parameter to TRUE.

b)Set the LOG_CHECKPOINT_TO_ALERT parameter to TRUE.

c)Set the SESSIONS_PER_USER limit in the profiles used by users.

d)Set the threshold for the Current Logons Count metric.

Which constraint state prevents new data that violates the constraint from being entered, but allows invalid data to exist in the table?

a)ENABLE VALIDATE

b)DISABLE VALIDATE

c)ENABLE NOVALIDATE

d)DISABLE NOVALIDATE

Which file can be used to manually configure the Oracle names server?

a)Onames.ora

b)Oranames.ora

c)Onames.ora

d)namesrv.ora