Examen_bd_part1
Database Fundamentals Quiz
Test your knowledge of database principles with our engaging quiz! Covering topics from ER diagrams to relational models, this quiz is designed for students and professionals alike.
- Multiple choice questions
- Assess your understanding of key concepts
- Learn while you play!
0
10
9
7
The representation of a relationship set in ER diagrams is a:
Diamond
Pentagon
Elipse
Rectangle
When we translate an ER model into a relational model, the constraint that should be added to the foreign key which link a weak entity to the owner entity should be:
ON DELETE CASCADE
ON DELETE SET NULL
CHECK N>0
ON DELETE NO ACTION
Which of the following models are used to analyze and understand the application data?
Conceptual model
Data model
None of the above
Physical model
10
7
0
9
Which of the following statements is true regarding the relation between the degree/cardinality of the resulting relation inputs of a cartesian product?
The resulting relation degree will be greater and the cardinality will be equal compared with each input table.
The resulting relation degree will be greater and the cardinality will be lower compared with each input table.
The resulting relation degree will be greater and the cardinality will be greater compared with each input table.
The resulting relation degree will be equal and the cardinality will be greater compared with each input table.
A relational database is in a consistent state if:
It does not contain empty tables.
It does not contain any field set to NULL.
All indexes where created.
All defined integrity constraints are satisfied.
Which of the following statements about a Relationship Set in ER model is not true?
Same entity set can participate in different relationship sets.
Same entity set can participate with different roles in different relationship sets.
It can contains relationships or entities.
It represents a collection of similar relationships.
The representation of an entity set in ER diagrams is a:
Rectangle
Diamond
Pentagon
Elipse
Which of the following is not an Armstrong Axiom?
Reflexivity
Transitivity
Augmentation
Associativity
The type of participation of the weak entity set in relationship with the owner in ER model is:
Partial participation.
Weak participation.
Can be any type.
Total participation
Which of the following statements is true regarding the relation between the degree/cardinality of the resulting relation and input of a projection relational operator?
The resulting relation degree will be lower or equal and the cardinality will be greater compared with the input table.
The resulting relation degree will be lower or equal and the cardinality will be lower or equal compared with the input table
The resulting relation degree will be greater and the cardinality will be lower compared with each input table.
The resulting relation degree will be equal and the cardinality will be greater compared with the input table.
Considering the following schema: Persons (pid: number, name: varchar, age: number) where pid is the primary key, what query must be used to make room for a new entry having pid = 1?
UPDATE Persons SET pid = pid + 1 WHERE pid> 1 ORDER BY pid;
UPDATE Persons SET pid = pid + 1;
UPDATE Persons SET pid = pid + 1 ORDER BY pid DESC
UPDATE Persons SET pid = pid + 1 WHERE pid > 1;
Which of the following property does not represent a disvadvantage of a file managed by the OS file system (database repository)?
Poor data protection.
Lack of support for data searching
General OS level protection
Liniar acces to a text file
Which of the following statements is true regarding the relation between the degree/cardinality of the resulting relation and inputs of a union product?
The resulting relation degree will be greater and the cardinality will be lower or equal compared with each input table.
The resulting relation degree will be greater and the cardinality will be equal compared with each input table.
The resulting relation degree will be lower or equal and the cardinality will be greater compared with each input table.
The manner the data is stored by a RDBMS on an external support is expressed by:
The external model.
The virtual model.
The physical model.
The conceptual model.
A thin line used to link an entity to a relationship denotes:
A weak participation constraint.
A strong participation constraint.
A partial participation constraint.
A total participation constraint.
Considering the following schema: Sailors(sid: number, name: varchar, rank number, salary: number, age: number). Which of the following Update expressions is reversible:
UPDATE Sailors SET rank = rank + 1 WHERE rank <9:
UPDATE Sailors SET name= "Retired* WHERE age > 65:
UPDATE Sailors SET rank = 1;
UPDATE Sailors SET salary = salary + 10/100 * salary
When it is not necessary to check the referential integrity in a relational database?
When changing the value of a primary key or of a foreign key in the related tables.
When deleting a record from the referenced (primary) table
When deleting a record in the secondary table
When adding a record in the secondary table.
The JOIN operator from relational algebra can be defined using:
Selection and Renaming
Selection and Cartesian product.
Projection and Union.
Selection and Projection
Which of the following services is not provided by a DBMS?
Data protection and recovery mechanism.
Advanced searching and retrieval algorithms.
Efficient physical data organization on external storage.
Advanced code versioning mechanism.
{"name":"Examen_bd_part1", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of database principles with our engaging quiz! Covering topics from ER diagrams to relational models, this quiz is designed for students and professionals alike.Multiple choice questionsAssess your understanding of key conceptsLearn while you play!","img":"https:/images/course5.png"}