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

Normalization is

🔒 Đáp án trong Source VIP

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

What is the difference between DELETE and TRUNCATE in SQL?

🔒 Đáp án trong Source VIP

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

The Data Definition Language (DDL) in SQL is used to:

🔒 Đáp án trong Source VIP

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

In SQL, converting an E/R design to a relational database schema is including:

🔒 Đáp án trong Source VIP

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

The intersection operator is used to get the _____ tuples.

🔒 Đáp án trong Source VIP

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

How many joins are required for 6 tables to join straight?

🔒 Đáp án trong Source VIP

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

Which of the following statements is/are TRUE? (1) A column with FOREIGN KEY constraint does not allow duplicate values. (2) A FOREIGN KEY constraint can be defined to refer to columns with the UNIQUE constraint in another table.

🔒 Đáp án trong Source VIP

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

Consider the join of a relation $R$ with relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples, then the maximum size of join is:

🔒 Đáp án trong Source VIP

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

Suppose relation $R(A, B)$ has the following tuples: | A | B | | :--- | :--- | | a | 5 | | b | 7 | | h | 8 | | m | 3 | | c | 6 | | b | 2 | | a | 9 | Which tuple is contained in the result of the following query: ```sql SELECT * FROM R WHERE A LIKE 'a%' UNION SELECT * FROM R WHERE B > 7; ```

🔒 Đáp án trong Source VIP

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

Regarding the difference between WHERE and HAVING in SQL, which of the following is true?

🔒 Đáp án trong Source VIP

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

In SQL, a view is a virtual table based on the result-set of an SQL statement. Which statement is not correct about view?

🔒 Đáp án trong Source VIP

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

How can you delete a user-defined function in SQL?

🔒 Đáp án trong Source VIP

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

The following SQL statement creates a stored procedure that selects Customers from a particular City with a particular PostalCode from the "Customers" table: ```sql CREATE PROCEDURE SelectAllCustomers @City nvarchar(30), @PostalCode nvarchar(10) AS BEGIN SELECT * FROM Customers WHERE City = @City AND PostalCode = @PostalCode; END; GO ``` Which of the following is the way to execute a procedure?

🔒 Đáp án trong Source VIP

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

Which of the following is an example of NoSQL database systems, which are not based on the relational model?

🔒 Đáp án trong Source VIP

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

Suppose relation R(A, B, C, D) has the following tuples: | A | B | C | D | |---|---|---|------| | 1 | a | 101 | 1000 | | 2 | b | 102 | 1500 | | 3 | c | 101 | 1500 | | 4 | d | 101 | 2000 | | 5 | e | 102 | 1000 | | 6 | f | 101 | 3000 | | 7 | g | 101 | 4000 | Which tuple is contained in the result of the following query: ```sql SELECT C , AVG(D) FROM R GROUP BY C HAVING AVG(D) > 1000 ORDER BY C ```

🔒 Đáp án trong Source VIP

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

The primary key is selected from the:

🔒 Đáp án trong Source VIP

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

Given following schema $R(A, B, C, D)$ and $S=\{A \to B, B \to C, C \to D\}$ Compute $(A)^+ ?$

🔒 Đáp án trong Source VIP

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

Relationships in the E/R model are also represented by relations. The relation for a given relationship R has the following attributes: If the relationship has attributes, then these are also attributes of relation R.

🔒 Đáp án trong Source VIP

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

Which type of relationship connects two entities where one entity can have multiple associations with another entity, but the second entity can only have one association with the first entity?

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

Normalization is

What is the difference between DELETE and TRUNCATE in SQL?

The Data Definition Language (DDL) in SQL is used to:

In SQL, converting an E/R design to a relational database schema is including:

The intersection operator is used to get the _____ tuples.

How many joins are required for 6 tables to join straight?

Which of the following statements is/are TRUE? (1) A column with FOREIGN KEY constraint does not allow duplicate values. (2) A FOREIGN KEY constraint can be defined to refer to columns with the UNIQUE constraint in another table.

Consider the join of a relation $R$ with relation $S$. If $R$ has $m$ tuples and $S$ has $n$ tuples, then the maximum size of join is:

Suppose relation $R(A, B)$ has the following tuples: | A | B | | :--- | :--- | | a | 5 | | b | 7 | | h | 8 | | m | 3 | | c | 6 | | b | 2 | | a | 9 | Which tuple is contained in the result of the following query: ```sql SELECT * FROM R WHERE A LIKE 'a%' UNION SELECT * FROM R WHERE B > 7; ```

Regarding the difference between WHERE and HAVING in SQL, which of the following is true?

In SQL, a view is a virtual table based on the result-set of an SQL statement. Which statement is not correct about view?

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

How can you delete a user-defined function in SQL?

Which of the following is an example of NoSQL database systems, which are not based on the relational model?

The primary key is selected from the:

Given following schema $R(A, B, C, D)$ and $S=\{A \to B, B \to C, C \to D\}$ Compute $(A)^+ ?$

Relationships in the E/R model are also represented by relations. The relation for a given relationship R has the following attributes: If the relationship has attributes, then these are also attributes of relation R.

Which type of relationship connects two entities where one entity can have multiple associations with another entity, but the second entity can only have one association with the first entity?