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 a foreign key in an ERD?

🔒 Đáp án trong Source VIP

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

The % wildcard when used with the LIKE keyword is used to represent a string of characters:

🔒 Đáp án trong Source VIP

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

In an UPDATE statement, what does the WHERE clause determine?

🔒 Đáp án trong Source VIP

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

In SQL, what is a view?

🔒 Đáp án trong Source VIP

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

Which of the following is used to define code that is fired when certain actions or event occur?

🔒 Đáp án trong Source VIP

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

In SQL, what is the primary advantage of using stored procedures?

🔒 Đáp án trong Source VIP

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

Correct statement about Stored Procedures

🔒 Đáp án trong Source VIP

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

A person or persons responsible for the structure or schema of the database is ________.

🔒 Đáp án trong Source VIP

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

In the context of a DBMS, what is meant by "data integrity"?

🔒 Đáp án trong Source VIP

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

If there is more than one key for relation schema in DBMS then each key relation schema is classified as

🔒 Đáp án trong Source VIP

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

Consider a relation with schema $R(A, B, C, D)$ and FD's $(A \to B, B \to C, B \to D, D \to A)$. Which of the following is the $\{A\}^{+}$?

🔒 Đáp án trong Source VIP

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

In an ERD, what role does a primary key play?

🔒 Đáp án trong Source VIP

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

Regarding difference between a primary key vs. unique key, which of the following is false?

🔒 Đáp án trong Source VIP

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

Two concurrent executing transactions T1 and T2 are allowed to update the same record in an uncontrolled manner. In such a scenario, the following problem may not occur if database system has no concurrency module and allows concurrent execution of above two transactions. Which of the following is correct in this case?

🔒 Đáp án trong Source VIP

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

Consider the table named “Boat”. Which option is the correct relation schema for the table?

🔒 Đáp án trong Source VIP

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

Consider the relation $R(A,B,C,D)$ and functional dependencies: $A \to B$, $C \to D$. Find key of the above relation.

🔒 Đáp án trong Source VIP

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

Assume that there is a table: And functional dependencies $\{ID \to NAME, ID \to Age, TAX\_NUMBER \to NAME, AGE, ID \to TAX\_NUMBER\}$. You are required to specify keys: primary key and unique key for the table “Employee”. Choose the most appropriate option for the table.

🔒 Đáp án trong Source VIP

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

Consider the relation $R(A,B,C,D,E,F,G,K)$ and functional dependencies: $A,B \to C$, $B \to C$, $C \to A,D$, $D \to E$, $C,F \to B$, $G \to K$. What is the closure of $\{A,B\}$?

🔒 Đáp án trong Source VIP

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

A stored procedure in SQL is a __________.

🔒 Đáp án trong Source VIP

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

Which normalization form eliminates transitive dependency?

🔒 Đá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 a foreign key in an ERD?

The % wildcard when used with the LIKE keyword is used to represent a string of characters:

In an UPDATE statement, what does the WHERE clause determine?

In SQL, what is a view?

Which of the following is used to define code that is fired when certain actions or event occur?

In SQL, what is the primary advantage of using stored procedures?

Correct statement about Stored Procedures

A person or persons responsible for the structure or schema of the database is ________.

In the context of a DBMS, what is meant by "data integrity"?

If there is more than one key for relation schema in DBMS then each key relation schema is classified as

Consider a relation with schema $R(A, B, C, D)$ and FD's $(A \to B, B \to C, B \to D, D \to A)$. Which of the following is the $\{A\}^{+}$?

In an ERD, what role does a primary key play?

Regarding difference between a primary key vs. unique key, which of the following is false?

Consider the table named “Boat”. Which option is the correct relation schema for the table?

Consider the relation $R(A,B,C,D)$ and functional dependencies: $A \to B$, $C \to D$. Find key of the above relation.

Assume that there is a table: And functional dependencies $\{ID \to NAME, ID \to Age, TAX\_NUMBER \to NAME, AGE, ID \to TAX\_NUMBER\}$. You are required to specify keys: primary key and unique key for the table “Employee”. Choose the most appropriate option for the table.

Consider the relation $R(A,B,C,D,E,F,G,K)$ and functional dependencies: $A,B \to C$, $B \to C$, $C \to A,D$, $D \to E$, $C,F \to B$, $G \to K$. What is the closure of $\{A,B\}$?

A stored procedure in SQL is a __________.

Which normalization form eliminates transitive dependency?