Crowdly
Add to Chrome
Questions Bank (1398906 total)
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?
Ce format de raport NU este menționat în prezentare ca fiind suportat de Jaspersoft Studio?
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 the number of employees per department?A)SELECT COUNT(*) FROM Employee;B) SELECT DepartmentID, COUNT(*) FROM Employee;C) SELECT DepartmentID, COUNT(*) FROM Employee GROUP BY DepartmentID;D) SELECT DepartmentID, COUNT(*) FROM Employee HAVING COUNT(*) > 1;