DBMS (KMBIT04) MCQ
Q. 1. The all-or-none property is commonly
known as
A : Isolation
B : Durability
C : Atomicity
D : seializability
Answer
Atomicity
Q.no 2. In formal relational model, the set of
indivisible values is called
A : Range
B : Domain
C : Relation
D : Tuple
Answer
Domain
Q.no 3. What is the full form of DDL
A : Dynamic Data Language
B : Detailed Data Language
C : Data Definition Language
D : Data Derivation Language
Answer
Data Definition Language
Q.no 4. The users who use easy-to-use menu are
called
A : Sophisticated end users
B : Naïve users.
C : Stand-alone users.
D : Casual end user
Answer
Naïve users.
Q.no 5. The highest level of abstraction that
describes only part of the entire database
A : View Level
B : Physical Level
C : Logical Level
D : Conceptal Level
Answer
View Level
Q.no 6. The core principal of NOSQL is
A : High availability
B : High concurrency
C : High Consistency
D : High Atomicity
Answer
High availability
Q.no 7. Which of the following is a NoSQL
Database Type?
A : SQL
B : Document databases
C : DB2
D : Maria DB
Answer
Document databases
Q.no 8. Which one is not a NoSQl data model?
A : Client Server
B : Key Value store
C : Column store
D : Document store
Answer
Client Server
Q.no 9. A collection of conceptual tool for
describing data ,data relation ship ,semantics and consistency is called
A : Data Model
B : Design
C : Package
D : Program
Answer
Data Model
Q.no 10. A data dictionary is a repository
that manages
A : Memory
B : Metadata
C : Spell Checker
D : Data Validator
Answer
Metadata
ISEE mcq
questions and answers
Q.no 11. Which property of a transaction that
protect data from system failure
A : Isolation
B : Durability
C : Atomicity
D : serializability
Answer
Durability
Q.no 12. Execution of transaction in isolation
preserves the
A : Atomicity
B : Consistency
C : Durability
D : concurrency
Answer
Consistency
Q.no 13. The system seeks to improve
performance through parallelization of various
operations, such as loading data, building indexes and evaluating queries is
A : Distributed database
B : Parallel database
C : Client server database
D : standalone systems
Answer
Parallel database
Q.no 14. The possible value associated with
every attribute is called
A : Domain
B : Assertion
C : instance
D : Schema
Answer
Domain
Q.no 15. The normalization form which is based
on the transitive dependency is
classified as
A : Fourth normal form
B : Third normal form
C : First normal form
D : Second normal form
Answer
Third normal form
Q.no 16. which DBMS distributes data
processing tasks between the workstation and a
network server.
A : Network
B : Relational
C : Client Server
D : Hierarchical
Answer
Client Server
Q.no 17. In SQL, which of the following is not
a data definition language commands?
A : RENAME
B : REVOKE
C : GRANT
D : CREATE
Answer
RENAME
Q.no 18. When a transaction completes the
execution of its final statement, it enters a state.
What is the name of this state?
A : Partially Committed state
B : Committed state
C : Failed state
D : Aborted State
Answer
Partially Committed state
Q.no 19. How many versions of two phase
locking protocol available
A : 1
B : 2
C : 3
D : 4
Answer
2
Q.no 20. The lowest level of abstraction that
describes how the data are actually stored is
A : Physical Level
B : Logical Level
C : View Level
D : user Level
Answer
Physical Level
Q.no 21. Each higher level entity must belong
to a lwer level entity
A : Total
B : Overlapping
C : Disjoint
D : partial
Answer
Total
Q.no 22. We can test a given schedule for
conflict serializability by constructing a
A : wait for graph
B : precedence graph
C : topological sorting
D : cyclic graph
Answer
precedence graph
Q.no 23. A relation which is in a higher
normal form
A : implies that it also qualifies to be in lower normal form
B : does not necessarily satisfy the conditions of lower normal form
C : is included in the lower normal form
D : is independent of lower normal forms
Answer
implies that it also qualifies to be in lower normal form
Q.no 24. which NameNode is used when the
Primary NameNode goes down.
A : Rack
B : Data
C : Secondary
D : primary
Answer
Secondary
Q.no 25. Which of the following methods
requires three phase for control concurrency
A : Timestamp Method
B : Two Phase Locking Method
C : Binary Locking Method
D : Optimistic Method
Answer
Optimistic Method
Q.no 26. Point out the wrong statement
A : Secondary indices is not available in MongoDB
B : MongoDB supports search by field, range queries, regular expression
searches
C : MongoDB can store the business subject in the minimal number of documents
D : MongoDB cannot store images
Answer
Secondary indices is not available in MongoDB
Q.no 27. Which of the following is a
disadvantage of replication?
A : Reduced network traffic
B : If the database fails at one site, a copy can be located at another site.
C : Each site must have the same storage capacity.
D : Each transaction may proceed without coordination across the network.
Answer
Each site must have the same storage capacity.
Q.no 28. which one of these is not correct
A : ER is an conceptual Data model
B : we cannot create a table without a primary key
C : An attribute of an entity can have more than one value
D : DBMS avoids Data redundancy
Answer
we cannot create a table without a primary key
Q.no 29. Maximum virtual memory of the
launched child-task is specified using
A : mapv
B : mapred
C : mapvim
D : mapr
Answer
mapred
Q.no 30. Which is essentially used to search
for patterns in target string.
A : Like Predicate
B : Null Predicate
C : In Predicate
D : Out Predicate
Answer
Like Predicate
Q.no 31. which command is used to interact and
view Job Queue information in HDFS
A : queue
B : priority
C : disc
D : diq
Answer
queue
Q.no 32. The Mapper implementation processes
one line at a time via which method.
A : map
B : reduce
C : mapper
D : reducer
Answer
map
Q.no 33. Supporting interquery parallelism is
more complicated in
A : Shared Memory
B : shared disk
C : shared nothing
D : shared disk and shared nothing
Answer
shared disk and shared nothing
Q.no 34. SQl uses which of these values to
indicate the absence of information about the value
of an attribute
A : 0
B : NA
C : NULL
D : AB
Answer
NULL
Q.no 35. which is the primary interface for a
user to describe a MapReduce job to the
Hadoop framework for execution.
A : JobConfig
B : JobConf
C : JobConfiguration
D : job
Answer
JobConf
Q.no 36. The technique that controls the
interaction between more than one executing
transactions is known as
A : Multitasking technique
B : Serialization technique
C : Schedule technique
D : Concurrency control technique
Answer
Concurrency control technique
Q.no 37. The virtual table that its created by
data from the result of an SQL Select statement
is called
A : View
B : Synonym
C : Sequence
D : Transaction
Answer
View
Q.no 38. When a participating site s1 decides
to commit the transaction T upon receiving the message from the coordinator, it
sends which message to the coordinator site.
A :
B :
C :
D :
Answer
C
Q.no 39. A type of query that is placed within
a WHERE or HAVING clause of another query
is called
A : Master query
B : Sub query
C : Super query
D : Multi-query
Answer
Sub query
Q.no 40. Which of the following is the default
Partitioner for Mapreduce?
A : MergePartitioner
B : HashedPartitioner
C : HashPartitioner
D : Hasher
Answer
HashPartitioner
Q.no 41. if queries are issued at one or more
nodes.a distributed transaction can be
A : fully read-only
B : partially read-only
C : fully read-write
D : partially read-write
Answer
partially read-only
Q.no 42. NoSQL supports
A : Vertical scaling, simple design, low control availability
B : Vertical scaling, simple design, fine controlled availability
C : Horizontal scaling, complex design, fine controlled availability
D : Horizontal scaling, simple design, fine controlled availability.
Answer
Horizontal scaling, simple design, fine controlled availability.
Q.no 43. While converting ER diagram into
table for which one these are not represented in a relational database design
A : Entity with Composite Attribute
B : Entity without a primary key
C : Relationship set linking a weak entity set to its corressponding strong
entity set
D : Relationship set with descriptive attribute
Answer
Relationship set linking a weak entity set to its corressponding
strong entity set
Q.no 44. Concurrency control is important for
which of the following reasons?
A : To ensure data integrity when updates occur to the database in a multiuser
environment
B : To ensure data integrity when updates occur to the database in a
single-user environment
C : To ensure data integrity while reading data occurs to the database in a
multiuser environment
D : To ensure data integrity while reading data occurs to the database in a
single-user environment
Answer
To ensure data integrity when updates occur to the database in a
multiuser environment
Q.no 45. In timestamp ordering protocol,
suppose that the transaction Ti issues read(X) and TS(Ti)>W-timestamp(X),
then
A : Read operation is executed
B : Read operation is rejected
C : Write operation is rejected
D : Write operation is executed
Answer
Read operation is executed
Q.no 46. Considering the functional
dependency, the one in which removal from some
attributes must affect dependency is called
A : Transitive dependency
B : Full functional dependency
C : Partial dependency
D : Primary dependency
Answer
Full functional dependency
Q.no 47. A 3 NF relation is converted to BCNF
by
A : removing composite keys
B : removing multivalued dependencies
C : dependent attributes of overlapping composite keys are put in a separate
relation
D : dependent non-key attributes are put in a separate table
Answer
dependent attributes of overlapping composite keys are put in a
separate relation
Q.no 48. Most NoSQL databases support
automatic which of these meaning that you get high availability and disaster recovery.
A : processing
B : scalability
C : replication
D : all of the mentioned
Answer
replication
Q.no 49. each book has exactly one publisher
but each publisher can publish many
books.What is the relation between Book and Pubisher
A : Many to one
B : One to One
C : Many to One
D : Many to Many
Answer
Many to one
Q.no 50. What command is used to removing
trigger
A : DROP TRIGGER Trig;
B : ALTER TRIGGER Trig;
C : DELETE TRIGGER Trig;
D : truncate trigger
Answer
DROP TRIGGER Trig;
Q.no 51. As companies move past the
experimental phase with Hadoop, many cite the need for additional capabilities,
including
A : Improved data storage and information retrieval
B : Improved extract, transform and load features for data integration
C : Improved data warehousing functionality
D : Improved security, workload management, and SQL support
Answer
Improved security, workload management, and SQL support
Q.no 52. While converting ER into tables, what
is done for Relationship set linking a weak
entity set to its corressponding strong entity set
A : Relationship set is not represented as a table
B : Relationship is represented as a table
C : descriptive attributes are added to relation ship set
D : Primary keys are added to the relationship set
Answer
Relationship set is not represented as a table
Q.no 53. Read one, write all available
protocol is used to increase
A : Availability
B : Robustness
C : Both Availability and Robustness
D : Neither Availability nor Robustness
Answer
Both Availability and Robustness
Q.no 54. Let us suppose that in a distributed
database, during a transaction T1, one of the
sites, say S1, is failed. When recovers, the site S1 has to check its log file
(log based recovery) to decide the next move on the transaction T1. If the log
contains a record, what
the site S1 has to do?
A : Need not do anything
B : Perform Undo
C : Perform Redo
D : Abort the transaction
Answer
Perform Undo
Q.no 55. which serves as the master and there
is only one NameNode per cluster.
A : Data Node
B : NameNode
C : Data block
D : Replication
Answer
NameNode
Q.no 56. which can be used for batch
processing of data and aggregation operations.
A : Hive
B : MapReduce
C : Oozie
D : None of the mentioned
Answer
MapReduce
Q.no 57. for taking advantage of load
balancing and data replication features over multiple
machines for storing files mogo DB can be used as
A : AMS
B : CMS
C : File system
D : None of the mentioned
Answer
AMS
Q.no 58. The relation EMPDT1 is defined with
attributes empcode(unique), name, street, city state, and pincode. For any
pincode,there is only one city and state. Also, for any given street, city and
state, there is just one pincode. In normalization terms EMPDT1 is a relation
A : 1NF only
B : 2NF and hence also in 1NF
C : 3NF and hence also in 2NF and 1NF
D : BCNF and hence also in 3NF, 2NF and 1NF
Answer
2NF and hence also in 1NF
Q.no 59. What are the advantages of
Replication of data in Distributed database?
A : Avaliability, Parallelism, Increased data transfer
B : Availability, Parallelism, Reduced data transfer
C : Availability, Increased parallelism, Cost of updates
D : All of the above
Answer
Availability, Parallelism, Reduced data transfer
Q.no 60. Trigger is not execute when
A : Select query execute
B : Insert query execute
C : Update query execute
D : Delete query execute
Answer
Select query execute
