- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
21.
Which of the following statements about tablespaces is true?
- A.A tablespace is the physical implementation of a logical structure called a namespace
- B.A tablespace can hold the objects of only one schema
- C.A bigfile tablespace can have only one data file
- D.The SYSAUX tablespace is an optional tablespace created only if you install certain database options
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Bigfile tablespaces can have only a single data file. The traditional or smallfile tablespace can have many data files (the limit is OS-dependent, mostly 1022). |
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 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. |
24.
Which allocation unit is the smallest?
- A.Data file
- B.Extent
- C.Data block
- D.Segment
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| An extent is composed of two or more data blocks; a segment is composed of one or more extents; and a data file houses all these. |
25.
You performed the following statement in the database. What actions can you perform
on the CUST_INFO table in the CUST_DATA tablespace. (Choose all that apply.)
ALTER TABLESPACE CUST_DATA READ ONLY;
ALTER TABLESPACE CUST_DATA READ ONLY;
- A.ALTER TABLE CUST_INFO DROP COLUMN xx;
- B.TRUNCATE TABLE CUST_INFO;
- C.INSERT INTO CUST_INFO VALUES (…);
- D.DROP TABLE CUST_INFO;
- E.RENAME CUST_INFO TO CUSTOMER_INFO;
- Answer & Explanation
- Report
Answer : [D, E]
Explanation :
Explanation :
| When a tablespace is read-only, DML operations and operations that affect data in the table are not allowed. TRUNCATE is not allowed, but the DROP operation is allowed. You can also rename the table using the RENAME statement or the ALTER TABLE statement. |
|
|
||||||||||||||||||||||||||||
