Evaluate the following command:CREATE TABLE employees -(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NUL

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899559
Joined: Mon Aug 02, 2021 8:13 am

Evaluate the following command:CREATE TABLE employees -(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NUL

Post by answerhappygod »

Evaluate the following command:CREATE TABLE employees -(employee_id NUMBER(2) PRIMARY KEY,last_name VARCHAR2(25) NOT NULL,department_id NUMBER(2), job_id VARCHAR2(8),salary NUMBER(10,2));You issue the following command to create a view that displays the IDs and last names of the sales staff in the organization:CREATE OR REPLACE VIEW sales_staff_vu ASSELECT employee_id, last_name job_idFROM employees -WHERE job_id LIKE 'SA_%' WITH CHECK OPTION;Which statements are true regarding the above view? (Choose all that apply.)

A. It allows you to insert details of all new staff into the EMPLOYEES table.
B. It allows you to delete the details of the existing sales staff from the EMPLOYEES table.
C. It allows you to update the job ids of the existing sales staff to any other job id in the EMPLOYEES table.
D. It allows you to insert the IDs, last names and job ids of the sales staff from the view if it is used in multitable INSERT statements.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!

This question has been solved and has 1 reply.

You must be registered to view answers and replies in this topic. Registration is free.


Register Login
 
Post Reply