8i Admin & Arch - 4 Questions

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!

#1 is D

#4 the other is D


#2 & 3 I am not sure about.

- Magnus

1. A
2. A, C
3. A (not sure)
4. C,D

3 is not really a very good question. I would guess the answer they are looking for is B.

Answer A is incorrect because I don't think a trigger fires when a user is dropped. System event triggers operate on objects or user logon/logoff. I am not sure if they operate on user creation.

Answer C is incorrect because a trigger doesn't get fired in this case.

Answer D is incorrect because it is not a valid event.

marist89 - Thanks for the guess... Any guess on the other 3?

Thanks,

Paul

1. A. Since its PCTFREE and PCTUSED they're talking about, you can't specify at tablespace level.
2. A,C
4. C,D

How does PCTUSED affect the concurrency of transactions on a data block?

Thanks,

Paul

Quote:

---

INITTRANS makes sense of course, but what is the other & why?

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

---

Good question. If you set a high value for PCTUSED, then you may decrease performance, because more migrated and
chained rows are present. Then low INITRANS on the other blocks may affect concurrency of the transaction.

With a low value for PCTUSED, the space usage is not efficient due to unused space in data blocks.

Thank you Julian.

I appreciate the help.

PW

Quote:

---

Originally posted by julian

Quote:

---

INITTRANS makes sense of course, but what is the other & why?

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

---

Good question. If you set a high value for PCTUSED, then you may decrease performance, because more migrated and
chained rows are present. Then low INITRANS on the other blocks may affect concurrency of the transaction.

With a low value for PCTUSED, the space usage is not efficient due to unused space in data blocks.

---

It really mess me. I found an some old threads answered BC and there is a guy got 63/64 stated the answer is BC too.