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

Which of the following is used to invoke a procedure in SQL?

🔒 Đáp án trong Source VIP

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

Suppose you have a table Employees(id, name, salary). To increase the salary of employees with a salary below 5000 by 10%, which of the following statements is correct?

🔒 Đáp án trong Source VIP

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

Given the set of functional dependencies $F=\{AB \to C,\ C \to D\}$. Determine the highest normal form of the relation $R(A,B,C,D)$.

🔒 Đáp án trong Source VIP

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

What is the main requirement of the First Normal Form (1NF) in database design?

🔒 Đáp án trong Source VIP

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

Which of the following best defines a functional dependency $X \to Y$ in a relation $R$?

🔒 Đáp án trong Source VIP

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

Which clause controls the order of query results?

🔒 Đáp án trong Source VIP

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

Which SQL object speeds up access to data in a table?

🔒 Đáp án trong Source VIP

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

Given two relations and its data: Student (ID, NAME) | ID | NAME | | :--- | :--- | | 1 | a | | 2 | b | Enroll (ID, COURSE) | ID | COURSE | | :--- | :--- | | 1 | Math | | 1 | Physical | | 2 | Math | In relational algebra, what is the output of the natural join?

🔒 Đáp án trong Source VIP

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

An E/R diagram is a graph that represents sets of entities, attributes, and relationships. Elements of each of these types are represented by nodes of the graph, and what three special node shapes indicate the type?

🔒 Đáp án trong Source VIP

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

Which two statements correctly describe stored procedures?

🔒 Đáp án trong Source VIP

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

Consider the relation: OrderDetail (orderNumber, productCode, productName, quantity, dateOrdered, salesDiscount). And FDs: $$\begin{aligned}(orderNumber, productCode) &\to quantity \\ orderNumber &\to dateOrdered \\ productCode &\to productName, salesDiscount\end{aligned}$$ And the key of OrderDetail is $\{orderNumber, productCode\}$. Which of the following is full dependency on the key?

🔒 Đáp án trong Source VIP

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

When converting a multivalued attribute from an ER model to a relational model using 1NF normalization, what is the most appropriate approach?

🔒 Đáp án trong Source VIP

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

To include integrity constraint in a existing relation use

🔒 Đáp án trong Source VIP

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

What is "normalization"?

🔒 Đáp án trong Source VIP

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

The highest normal form for relation schema R(A,B,C) with functional dependencies: F = {AB->C; B->A; C->B} is:

🔒 Đáp án trong Source VIP

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

Given the relation Employee(SSN, FNAME, LNAME, SALARY, DepartmentNo). Select the right query below to count the number of employees in each department.

🔒 Đáp án trong Source VIP

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

A database transaction, by definition, must be ACID (atomic, consistent, isolated and durable). What does "Consistent" mean?

🔒 Đáp án trong Source VIP

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

A person who is responsible for the structure or schema of the database is called:

🔒 Đáp án trong Source VIP

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

The key for a weak entity set E is ........

🔒 Đáp án trong Source VIP

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

For what values of x, y, and z, including NULL, does the Boolean expression $x <= 100$ AND NOT($y >= 15$ OR $z = 35$) have the truth value UNKNOWN? Identify one of those values from the list below.

🔒 Đá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

Which of the following is used to invoke a procedure in SQL?

Suppose you have a table Employees(id, name, salary). To increase the salary of employees with a salary below 5000 by 10%, which of the following statements is correct?

Given the set of functional dependencies $F=\{AB \to C,\ C \to D\}$. Determine the highest normal form of the relation $R(A,B,C,D)$.

What is the main requirement of the First Normal Form (1NF) in database design?

Which of the following best defines a functional dependency $X \to Y$ in a relation $R$?

Which clause controls the order of query results?

Which SQL object speeds up access to data in a table?

Given two relations and its data: Student (ID, NAME) | ID | NAME | | :--- | :--- | | 1 | a | | 2 | b | Enroll (ID, COURSE) | ID | COURSE | | :--- | :--- | | 1 | Math | | 1 | Physical | | 2 | Math | In relational algebra, what is the output of the natural join?

An E/R diagram is a graph that represents sets of entities, attributes, and relationships. Elements of each of these types are represented by nodes of the graph, and what three special node shapes indicate the type?

Which two statements correctly describe stored procedures?

When converting a multivalued attribute from an ER model to a relational model using 1NF normalization, what is the most appropriate approach?

To include integrity constraint in a existing relation use

What is "normalization"?

The highest normal form for relation schema R(A,B,C) with functional dependencies: F = {AB->C; B->A; C->B} is:

Given the relation Employee(SSN, FNAME, LNAME, SALARY, DepartmentNo). Select the right query below to count the number of employees in each department.

A database transaction, by definition, must be ACID (atomic, consistent, isolated and durable). What does "Consistent" mean?

A person who is responsible for the structure or schema of the database is called:

The key for a weak entity set E is ........

For what values of x, y, and z, including NULL, does the Boolean expression $x <= 100$ AND NOT($y >= 15$ OR $z = 35$) have the truth value UNKNOWN? Identify one of those values from the list below.