Want to pass your Upgrade Oracle9i/10g OCA to Oracle Database OCP 1Z0-034 exam in the very first attempt? Try Pass2lead! It is equally effective for both starters and IT professionals.
VCE
Which data dictionary view would you query to find the name of the default permanent tablespace of the database?
A. DICTIONARY
B. DBA_TABLESPACES
C. DBA_DIRECTORIES
D. DBA_STORED_SETTINGS
E. DATABASE_PROPERTIES
F. DBA_TABLESPACE_GROUPS
You created a tablespace with the following statement:
CREATE BIGFILE TABLESPACE adtbs
DATAFILE '/probdb/data/adtbs.dbf' SIZE 10G;
There is now a requirement to increase the size of the tablespace.
Which two ALTER statements are correct in this scenario? (Choose two.)
A. ALTER TABLESPACE adtbs RESIZE 20G;
B. ALTER TABLESPACE adtbs ADD DATAFILE;
C. ALTER TABLESPACE adtbs AUTOEXTEND ON;
D. ALTER TABLESPACE adtbs ADD DATAFILE'/proddb/data/adtbs1.dbf' SIZE 10G;
E. ALTER TABLESPACE adtbs MODIFY DATAFILE '/proddb/data/adtbs.dbf' AUTOEXTEND ON;
Which three types of files can be automatically placed in the flash recovery area (fast recovery area in 11g Release 2)? (Choose three.)
A. Alert log file
B. Archived redo log files
C. Control file autobackups
D. Server Parameter file (SPFILE)
E. Recovery Manager (RMAN) backup piece