I'm trying to get some clarification on the following questions. Can anyone
help?
- Which statement about using PCTFREE and PCTUSED is true?
Is it only at a segment level? Multiple segments belong to a single
tablespace, so shouldn't it be both?
- Block space utilization can be specified only at the segment level.
- Block space utilization can be specified only in the data dictionary.
- Block space utilization parameters can only be specified at the
tablespace.
- Block space utilization can be specified both at the tablespace level and
segment level.
- Which two parameters might affect the concurrency of transactions on a
data block? (choose 2)
INITTRANS makes sense of course, but what is the other & why?
- PCTUSED
- PCTFREE
- INITRANS
- MAXEXTENTS
- NEXTEXTENT
- Which are DATABASE event triggers?
- DROP USER
- ALTER VIEW
- CREATE DB
- CALL TO A PROCEDURE
- What are two effects of setting REMOTE_LOGIN_PASSWORDFILE to EXCLUSIVE?
(choose 2)
C is correct, but I'm not sure if D or E is the other correct answer. SYSDBA
is a granted priv, so are they trying to say by default, SYSDBA would not be
allowed in until this is done?
- Passwordfile can be stored remotely
- Passwordfile access is restricted to local users
- Only one instance on the database can use the passwordfile
- Remote connection using the SYSDBA privileges are allowed
- Remote connection using the SYSDBA privileges are prohibited
Received on Tue Nov 27 2001 - 19:01:45 CST