WorksheetsIntroduction To DBMS
Total questions: 40
Worksheet time: 20mins
Which language is used to request information from a Database?
Relational
Structural
Query
Compiler
The ---------- diagram gives a logical structure of the database graphically?
Entity - Relationshipt
Entity
Architectural Representation
Database
The ---------- diagram gives a logical structure of the database graphically?
Strong entity set
Weak entity set
Identity set
Owner set
---------- Command is used to delete a database.
Delete database database_name
Delete database_name
drop database database_name
drop database_name
Which type of below DBMS is MySQL?
Object Oriented
Hierarchical
Relational
Network
MySQL is freely available and is open source.
True
False
---------- represents a “tuple” in a relational database?
Table
Row
Column
Object
Communication is established with MySQL using
SQL
Network calls
Java
API’s
Which is the MySQL instance responsible for data processing?
MySQL Client
MySQL Server
SQL
Server Daemon Program
The structure representing the organizational view of entire
database is known as -------- in MySQL database.
Schema
View
Instance
Table
________ is the hierarchical database model.
Information Management System
Integrated Data Store
Oracle
DB2
________ is the network database model.
Information Management System
Integrated Data Store
Oracle
DB2
Identify the relational database model.
Information Management System
Integrated Data Store
Oracle
DB2
Which is not a RDBMS?
MySql
Ms Access
Oracle
Ms word
____ is defined as the collection of data.
Table
Row
Column
Database
Each column is known as
Tuple
Record
Relation
Attribute
A single entry in a table is called as
Row
Tuple
Record
All the above
Which key is used for identification task _______
Primary Key
Candidate Key
Super Key
Alternate Key
Non primary keys are called _________
Primary Key
Candidate Key
Super Key
Alternate Key
The _____ is also known as minimal super keys
Primary Key
Candidate Key
Super Key
Alternate Key
_____ is a column that creates a relationship between two tables.
Primary Key
Candidate Key
Super Key
Foreign Key
A key with more than one attribute to identify rows uniquely in a table is called
Primary Key
Candidate Key
Super Key
Composite key
______ also known as Compound Key
Primary Key
Candidate Key
Super Key
Composite key
The basic concept of ER model consists of
Entity
Relationship
Attributes
All the above
An _____ is an object or component of data.
Entity
Relationship
Attribute
Instance
A ______ is the one which doesn’t depend on any other entity on the database
Strong entity
Weak entity
Entity Instance
None of the above
______ are the values for the entity
Strong entity
Weak entity
Instance
None of the above
An _______describes the property of an entity.
Entity
Relationship
Attribute
Instance
How many types of attributes are there?
2
3
4
5
Uniquely identifies each entity in the entity set is called
Key attribute.
Composite Attribute
Multi valued attribute
Derived attribute
____ have atomic values, which cannot be divided further.
Simple attributes
Composite Attribute
Multi valued attribute
Derived attribute
____ can be subdivided into simple attributes without change in the meaning of that attribute.
Simple attributes
Composite Attribute
Multi valued attribute
Derived attribute
Contains only one value for the attribute and they don’t have multiple numbers of values?
Simple attributes
Composite Attribute
Multi valued attribute
Single Valued attribute
A _____ has more than one value for that particular attribute.
Simple attributes
Composite Attribute
Multi valued attribute
Single Valued attribute
•A relationship is represented by
Diamond shape.
Oval
Circle
Rectangle
When a single instance of an entity is associated with a single instance of another entity then it is called
One to one relationship.
One-to-Many relationship
Many-to-Many relationship
Many to one relationship
When a single instance of an entity is associated with more than one instances of another entity then it is called
One to one relationship.
One-to-Many relationship
Many-to-Many relationship
Many to one relationship
Each instance of the relationship between members of these entity types is called a
Entity
Relationship
Attribute
Relationship instance
The number of entity types involved is known as
Relationship type
Cardinality
Degree of relationship
None of the above
The number of items that must be included in a relationship is called
Relationship type
Cardinality
Degree of relationship
None of the above
