You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

1. A. It must be smaller than the smallest BIGFILE tablespace
2. B. Free space is managed using freelists
3. C. Any data files added to the tablespace must have a size of 5 gigabytes
4. D. It uses the database default blocksize
5. E. It is a locally managed tablespace

Correct Answer: DE

Which four statements are true regarding primary and foreign key constraints and the effect they can have on table data? (Choose four.)

1. A. A table can have only one primary key but multiple foreign keys
2. B. A table can have only one primary key and foreign key
3. C. The foreign key columns and parent table primary key columns must have the same names
4. D. It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted
5. E. It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted
6. F. Only the primary key can be defined at the column and table level
7. G. Primary key and foreign key constraints can be defined at both the column and table level

Correct Answer: ACEG

Your database instance is started with a PFILE.
Examine these parameters:

You want to increase the size of the buffer cache.
Free memory is available to increase the size of the buffer cache. You execute the command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE=1024M;
What is the outcome?

1. A. The value is changed only in the PFILE and takes effect at the next instance startup
2. B. The value is changed for the current instance and in the PFILE
3. C. It fails because the SCOPE clause is missing
4. D. Change is applied to the current instance, but does not persist after instance restart

Correct Answer: D

In the ORCL database, UNDOTBS1 is the active undo tablespace with these properties:
1. A size of 100 MB
2. AUTOEXTEND is off
3. UNDO_RETENTION is set to 15 minutes
4. It has RETENTION GUARANTEE
UNDOTBS1 fills with uncommitted undo 10 minutes after the database opens. What will happen when the next update is attempted by any transaction?

1. A. It succeeds and the generated undo is stored in SYSTEM.
2. B. It fails and returns the error message “ORA-30036: unable to extend segment by 8 in undo tablespace ‘UNDOTBS1’ “.
3. C. It succeeds and the least recently written undo block of UNDOTBS1 is overwritten by the generated undo.
4. D. It succeeds and the generated undo is stored in SYSAUX.
5. E. It succeeds and the least recently read undo block of UNDOTBS1 is overwritten by the generated undo.

Correct Answer: C

Which three statements are true regarding indexes? (Choose three.)

1. A. A UNIQUE index can be altered to be non-unique
2. B. A SELECT statement can access one or more indices without accessing any tables
3. C. A table belonging to one user can have an index that belongs to a different user
4. D. An update to a table can result in updates to any or all of the table’s indexes
5. E. When a table is dropped and is moved to the RECYCLE BIN, all indexes built on that table are permanently dropped
6. F. An update to a table can result in no updates to any of the table’s indexes

Correct Answer: ADE