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

In the relational model of data, what is the result of an algebraic query language?

🔒 Đáp án trong Source VIP

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

What is relational algebra?

🔒 Đáp án trong Source VIP

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

To modify the schema of an existing relation use ____________.

🔒 Đáp án trong Source VIP

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

__________ is a set of one or more attributes taken collectively to uniquely identify a record.

🔒 Đáp án trong Source VIP

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

If a relation is in BCNF, then it is also in.

🔒 Đáp án trong Source VIP

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

Which of the following statements is true regarding Third Normal Form (3NF)?

🔒 Đáp án trong Source VIP

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

Which normalization level ensures that each attribute is dependent only on the primary key?

🔒 Đáp án trong Source VIP

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

In the entity-relationship model, what is the entity?

🔒 Đáp án trong Source VIP

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

What is a derived attribute in an ERD?

🔒 Đáp án trong Source VIP

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

How are many-to-many relationships typically represented in the relational model?

🔒 Đáp án trong Source VIP

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

A Delete command operates on ______ relation.

🔒 Đáp án trong Source VIP

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

What happens if an error occurs during a transaction and it is not explicitly handled or rolled back?

🔒 Đáp án trong Source VIP

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

Which one of the following is not true for a view?

🔒 Đáp án trong Source VIP

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

Which of the following is not mentioned how does a local variable is defined using T-SQL?

🔒 Đáp án trong Source VIP

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

The ______ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

🔒 Đáp án trong Source VIP

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

Which relational algebra operation returns a relation instance containing all tuples that occur in both R and S?

🔒 Đáp án trong Source VIP

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

UPDATE instructor ```sql _____ salary = salary * 1.05; ``` Fill in with correct keyword to update the instructor relation.

🔒 Đáp án trong Source VIP

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

Foreign key constraints are created by using the "_____" keyword to refer to the primary key of another table.

🔒 Đáp án trong Source VIP

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

Which of the following describes an SQL cursor?

🔒 Đáp án trong Source VIP

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

What is a weak entity in an ERD?

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 4 đề 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

In the relational model of data, what is the result of an algebraic query language?

What is relational algebra?

To modify the schema of an existing relation use ____________.

__________ is a set of one or more attributes taken collectively to uniquely identify a record.

If a relation is in BCNF, then it is also in.

Which of the following statements is true regarding Third Normal Form (3NF)?

Which normalization level ensures that each attribute is dependent only on the primary key?

In the entity-relationship model, what is the entity?

What is a derived attribute in an ERD?

How are many-to-many relationships typically represented in the relational model?

A Delete command operates on ______ relation.

What happens if an error occurs during a transaction and it is not explicitly handled or rolled back?

Which one of the following is not true for a view?

Which of the following is not mentioned how does a local variable is defined using T-SQL?

The ______ operation allows the combining of two relations by merging pairs of tuples, one from each relation, into a single tuple.

Which relational algebra operation returns a relation instance containing all tuples that occur in both R and S?

UPDATE instructor ```sql _____ salary = salary * 1.05; ``` Fill in with correct keyword to update the instructor relation.

Foreign key constraints are created by using the "_____" keyword to refer to the primary key of another table.

Which of the following describes an SQL cursor?

What is a weak entity in an ERD?