AMA University Answers
Login
Register
AMA OED
Courses
IT
IT-6203
Which of the following is the...
Which of the following is the correct example of creating a subquery that will copy all values from employees table to workers where job_id is equal to ST_CLERK;
INSERT INTO WORKERS(SELECT * FROM EMPLOYEES WHERE JOB_ID = ‘ST_CLERK’);
Correct
Similar IT-6203 questions
Which of the following is not true about complex view when using DELETE statement?
Which of the following is the correct example of adding a CHECK constraint where CODE should start w...
What are the two forms of key integrity constraint?
Which of the following is the correct example of multiple row subquery?
Which of the following is the correct example of modifying a view where salary managerid is null?
Which of the following is not true about complex view when using UPDATE statement?