26.
How can you change the comment assigned to the columns in a table?
- A.Use the ALTER TABLE MODIFY COLUMN statement.
- B.Use the COMMENT ON TABLE statement.
- C.Use the RENAME statement.
- D.Use the COMMENT ON COLUMN statement.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| You assign or change comments on a column with the COMMENT ON COLUMN statement. The COMMENT ON TABLE statement is used to add or change the comment assigned to a table. |
27.
How do you specify that a temporary table will be emptied at the end of a user's session?
- A.Create the temporary table with the ON COMMIT PRESERVE ROWS option.
- B.Create the temporary table with the ON DISCONNECT PRESERVE ROWS option.
- C.Create the temporary table with the ON DISCONNECT PURGE ROWS option.
- D.Create the temporary table with the ON COMMIT DELETE ROWS option.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The options for temporary tables are either ON COMMIT DELETE ROWS, with causes the table to flush at the end of each transaction, or ON COMMIT PRESERVE ROWS, which causes the table to flush at the end of each session. |
28.
Which of the following is not a valid Oracle10g datatype?
- A.timestamp with local timezone
- B.binary
- C.blob
- D.urowid
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Although binary_float and binary_double are valid datatypes, binary is not. |
29.
Which is a valid tablespace extent management specification?
- A.Automatic
- B.Local
- C.Manual
- D.Temporary
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| A tablespace can have either dictionary extent management or local extent management. |
30.
Which allocation unit is the smallest?
- A.Datafile
- 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 datafile houses all these. |
|
|
||||||||||||||||||||||||||||
