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 data normalization in the context of the database design?

🔒 Đáp án trong Source VIP

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

_____ Real-world thing, distinguishable from other objects, in ERD

🔒 Đáp án trong Source VIP

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

Insert into Students ________ (32, N'Iona Bush', N'Female'); In the given query which of the keyword has to be inserted?

🔒 Đáp án trong Source VIP

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

We can use these _____ in SQL queries and other statements to perform computations that cannot be done with SQL alone.

🔒 Đáp án trong Source VIP

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

What are logical constraints?

🔒 Đáp án trong Source VIP

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

A(n) _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

🔒 Đáp án trong Source VIP

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

What is the primary goal of normalization in database design?

🔒 Đáp án trong Source VIP

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

What are some benefits of normalization when converting an ERD to a relational model?

🔒 Đáp án trong Source VIP

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

How are composite attributes represented in the relational model?

🔒 Đáp án trong Source VIP

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

What is the main disadvantage of having too many indexes on a table?

🔒 Đáp án trong Source VIP

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

In a network data model, a node can be linked to multiple other nodes. What is this relationship called?

🔒 Đáp án trong Source VIP

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

To convert a table to First Normal Form (1NF), what step must be taken?

🔒 Đáp án trong Source VIP

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

A primary key is combined with a foreign key creates:

🔒 Đáp án trong Source VIP

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

What is a composite key in an ERD?

🔒 Đáp án trong Source VIP

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

In SQL ERD use three types of principle elements to form relationships:

🔒 Đáp án trong Source VIP

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

What happens to derived attributes when converting an ERD to a relational model?

🔒 Đáp án trong Source VIP

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

What data type is best suited for Vietnamese name? (in SQL Server)

🔒 Đáp án trong Source VIP

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

What is not the purpose of the index in MS-SQL Server?

🔒 Đáp án trong Source VIP

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

Which SQL command is used to undo changes made by a transaction?

🔒 Đáp án trong Source VIP

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

Transaction processing is associated with everything below except.

🔒 Đáp án trong Source VIP

DBI202Đã xuất hiện trong 3 đề 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 data normalization in the context of the database design?

_____ Real-world thing, distinguishable from other objects, in ERD

Insert into Students ________ (32, N'Iona Bush', N'Female'); In the given query which of the keyword has to be inserted?

We can use these _____ in SQL queries and other statements to perform computations that cannot be done with SQL alone.

What are logical constraints?

A(n) _____ is a property of the entire relation, rather than of the individual tuples in which each tuple is unique.

What is the primary goal of normalization in database design?

What are some benefits of normalization when converting an ERD to a relational model?

How are composite attributes represented in the relational model?

What is the main disadvantage of having too many indexes on a table?

In a network data model, a node can be linked to multiple other nodes. What is this relationship called?

To convert a table to First Normal Form (1NF), what step must be taken?

A primary key is combined with a foreign key creates:

What is a composite key in an ERD?

In SQL ERD use three types of principle elements to form relationships:

What happens to derived attributes when converting an ERD to a relational model?

What data type is best suited for Vietnamese name? (in SQL Server)

What is not the purpose of the index in MS-SQL Server?

Which SQL command is used to undo changes made by a transaction?

Transaction processing is associated with everything below except.