#105. Acme Company has 32 employees who routinely access an Oracle database. On the average, each user has one active transaction at any time of the day. The DBS is attempting to create the ideal number of rollback segments for this OLTP environment. The users work in a typical OLTP environment. How many rollback segments should the DBA create?
#106. A transaction fails and returns an ORA-01562 indicating that there is insufficient space in the rollback segment. What are two possible causes? (Choose two)
#108. Two tables have a parent-child relationship that will be enforced by a primary key constraint and foreign key constraint. You would like the flexibility to insert rows in the child table before inserting rows in the parent table. What must you create to enforce the primary key constraint with a unique index?
gen. 0.074
Forum
Master braindump