request for doubts to be cleared at the earliest. [message #8706] |
Fri, 19 September 2003 08:19 |
Harini
Messages: 4 Registered: September 2003
|
Junior Member |
|
|
Dear sir?maam,
I have a set of questions for which I require answers at the earliest.
Q1.What is the purpose of defining an Index?
Q2.What should one use to group users based on common access permission?
Q3.What constraint can be defined at the table level as well as at the column level?
Q4.What do we have to do to change the default date formate in a SQLPLUS session ?
Q5.At what time is the Integrity constrains are not checked?
Q6.In what case is the Roll Back segment not used?
Q7.When is an Arc relationship applicable?
Q8.What type of Binding does PL/SQL use?
-Harini
|
|
|
|
|
|
Re: request for doubts to be cleared at the earliest. [message #8720 is a reply to message #8706] |
Sat, 20 September 2003 09:20 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Harini,
Answers in brief :
1) Enhance Search & Sort performance
2) A Role is a named group of access privileges.
3) Most of the constraints
4) Alter session set NLS_DATE_FORMAT
5) When they are disabled ! or deferred ..it depends on the statements
6) Generalisation is difficult. They are used in almost all cases (end user and/or oracle internal perspective).For your test,you could say DDL. You need to understand also that DDL will COMMIT all the work you did(DML) before and Oracle touches those Rollback segments internally.
7)When an Entity has multiple mutually exclusive relationship with another entity ,it is said to be an ARC
8)By default, Early Binding ..ie at the compilation time
All the best!
Thiru
|
|
|