Crowdly
Add to Chrome
CC - P2 - Promo 2028
Looking for CC - P2 - Promo 2028 test answers and solutions? Browse our comprehensive collection of verified answers for CC - P2 - Promo 2028 at moodle.myefrei.fr.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Schéma relationnel :
- Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
- Department (DepartmentID, DepartmentName, #ManagerID)
- Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
- Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)
Explication des relations :
- Employee (
EmployeeID) est la clé primaire. - Department (
DepartmentID) est la clé primaire. - Project (
ProjectID) est la clé primaire. - Employee_Project (
#EmployeeID, #ProjectID) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project). - Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département.
- Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé.
- Employee_Project(#EmployeeID) → Employee(EmployeeID)
- Employee_Project(#ProjectID) → Project(ProjectID)
QUESTION
Quelle requête retourne le salaire moyen des employés ?A) SELECT AVG(Salary) FROM Employee;B) SELECT MEAN(Salary) FROM Employee;C) SELECT AVG(Salary) FROM Employee GROUP BY Salary;D) SELECT AVG(Salary) WHERE Employee HAVING Salary
❌
✅
❌
❌
View this question
Relational Schema:
Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)Department (DepartmentID, DepartmentName, #ManagerID)Project (ProjectID, ProjectName, StartDate, EndDate, Budget)Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)
Explanation of Relationships:
- Employee (EmployeeID) is the primary key.
- Department (DepartmentID) is the primary key.
- Project (ProjectID) is the primary key.
- Employee_Project (#EmployeeID, #ProjectID) is a composite primary key (many-to-many relationship between Employee and Project).
- Employee(#DepartmentID) REFERENCES Department(DepartmentID): An employee belongs to a department.
- Department(#ManagerID) REFERENCES Employee(EmployeeID): A manager is an employee.
- Employee_Project(#EmployeeID) REFERENCES Employee(EmployeeID)
- Employee_Project(#ProjectID) REFERENCES Project(ProjectID)
QUESTION
Which query selects employees whose salary is greater than at least one employee in department 2?A)SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);B) SELECT * FROM Employee WHERE Salary > (SELECT MAX(Salary) FROM Employee WHERE DepartmentID = 2);C) SELECT * FROM Employee WHERE Salary = ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);D) SELECT * FROM Employee WHERE Salary < (SELECT Salary FROM Employee WHERE DepartmentID = 2);❌
✅
❌
❌
View this question
Schéma relationnel :
- Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
- Department (DepartmentID, DepartmentName, #ManagerID)
- Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
- Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)
Explication des relations :
- Employee (
EmployeeID) est la clé primaire. - Department (
DepartmentID) est la clé primaire. - Project (
ProjectID) est la clé primaire. - Employee_Project (
#EmployeeID, #ProjectID) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project). - Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département.
- Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé.
- Employee_Project(#EmployeeID) → Employee(EmployeeID)
- Employee_Project(#ProjectID) → Project(ProjectID)
QUESTION
Quelle requête affiche les employés qui ne sont pas dans le département 3 ou 5 ?A)SELECT * FROM Employee WHERE DepartmentID NOT IN (3,5);B) SELECT * FROM Employee WHERE DepartmentID != (3,5);C) SELECT * FROM Employee WHERE DepartmentID <> (3,5);D) SELECT * FROM Employee WHERE DepartmentID NOT ANY (3,5);❌
✅
❌
❌
View this question
Relational Schema:
Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)Department (DepartmentID, DepartmentName, #ManagerID)Project (ProjectID, ProjectName, StartDate, EndDate, Budget)Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)
Explanation of Relationships:
- Employee (EmployeeID) is the primary key.
- Department (DepartmentID) is the primary key.
- Project (ProjectID) is the primary key.
- Employee_Project (#EmployeeID, #ProjectID) is a composite primary key (many-to-many relationship between Employee and Project).
- Employee(#DepartmentID) REFERENCES Department(DepartmentID): An employee belongs to a department.
- Department(#ManagerID) REFERENCES Employee(EmployeeID): A manager is an employee.
- Employee_Project(#EmployeeID) REFERENCES Employee(EmployeeID)
- Employee_Project(#ProjectID) REFERENCES Project(ProjectID)
QUESTION
Which query displays departments with more than 5 employees?A)SELECT DepartmentID FROM Employee WHERE COUNT(*) > 5;B) SELECT DepartmentID, COUNT(*) FROM Employee GROUP BY DepartmentID HAVING COUNT(*) > 5;C) SELECT DepartmentID, COUNT(*) FROM Employee HAVING COUNT(*) > 5;D) SELECT DepartmentID FROM Employee GROUP BY DepartmentID;❌
❌
❌
✅
View this question
Schéma relationnel :
- Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
- Department (DepartmentID, DepartmentName, #ManagerID)
- Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
- Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)
Explication des relations :
- Employee (
EmployeeID) est la clé primaire. - Department (
DepartmentID) est la clé primaire. - Project (
ProjectID) est la clé primaire. - Employee_Project (
#EmployeeID, #ProjectID) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project). - Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département.
- Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé.
- Employee_Project(#EmployeeID) → Employee(EmployeeID)
- Employee_Project(#ProjectID) → Project(ProjectID)
QUESTION
Quelle requête sélectionne les employés dont le salaire est supérieur à au moins un employé du département 2 ?A)SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);B) SELECT * FROM Employee WHERE Salary > (SELECT MAX(Salary) FROM Employee WHERE DepartmentID = 2);C) SELECT * FROM Employee WHERE Salary = ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);D) SELECT * FROM Employee WHERE Salary < (SELECT Salary FROM Employee WHERE DepartmentID = 2);0%
0%
0%
0%
View this question
Schéma relationnel :
- Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
- Department (DepartmentID, DepartmentName, #ManagerID)
- Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
- Employee_Project (#EmployeeID, #ProjectID, Role, AssignmentDate)
Explication des relations :
- Employee (
EmployeeID) est la clé primaire. - Department (
DepartmentID) est la clé primaire. - Project (
ProjectID) est la clé primaire. - Employee_Project (
#EmployeeID, #ProjectID) est une clé primaire composite (relation plusieurs-à-plusieurs entre Employee et Project). - Employee(#DepartmentID) → Department(DepartmentID) : Un employé appartient à un département.
- Department(#ManagerID) → Employee(EmployeeID) : Un manager est un employé.
- Employee_Project(#EmployeeID) → Employee(EmployeeID)
- Employee_Project(#ProjectID) → Project(ProjectID)
QUESTION
Comment trier les employés par salaire décroissant ?A)SELECT * FROM Employee ORDER BY Salary DESC;B) SELECT * FROM Employee ORDER Salary DESC;C) SELECT * FROM Employee SORT BY Salary DESC;D) SELECT * FROM Employee GROUP BY Salary DESC;0%
0%
0%
0%
View this question
Cette question permet de tester l'affichage en langage mathématique d'un vecteur : .Vous devriez voir cela . Si vous voyez
, essayez avec un autre navigateur.
0%
0%
0%
View this question
Code à observer
100%
0%
View this question
La résistance vaut:
100%
0%
0%
View this question
Cette question permet de tester l'affichage en langage mathématique d'un vecteur : .Vous devriez voir cela . Si vous voyez
, essayez avec un autre navigateur.
0%
100%
0%
View this question