Crowdly
Add to Chrome
Questions Bank (1278122 total)
Ja taisnstūra paralēlskaldņa pamata malu garumi ir 9 cm un 12 cm, bet diagonālšķēlums ir kvadrāts, tad paralēlskaldņa augstums ir ... cm.
Atbildē raksti tikai skaitli!
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 all employees in department 2?A) SELECT * FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);B) SELECT * FROM Employee WHERE Salary > (SELECT Salary FROM Employee WHERE DepartmentID = 2);C) SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);D) SELECT * FROM Employee WHERE Salary IN (SELECT Salary FROM Employee WHERE DepartmentID = 2);
Kurš no nosauktajiem ķermeņiem nav daudzskaldnis?
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 à tous les employés du département 2 ?A) SELECT * FROM Employee WHERE Salary > ALL (SELECT Salary FROM Employee WHERE DepartmentID = 2);B) SELECT * FROM Employee WHERE Salary > (SELECT Salary FROM Employee WHERE DepartmentID = 2);C) SELECT * FROM Employee WHERE Salary > ANY (SELECT Salary FROM Employee WHERE DepartmentID = 2);D) SELECT * FROM Employee WHERE Salary IN (SELECT Salary FROM Employee WHERE DepartmentID = 2);
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 retrieves all employees with a salary greater than 50,000?A) SELECT * FROM Employee WHERE Salary >= 50000;B) SELECT Salary FROM Employee WHERE Salary >= 50000;C) SELECT * FROM Employee HAVING Salary >= 50000;D) SELECT * FROM Employee GROUP BY Salary >= 50000;
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 retrieves employees who are not in department 3 or 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);