Question 15 Which SQL statement returns customers with creditlimit less than or equal to 2000 (Creditlimit is a posititve number.)? Question 15 options: WHERE creditlimit in (0, 2000) WHERE creditlimit < 2000 WHERE creditlimit > 0 creditlimit <2000 WHERE creditlimit <= 2000 Question 16 ListenReadSpeaker webReader: Listen Imagine there are 12 columns in employees table and 450 records.... CREATE VIEW part_of_emp AS SELECT first_name , last_name FROM employees WHERE salary > 5000; Which statement is true about this view Question 16 options: This view contains all the employee records but shows only their first and last name in the data set This view has done only projection because it lists only two columns but not rest of 10 other columns In this view they have done elimination via both projection and selection to eliminate some attributes and also some records. ALL OF ABOVE
Question 15
Which SQL statement returns customers with creditlimit less than or equal to 2000 (Creditlimit is a posititve number.)?
Question 15 options:
|
WHERE creditlimit in (0, 2000) |
|
|
WHERE creditlimit < 2000 |
|
|
WHERE creditlimit > 0 creditlimit <2000 |
|
|
WHERE creditlimit <= 2000 |
Question 16
ListenReadSpeaker webReader: Listen
Imagine there are 12 columns in employees table and 450 records.... CREATE VIEW part_of_emp AS SELECT first_name , last_name FROM employees WHERE salary > 5000;
Which statement is true about this view
Question 16 options:
|
This view contains all the employee records but shows only their first and last name in the data set |
|
|
This view has done only projection because it lists only two columns but not rest of 10 other columns |
|
|
In this view they have done elimination via both projection and selection to eliminate some attributes and also some records. |
|
|
ALL OF ABOVE |
Step by step
Solved in 2 steps
