logo

Crowdly

LE/EECS 3421 M & N - Introduction to Database Systems (Winter 2024-2025)

Looking for LE/EECS 3421 M & N - Introduction to Database Systems (Winter 2024-2025) test answers and solutions? Browse our comprehensive collection of verified answers for LE/EECS 3421 M & N - Introduction to Database Systems (Winter 2024-2025) at eclass.yorku.ca.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

What does the following query return?

q

View this question

What is the result of the following query on the staff table? SELECT COUNT(DISTINCT DEPTNUMB) FROM staff;

sql1

0%
0%
0%
View this question

Which query returns the maximum salary from the staff table? (select all that apply)

View this question

What does the following query returns?

SELECT C.CUST_ID, C.CUST_NAME, O.ORDER_NUMBER 

FROM CUSTOMERS C LEFT JOIN ORDERS O 

ON C.CUST_ID = O.CUST_ID 

WHERE O.ORDER_NUMBER IS NULL;

View this question

What does the following query return?

SELECT E.EMP_ID, E.EMP_NAME, D.DEPT_NAME 

FROM Employees E FULL OUTER JOIN Departments D 

ON E.DEPT_ID = D.DEPT_ID;

View this question

What is the result of running the following query? 

SELECT TOP 1 Salary FROM (SELECT DISTINCT TOP 3 Salary FROM STAFF ORDER BY Salary DESC) AS TORDER BY Salary;

sql2

0%
0%
0%
View this question

What does the following query do?

ALTER TABLE Employees ADD BirthDate DATE;

View this question

Which command modifies a column’s data type?

View this question

What happens when you execute DROP TABLE Employees?

View this question

A relation in 2NF must not contain any transitive dependencies.

View this question

Want instant access to all verified answers on eclass.yorku.ca?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!