NEW
Font size
WorksheetsDatabase Concepts Worksheet (Grade 13)
Total questions: 72
Worksheet time: 36mins
Which one of the following refers to the "data about data"?
Directory
Sub Data
Warehouse
Meta Data
Which of the following is a top-down approach in which the entity's higher level can be divided into two lower sub-entities?
Aggregation
Generalization
Specialization
All of the above
In the relational table, which of the following can also be represented by the term "attribute"?
entity
Row
Column
Both B & C
Which of the following is not a type of database?
(Implied)
Network
Distributed
Decentralized
Given the basic ER and relational models, which of the following is INCORRECT?
An attribute of an entity can have more than one value
An attribute of an entity can be composite
In a row of a relational table, an attribute can have more than one value
In a row of a relational table, an attribute can have exactly one value or a NULL value
What is a relationship called when it is maintained between two entities?
Unary
Binary
Ternary
Quaternary
Which of the following can be a multivalued attribute?
phone_number
Name
Date_of_birth
All of the mentioned
The candidate key which are not selected as primary key are known as secondary keys or alternative keys.
Alternative key
Composite Key
Primary Key
Candidate Key
When an Entity is related with itself it is known as — Relationship.
Ternary
Binary
Recursive
None
This model efficiently describes many real-world relationships like index of a book.
E-R Models
Network Model
Hierarchical Model
Relational Model
The attributes with values that are atomic and cannot be broken down further are simple attributes.
Simple attribute
Composite attribute
Derived attribute
Single-valued attribute
_____ is the most commonly used architecture for web applications.
3-tier DBMS
1-tier DBMS
2-tier DBMS
none
Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
DML (Data Manipulation Language)
Query
Relational Schema
DDL (Data Definition Language)
Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
DML (Data Manipulation Language)
DDL (Data Definition Language)
Query
Relational Schema
Which one of the following given statements possibly contains the error?
select * from emp where empid = 10003;
select empid from emp where empid = 10006;
select empid from emp;
select empid where empid = 1009 and Lastname = 'GELLER';
What do you mean by one to many relationship?
One class may have many teachers
One teacher can have many classes
Many classes may have many teachers
Many teachers may have many classes
In the following Query, which of the following can be placed in the blank portion to display salary from highest to lowest, and name alphabetically? (ORDER BY salary __, name __)
Ascending, Descending
Asc, Desc
Desc, Asc
All of the above
A Database Management System is a type of software.
It is a type of system software
It is a kind of application software
It is a kind of general software
Both 1 and 3
Which of the following commands is used to save any transaction permanently?
Commit
Rollback
Delete
All of the above
(Context: Data Independence) Which of the following implies that programs are not dependent on physical attributes?
Data is defined separately and not included in the programs
Programs are not dependent on the logical attributes of the data
Programs are not dependent on the physical attributes of the data
None
In the relational model, the relation are generally termed as.
Tuples
Attributes
Rows
Tables
It is used to establish an association between related tables?
Line
Relationship
Primary Key
Records
Which of the following enables us to view data from a table based on a specific criteria?
Form
Query
Macro
Report
Which one of the following commands is used to modify a column inside a table?
Drop
Update
Alter
Set
The Database Management Query language is generally designed for the.
Support end-users who use English like commands
Specifying the structure of the database
Support in the development of the complex applications software
Ensure Foreign Key
Two tables can be linked with relationship to.
entity set
Entity
attribute
Keys
The descriptive property possessed by each entity set is.
Entity
Attribute
Relation
Model
They are used to establish and identify relationships between tables and also to uniquely identify any record or row of data inside a table.
entity set
Entity
attribute
Keys
_____ is a bottom-up approach in which two lower level entities combine to form a higher level entity.
Generalization
Specialization
Aggregations
None
Which one is an example of DBMS?
C++
Oracle
Java
none
This user group is involved in developing and designing the parts of DBMS.
Database Administrators
Application Programmer
End User
Designer
In which of the following formats data is stored in the database management system?
Image
Text
Table
Graph
Which of the following is a function of the DBMS?
Storing data
Data Integrity
Providing multi-users access control
All of the above
Which of the following is not an example of DBMS?
Hyper data
Beta data
Meta data
Relations
What is information about data called?
MySQL
Microsoft Access
IBM DB2
Meta Data
What does an RDBMS consist of?
Collection of Records
Collection of Keys
Collection of Tables
Collection of Fields
The DBMS acts as an interface between _____ and _____ of an enterprise-class system.
Data and the DBMS
Application and SQL
Database application and the database
Application and SQL
The ability to query data, as well as insert, delete, and alter tuples, is offered by.
TCL
DCL
DDL
DML
Which command is used to remove a relation from SQL?
Drop table
Delete
Purge
Remove
_____ is a set of one or more attributes taken collectively to uniquely identify a record.
Primary Key
Foreign key
Super key
Candidate key
The term _____ is used to refer to a row.
Attribute
Tuple
Field
Instance
An attribute in a relation is a foreign key if the _____ from one relation is used as an attribute in that relation.
Candidate
Primary
Super
Sub
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called.
Simple attribute
Composite attribute
Multivalued attribute
Derived attribute
The Entity-Relationship (E-R) Model represents data using:
File directories and folders
Binary trees
Graphical diagrams showing entities and relationships
Two-dimensional tables
What is a Database?
A collection of related data organized for easy access and management
A collection of unrelated data stored randomly
A hardware device that stores data temporarily
A software tool used for data analysis only
The Network Model is mainly an extension of which model?
Object-Oriented Model
Hierarchical Model
Relational Model
Entity-Relationship Model
Which of the following is not a disadvantage of a DBMS? (Which is an advantage?)
Lack of data consistency
Large in size
Cost
Complexity
When does Data become Information?
When it is stored in a table
When it is converted into binary form
When it is processed to provide meaning
When it is transmitted over a network
Who among the following was one of the first to realize the need for a software-based Database Management System (DBMS)?
Charles Babbage
Dennis Ritchie
Bill Gates
Larry Ellison
Which of the following best describes a 3-tier DBMS architecture?
It adds an extra GUI or Presentation Layer above the Application Layer
It allows direct connection of users to the database
It is used only for local testing purposes
It includes only user and database layers
In a One-to-Many relationship, one entity instance in table A can be related to multiple instances in table B.
TRUE
FALSE
In a Hierarchical Model, each child node can have:
Only one parent node
Multiple parent nodes
No parent node
Unlimited parent and child nodes
A Derived Attribute is physically stored in the database as raw data.
TRUE
FALSE
What does a Database Model define?
The logical design and structure of a database
The type of hardware used to store data
The physical location of data files
The language used to write queries
Aggregation treats the relationship between two entities as an entity itself.
TRUE
FALSE
What does the term Generalization mean in an Enhanced ER Model?
Representing a recursive relationship
Dividing one higher-level entity into lower-level entities
Combining two or more lower-level entities to form a higher-level entity
Creating a new attribute from existing ones
Which of the following is NOT a component of a DBMS?
Software
Hardware
Data
Compiler
In the Hierarchical Model, data is organized in which structure?
Linear structure
Graph-like structure
Tabular structure
Tree-like structure
What is Data?
Processed information that provides meaning
Raw facts and statistics that are unprocessed
Information derived from database queries
A collection of related records stored in tables
What does the Hardware component of a DBMS include?
Only Database Files
Only CPU and Monitor
The DBMS Software and Application Layer
Computer, Hard Disks, I/O Channels, RAM, and Keyboard
Each child node in a hierarchical model can have multiple parent nodes.
TRUE
FALSE
Which DBMS component refers to instructions for using and managing the system?
Data
Procedures
Software
Database Access Language
Who introduced the Relational Model?
Larry Ellison
E. F. Codd
Dennis Ritchie
Charles Babbage
In the Student table, the attribute student_id is an example of which type of key?
Composite Key
Foreign Key
Alternate Key
Candidate Key (or Primary)
Which of the following is not a characteristic of DBMS?
Data inconsistency
Reduced redundancy
Data stored into tables
Security and protection of data
In 2-tier DBMS architecture, what lies between the user and the DBMS?
Hardware Layer
Backup Layer
Application Layer
Presentation Layer
In the Relational Model, data is stored in:
Two-dimensional tables called relations
Files and folders
Trees and branches
Linked lists and arrays
Which type of attribute can be divided into smaller subparts like "street name" and "pin code"?
Composite Attribute
Simple Attribute
Derived Attribute
Multivalued Attribute
A Weak Entity is represented in an ER diagram by a single rectangular box.
FALSE
TRUE
What is the role of the Database Access Language?
To connect hardware devices to the DBMS
To define procedures and backups
To translate software code into SQL
To write commands for accessing, inserting, updating, and deleting data
Which of the following best defines an Entity in an ER Model?
A field used as a primary key
A software component of DBMS
A relationship between two tables
A real-world object that has attributes
Which of the following is an advantage of a DBMS?
Lack of data security
High cost and complexity
Minimal data duplicity
Increased data redundancy
