WorksheetsDBMS Unit 1
Total questions: 40
Worksheet time: 20mins
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
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
Data about data is normally termed as
directory
data bank
meta data
super data
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.
All the _____________ in a table are called fields.
rows
columns
cells
constraints
The rows in a table are called _______________.
data
records
queries
output
A database stores a vast amount of data, but _____________ helps us to retrieve the filtered data based upon some conditions.
forms
reports
queries
all of the above
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 statement in SQL which allows to change the definition of a table is
Alter
Update
Create
Select
Which of the following are characteristics of a DBMS
Self-Describing
Support Multiple Views
Single user systems
Data Sharing
Which data type collect whole numbers?
Float
Integer
Text
Date/Time
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
DDL
Relational Schema
Query
CREATE TABLE employee (name VARCHAR, id INTEGER)
What type of statement is this?
DML
DDL
View
Integrity constraint
Which word is missing from the following SQL statement?
Select * table_name
With
Where
From
And
How do we select all rows for the "Design" table?
SELECT * FROM Design
SELECT [All] FROM Design
SELECT star from Design
SELECT FROM Design
The data model which describes how the data is actually stored is
internal model
external model
logical model
none of these
A view of database that appears to an application program is known as
schema
subschema
virtual table
none of the above
Which of the following statements contains an 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’;
The ______ clause allows us to select only those rows in the result relation of the ____ clause that satisfy a specified predicate.
Where, from
From, select
Select, from
From, where
SELECT * FROM employee WHERE dept_name="Comp Sci";
In the SQL given above there is an error . Identify the error.
Dept_name
Employee
“Comp Sci”
From
In the given query which of the keyword has to be inserted?
INSERT INTO employee _____ (1002,'Joey',2000);
table
values
from
relation
An attribute A of datatype varchar(20) has the value “Avi” . The attribute B of datatype char(20) has value ”Reed” .Here attribute A has ____ spaces and attribute B has ____ spaces .
(i.e the total number of utilized space by A,B)
3,20
20,4
3,4
20,20
Who proposed the relational model?
Bill gates
E.F.Codd
Charles Babbage
Herman Hollerith
Which of the following is incorrect regarding levels of abstraction in database?
Physical level describes how to store a record and not the relationship among the data.
Logical level describes what data to stored in database and the relationship among the data.
View level hides the details of data types
Physical level describes what data to stored in the database.
Which of the following is true about data independence?
It is the ability:
To modify schema definition in one level without affecting schema definition in the next lower level.
To modify schema definition in one level without affecting schema definition in the next higher level.
To modify the data at one level without affecting the data in the next lower level
To modify the data at one level without affecting the data in the next higher level.
Identify the following the correct way/s to delete all rows at a time from salary table.
DELETE * FROM salary;
TRUNCATE TABLE salary;
DELETE FROM SALARY;
TRUNCATE TABLE FROM salary;
The actual content in the database at a particular point.
Schema
Attribute
Parameter
Instance
Which one of the following is commonly used to define the overall design of the database?
Application program
Data definition language
Schema
Source code
........... 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
A ............ in DBMS is a Database architecture where the presentation layer runs on a client (PC, Mobile, Tablet, etc.), and data is stored on a server called the second tier.
1 Tier architecture
2 Tier architecture
3 Tier architecture
n Tier architecture
........... contains a presentation layer, an application layer, and a database server.
1 Tier architecture
2 Tier architecture
3 Tier architecture
n Tier architecture
A Relational database consists of a collection of
Tables
Fields
Records
Keys
Which of the following is not a level of data abstraction?
Physical Level
Critical Level
Logical Level
View Level
Select the DBMS software
MySQL is
A Programming language
A Markup language
A technique for writing reliable programs
A Relational Database Management System
Before use of DBMS information was stored using __________.
Cloud Storage
Data System
File Management System
Business Process Modeling
Which of the following is NOT the DDL command?
Drop
Create
Alter
Update
In database records are called:
Attributes
Entity
Tuples
Relations
