WorksheetsDBMS Practical Quiz
Total questions: 40
Worksheet time: 40mins
Which of the following is a property of database
Represents some aspect of the real world
Logically related collection of data
Built, and populated with data for a specific purpose
All the above
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
Which one of the following is used to define the structure of the relation, deleting relations and relating schemas?
DML(Data Manipulation Langauge)
DDL(Data Definition Langauge)
Query
Relational Schema
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
The SQL used by front-end application programs to request data from the DBMS is called _______
A. DML
B .DDL
C .VDL
D. SDL
The command used to delete a particular column in a relation is ____________
A.UPDATE TABLE
B.TRUNCATE COLUMN
C.ALTER , DROP
D.DELETE COLUMN
What is the full form of DDL ?
A.Dynamic Data Language
B.Detailed Data Language
C.Data Definition Language
D.Data Derivation Language
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
In SQL, which command is used to SELECT only one copy of each set of duplicable rows
A. SELECT DISTINCT
B. SELECT UNIQUE
C. SELECT DIFFERENT
D. All of the above
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database definition or descriptive information is also stored by the DBMS in the form of a _______________
Data catalog
excel file
document file
pdf file
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
What does "SQL" stand for?
Structured Question Language
Structured Query Language
Simple Query Language
Simple Question Language
How do we select all rows for the "Designer" table?
SELECT * FROM Designer
SELECT [All] FROM Designer
SELECT Designer.*
SELECT FROM Designer
Data redundancy occurs
when the same piece of data exists in multiple places.
when there is mismatch of data.
when there is NULL values.
when there is multiple values for an attribute.
ACID properties means
Atomicity, Consistency, Isolation, and Deletion
Atomicity, Consistency, Identification, and Deletion
Atomicity, Consistency, Isolation, and Durability
Atomicity, Construction, Isolation, and Deletion
In an E-R diagram attributes are represented by
square
ellipse
rectangle
triangle
What is the primary key in a relational database?
A key that uniquely identifies each record in a table
A key that is used for encryption
A key that is used for indexing purposes
A key that is a combination of other keys
In a relational database, what is a foreign key?
A key used for opening encrypted data
A key that uniquely identifies each record in a table
A key that links two tables together
A key that is used for indexing purposes
Which type of join returns all rows when there is a match in one of the tables?
Inner join
Left join
Right join
Full outer join
What is the purpose of normalization in database design?
To speed up database performance
To eliminate redundancy and dependency
To make databases smaller in size
To encrypt sensitive data
In which normal form is a relation if it is in Second Normal Form (2NF) and every non-prime attribute is fully functionally dependent on the primary key?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF
In the context of database transactions, what does the term "isolation level" refer to?
The level of security encryption applied to the database
The degree to which transactions are isolated from each other
The level of database indexing applied to improve query performance
The level of redundancy introduced into the database schema
In the context of database transactions, what does the term "isolation level" refer to?
The level of security encryption applied to the database
The degree to which transactions are isolated from each other
The level of database indexing applied to improve query performance
The level of redundancy introduced into the database schema
........... in DBMS is the simplest architecture of Database in which the client, server, and Database all reside on the same machine.
1 Tier architecture
2 Tier architecture
3 Tier architecture
n Tier architecture
Which one of these cannot be taken as a primary key?
ID
registration no
Department ID
Street
Which functional dependency types is/are not present in the following dependencies?
Empno -> EName, Salary, Deptno, DName
DeptNo -> DName
EmpNo -> DName
A. Full functional dependency
B. Partial functional dependency
C. Transitive functional dependency
D. Both B and C
Consider a relation R(A,B,C,D,E) with the following functional dependencies:
ABC -> DE and
D -> AB
The number of superkeys of R is:
2
7
10
12
Suppose relation R(A,B,C,D,E) has the following functional dependencies:
A -> B
B -> C
BC -> A
A -> D
E -> A
D -> E
Which of the following is not a key?
a) A
b) E
c) B, C
d) D
A table is in BCNF if it is in 3NF and if every determinant is a ___________ key.
Dependent
Normal
Candidate
Both Normal and Candidate
What is TRUE about 5NF?
A relation is in 5NF if it is in 4NF, does not contain any join dependencies, and has lossless joining.
In order to avoid redundancy, 5NF ensures that the tables are broken up in as many ways as possible.
Project-join normal form (5NF) is sometimes referred to as Project-join NF.
All of the above
........... is the process of minimizing redundancy from a relation or set of relations.
Normalization
Data redundancy
Data consistency
Schema
To preserve the integrity and consistency of data, the database system must ensure
Atomicity
Isolation
Durability
Consistency
All of the above
Logical design of database, is known to be________
Database relation
Database instance
Database Schema
Database entity
Collections of operations that form a single logical unit of work are called __________
Views
Networks
Units
Transactions
Which of the following is not a property of a transaction?
Atomicity
Simplicity
Isolation
Durability
