Question
a.
True
b.
False
c.
May be
d.
Can't say
Posted under DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. State true or false: SQL specifies a way of mentioning functional dependencies
Similar Questions
Discover Related MCQs
Q. State true or false: Most current database systems do not support constraints on materialized view
View solution
Q. Multi valued dependencies are also called as __________
View solution
Q. Functional dependencies are sometimes referred to as ________
View solution
Q. The _______ is a set of all functional and multi values dependencies implied by a set of functional dependencies
View solution
Q. State true or false: If a relational schema is in _______ NF and A is a subset of R and B is also a subset of R then it is that A is a superkey is a trivial multi values dependency.
View solution
Q. Which of the following normal forms does not exist?
View solution
Q. Choose the correct statement regarding superkeys
View solution
Q. What is an Instance of a Database?
View solution
Q. What is a foreign key?
View solution
Q. What action does ⋈ operator perform in relational algebra
View solution
Q. What does the “x” operator do in relational algebra?
View solution
Q. An attribute is a __________ in a relation.
View solution
Q. What is the method of specifying a primary key in a schema description?
View solution
Q. Statement 1: A tuple is a row in a relation
Statement 2: Existence of multiple foreign keys in a same relation is possible
View solution
Q. Choose the option that correctly explains in words, the function of the following relational algebra expression:
σyear≥2009 (book ⋈ borrow)
View solution
Q. State true or false: If a relation consists of a foreign key, then it is called a referenced relation of the foreign key dependency.
View solution
Q. Which of the following is not a feature of a good relational design?
View solution
Q. The dependency rules specified by the database designer are known as _______
View solution
Q. If the decomposition is unable to represent certain important facts about the relation, then such a decomposition is called as?
View solution
Q. If the decomposition is able to represent all the facts about the relation then such a decomposition is called as?
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!
