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

Suppose we have a relation $R(A,B,C,D,E,F,N)$ and functional dependencies: $F \to A \to B$, $B \to C$, $BC \to A$, $A \to D$, $E \to A$, $D \to E$. Which of the following is not a key?

🔒 Đáp án trong Source VIP

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

Which data model introduced the concept of tables with rows and columns?

🔒 Đáp án trong Source VIP

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

Which of the following best describes an entity in an ERD (Entity-Relationship Diagram)?

🔒 Đáp án trong Source VIP

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

Which SQL statements will correctly update the salary of all employees by 10% where job title is 'Manager'?

🔒 Đáp án trong Source VIP

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

Which of the following wildcard characters matches any sequence of zero or more characters in a string comparison?

🔒 Đáp án trong Source VIP

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

Given a relation R(A,B,C,D) with the key is A, the foreign key is D. And the query: “select A, count(D) from R group by D” What is the output of the query?

🔒 Đáp án trong Source VIP

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

In a binary relationship with cardinality $(1, N)$, what does it signify?

🔒 Đáp án trong Source VIP

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

Which of the following statements is false regarding SQL Correlated sub-queries?

🔒 Đáp án trong Source VIP

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

Consider a relation $R(A,B,C,D)$ with functional dependencies: $A \to C$, $AB \to A$, $A \to CB$, $AD \to ABC$. Which of the following is a trivial functional dependency of the relation?

🔒 Đáp án trong Source VIP

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

Which of the following best describes Atomicity in transactions?

🔒 Đáp án trong Source VIP

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

Suppose we have defined VIEW ParamountMovies from the Movies table. When we execute the command:\nDROP TABLE Movies\nwhich of the following statements is correct?

🔒 Đáp án trong Source VIP

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

In ER modeling, what does a weak entity require in order to be uniquely identified?

🔒 Đáp án trong Source VIP

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

Which of the following SQL statement returns all rows from Cars where year is greater than 2019?

🔒 Đáp án trong Source VIP

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

Trong SQL, mục đích của câu lệnh CLOSE liên quan đến cursor là gì?

🔒 Đáp án trong Source VIP

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

Which of the following violates 1NF (First Normal Form)?

🔒 Đáp án trong Source VIP

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

In SQL, which of the following statements is correct?

🔒 Đáp án trong Source VIP

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

Given the relational schema $R(A,B,C,D,E)$ and the set of functional dependencies: $F=\{AB\to C, B\to D, C\to E, D\to B\}$.\nWhat is the closure of the attribute set $\{A,B\}$?

🔒 Đáp án trong Source VIP

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

Assume that you are required to develop an application to manage courses at the university, which requires: Structured data (tables, rows, columns), strict consistency, and the need to use complex queries. The enforcement of ACID properties (Atomicity, Consistency, Isolation, Durability). In the context of databases, which most appropriate data model should you choose for developing this application?

🔒 Đáp án trong Source VIP

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

In the relational model, what is the main purpose of using a primary key in a table?

🔒 Đáp án trong Source VIP

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

Suppose we have a relation $R(A,B,C,D,E,F,N)$ and functional dependencies: $F \to A \to B$, $B \to C$, $BC \to A$, $A \to D$, $E \to A$, $D \to E$. Which of the following is not a key?

Which data model introduced the concept of tables with rows and columns?

Which of the following best describes an entity in an ERD (Entity-Relationship Diagram)?

Which SQL statements will correctly update the salary of all employees by 10% where job title is 'Manager'?

Which of the following wildcard characters matches any sequence of zero or more characters in a string comparison?

Given a relation R(A,B,C,D) with the key is A, the foreign key is D. And the query: “select A, count(D) from R group by D” What is the output of the query?

In a binary relationship with cardinality $(1, N)$, what does it signify?

Which of the following statements is false regarding SQL Correlated sub-queries?

Consider a relation $R(A,B,C,D)$ with functional dependencies: $A \to C$, $AB \to A$, $A \to CB$, $AD \to ABC$. Which of the following is a trivial functional dependency of the relation?

Which of the following best describes Atomicity in transactions?

Suppose we have defined VIEW ParamountMovies from the Movies table. When we execute the command:\nDROP TABLE Movies\nwhich of the following statements is correct?

In ER modeling, what does a weak entity require in order to be uniquely identified?

Which of the following SQL statement returns all rows from Cars where year is greater than 2019?

Trong SQL, mục đích của câu lệnh CLOSE liên quan đến cursor là gì?

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

Which of the following violates 1NF (First Normal Form)?

In SQL, which of the following statements is correct?

Given the relational schema $R(A,B,C,D,E)$ and the set of functional dependencies: $F=\{AB\to C, B\to D, C\to E, D\to B\}$.\nWhat is the closure of the attribute set $\{A,B\}$?

In the relational model, what is the main purpose of using a primary key in a table?