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 SQL function returns the number of tuples?

🔒 Đáp án trong Source VIP

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

Given two relations: PC(model, speed, ram, hd, type) Laptop(model, speed, ram, hd, screen, price) Which subquery gets the model of laptops with the same price as any PC?

🔒 Đáp án trong Source VIP

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

Which anomaly can occur when data redundancy exists in a database?

🔒 Đáp án trong Source VIP

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

What is the relationship between a weak entity set and its identifying entity set?

🔒 Đáp án trong Source VIP

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

Which of the following is NOT a standard operation in relational algebra?

🔒 Đáp án trong Source VIP

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

Which SQL command is used to create a non-clustered index on the EmployeeName column in the Employees table?

🔒 Đáp án trong Source VIP

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

What is a NULL constraint?

🔒 Đáp án trong Source VIP

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

Which of the following is a function of a DBMS?

🔒 Đáp án trong Source VIP

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

What’s the default behavior if autocommit is ON?

🔒 Đáp án trong Source VIP

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

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

🔒 Đáp án trong Source VIP

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

A key:

🔒 Đáp án trong Source VIP

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

What is a superkey?

🔒 Đáp án trong Source VIP

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

Given the ERD following: \nHow many attributes does the table “ORDER” contain? \nmermaid\ngraph LR Customer[Customer] ---|1| Makes{Makes} Makes ---|n| Order[Order] CustomerId((CustomerId)) --- Customer FirstName((FirstName)) --- Customer LastName((LastName)) --- Customer Email((Email)) --- Customer PhoneNumber((PhoneNumber)) --- Customer OrderId((OrderId)) --- Order OrderDate((OrderDate)) --- Order

🔒 Đáp án trong Source VIP

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

For the following relations and a Set operation: \nEmployee\nName | City | Gender\nNguyen Trung Truc | HCM | Male\nLe Hong Son | HCM | Male \nCustomer\nName | City | Gender\nNguyen Trung Truc | HCM | Male\nTran Tuyet Nhi | HN | Female \nand \nEmployee ∪ Customer \nWhat is the result of the Union operation?

🔒 Đáp án trong Source VIP

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

Converting entity set to relation \nSơ đồ thực thể - thuộc tính:\nmermaid\ngraph TD E[Employees] SSN((SSN)) Name((Name)) Address((Address)) Street((Street)) City((City)) E --- SSN E --- Name E --- Address Address --- Street Address --- City \nTrong đó $SSN$ và $City$ là các thuộc tính được gạch chân trong sơ đồ.

🔒 Đáp án trong Source VIP

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

Which statement is the best represents Armstrong's Axiom of Decomposition?

🔒 Đáp án trong Source VIP

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

How can you pass parameters to a stored procedure?

🔒 Đáp án trong Source VIP

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

What does the following SQL query return?\nSELECT name FROM Products WHERE price > 100;

🔒 Đáp án trong Source VIP

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

Which of the following is not one of Armstrong's axioms for inference of functional dependencies?

🔒 Đáp án trong Source VIP

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

What does the ON UPDATE CASCADE option do in SQL Server when defined for a foreign key constraint?

🔒 Đá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 SQL function returns the number of tuples?

Given two relations: PC(model, speed, ram, hd, type) Laptop(model, speed, ram, hd, screen, price) Which subquery gets the model of laptops with the same price as any PC?

Which anomaly can occur when data redundancy exists in a database?

What is the relationship between a weak entity set and its identifying entity set?

Which of the following is NOT a standard operation in relational algebra?

Which SQL command is used to create a non-clustered index on the EmployeeName column in the Employees table?

What is a NULL constraint?

Which of the following is a function of a DBMS?

What’s the default behavior if autocommit is ON?

A key:

What is a superkey?

Which statement is the best represents Armstrong's Axiom of Decomposition?

How can you pass parameters to a stored procedure?

What does the following SQL query return?\nSELECT name FROM Products WHERE price > 100;

Which of the following is not one of Armstrong's axioms for inference of functional dependencies?

What does the ON UPDATE CASCADE option do in SQL Server when defined for a foreign key constraint?