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

You have a table named Books that has columns named BookTitle and Description. There is a full-text index on these columns. You need to return rows from the table in which the word 'computer' exists in either column. Which SQL code segment should you use?

🔒 Đáp án trong Source VIP

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

Your database contains a table named Purchases. The table includes a DATETIME column named PurchaseTime that stores the date and time each purchase is made. There is a non-clustered index on the PurchaseTime column. The business team wants a report that displays the total number of purchases made on the current day. You need to write a query that will return the correct results in the most efficient manner. Which Transact-SQL query should you use?

🔒 Đáp án trong Source VIP

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

Let ParamountMovies be the VIEW defined from the Movies table: ```sql CREATE VIEW ParamountMovies AS SELECT title, year FROM Movies WHERE studioName = 'Paramount' ``` If you execute the statement: ```sql DROP VIEW ParamountMovies ``` choose the correct statement for the Movies table.

🔒 Đáp án trong Source VIP

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

What is the most useful index we can put on a relation?

🔒 Đáp án trong Source VIP

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

What is a database trigger in SQL Server?

🔒 Đáp án trong Source VIP

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

Create a stored procedure named GetEmployeeByID that accepts an EmployeeID as a parameter and returns the corresponding employee's details.

🔒 Đáp án trong Source VIP

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

What does the relational algebra operation "Projection" do?

🔒 Đáp án trong Source VIP

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

Which of the following is a relational algebra operation?

🔒 Đáp án trong Source VIP

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

Consider the table: Which functional dependency exists in the above table?

🔒 Đáp án trong Source VIP

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

Which constraint ensures that the values of certain attributes in a relation uniquely identify tuples in that relation?

🔒 Đáp án trong Source VIP

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

What is Boyce-Codd Normal Form (BCNF)?

🔒 Đáp án trong Source VIP

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

In a functional dependency $A \to B$, what can be said about $B$?

🔒 Đáp án trong Source VIP

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

Consider a relation $R(A, B, C, D, E, F)$ with FDs $\{AB \to C,\ C \to D,\ D \to A,\ D \to E\}$. Which of the following is the closure of $\{B,D\}$?

🔒 Đáp án trong Source VIP

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

Consider a relation $R(A,B,C,D)$ and: Rule 1: If $A \to C$ then $C \to A$ Rule 2: If $B \to C$ then $BC \to C$ Rule 3: If $AB \to C$ then $A \to C$ and $B \to C$ Which of the following is NOT valid rule?

🔒 Đáp án trong Source VIP

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

Consider two relations: MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) We want the names and addresses of all female movie stars who are also movie executives with a net worth over $10,000,000. What is the correct statement?

🔒 Đáp án trong Source VIP

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

Which of the following is correct?

🔒 Đáp án trong Source VIP

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

Which statement is used to disable a foreign key constraint named `fk_name` during INSERT and UPDATE transactions in table B?

🔒 Đáp án trong Source VIP

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

The function to get the date value (of the month) in SQL is:

🔒 Đáp án trong Source VIP

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

Which of the following to delete "model" field is "ford" from Cars table?

🔒 Đáp án trong Source VIP

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

The CREATE TRIGGER statement is used to create the trigger. The clause specifies the table name on which the trigger is to be attached. The specifies that this is an AFTER INSERT trigger.

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

You have a table named Books that has columns named BookTitle and Description. There is a full-text index on these columns. You need to return rows from the table in which the word 'computer' exists in either column. Which SQL code segment should you use?

Let ParamountMovies be the VIEW defined from the Movies table: ```sql CREATE VIEW ParamountMovies AS SELECT title, year FROM Movies WHERE studioName = 'Paramount' ``` If you execute the statement: ```sql DROP VIEW ParamountMovies ``` choose the correct statement for the Movies table.

What is the most useful index we can put on a relation?

What is a database trigger in SQL Server?

Create a stored procedure named GetEmployeeByID that accepts an EmployeeID as a parameter and returns the corresponding employee's details.

What does the relational algebra operation "Projection" do?

Which of the following is a relational algebra operation?

Consider the table: Which functional dependency exists in the above table?

Which constraint ensures that the values of certain attributes in a relation uniquely identify tuples in that relation?

What is Boyce-Codd Normal Form (BCNF)?

In a functional dependency $A \to B$, what can be said about $B$?

Consider a relation $R(A, B, C, D, E, F)$ with FDs $\{AB \to C,\ C \to D,\ D \to A,\ D \to E\}$. Which of the following is the closure of $\{B,D\}$?

Consider a relation $R(A,B,C,D)$ and: Rule 1: If $A \to C$ then $C \to A$ Rule 2: If $B \to C$ then $BC \to C$ Rule 3: If $AB \to C$ then $A \to C$ and $B \to C$ Which of the following is NOT valid rule?

Consider two relations: MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) We want the names and addresses of all female movie stars who are also movie executives with a net worth over $10,000,000. What is the correct statement?

Which of the following is correct?

Which statement is used to disable a foreign key constraint named `fk_name` during INSERT and UPDATE transactions in table B?

The function to get the date value (of the month) in SQL is:

Which of the following to delete "model" field is "ford" from Cars table?

The CREATE TRIGGER statement is used to create the trigger. The clause specifies the table name on which the trigger is to be attached. The specifies that this is an AFTER INSERT trigger.

Đ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

You have a table named Books that has columns named BookTitle and Description. There is a full-text index on these columns. You need to return rows from the table in which the word 'computer' exists in either column. Which SQL code segment should you use?

Let ParamountMovies be the VIEW defined from the Movies table: ```sql CREATE VIEW ParamountMovies AS SELECT title, year FROM Movies WHERE studioName = 'Paramount' ``` If you execute the statement: ```sql DROP VIEW ParamountMovies ``` choose the correct statement for the Movies table.

What is the most useful index we can put on a relation?

What is a database trigger in SQL Server?

Create a stored procedure named GetEmployeeByID that accepts an EmployeeID as a parameter and returns the corresponding employee's details.

What does the relational algebra operation "Projection" do?

Which of the following is a relational algebra operation?

Consider the table: Which functional dependency exists in the above table?

Which constraint ensures that the values of certain attributes in a relation uniquely identify tuples in that relation?

What is Boyce-Codd Normal Form (BCNF)?

In a functional dependency $A \to B$, what can be said about $B$?

Consider a relation $R(A, B, C, D, E, F)$ with FDs $\{AB \to C,\ C \to D,\ D \to A,\ D \to E\}$. Which of the following is the closure of $\{B,D\}$?

Consider a relation $R(A,B,C,D)$ and: Rule 1: If $A \to C$ then $C \to A$ Rule 2: If $B \to C$ then $BC \to C$ Rule 3: If $AB \to C$ then $A \to C$ and $B \to C$ Which of the following is NOT valid rule?

Consider two relations: MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, netWorth) We want the names and addresses of all female movie stars who are also movie executives with a net worth over $10,000,000. What is the correct statement?

Which of the following is correct?

Which statement is used to disable a foreign key constraint named `fk_name` during INSERT and UPDATE transactions in table B?

The function to get the date value (of the month) in SQL is:

Which of the following to delete "model" field is "ford" from Cars table?

The CREATE TRIGGER statement is used to create the trigger. The ______ clause specifies the table name on which the trigger is to be attached. The ______ specifies that this is an AFTER INSERT trigger.

The CREATE TRIGGER statement is used to create the trigger. The clause specifies the table name on which the trigger is to be attached. The specifies that this is an AFTER INSERT trigger.