Part – B Unit – 3

DATABASE MANAGEMENT SYSTEM

1. __________ helps us to retrieve the filtered data based upon specified conditions.
a) Report b) Table c) Query ✓ d) Form

2. The fundamental object of a database that is a collection of information stored in rows and
columns format is called____________.
a) Tables ✓ b) Form c) Query d) Report
3. ODB stands for
a) Open Office Database ✓ b) Open Document Database
c) Open Database d) Open Office Base
4. Which of the following is not the advantage of database?
a) Sharing of Data b) Reduce Data Redundancy
c) Increase Data Inconsistency ✓ d) Data Security
5. When primary key is made up of two or more columns then it is called __ primary key.
a) Mixed b) Reference c) Composite ✓ d) Compost
6. All the values in ________ are of same type.
a) Records b) Table c) Database d) Fields ✓
7. _______________ are the basic building blocks of a database.
a) Tables ✓ b) Record c) Field d) All of the above
8. Which of the following is not valid field of table “Student”
a) adm. No b) name c) fees d) Salary ✓
9. A field which is ______ for each and every record is called Primary key.
a) Common b) Same c) Unique ✓ d) None of the above

10. A database stores and processes data in the form of.

a) Rows b) Columns c) Tables ✓ d) All of these
11. Which Query is used to retrieve data from one or more tables and display the record set in a
datasheet?
a) Select ✓ b) Update c) Cross d) Drop
12. A query can be previewed by pressing.
a) F1 b) F2 c) F3 d) F4 ✓
13. Which key defines a relationship between two tables?
a) Foreign key ✓ b) Primary key c) Secondary key d) Alternate Key
14. How many sections are there in a Query Design window?
a) One b) Two ✓ c) Three d) Four

15. Which key helps to run a query?

a) F2 b) F5 ✓ c) F6 d) F8
16. Which view gives more control over a query?
a) Design View ✓ b) Wizard c) SQL View d) View
17. RDBMS is based on the relational model introduced by
a) Henry Ford b) E.F.Codd ✓ c) Both (a) and (b) d) None of these
18. Ragini has created a table named Student_Details in order to store all the details of
the student of her class. She has added the following fields: Admission_No, Student_Name,
Birth_Date, Address, Joining_Date, Mother_Name, Father_Name. Out of the following fields,
which field can be selected as primary key as the entries in it will be unique?
a) Admission_No ✓ b) Birth_Date c) Student_Name d) None of these

1. Distinguish between Data and Information.

