1. Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQL*Plus. b. A commit is issued implicitly when a DDL command is executed. c. A co…
1. Which of the following is a correct statement?
a. A commit is issued implicitly when a user exits SQL Developer or SQL*Plus.
b. A commit is issued implicitly when a DDL command is executed.
c. A commit is issued automatically when a DML command is executed.
d. All of the above are correct.
e. Both a and b are correct.
f. Both a and c are correct.
2. Which of the following is a valid SQL statement?
a. SELECT * WHERE amid = ‘J100’ FOR UPDATE;
b. INSERT INTO homeworkl0 VALUES (SELECT * FROM acctmanager);
c. DELETE amid FROM acctmanager;
d. rollback;
e. all of the above
3. Which of the following commands can be used to add rows to a table?
a. INSERT INTO
b. ALTER TABLE … ADD
c. UPDATE
d. SELECT … FOR UPDATE
OR