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

Sub-queries can be nested in?

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

Which of the following SQL statement returns the number of Service Tickets placed by each customer?

🔒 Đáp án trong Source VIP

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

Which of the following command is correct to delete the values in the relation teaches?

🔒 Đáp án trong Source VIP

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

Suppose relation R(A, B) has the following tuples: | A | B | |---|---| | 1 | a | | 2 | b | | 3 | a | | 4 | d | | 5 | e | | 6 | a | | 7 | g | The SQL statement to count distinct rows from column B in relation R is:

🔒 Đáp án trong Source VIP

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

What is the result of ROLLBACK?

🔒 Đáp án trong Source VIP

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

In which line of the following code is the error? CREATE TRIGGER trigger1 -- 1 ON dbo.EMPLOYEE -- 2 AFTER FOR INSERT AS -- 3 BEGIN -- 4 INSERT INTO EMPLOYEE_BACKUP -- 5 SELECT * FROM INSERTED -- 6 END -- 7

🔒 Đáp án trong Source VIP

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

Which of the following SQL statement to return all rows from both the Mechanic and ServiceMechanic tables, the result will contain NULLs for the missing values on the side without a match?

🔒 Đáp án trong Source VIP

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

In SQL, which of the following operation is used to remove duplicate rows from a query result?

🔒 Đáp án trong Source VIP

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

Consider a relation $R(A,B,C,D)$ and FDs \{$AB \to C$, $C \to D$, $D \to A$\}. What are all the keys of $R$?

🔒 Đáp án trong Source VIP

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

Which of the following statement is used to insert data from table Customer_Service to table Customer?

🔒 Đáp án trong Source VIP

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

Which property of ACID transactions ensures that a transaction, once committed, remains committed even in the event of a system failure?

🔒 Đáp án trong Source VIP

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

Giả sử ta có một quan hệ: $R(ID,\ \text{full name},\ \text{address})$ và tập phụ thuộc hàm $FDs:\ \{ID\to\text{full name},\ ID\to\text{address}\}$. Dạng chuẩn cao nhất của $R$ trong thiết kế cơ sở dữ liệu quan hệ là gì? Chọn các đáp án đúng.

🔒 Đáp án trong Source VIP

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

The following SQL statement creates a stored procedure that count number of customers in each City from the "Customers" table: CREATE PROCEDURE CountOfCustomers @City nvarchar(30), @CountCus int OUTPUT AS SET @CountCus = ( SELECT COUNT(CustomerID) FROM Customers WHERE City = @City GROUP BY City ) 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

Given two relations: R(A,B,C,D) with the primary key is A, and S(D,E,F) with the unique key is D. How to make a R.D foreign key referencing S.D?

🔒 Đáp án trong Source VIP

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

Consider the following table: (StudentID, StudentName, CourseID, CourseName, InstructorName, InstructorEmail) Redesign the table structure to achieve at least Third Normal Form (3NF).

🔒 Đáp án trong Source VIP

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

How can you rename multiple attributes simultaneously in Relational Algebra?

🔒 Đáp án trong Source VIP

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

Choose the incorrect statement about DELETE and TRUNCATE in SQL Server.

🔒 Đáp án trong Source VIP

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

Which of the following is an example of a violation of 2NF?

🔒 Đáp án trong Source VIP

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

Which of the following is not involved in DBMS?

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

Sub-queries can be nested in?

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?

Which of the following SQL statement returns the number of Service Tickets placed by each customer?

Which of the following command is correct to delete the values in the relation teaches?

Suppose relation R(A, B) has the following tuples: | A | B | |---|---| | 1 | a | | 2 | b | | 3 | a | | 4 | d | | 5 | e | | 6 | a | | 7 | g | The SQL statement to count distinct rows from column B in relation R is:

What is the result of ROLLBACK?

In which line of the following code is the error? CREATE TRIGGER trigger1 -- 1 ON dbo.EMPLOYEE -- 2 AFTER FOR INSERT AS -- 3 BEGIN -- 4 INSERT INTO EMPLOYEE_BACKUP -- 5 SELECT * FROM INSERTED -- 6 END -- 7

Which of the following SQL statement to return all rows from both the Mechanic and ServiceMechanic tables, the result will contain NULLs for the missing values on the side without a match?

In SQL, which of the following operation is used to remove duplicate rows from a query result?

Consider a relation $R(A,B,C,D)$ and FDs \{$AB \to C$, $C \to D$, $D \to A$\}. What are all the keys of $R$?

Which of the following statement is used to insert data from table Customer_Service to table Customer?

Which property of ACID transactions ensures that a transaction, once committed, remains committed even in the event of a system failure?

Giả sử ta có một quan hệ: $R(ID,\ \text{full name},\ \text{address})$ và tập phụ thuộc hàm $FDs:\ \{ID\to\text{full name},\ ID\to\text{address}\}$. Dạng chuẩn cao nhất của $R$ trong thiết kế cơ sở dữ liệu quan hệ là gì? Chọn các đáp án đúng.

Given two relations: R(A,B,C,D) with the primary key is A, and S(D,E,F) with the unique key is D. How to make a R.D foreign key referencing S.D?

Consider the following table: (StudentID, StudentName, CourseID, CourseName, InstructorName, InstructorEmail) Redesign the table structure to achieve at least Third Normal Form (3NF).

How can you rename multiple attributes simultaneously in Relational Algebra?

Choose the incorrect statement about DELETE and TRUNCATE in SQL Server.

Which of the following is an example of a violation of 2NF?

Which of the following is not involved in DBMS?