Module 3: MCQ with correct answer on Database Theory concept from
Q1. A primary key if combined with a foreign key creates .
a). Parent-Child relationship between the tables that connect them.
b). Many to many relationship between the tables that connect them.
c). Network model between the tables that connect them.
d). None of the above
Correct answer: a) Parent-Child relationship between the tables that connect them
Q2. In E-R Diagram relationship type is represented by .
a). Ellipse
b). Dashed Ellipsed
c). Rectangle
d). Diamond
Correct answer: d) Diamond
Q3. Hierarchical model is also called .
a) Tree structure
b) Plex Structure
c). Normalize Structure
d). Table Structure
Correct answer: a) Tree structure
Q4. To delete a particular column in a relation the command used is:
a). UPDATE
b). DROP
c). ALTER
d). DELETE
Correct answer: c) ALTER
Q1. The ______ operator is used to compare a value to a list of literals
values that have been specified.
a). BETWEEN
b). ANY
c). WHERE
d). ALL
Correct answer: a) BETWEEN
Q2. A logical schema .
a) is the entire database.
b) is a standard way of organizing information into a accessible part.
c) describes how data is actually stored on disk.
d) None of these.
Correct answer: d) None of the these
Q3. A data manipulation command that combines the records from one or more tables is called ?
a) SELECT
b). PROJECT
c). JOIN
d). PRODUCT
Correct answer: c) JOIN
Q1. In E-R diagram generalization is represented by .
a). Ellipse
b). Dashed ellipse
c) Rectangle
d). Triangle
Correct answer: d) Triangle
Q2. ________ is a virtual table that draws its data from the result of an SQL SELECT statement.
a). View
b). Synonym
c). Sequence
d). Transaction
Correct answer: a) View
Q3. The method of access which uses key transformation is known as
a). Direct
b). Hash
c). Random
d). Sequential
Correct answer: b) Hash
Q1. The view of total database content is ____________
a) Conceptual view
b) Internal view
c) External view
d) Physical View.
Correct answer: a) Conceptual view
Q2. The database schema is written in _________________
a) DDL
b) DCL
c) DML
d) HLL
Correct answer: a) DLL
Q3. In Hierarchical model records are organized as___________
a) Graph
b) List
c) Link
d) Tree
Correct answer: d) Tree
Q4. A sub-schema expresses ______________
a) Conceptual view
b) Internal view
c) External view
d) Physical View.
Correct answer: c) External view
Q1. SET concept is used in :_________________
a) Network Model
b) Relational Model
c) Hierarchical Model
d) ER Model
Correct answer: a) Network Model
.Q2. The relationship associating the weak entity sets with the identifying entity set is called as ________
a) Identifying relationship
b) Connecting relationship
c) Completing relationship
d) Unique relationship
Correct answer: a) Identifying relationship
Q3. Relational Algebra is a __________ query language that takes two relations as input and produces another relation as an output of the query.
a) Relational
b) Structural
c) Procedural
d) Fundamental
Correct answer: c) Procedural
Q1. Which one of the following statements is false?
a) The data dictionary is normally maintained by the database administrator.
b) Data elements in the database can be modified by changing the data dictionary.
c) The data dictionary contains the name and description of each data element.
d) A data dictionary is a tool used exclusively by the database administrator.
Correct answer: b) Data elements in the database can be modified by changing the data dictionary
Q2. ____________ means to hide certain details of how data is stored and maintain.
a) Data Integrity
b) Data Abstraction
c) Data Isolation
d) None of these
Correct answer: b) Data Abstraction
Q3. For select operation the ________ appear in the subscript and the ___________ argument appears in the parenthesis after the sigma
a) Predicates, relation
b) Relation, Predicates
c) Operation, Predicates
d) Relation, Operation
Correct answer: a) Predicates, relation
Q1. A table can have
a) One primary key
b) Two primary keys
c) Three primary keys
d) Unlimited primary keys
Correct answer: a) Option 1
Q2. Which key creates a relationship between two tables
a) Primary Key
b) Foreign key
c) Candidate Key
d) Compound Key
Correct answer: b) Option 2
Q3. The long form of DDL is
a) Data Duplicate Language
b) Data Dedicated Language
c) Data Definition Language
d) Data Determining Language
Correct answer: c) Option 3
Q4. Relational Algebra is a
a) programming language
b) structure query language
c) non-procedural query language
d) procedural query language
Correct answer: d) Option 4
Q1. The relational model ( RM ) for database management is first described by
English computer scientist Edgar F Codd
e) in 1967
f) in 1968
g) in 1969
h) in 1970
Correct answer: g) Option 3
Q2. In relational algebra select operation is denoted by the
e) symbol: ς
f) symbol: ρ
g) symbol: π
h) symbol: υ
Correct answer: e) Option 1
Q3. Which of the following concept is not present in MongoDB
e) Documents
f) Collections
g) Field
h) Joins
Correct answer: h) Option 4
Q1. First-order logic—also known as
i) queue logic
j) stack logic
k) predicate logic
l) preceding logic
Correct answer: k) Option 3
Q2. The following represents the name of the relation with its attributes.
i) Relation instance
j) Relation schema
k) Relation key
l) Attribute domain
Correct answer: j) Option 2
Q3. Which of the following is not correct
i) ALTER TABLE <table_name>
ADD <column_name datatype>;
j) ALTER TABLE <table_name>
CHANGE <old_column_name> <new_column_name>;
k) ALTER TABLE <table_name>
DROP COLUMN <column_name>;
l) ALTER TABLE <database_name, table_name>
SET <column_name = value>
Correct answer: l) Option 4
MCQ with correct answer on AWS Cloud Theory concept from Module 3:
Q1. Which of the cloud service models provide hardware infrastructure along with operating
system and runtime environments for applications?
a) Infrastructure as a Service (IaaS)
b) Platform as a Service (PaaS)
c) Database as a Service (DBaaS)
d) Software as a Service (SaaS)
Correct answer: b) Platform as a Service (PaaS)
Q2. Which deployment model allows you to host part of your application in cloud and remaining
within your on-premises infrastructure?
a) Public
b) Private
c) Hybrid Cloud
d) Community Cloud
Correct answer: c) Hybrid
Q3. Which among is/are service(s) that can be provided by cloud environment for online live
webinars?
a) Video Encoding
b) Content Sharing
c) Multipoint Scaling
d) All of the mentioned
Correct answer d) All of the mentioned
Q4. Which service among the following is an AWS service for running event driven
functionalities?
a) Lambda
b) EC2
c) Route 53
d) Glacier
Correct answer a) Lambda
Q1. Which service in AWS can be used for storing data archives, not accessed frequently?
a) EBS
b) S3 Bucket
c) Glacier
d) EFS
Correct answer: c) Glacier
Q2. Method(s) to access Amazon Web Services includes:
a) CLI
b) SDK
c) Management Console (Web Based GUI)
d) All of the mentioned
Correct answer d) All of the mentioned
Q3. Which among the following is the service in AWS used for managing user accounts and
permissions?
a) Route 53
b) Lambda
c) AWS Shield
d) AWS Identity and Access Management
Correct answer d) AWS Identity and Access Management
Q1. A location from where cloud services are being accessed by users is known as
a) Region
b) Zone
c) Edge Location
d) Data Center
Correct answer: c) Edge Location
Q2. Which among the following is NOT a default feature of cloud computing environment?
a) High Availability
b) Fault Tolerance
c) Scalability
d) Auto Deletion
Correct answer d) Auto Deletion
Q3. Ability to grow or scale when required and reduce in size when resources are no longer
needed.
a) Elasticity
b) Scalability
c) Availability
d) Reliability
Correct answer a) Elasticity
Comments
Post a Comment