Managing Space For Schema Objects MCQs
Managing Space For Schema Objects MCQs
Try to answer these Managing Space For Schema Objects MCQs and check your understanding of the Managing Space For Schema Objects subject.
Scroll down and let's begin!
1: As for SQL*Loader, a command line parameter controls whether statements are resumable after recoverable errors in which operations?
A. DML
B. DDL
C. Import/Export
D. Queries
2: 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?
A. GET_TIMEOUT()
B. SET_TIMEOUT(timeout)
C. GET_SESSION_TIMEOUT(sessionID)
D. SET_SESSION_TIMEOUT(sessionID,timeout)
3: 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?
A. In the STORAGE clause of the ALTER INDEX statement
B. None
C. In the ENABLE ... USING INDEX clause of the CREATE TABLE or ALTER TABLE statement
D. In the ENABLE ... USING INDEX clause of the CREATE TABLE or ALTER TABLE statement And In the STORAGE clause of the ALTER INDEX statement
4: In Managing Tablespace Alerts which way is used to specify alert thresholds for both locally managed and dictionary managed tablespaces?
A. By free space remaining (in kilobytes (KB)) And By percent full
B. By free space remaining (in kilobytes (KB))
C. By percent full
D. None
5: In the following which errors are correctable?
A. Out of space condition
B. Space Quota exceeded condition
C. Minimum extents reached condition
D. Out of space condition And Space Quota exceeded condition
6: INITRANS specifies the number of update transaction entries for which space is initially reserved in the data block header?
A. True
B. False
7: In a distributed transaction, sessions or remote instances are suspended only if RESUMABLE has been disabled in the remote instance?
A. False
B. True
8: In the AFTER SUSPEND trigger whenever a resumable statement is suspended in any session, this trigger can have which effects?
A. None
B. If an undo segment has not reached its space limit
C. If an undo segment has not reached its space limit, then a message is sent to the DBA and the statement is aborted
D. If any other recoverable error has occurred, the timeout interval is reset to 10 hours
9: 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?
A. CREATE_OBJECT
B. SET_TASK_PARAMETER
C. EXECUTE_TASK
D. CREATE_TASK
10: 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?
A. DBMS_SPACE.SPACE_USAGE
B. DBMS_SPACE.FREE_BLOCKS
C. DBMS_SPACE.UNUSED_SPACE
D. None
List of Managing Space For Sch...
Available in:
Managing Space For Schema Objects MCQs
