In an ERD, what does a line connecting two entities represent?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Database data models usually have a way to go describe limitations on what the data can be, is called🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
The result which operation contains all pairs of tuples from the two relations, regardless of whether their attribute values match.🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Problems such as redundancy that occur when we try to cram too much into a single relation are called __________.🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
In relational database design, which normal form of a relation eliminates multi-valued attributes and ensures that data is organized at a fundamental level?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Let E1 and E2 be two entities in an E/R diagram with simple single-valued attributes. R1 and R2 are two relationships between E1 and E2, where R1 is one-to-many and R2 is many-to-many. R1 and R2 do not have any attributes of their own. What is the minimum number of tables required to represent this situation in the relational model?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Which of the following statements is correct when converting from the ERD model to the relational model?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Which of the following is known as a set of entities of the same type that share same properties, or attributes?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
What does the attribute domain define in the relational model?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
The predicate in a where clause can involve Boolean operations such as and. The result of true and unknown is ______, false and unknown is ______ while unknown and unknown is ______.🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Which SQL clause is used to add a new column to an existing table?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
In SQL, what does the acronym ACID stand for concerning transactions?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
In an employee table to include the attributes whose value always have some value which of the following constraint must be used?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
In SQL, to update a relation's schema, which one of the following statements can be used?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Domain constraints, functional dependency and referential integrity are special forms of __________🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
In SQL, what is the purpose of the CLOSE statement in relation to cursors?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
Which of the following is not a typical trigger action?🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi
A database administrator: a person or persons responsible for the structure or schema of the database.🔒 Đáp án trong Source VIPDBI202Đã xuất hiện trong 4 đề thi