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
Saturday, June 27, 2015
Friday, June 26, 2015
Tuesday, April 7, 2015
Friday, April 3, 2015
Thursday, April 2, 2015
Monday, March 9, 2015
Monday, February 16, 2015
DBMS Basics - Quiz 5
DBMS Basics - Quiz 5
[Answers are given in Green color]
1. A relational database is said to be a group of
____.
a. common fields c.
records
b. field values d. tables
2. One of the advantages of a relational database
model is ____.
a. structural dependence c. easier database design
b. conceptual complexity d. complex database design
3. Using network terminology, a relationship is
called a(n) ____.
a. member c. set
b. owner d.
table
4. The hierarchical database model is based on a
____.
a.
tree structure c.
lack of a child segment
b. lack of a parent segment d. Matrix
5. The hierarchical database model depicts a set
of ____ relationships.
a. M:1 c. 1:M
b. 1:1 d.
M:N
6. The hierarchical database is not very efficient
when handling ____.
a. large amounts of data c. many transactions
b.
few transactions d.
1:M relationships
7. The hierarchical database models ____.
a. have no implementation limitations c. have very strict standards
b.
promote database integrity d.
have a simple navigational system
8. A relational database model ____.
a. does not require substantial hardware and
system software overhead
b. does not promote "islands of
information" problems
c. allows trained people to use a good system
poorly
d.
lets the user operate in a human logical environment
9. The network database models have a ____.
a. navigational system that yields simple design
b. simple system that promotes efficiency
c.
relationship of owner/member that promotes database integrity
d. great deal of structural independence
10. Database models have been developed for ____.
a.
modeling real-world events or conditions
b. depositing data within a single file
c. keeping data within multiple data repositories
d. allowing DBMSs to maintain lose control over
the database activities.
11. The RDBMS ____.
a.
performs functions provided by the hierarchical and network DBMS system
b. does not manage data structures
c. allows the user/designer to ignore the logical
view of the database
d. does not manage the details of physical storage
12. System’s complexity is hidden from the user
and designer in RDBMS. This leads to ____.
a. it does not exhibit data independence
b. it does not exhibit structural independence
c.
easier data management
d. data management is very difficult
13. Database models can be grouped into two
categories: conceptual models and ____
models.
a.
implementation c.
physical
b. logical d.
query
14. Every row/record in the relational table is called
as an entity ____.
a.
instance c.
attribute
b. relationship d.
model
15. Degree of ______ is a way to classify data
models.
a. difficulty c. abstraction
b. knowledge d.
unification
Wednesday, September 10, 2014
Tuesday, June 24, 2014
Thursday, May 22, 2014
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...
-
Bigram Trigram and NGram in NLP, How to calculate the unigram, bigram, trigram, and ngram probabilities of a sentence? Maximum likelihood...
-
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...
-
Bigram probability estimate of a word sequence, Probability estimation for a sentence using Bigram language model Bigram Model - Probab...