Crowdly
Додати до Chrome
Fundamental of databases (2025-2026)
Шукаєте відповіді та рішення тестів для Fundamental of databases (2025-2026)? Перегляньте нашу велику колекцію перевірених відповідей для Fundamental of databases (2025-2026) в moodle.usth.edu.vn.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1002,Joey,2000);
Which of the following is not an aggregate function in SQL?
Suppose relation R(A,B,C) has the tuples:
A
|
B
|
C
|
1
|
2
|
3
|
4
|
2
|
3
|
4
|
5
|
6
|
2
|
5
|
3
|
1
|
2
|
6
|
Compute the projection π
C,B(R), and
identify one of its tuples from the list below.
Which of the following columns cannot be directly indexed without extra mechanisms?
Which keyword allows us to find the unique values in the database?
Consider relation Student(ID, Name, Major, Dept, HOD) with FDs:
ID → Name, Major
Major → Dept
Dept → HOD
Primary Key = {ID}
What is the highest normal form?Given R(A,B,C,D,E,F) and S={A→C,A→D,D→E,E→F}, what is A+
Which of the following clauses in SQL allows us to extract data in a range?
CREATE TRIGGER Products_Update
ON Products
FOR UPDATE
AS
INSERT INTO PriceTracking(ProductID, Time, OldPrice, NewPrice)
SELECT I.ProductID, GETDATE(), D.UnitPrice, I.UnitPrice
FROM Inserted I
INNER JOIN Deleted D
ON I.ProductID = D.ProductID
AND I.UnitPrice <> D.UnitPrice;
What is the purpose of this trigger?
Which of the following is used to modify the data stored in the database?