DBMS mcq with answers pdf for SPPU online

database management system mcq, dbms mcq sppu, dbms mcq questions, dbms mcq with answers pdf, database management system mcq questions with answers pdf, database management system mcq questions with answers

SEPM mcq questions sppu

Database management system mcq questions with answers are listed below. It includes some of the most important DBMS mcqs to be asked in your dbms sppu mcq online exam. The question below and DBMS mcq with answers pdf is given below with answer for each question mentioned properly in hidden format. You need to click on show answer to see the answer. Meanwhile you can guess the corret answer.

Computer Networks mcq questions and answers

Q. 1. The all-or-none property is commonly known as
A : Isolation
B : Durability
C : Atomicity
D : seializability

Advertisement

Atomicity

Q.no 2. In formal relational model, the set of indivisible values is called
A : Range
B : Domain
C : Relation
D : Tuple

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

Advertisement

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

Advertisement

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

View Level

Q.no 6. The core principal of NOSQL is
A : High availability
B : High concurrency
C : High Consistency
D : High Atomicity

Advertisement

High availability

Q.no 7. Which of the following is a NoSQL Database Type?
A : SQL
B : Document databases
C : DB2
D : Maria DB

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

Advertisement

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

Data Model

Q.no 10. A data dictionary is a repository that manages
A : Memory
B : Metadata
C : Spell Checker
D : Data Validator

Advertisement

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

Advertisement

Durability

Q.no 12. Execution of transaction in isolation preserves the
A : Atomicity
B : Consistency
C : Durability
D : concurrency

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

Advertisement

Parallel database

Q.no 14. The possible value associated with every attribute is called
A : Domain
B : Assertion
C : instance
D : Schema

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

Advertisement

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

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

Advertisement

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

Partially Committed state

Q.no 19. How many versions of two phase locking protocol available
A : 1
B : 2
C : 3
D : 4

Advertisement

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

Physical Level

Q.no 21. Each higher level entity must belong to a lwer level entity
A : Total
B : Overlapping
C : Disjoint
D : partial

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

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

Advertisement

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

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

Advertisement

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

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.

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

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

Advertisement

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

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

queue

Q.no 32. The Mapper implementation processes one line at a time via which method.
A : map
B : reduce
C : mapper
D : reducer

Advertisement

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

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

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

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

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

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 :

Advertisement

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

Sub query

Q.no 40. Which of the following is the default Partitioner for Mapreduce?
A : MergePartitioner
B : HashedPartitioner
C : HashPartitioner
D : Hasher

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

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.

Advertisement

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

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

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

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

Advertisement

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

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

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

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

Advertisement

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

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

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

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

Advertisement

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

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

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

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

Advertisement

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

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

Advertisement

Select query execute

database management system mcq, dbms mcq sppu, dbms mcq questions, dbms mcq with answers pdf, database management system mcq questions with answers pdf, database management system mcq questions with answers


Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top