21.
Which of the following statements about tablespaces is true?
- A.A tablespace is the physical implementation of logical structure called a namespace.
- B.A tablespace can hold the objects of only one schema.
- C.A bigfile tablespace can have only one datafile.
- D.The SYSAUX tablespace is an optional tablespace only created if you install certain database options.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Bigfile tablespaces are new to Oracle10g and can have only a single datafile. The traditional or smallfile tablespace can have many datafiles. |
22.
Automatic segment space management on the tablespace causes which of the following table
attributes in that tablespace to be ignored?
- A.The whole storage clause
- B.NEXT and PCTINCREASE
- C.BUFFERPOOL and FREEPOOL
- D.PCTFREE and PCTUSED
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Segment space management refers to free space management, with automatic segment space management using bitmaps instead of FREELISTS, PCTFREE, and PCTUSED. |
23.
Which objects share the same namespace and therefore cannot have the same name?
- A.Tables and indexes
- B.Tables and procedures
- C.Tables and constraints
- D.Tables and triggers
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Indexes, constraints, and triggers all have separate namespaces. Tables share a namespace with views, sequences, private synonyms, procedures, functions, packages, materialized views, and user-defined types. Objects within the same schema sharing a namespace must have unique names. |
24.
Which is not a type of segment that is stored in a tablespace?
- A.Undo
- B.Redo
- C.Permanent
- D.Temporary
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Redo information is not stored in a segment; it is stored in the redo logs. Undo segments are stored in the undo tablespace, temporary segments are in the temporary tablespace, and permanent segments go into all the other tablespaces. |
25.
With which parameters do you specify unlimited datafile growth?
- A.MAXSIZE UNLIMITED
- B.UNLIMITED GROWTH
- C.MAXEXTENTS UNLIMITED
- D.Datafile size cannot change.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The autoextend MAXSIZE parameter tells Oracle how large a data or temp file can grow to. UNLIMITED specifies no bounds to the automatic growth. |
|
|
||||||||||||||||||||||||||||
