Using PL/SQL Packages to Display Information About Schema Object Space Usage which Returns information about free data blocks in an object (table, index, or cluster) whose segment space management is AUTO?
Answer
Correct Answer:
DBMS_SPACE.SPACE_USAGE
Note: This Question is unanswered, help us to find answer for this one
DBMS_ADVISOR package procedures relevant to the segment advisor which package procedure name Use this procedure to create the Segment Advisor task. Specify 'Segment Advisor ‘as the value of the ADVISOR_NAME parameter?
Answer
Correct Answer:
CREATE_TASK
Note: This Question is unanswered, help us to find answer for this one
In the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session, this trigger can have which effects?
Answer
Correct Answer:
None
Note: This Question is unanswered, help us to find answer for this one
In a distributed transaction, sessions or remote instances are suspended only if RESUMABLE has been disabled in the remote instance?
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
INITRANS specifies the number of update transaction entries for which space is initially reserved in the data block header?
Answer
Correct Answer:
True
Note: This Question is unanswered, help us to find answer for this one
In the following which errors are correctable?
Answer
Correct Answer:
Out of space condition And Space Quota exceeded condition
Note: This Question is unanswered, help us to find answer for this one
In Managing Tablespace Alerts which way is used to specify alert thresholds for both locally managed and dictionary managed tablespaces?
Answer
Correct Answer:
By free space remaining (in kilobytes (KB)) And By percent full
Note: This Question is unanswered, help us to find answer for this one
Storage parameters of an index segment created for the index used to enforce a primary key or unique key constraint can be set in either of the following ways?
Answer
Correct Answer:
In the ENABLE ... USING INDEX clause of the CREATE TABLE or ALTER TABLE statement And In the STORAGE clause of the ALTER INDEX statement
Note: This Question is unanswered, help us to find answer for this one
In DBMS_RESUMABLE Package which function returns the current timeout value of resumable space allocation for the current session. The returned value is in seconds?
Answer
Correct Answer:
GET_TIMEOUT()
Note: This Question is unanswered, help us to find answer for this one
As for SQL*Loader, a command line parameter controls whether statements are resumable after recoverable errors in which operations?
Answer
Correct Answer:
Import/Export
Note: This Question is unanswered, help us to find answer for this one
