PrepAway - Latest Free Exam Questions & Answers

What is the current content of the staffsalary table?

The following SQL statements were executed in sequence:
CREATE DISTINCT TYPE salary AS decimal(7,2) WITH COMPARISONS;
CREATE TABLE staffsalary(empid INT, empsalary salary);
INSERT INTO staffsalary VALUES (10, 50000), (20, 50000.00);
UPDATE staffsalary SET empsalary = 60000
WHERE salary(50000) = empsalary;

What is the current content of the staffsalary table?

PrepAway - Latest Free Exam Questions & Answers

A.
ID | EMPSALARY —————– 10 | 60000 20 | 50000.00 —————–

B.
ID | EMPSALARY —————– 10 | 50000.00 20 | 50000.00 —————–

C.
ID | EMPSALARY —————– 10 | 60000.00 20 | 60000.00 —————–

D.
ID | EMPSALARY —————– 10 | 60000.00 20 | 50000.00 —————–

One Comment on “What is the current content of the staffsalary table?


Leave a Reply