Podcast
Questions and Answers
What kind of join is applicable if any other comparison operator is used?
What kind of join is applicable if any other comparison operator is used?
- Equijoin
- Theta join (correct)
- Natural join
- Implicit join
Which relational operator yields only the rows that appear in both tables?
Which relational operator yields only the rows that appear in both tables?
- Difference
- Equijoin
- Intersect (correct)
- Union
What is an attribute that uniquely identifies any given entity?
What is an attribute that uniquely identifies any given entity?
- Super key
- Secondary key
- Primary key (correct)
- Composite key
What command marks and saves the current point in the processing of a transaction?
What command marks and saves the current point in the processing of a transaction?
Which term best describes the collection of interrelated data?
Which term best describes the collection of interrelated data?
What yields all rows in one table not found in the other table?
What yields all rows in one table not found in the other table?
What type of database supports data located at a single site?
What type of database supports data located at a single site?
What does DML stand for in the context of database management systems?
What does DML stand for in the context of database management systems?
Which of the following is NOT a type of database anomaly?
Which of the following is NOT a type of database anomaly?
Which attribute can have many values?
Which attribute can have many values?
What is a candidate key?
What is a candidate key?
What type of database supports only one user at a time?
What type of database supports only one user at a time?
Flashcards are hidden until you start studying
