Oracle
1Z0-061 · Question #157
Evaluate the following SQL statements: You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization. Which two statements are true…
The correct answer is B. It allows you to delete details of the existing sales staff from the EMPLOYEES table D. It allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in. See the full explanation below for the reasoning.
Question
Evaluate the following SQL statements:
You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization. Which two statements are true regarding the above view? (Choose two.)
Options
- AIt allows you to update job IDs of the existing sales staff to any other job ID in the EMPLOYEES
- BIt allows you to delete details of the existing sales staff from the EMPLOYEES table
- CIt allows you to insert rows into the EMPLOYEES table
- DIt allows you to insert IDs, last names, and job IDs of the sales staff from the view if it is used in
How the community answered
(29 responses)- A14% (4)
- B79% (23)
- C7% (2)
Community Discussion
No community discussion yet for this question.