gs gs114 Introduction to Relational Model and SQL - Introduction to the Relational Model - Quiz No.1
gs gs114 Relational Database Management System Quiz
This quiz belongs to book/course code gs gs114 Relational Database Management System of gs organization. We have 63 quizzes available related to the book/course Relational Database Management System. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Introduction to Relational Model and SQL. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Choose the correct statement regarding superkeys
A superkey is an attribute or a group of multiple attributes that can uniquely identify a tuple
A superkey is a tuple or a set of multiple tuples that can uniquely identify an attribute
Every superkey is a candidate key
A superkey is an attribute or a set of attributes that distinguish the relation from other relations
Question 2: What is an Instance of a Database?
The logical design of the database system
The entire set of attributes of the Database put together in a single relation
The state of the database system at any given point of time
The initial values inserted into the Database immediately after its creation
Question 3: What is a foreign key?
A foreign key is a primary key of a relation which is an attribute in another relation
A foreign key is a superkey of a relation which is an attribute in more than one other relations
A foreign key is an attribute of a relation that is a primary key of another relation
A foreign key is the primary key of a relation that does not occur anywhere else in the schema
Question 4: What action does ⋈ operator perform in relational algebra
Output specified attributes from all rows of the input relation and remove duplicate tuples from the output
Outputs pairs of rows from the two input relations that have the same value on all attributes that have the same name
Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)
Return rows of the input relation that satisfy the predicate
Question 5: What does the “x” operator do in relational algebra?
Output specified attributes from all rows of the input relation. Remove duplicate tuples from the output
Output pairs of rows from the two input relations that have the same value on all attributes that have the same name
Output all pairs of rows from the two input relations (regardless of whether or not they have the same values on common attributes)
Returns the rows of the input relation that satisfy the predicate
Question 6: An attribute is a __________ in a relation.
Row
Column
Value
Tuple
Question 7: What is the method of specifying a primary key in a schema description?
By writing it in bold letters
By underlining it using a dashed line
By writing it in capital letters
By underlining it using a bold line
Question 8: Statement 1: A tuple is a row in a relation
Statement 2: Existence of multiple foreign keys in a same relation is possible
Statement 2: Existence of multiple foreign keys in a same relation is possible
Both the statements are true
Statement 1 is correct but Statement 2 is false
Statement 1 is false but Statement 2 is correct
Both the statements are false
Question 9: Choose the option that correctly explains in words, the function of the following relational algebra expression
σyear≥2009 (book ⋈ borrow)
σyear≥2009 (book ⋈ borrow)
Selects all tuples from the Cartesian product of book and borrow
Selects all the tuples from the natural join of book and borrow wherever the year is lesser than 2009
Selects all the tuples from the natural join of book and student wherever the year is greater than or equal to 2009
Selects all tuples from the Cartesian product of book and borrow wherever the year is greater than or equal to 2009
