Administration Oracle :
1/ You execute this command :
CREATE BIGFILE TABLESPACE big_tbs
DATAFILE `/u01/oracle/data/big_f1.dbf ‘
SIZE 20G ;
Sufficient storage is available in filesystem /u01. Which two statements are true about the
BIG_TBS tablespace ? (Choose two.)
A. AUTOEXTEND is possible for the datafile
B. It must be bigger than the largest SMALLFILE tablespace
C. Additional data files may not be added
D. It will be a dictionary-managed tablespace by default
E. It will always have a 32K blocksize
2/ A database is configured to use automatic undo management with temporary undo
enabled. An UPDATE is executed on a temporary table. Where is the UNDO stored?
A. in the undo tablespace
B. in the SYSAUX tablespace
C. in the SGA D. in the PGA
E. in the temporary tablespace
3/ Which three statements are true concerning logical and physical database structures?
(Choose three.)
A. All tablespaces may have one or more data files
B. The extents of a segment must always reside in the same datafile
C. A smallfile tablespace might be bigger than a bigfile tablespace
D. A segment can span multiple data files in some tablespaces
E. A segment's blocks can be of different sizes
F. A segment might have only one extent
4/ Examine this command:
ALTER DATABASE
MOVE DATAFILE `/U10/SALES1.DBF ‘
TO `/U10/SALES01.DBF’
REUSE ;
Which two statements are true? (Choose two.)
A. DML may be performed on tables with one or more extents in this data file during the execution of
this command.
B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the
command.
C. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
D. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to
DB_CREATE_FILE_DEST.
E. The file is renamed and stored in the same location
5/ Which three instance situations are possible with the Oracle Database server without
multi-tenant? (Choose three.)
A. two or more instances on separate servers all associated with one database
B. one instance on one server associated with one database
C. one instance on one server associated with two or more databases on the same server
D. one instance on one server not associated with any database
E. one instance on one server associated with two or more databases on separate servers
6/ Which two statements are true about the PMON background process? (Choose two.)
A. It registers database services with all local and remote listeners known to the database instance
B. It frees resources held by abnormally terminated processes
C. It records checkpoint information in the control file
D. It frees unused temporary segments E. It kills sessions that exceed idle time
E. It kills sessions that exceed idle time
7/ 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?
A. The value is changed only in the PFILE and takes effect at the next instance startup
B. The value is changed for the current instance and in the PFILE
C. It fails because the SCOPE clause is missing
D. Change is applied to the current instance, but does not persist after instance restart
