Crowdly
Додати до Chrome
Questions Bank (1278098 total)
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) RÉFÉRENCE Department(DepartmentID) : Un employé appartient à un département.
- Department(#ManagerID) RÉFÉRENCE Employee(EmployeeID) : Un manager de département est un employé.
- Employee_Project(#EmployeeID) RÉFÉRENCE Employee(EmployeeID) : Associe un employé à un projet.
- Employee_Project(#ProjectID) RÉFÉRENCE Project(ProjectID) : Associe un projet à un employé.
QUESTION
Quelle requête permet d'afficher les employés et le nom de leur département ?A)SELECT * FROM Employee INNER JOIN Department;B) SELECT Employee.FirstName, Employee.LastName, Department.DepartmentName FROM Employee JOIN Department ON Employee.DepartmentID = Department.DepartmentID;C) SELECT FirstName, LastName FROM Employee, Department;D) SELECT Employee.FirstName, Employee.LastName, Department.DepartmentName FROM Employee RIGHT JOIN Department;Parmi les relations définies sur suivantes cocher celles qui sont des relations d'équivalence
Si A et B sont deux parties d'un même ensemble E, les relations et sont équivalentes.
La relation d'inclusion au sens large entre parties d'un même ensemble est une relation d'ordre.
Deux classes d'équivalence qui ont un élément commun sont confondues.
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
How do you sort employees by salary in descending order?A) SELECT * FROM Employee ORDER Salary DESC;B) SELECT * FROM Employee ORDER BY Salary DESC;C) SELECT * FROM Employee SORT BY Salary DESC;D) SELECT * FROM Employee GROUP BY Salary DESC;
Ce permite utilizarea expresiilor personalizate în Jaspersoft?
Asociază fiecare categorie de raport cu domeniul său specific:
Which of the following molecules act as building blocks (monomers) of polypeptides?