Crowdly
Додати до Chrome
Fundamental of databases (2025-2026)
Шукаєте відповіді та рішення тестів для Fundamental of databases (2025-2026)? Перегляньте нашу велику колекцію перевірених відповідей для Fundamental of databases (2025-2026) в moodle.usth.edu.vn.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
Supposed we have a table Employee that contains the id (emp_id), name (emp_name) and working experience (experience) of each employee in a company. Write a query to find the second employee in terms of experience in increasing order? (first being the one with max experience)
Which of the following is NOT true about SQL Subqueries?
A UNION query is which of the following?
CREATE TRIGGER Products_Delete
ON Products
FOR DELETE
AS
IF (SELECT COUNT(*) FROM [Order Details] OD
WHERE OD.ProductID = (SELECT ProductID FROM Deleted)) > 0
BEGIN
PRINT 'Violate Foreign key reference. Rollback!!!'
ROLLBACK TRAN
END
What is the effect of this trigger?
The ER model is meant to
Consider the following schema –
STUDENTS (student_code, first_name, last_name, email, phone_no, date_of_birth, honours_subject, percentage_of_marks);
Which of the following query would display the names of all the students whose honours subject is English and percentage of marks more than 80, or honours subject is Spanish and percentage of marks more than 80?
Consider relation R(A, B, C, D) with FDs:
- AB → C
- C → D
Primary Key = {AB}.
Suppose that all attributes are atomic and single value. What is the highest normal form of R?
Suppose the university creates:
CREATE VIEW Public_Students AS
SELECT id, name, major
FROM Students;
Why might the DBA grant access to this view instead of the base Students table?
Which of the following relations is in Third normal form (3NF)?
What does this following query do?
SELECT customer_id, COUNT (orders)
FROM Sales
GROUP BY customer_id
HAVING COUNT(orders) >5;