16. Which of the following is the standard extension used for a script file? a. .spt b. .srt c. .script d. .sql 17. A rollback occurs automatically when: a. A DDL command is executed. b. A DML command…
16. Which of the following is the standard extension used for a script file?
a. .spt
b. .srt
c. .script
d. .sql
17. A rollback occurs automatically when:
a. A DDL command is executed.
b. A DML command is executed.
c. The user exits the system.
d. none of the above
18. What is the maximum number of rows that can be deleted from a table at one time?
a. 1
b. 2
c. 3
d. unlimited
19. Which of the following is a correct statement?
a. If you attempt to add a record that violates a constraint for one of the table’s columns,
only the valid columns for the row are added.
b. A subquery nested in the VALUES clause of an INSERT INTO command can return
only one value without generating an Oracle 12c error message.
c. If you attempt to add a record that violates a NOT NULL constraint, a blank space is
inserted automatically in the appropriate column so that Oracle 12c can complete the
DML operation.
d. None of the above statements is correct.
20. What is the maximum number of records that can be modified with a single UPDATE
command?
a. 1
b. 2
c. 3
d. unlimited
OR