Ans. Data are facts or the raw material of information. Data are represented by symbols. After
processing the data, information is produced. Thus, information is data arranged in an order that would
be useful to the user.
2. Define the term DBMS.
Ans. The database is managed by a software package known as database management system.
3. What is database? Give example.
Ans. A database is a collection of information that is organized so that it can easily be accessed,
managed, and updated. They do so through the use of tables. For example, MS-Access, OpenOffice
Base, Oracle, MySQL, etc.
4. Define RDBMS.
Ans. In RDBMS the data is organized in the form of tables (i.e. rows and columns). These tables are
called relations. Each row in a table represents a relationship among a set of values.
5. Write any two advantages of using database.
Ans. The advantages of using database are:
(i) A database is used to store information for future purpose in a tabular form, whereas the data can be
used further at any time.
(ii) Storage and retrieval of data becomes faster and convenient.
(iii) Reduces Data Redundancy
(iv) Reduces Data Inconsistency
(v) Improves Data security
Explain Different types of Databases.
Ans – The two most common types of databases are Flat File Database and Relational Database.
A flat file database is a database that stores its contents in a single table.
A Relational Database stores the data and information in multiple tables with rows and columns.
6. What is a field?
Ans. A field is a column on a datasheet and defines a data type for a set of values in a table.
7. What is a record?
Ans. A record is a row on a datasheet and is a set of values defined by fields.
8. Distinguish between a record and a field in a table, with an example.
Ans. A record is a collection of data items which represents a complete unit of information.
A field is a category of information. It contains set of characters which have a proper meaning. For
example, if Student is a table, then rollno, name, class and section are the fields, and the entire
information of one student is called a record.
9. What is the difference between ‘Rows’ and ‘Columns’ in a table?
Ans. In a table, rows are called the records and columns are called fields. A row stores complete
information of a record, whereas a column stores only similar data values for a number of records
10. What do you mean by DBMS? Write two advantages of using Database Management System
for school.
Ans. The Database Management System is an integrated set of programs which help us to manipulate
database. The manipulation of database means collection, addition, insertion, modification and deletion
of records into a database. The two advantages of DBMS are: (i) sharing of data and data security.
11. Give any one use of database.
Ans. A database is used to store information for future purpose in a tabular form, whereas the data can
be used further at any time.
12. Write the purpose of Database Management System.
Ans. A DBMS is used to store information for future purpose in a tabular form, whereas the data can be
used further at any time. Using this system, we can manipulate database which means collection,
addition, insertion, modification and deletion of records into a database.
13. How does an MS-Access table stored?
Ans. In Microsoft Access a database consists of one single file. The file contains all the tables of the
database, the relationships (the crow’s feet), queries (computed tables), forms (user windows), and
many other things.
14. What is a data type?
Ans. The attribute of a field that determines the kind of data the field can contain is called data type.
15. What is a primary key in Database? Give an example.
Ans. The column or set of columns included in the definition of a table is called PRIMARY KEY. A
primary key’s values uniquely identify the rows in a table. Only one primary key can be defined for each
table. For example, in a table like Student, Roll No. is a primary key.
16. Name two possible Primary key fields for an Employee table.
Ans. Possible Primary key fields for an Employee table are: Empcode, Empname.
17. Give any one advantage of using Primary Key.
Ans. The primary key is one which is having a unique value for the row. This key helps us to uniquely
identify each row.
18. Write the difference between Text and memo data types.
Ans. Text field can contain alphanumeric characters (A-Z and 0-9) plus special characters such as !, @
and %. Text fields have a maximum length of 255 characters. Memo fields also contain alphanumeric
characters, though memo fields can store much more data than text fields i.e., up to 64,000 characters.
19. Name the data type that should be used to store Student’s Admission numbers.
[Examples of Admission numbers: S100, S101, S102].
Ans. The data type is: Text
20. What are the uses of TCL commands?
Ans. These are used to manage the changes made to the data in a table by DML statements. It also
allows statements to be grouped together into logical transactions.
21. What are DDL and DML?
Ans. DDL. DDL is a part of SQL. It stands for data definition language. It provides statements for
creation and deletion of the database. For example, CREATE TABLE, ALTER TABLE.
DML. DML is also a part of SQL. It stands for data manipulation language. It provides statements for
manipulating the database. It includes commands to insert, delete and modify tuples in the database.
For example, INSERT INTO, DELETE FROM, UPDATE.
22. What is the purpose of ALTER command?
Ans. This command is used to change or alter the table structure. We can add new columns and
change the data type of column or drop any constraint like primary key using alter command.
23. What is the purpose of using COMMENT command?
Ans. When we use any DML command like INSERT, UPDATE or DELETE, the changes made by these
commands are not permanent, until the current session is closed, the changes made by these
commands can be rolled back.
Write database objects
24. How does an MS-Access table stored?
Ans. In Microsoft Access a database consists of one single file. The file contains all the tables of the
database, the relationships (the crow’s feet), queries (computed tables), forms (user windows), and
many other things.
25. Name the MS-Access view in which you can define the fields and their data types.
Ans. Design View
26. Name the extension of an Access 2010 database file.
Ans. .accdb
27. Name the view in which you can add, edit and view records in MS-Access.
Ans. Datasheet View
28. Write the difference between design view and datasheet view in Access.
Ans. In design view, you have to specify by own data types & column names. It allows you to define the
fields in the table before adding any data to the datasheet. This is the most common way of creating a
table. Datasheet view create table by entering data. The Datasheet View shows the records in a table.
Each row is one record. The columns are the fields from the table’s definition. This table looks a lot like
a spreadsheet, but it does not behave quite like a spreadsheet.
29. Mention any one difference between Text and Numeric type field in database.
Ans. Text field stores character type data. Text fields can contain alphanumeric characters (A-Z and 0-
9) plus special characters such as !, @ and %.
Number fields store only numbers. The range of numeric values stored depends upon which value you
select from the field size property.
30. What are the two areas of the Design view of the Table?
Ans. Field information and Field Properties.
31. What is primary key? How do we set Primary Key?
Ans. Primary key is the key which can be assigned once into a table. Using this key, it allows entry of
unique records into the table. For example, to set the primary key,
32. What are queries?
Ans. Queries are those objects in a database that allow us to view, change, and arrange data stored in
tables.
33. What is select query?
Ans. A select query is a simple query which retrieves data from one or more tables, and in many cases,
uses specified criteria to limit the records displayed and to sort them in a specified order
34. What are table relationships?
Ans. Table relationships means to create a link between two or more tables within a database. A table
relationship exists when two tables share some information in the form of common fields.
35. How does a relationship occur between two tables?
Ans. A relationship between two tables occur through a primary key and a foreign key.
36. What is keys in database?
Ans. A Key plays a significant role, since it is used to identify unique records or tuples from a table.
37. What is composite key?
Ans : A composite key is also known as a composite primary key. This key refers to a combination of
multiple fields that uniquely identify the record in a table. This could be a primary key or candidate key.
38.What is foreign Key?
Foreign key is a field in a table which acts as a primary key in another table. It works as a cross
reference between the table.
39. What is candidate Key?
Ans – A table can have more than one field that can uniquely identify the records or tuples are known as
Candidate keys.
2) What is DDL and DML? Give one example of each.
Ans: Data Definition Language (DDL) A data definition language or data
description language (DDL) is a standard for commands that define the different
structures in a database. DDL statements create, modify, and remove database
objects such as tables, indexes, and users. Example CREATE, ALTER, and
DROP.
 Data Manipulation Language (DML) A data manipulation language (DML) is a
language that enables users to access and manipulate data in a database. The
goal is to provide efficient human interaction with the system. For Example
Insert, Update, Delete and Select.

(a) Write a Query to create a Table with the following structure

Table Product
Field Datatype
PID Char(4)
Pname Varchar(20)
Description Varchar(40)
Price Decimal
Ans: Create table Product (PID Char(4), Pname Varchar(20), Description
Varchar(40), Price Decimal);
(b) Consider the following Vendor table and write the queries
Table Vendor
VendorID VName DateofRegistration Location
V001 Mother Dairy 20-01-2009 Delhi
V002 Havmor 01-04-2015 Gujrat
V003 Amul 12-05-2012 Kolkata
V004 Kwality Walls 15-10-2013 Mumbai
(i) Write a Query to display all records
Ans Select * from Vendor;
(ii) Write a Query to add a new row with the following details (‘V005’, ‘Vadilal’,
‘2010-03-20’, ‘Pune’)
Ans Insert into Vendor values (‘V005’, ‘Vadilal’, ‘2010-03-20’, ‘Pune’);
(iii) Write a query to modify the location of V003 from Kolkata to Gujrat
Ans Update Vendor Set location= ‘Gujrat’ Where location= ‘Kolkata’;
Students
*