×
Detail Form
We will send your result on your email id and phone no. please fill detail
1.
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?
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?
2.
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?
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?
3.
In order to guarantee a minimum number of concurrent updates on a data block, which parameter do you need
to set?
to set?
4.
You are logged on to a client. You do not have a secure connection from your client to the host where your
Oracle database is running. Which authentication mechanism allows you to connect to the database using the
SYSDBA privilege?
Oracle database is running. Which authentication mechanism allows you to connect to the database using the
SYSDBA privilege?
5.
From the data dictionary you know that user A has profile TEST_PROF assigned, and the IDLE_TIME resource
shows default as its value. What does this mean?
shows default as its value. What does this mean?
6.
Which system parameter must be set to TRUE in orderfor Oracle to enforce the resource usage defined in the
profile?
profile?
7.
Which clause can be used with a CREATE PROFILE command?
8.
To select only objects that belong to a specific schema from DBA_OBJECTS, specify a value for the column
___ in the predicate.
___ in the predicate.
9.
When creating a table, you must place the table in which tablespace?
10.
How do you temporarily revoke a role from a user?