Câu hỏi gốc môn DBI202

524 câu gốc, sắp theo số đề từng chứa câu đó.

20 kết quả phù hợp nhất

What is the purpose of the RENAME operation in relational algebra?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Which operation is not part of basic relational algebra?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Given a relation: Laptop(model, speed, ram, hd, price) What will this function return when called with dbo.GetLaptopPrice(1)? ```sql CREATE FUNCTION dbo.GetLaptopPrice (@model INT) RETURNS BIGINT AS BEGIN DECLARE @price BIGINT SELECT @price = price FROM Laptop WHERE model = @model RETURN @price END ```

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

The key for a weak entity set is _?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

What type of attribute in an ER diagram is represented with a dashed oval?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

The Isolation property in transactions ensures that:

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Given relation $R(X, Y, Z, W)$ with the set of functional dependencies: $F = \{X o Y,\ Y o Z,\ Z o W\}$. Which of the following is a key for $R$?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

If two entities in an ER model share the same attribute name but represent different meanings, what should be done during schema transformation?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

In which of the following is a single-entity instance of one type related to many entity instances of another type?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Which two statements about foreign key constraints are true? (Choose two correct answers)

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

What is the result of a CROSS JOIN in SQL?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Given two relations:\nPrinter(maker, model, type)\nPC(model, speed, ram, hd, price) \nWhat does this query return? \nSELECT maker FROM Product WHERE model NOT IN ( SELECT model FROM PC );

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Which of the following accurately represents the purpose of a transaction in a database system? Choose two answers.

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Triggers are stored blocks of code that have to be called in order to operate.

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

In an ER diagram, what does a double rectangle represent?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Generally, what parts does a data model include in the context of a database?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

A functional dependency $X \to Y$ means:

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

A natural join joins two relations by:

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

To completely remove a table and its data in SQL, we use:

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Consider the statement: "Once money is transferred, it won’t disappear due to a power outage." In database transactions, which property does this statement exemplify?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 2 đề thi

Đang tải dữ liệu

Đang tải dữ liệu

Đang tải dữ liệu

Câu hỏi gốc môn DBI202

What is the purpose of the RENAME operation in relational algebra?

Which operation is not part of basic relational algebra?

The key for a weak entity set is _?

What type of attribute in an ER diagram is represented with a dashed oval?

The Isolation property in transactions ensures that:

Given relation $R(X, Y, Z, W)$ with the set of functional dependencies: $F = \{X o Y,\ Y o Z,\ Z o W\}$. Which of the following is a key for $R$?

If two entities in an ER model share the same attribute name but represent different meanings, what should be done during schema transformation?

In which of the following is a single-entity instance of one type related to many entity instances of another type?

Which two statements about foreign key constraints are true? (Choose two correct answers)

What is the result of a CROSS JOIN in SQL?

Given two relations:\nPrinter(maker, model, type)\nPC(model, speed, ram, hd, price) \nWhat does this query return? \nSELECT maker FROM Product WHERE model NOT IN ( SELECT model FROM PC );

Which of the following accurately represents the purpose of a transaction in a database system? Choose two answers.

Triggers are stored blocks of code that have to be called in order to operate.

In an ER diagram, what does a double rectangle represent?

Generally, what parts does a data model include in the context of a database?

A functional dependency $X \to Y$ means:

A natural join joins two relations by:

To completely remove a table and its data in SQL, we use:

Consider the statement: "Once money is transferred, it won’t disappear due to a power outage." In database transactions, which property does this statement exemplify?