Organizational Research By

Surprising Reserch Topic

Question:Which of the following SQL statements can use NOLOGGING mode?


a.        DELETE FROM EMPLOYEE_MASTER;
b.        INSERT INTO EMPLOYEE_MASTER VALUES ('JOHN', 2000);
c.        CREATE TABLE EMPLOYEE AS SELECT * FROM EMPLOYEE_MASTER;
d.        CREATE INDEX EMPLOYEE_MASTER_PK ON EMPLOYEE_MASTER (EMPLOYEE_ID);
e.        UPDATE EMPLOYEE_MASTER SET FIRST_NAME = 'JOE' WHERE EMPLOYEE_ID = 1200;

asked Sep 13, 2013 in MYSQL by anonymous
reshown Sep 12, 2013 by rajesh
0 votes
21 views



Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

...