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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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 :
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.
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
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
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
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
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
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