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 result of the below query: SELECT SUBSTRING('FPTUDN', 1, 3) AS 'Substring'

🔒 Đáp án trong Source VIP

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

Which of the following is NOT the binary operation in the relational Algebra?

🔒 Đáp án trong Source VIP

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

Choose the correct statement.

🔒 Đáp án trong Source VIP

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

Which of the following is NOT a standard aggregation operator?

🔒 Đáp án trong Source VIP

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

In order to undo the work of transaction after last commit which one should be used?

🔒 Đáp án trong Source VIP

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

Which of the following makes the transaction permanent in the database?

🔒 Đáp án trong Source VIP

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

Which of the following SQL statement remove all of the content from a table name "employees" but keep the schema?

🔒 Đáp án trong Source VIP

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

The following SQL updates the first employees (empID = 1) with a new empName and a new City from employees table.

🔒 Đáp án trong Source VIP

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

What are the different events in Triggers?

🔒 Đáp án trong Source VIP

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

In the Select clause, the keyword DISTINCT mean?

🔒 Đáp án trong Source VIP

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

Which of the following represents Armstrong's Axiom of Transitivity?

🔒 Đáp án trong Source VIP

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

Which statement is used to change the data type of a column named E in table A?

🔒 Đáp án trong Source VIP

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

The SQL ALTER statement can be used to:

🔒 Đáp án trong Source VIP

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

NULL is:

🔒 Đáp án trong Source VIP

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

With SQL, how do you select all the records from a table named "tblDepartment" where the value of the column "depName" is "E&D department"? Choose correct answers.

🔒 Đáp án trong Source VIP

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

The SQL keyword BETWEEN is used:

🔒 Đáp án trong Source VIP

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

When does the Deleted temporary trigger table become populated?

🔒 Đáp án trong Source VIP

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

Queries and other DML actions are grouped into ________, which are units that must be executed atomically and in isolation from one another.

🔒 Đáp án trong Source VIP

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

Consider the two relations from our running movie database: Movies(title, year, length, genre, studioName, producerC#) MovieExec(name, address, cert#, netWorth) The producerC# component of each Movies tuple must also appear in the cert# component of some MovieExec tuple. How can we express this integrity constraint in relational algebra?

🔒 Đáp án trong Source VIP

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

The relations are constructed by the SQL language processor when it performs its job of executing queries and data modifications, and then thrown away and not stored, are called ______.

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

What is the result of the below query: SELECT SUBSTRING('FPTUDN', 1, 3) AS 'Substring'

Which of the following is NOT the binary operation in the relational Algebra?

Choose the correct statement.

Which of the following is NOT a standard aggregation operator?

In order to undo the work of transaction after last commit which one should be used?

Which of the following makes the transaction permanent in the database?

Which of the following SQL statement remove all of the content from a table name "employees" but keep the schema?

The following SQL updates the first employees (empID = 1) with a new empName and a new City from employees table.

What are the different events in Triggers?

In the Select clause, the keyword DISTINCT mean?

Which of the following represents Armstrong's Axiom of Transitivity?

Which statement is used to change the data type of a column named E in table A?

The SQL ALTER statement can be used to:

NULL is:

With SQL, how do you select all the records from a table named "tblDepartment" where the value of the column "depName" is "E&D department"? Choose correct answers.

The SQL keyword BETWEEN is used:

When does the Deleted temporary trigger table become populated?

Queries and other DML actions are grouped into ________, which are units that must be executed atomically and in isolation from one another.

The relations are constructed by the SQL language processor when it performs its job of executing queries and data modifications, and then thrown away and not stored, are called ______.