TOPICS (Click to Navigate)
- Advanced Database Concepts
- Data structures, Operating Systems
- Natural Language Processing
- Quiz Questions and Answers
- DBMS, ADBMS Question Bank
- SQL
- RDBMS Exam and Interview Questions
- Parallel Databases
- ADBMS Quizzes
- Advanced DBMS Concepts
- Distributed Databases
- Modern Databases - Special Purpose Databases
- Object Based Database Systems
Showing posts with label Database Quizzes. Show all posts
Showing posts with label Database Quizzes. Show all posts
Wednesday, February 24, 2016
Saturday, February 20, 2016
Database Management Systems - Relational Algebra quiz
Database management system quiz - DBMS quiz with answers - DBMS multiple choice questions - DBMS basics quiz - DBMS interview questions - Relational Algebra quiz in DBMS - Relational Algebra operations in Database interview questions
Let us use the following
relations R and S to answer the questions 1 – 10s;
|
|||||||||||||||||||||||||
|
|
||||||||||||||||||||||||
1. Compute R ⋈
S. Which of the following records will be in the result? Assume each record
has the schema (A, B, C, D).
|
|||||||||||||||||||||||||
(a) (3, 3, 1, 6)
|
(b) (6, 4, 4, 1)
|
||||||||||||||||||||||||
(c) (2,
3, 3, 5)
|
(d) (3, 5, 3, 1)
|
||||||||||||||||||||||||
2. Compute R ⋈R.A<S.C S. [this is theta join]. Which of the following
records will be in the result? Assume each record has the schema (A, B, C,
D).
|
|||||||||||||||||||||||||
(a) (2,
3, 3, 5)
|
(b) (6, 4, 4, 1)
|
||||||||||||||||||||||||
(c) (6, 4, 3, 1)
|
(d) (3, 5, 1, 6)
|
||||||||||||||||||||||||
3. Compute R ⋈R.B < S.D AND R.A<S.C S. [this is
theta join]. Which of the following records will be in the result? Assume each
record has the schema (A, B, C, D).
|
|||||||||||||||||||||||||
(a) (3, 3, 3, 5)
|
(b) (6, 4, 3, 1)
|
||||||||||||||||||||||||
(c) (2,
3, 3, 5)
|
(d) (3, 5, 1, 6)
|
||||||||||||||||||||||||
4. Compute π C, D (S). Which of the
following records will be in the result?
|
|||||||||||||||||||||||||
(a) (5, 1)
|
(b) (4, 3)
|
||||||||||||||||||||||||
(c) (3, 3)
|
(d) (3,
5)
|
||||||||||||||||||||||||
5. Compute Ï€ B, C (R ⋈
S). Which of the following records will be in the result?
|
|||||||||||||||||||||||||
(a) (6, 4)
|
(b) (4,
3)
|
||||||||||||||||||||||||
(c) (5, 1)
|
(d) (5, 3)
|
||||||||||||||||||||||||
6. Compute π B (R) - π B (S). Which of
the following records will be in the result?
|
|||||||||||||||||||||||||
(a) (6)
|
(b) (4)
|
||||||||||||||||||||||||
(c) (1)
|
(d) (5)
|
||||||||||||||||||||||||
7. Compute Ï€ B (R) ∩ Ï€ B (S). Which of
the following records will be in the result?
|
|||||||||||||||||||||||||
(a) (6)
|
(b) (1)
|
||||||||||||||||||||||||
(c) (2)
|
(d) (5)
|
||||||||||||||||||||||||
8. Compute R ⋈
S. Which of the following records will be in the result? Assume each record
has the schema (A, B, C, D).
|
|||||||||||||||||||||||||
(a) (3, 3, 1, 6)
|
(b) (6, 4, 4, 1)
|
||||||||||||||||||||||||
(c) (3,
5, 1, 6)
|
(d) (3, 5, 3, 1)
|
||||||||||||||||||||||||
9. Compute π B (R) U π B (S). Which of
the following records will be in the result?
|
|||||||||||||||||||||||||
(a) (6)
|
(b) (1)
|
||||||||||||||||||||||||
(c) (2)
|
(d) (5)
|
||||||||||||||||||||||||
10. Assume a
relation R(A, B) with n unique records, and a relation S(B, C) with m unique
records. When you compute the natural join between R and S you shall get r
records as the result. Which of the following assumptions are correct in
terms of (n, m, r)?
|
|||||||||||||||||||||||||
(a) (5, 4, 25)
|
(b) (2, 3, 8)
|
||||||||||||||||||||||||
(c) (3, 3, 10)
|
(d) (2,
3, 6)
|
Go to QUIZZ in Database / DBMS / Advanced DBMS page
Monday, February 15, 2016
Database management systems - Normalization and normal forms quiz
Database management system quiz - DBMS quiz with answers - DBMS multiple choice questions - Database normalization quiz - DBMS normalization process interview questions - Normalization and normal forms quiz in DBMS - Normal forms in Database interview questions
Normalization QUIZ
1. Assume that a
relation R has the following properties. What is the normal form of R?
No multi-valued attributes
No
partial key dependencies
|
|
(a) First Normal
Form
|
(b) Second
Normal Form
|
(c) Third Normal
Form
|
(d) Boyce-Codd
Normal Form
|
2. Assume that a
relation R has the following properties. What is the normal form of R?
Has no partial key dependencies
Has multi-valued attributes
|
|
(a) First Normal
Form
|
(b) Second Normal
Form
|
(c) Third Normal
Form
|
(d) None
of the above
|
3. All functional
dependencies must _________
|
|
(a) have
attributes of the same table
|
(b) have a single
attribute on its LHS
|
(c) have a single
attribute on its RHS
|
(d) All of the
above
|
4. Which one of the
following is always a single-valued attribute?
|
|
(a) a person’s
phone number
|
(b) a person’s
address
|
(c) a
person’s age
|
(d) a person’s car
|
Let R (A, B, C,
D, E, F) be a relation with the functional dependencies A → B, A → C, CD → E,
CD → F, B → E. Use this information to answer questions 5, 6, and 7.
|
|
5. Which of the
following does not hold on R?
|
|
(a) A → E
|
(b) CD → EF
|
(c) AD → F
|
(d) B
→ CD
|
6. Which of the following
is holding on R?
|
|
(a) A
→ C
|
(b) B → A
|
(c) CD → A
|
(d) C → D
|
7. Which of the following
does not hold on R?
|
|
(a) BC
→ D
|
(b) AD → B
|
(c) BC → E
|
(d) ACD → BEF
|
8. A functional dependency
that exist between two non-key attributes is called _____
|
|
(a) Non-transitive
dependency
|
(b) Transitive
dependency
|
(c) Partial transitive
dependency
|
(d) None of the
above
|
9. Assume that a
relation R has the following properties. What is the normal form of R?
Has no multi-valued attributes
Has no
partial key dependencies
Has attributes with atomic domains
Has
transitive dependencies
|
|
(a) 1NF
& 2NF
|
(b) 1NF, 2NF,
& 3NF
|
(c) 1NF & 3NF
|
(d) BCNF
|
10. Assume a
relation R with the following 3 attributes; one attribute as primary key, one
attribute as foreign key and one non-key attribute. Also, none of them is
multi-valued attribute. What is the maximum normal form R can be in?
|
|
(a) 1NF
|
(b) 2NF
|
(c) 3NF
|
(d) BCNF
|
Go to QUIZZ in Database / DBMS / Advanced DBMS page
Subscribe to:
Posts (Atom)
Featured Content
Multiple choice questions in Natural Language Processing Home
MCQ in Natural Language Processing, Quiz questions with answers in NLP, Top interview questions in NLP with answers Multiple Choice Que...
All time most popular contents
-
Relational algebra in database management systems solved exercise Relational algebra – solved exercise Question: Consider the fo...
-
Top 5 Machine Learning Quiz Questions with Answers explanation, Interview questions on machine learning, quiz questions for data scienti...
-
Parallel query execution - example SQL queries / Inter-query, Intra-query parallelism examples / Inter-operation and Intra-operation paral...
-
Set of solved exercises in Normalization / Normalization Solved Examples / How to find candidate keys, and primary keys in database? /...
-
Top 5 Machine Learning Quiz Questions with Answers explanation, Interview questions on machine learning, quiz questions for data scienti...