71.
Tom executed the following SQL statement.
create table xx (n number, x long, y clob);
Choose the best option.
create table xx (n number, x long, y clob);
Choose the best option.
- [A]A table named xx will be created.
- [B]Single-character column names are not allowed in table definitions.
- [C]When using the LONG datatype, other LOB datatypes cannot be used in table definitions.
- [D]It provides a means of storing all RMAN backup sets physically in an Oracle database server.
- [E]One of the datatypes used in the column definition needs the size specified.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The table will be created without error. A table cannot have more than one LONG column, but LONG and multiple LOB columns can exist together. If a LONG or LONG RAW column is defined, another LONG or LONG RAW column cannot be used. |
72.
You are connected to the database as user JOHN. You need to rename a table named
NORDERS to NEW_ORDERS, owned by SMITH. Consider the following two statements:
1. RENAME SMITH.NORDERS TO NEW_ORDERS;
2. ALTER TABLE SMITH.NORDERS RENAME TO NEW_ORDERS;
Which of the following is correct?
2. ALTER TABLE SMITH.NORDERS RENAME TO NEW_ORDERS;
Which of the following is correct?
- [A]Statement 1 will work; statement 2 will not.
- [B]Statements 1 and 2 will work.
- [C]Statement 1 will not work; statement 2 will work.
- [D]Statements 1 and 2 will not work.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| RENAME can be used to rename objects owned by the user. ALTER TABLE should be used to rename tables owned by another user. To do so, you must have the ALTER privilege on the table or the ALTER ANY TABLE privilege. |
73.
You have a large job that will load many thousands of rows into your ORDERS table. To
speed up the loading process, you want to temporarily stop enforcing the foreign key constraint
FK_ORDERS. Which of the following statements will satisfy your requirement?
- [A]ALTER CONSTRAINT FK_ORDERS DISABLE;
- [B]ALTER TABLE ORDERS DISABLE FOREIGN KEY FK_ORDERS;
- [C]ALTER TABLE ORDERS DISABLE CONSTRAINT FK_ORDERS;
- [D]ALTER TABLE ORDERS DISABLE ALL CONSTRAINTS;
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You can disable a constraint by specifying its constraint name. You may enable the constraint after the load and avoid the constraint checking while enabling using the ALTER TABLE ORDERS MODIFY CONSTRAINT FK_ORDERS ENABLE NOVALIDATE; command. |
74.
Which datatype shows the time-zone information along with the date value?
- [A]TIMESTAMP
- [B]TIMESTAMP WITH LOCAL TIME ZONE
- [C]TIMESTAMP WITH TIME ZONE
- [D]DATE
- [E]Both options B and C
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Only TIMESTAMP WITH TIME ZONE stores the time-zone information as a displacement from UTC. TIMESTAMP WITH LOCAL TIME ZONE adjusts the time to the database's time zone before storing it. |
75.
What is the default precision for fractional seconds in a TIMESTAMP datatype column?
- [A]0
- [B]2
- [C]6
- [D]9
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The default precision is 6 digits. The precision can range from 0 to 9. |
|
|
||||||||||||||||||||||||||||
