Oracle Advanced SQL and PL/SQL Developer Certification Questions and Answers (Dumps and Practice Questions)

Question : How can you delete the values from one column of every row in a table?

1. Use the DELETE COLUMN command.
2. Use the TRUNCATE COLUMN command.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Use the DROP COLUMN command.



Correct Answer : Get Lastest Questions and Answer :

Explanation: An UPDATE, without a WHERE clause, is the only way.

Related Questions

---

Question : How can you delete the values from one column of every row in a table?

1. Use the DELETE COLUMN command.
2. Use the TRUNCATE COLUMN command.
3. Access Mostly Uused Products by 50000+ Subscribers
4. Use the DROP COLUMN command.




Question : Which two statements are true regarding constraints?
A. A table can have only one primary key and one foreign key.
B. A table can have only one primary key but multiple foreign keys.
C. Only the primary key can be defined at the column and table levels.
D. The foreign key and parent table primary key must have the same name.
E. Both primary key and foreign key constraints can be defined at both column and table levels.

1. A,C
2. B,D
3. A,E
4. C,D
5. B,E



Question : In which three situations does a transaction complete?
A. When a DELETE statement is executed
B. When a ROLLBACK command is executed
C. When a PL/SQL anonymous block is executed
D. When a data definition language (DDL) statement is executed
E. When a TRUNCATE statement is executed after the pending transaction

1. A,B,C
2. A,C,E
3. A,D,E
4. B,C,E
5. B,D,E


Question : Examine the structure of the orders table:
Which statement is true regarding the outcome?

1. It executes successfully and gives the correct output.
2. It gives an error because the TO_CHAR function is not valid.
3. It executes successfully but does not give the correct output.
4. It gives an error because the data type conversion in the SELECT list does not match the data type conversion in the GROUP BY clause.