1)You want to build a report that will show the current usage of every block in the USERS tablespace. The
report should allow a reader to tell
whether or not a block is allocated to a segment, and if so, what the name of that segment is. This can be
done by querying which two of the following data dictionary views?

Ans: DBA_FREE_SPACE .
DBA_EXTENTS.

2)You are preparing to create a new
Oracle8i database.
In order to create your new database, you need to complete the
following steps. What is the correct order that these steps
need to be completed?

A) CREATE DATABASE
B) cp init.ora initswamp.ora
C) @catproc.sql
D) db_name=swamp


Ans:B, D, A, C.


3)You
have determined that data access to your CUSTOMERS table would benefit from having a bitmap index created on the REGION column.
Which line in the
following CREATE INDEX statement must be changed in
order to create this index?

CREATE BITMAP INDEX CUSTOMERS_REGION_IDX
ON
CUSTOMERS(REGION) REVERSE
PCTFREE 30
STORAGE (INITIAL 100K NEXT 100K
PCTINCREASE 0 MAXEXTENTS 100)
TABLESPACE INDX

Ans:ON
CUSTOMERS(REGION) REVERSE .



4)A particular user is having trouble with his application.
How should you enable tracing for this particular
user?

Ans:Issue the ALTER SESSION SET SQL_TRACE=TRUE command.

5)As a consultant, a new client asks you to provide an assessment of their
backup strategy. In gathering your research, you execute the ARCHIVE LOG LIST command. What information does this command give you?

Ans:The
current status of automatic archiving.


6)When you issue the STARTUP OPEN command, where does the server find
information about the names and
locations of data files, log files,
and checkpoint information?

Ans: Control file.


7)A table named SCOTT.CUSTOMER_CONTACTS has been
exhibiting poor performance, and you think that the table may be suffering from row migration. Which of the following ANALYZE commands will help you
get
the most conclusive information to help you investigate this theory?

Ans:ANALYZE TABLE SCOTT.CUSTOMER_CONTACTS COMPUTE STATISTICS;



8)Which of the following views will show you the NLS settings for your current session?

Ans:V$NLS_PARAMETERS .
NLS_SESSION_PARAMETERS .



9)As a consultant, a new client asks you to provide an assessment of their backup strategy. In gathering your research, you execute the
ARCHIVE LOG LIST command. What information does this command give you?

Ans:The current status of automatic archiving.


10)You have created
a profile called CLERKS and you want these policies to apply to the user BLAKE. Which of the following commands should you
issue to accomplish
this?

Ans:ALTER USER BLAKE PROFILE CLERKS;

---