PLEASE HELP - I NEED SOME CLARIFICATION ON THE QUESTIONS BELOW.

1. 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?

A. Block space utilization can be specified only at the segment level.
B. Block space utilization can be specified only in the data dictionary.
C. Block space utilization parameters can only be specified at the tablespace.
D. Block space utilization can be specified both at the tablespace level and segment level.


2. 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?

A. PCTUSED
B. PCTFREE
C. INITRANS
D. MAXEXTENTS
E. NEXTEXTENT


3. Which are DATABASE event triggers?

A. DROP USER
B. ALTER VIEW
C. CREATE DB
D. CALL TO A PROCEDURE


4. 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?

A. Passwordfile can be stored remotely
B. Passwordfile access is restricted to local users
C. Only one instance on the database can use the passwordfile
D. Remote connection using the SYSDBA privileges are allowed
E. Remote connection using the SYSDBA privileges are prohibited


Thank you very much!