logo

Crowdly

Browser

Додати до Chrome

CC - P2 - Promo 2028

Шукаєте відповіді та рішення тестів для CC - P2 - Promo 2028? Перегляньте нашу велику колекцію перевірених відповідей для CC - P2 - Promo 2028 в moodle.myefrei.fr.

Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!

Schéma relationnel :

  1. Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
  2. Department (DepartmentID, DepartmentName, #ManagerID)
  3. Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
  4. 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

❌
✅
❌
❌
Переглянути це питання

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);

❌
✅
❌
❌
Переглянути це питання

Schéma relationnel :

  1. Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
  2. Department (DepartmentID, DepartmentName, #ManagerID)
  3. Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
  4. 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);

❌
✅
❌
❌
Переглянути це питання

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;

❌
❌
❌
✅
Переглянути це питання

Schéma relationnel :

  1. Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
  2. Department (DepartmentID, DepartmentName, #ManagerID)
  3. Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
  4. 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%
Переглянути це питання

Schéma relationnel :

  1. Employee (EmployeeID, FirstName, LastName, Email, Phone, HireDate, Salary, #DepartmentID)
  2. Department (DepartmentID, DepartmentName, #ManagerID)
  3. Project (ProjectID, ProjectName, StartDate, EndDate, Budget)
  4. 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%
Переглянути це питання

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%
Переглянути це питання

Code à observer

100%
0%
Переглянути це питання

La résistance vaut:

100%
0%
0%
Переглянути це питання

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%
Переглянути це питання

Хочете миттєвий доступ до всіх перевірених відповідей на moodle.myefrei.fr?

Отримайте необмежений доступ до відповідей на екзаменаційні питання - встановіть розширення Crowdly зараз!

Browser

Додати до Chrome

TelegramInstagramTikTokQuestion Bank
Умови використанняЗв'яжіться з нами