One Mark Important Questions
Unit 1
1. What does DBMS stand for?
a. Data Base Management Software
b. Data Base Management System
c. Data Bank Management Software
d. Data Banking Management System
2. Which of the following is not a function of DBMS?
a) Data storage, retrieval, and update
b) User authentication and authorization
c) Web page creation
d) Database integrity and security
3. The file processing system typically requires __________ to handle the data.
a) Custom software
b) Database software
c) Spreadsheet software
d) Word processing software
4. The external level of the ANSI/SPARC model deals with __________.
a) User views of the data
b) Data encryption
c) Data indexing
d) Data back-ups
5. Which of the following provides the best example of data independence?
a) Changing the storage device without modifying application programs
b) Changing a user password without modifying data access
c) Modifying the user interface without changing data
d) Altering the logical schema without changing the external schema
6. Which of the following is an advantage of the client-server architecture?
a) Centralized control
b) Data redundancy
c) Increased data inconsistency
d) Simplified data sharing
9. The DBA is responsible for __________.
a) Creating databases and maintaining them
b) Writing SQL queries for users
c) Interpreting data analysis
d) Providing technical support to users10. Which of the following is not a component
of the three-tier database architecture?
a) Presentation tier
b) Application tier
c) Data tier
d) Network tier
1. The __________ level in the ANSI/SPARC model is responsible for the physical
storage of data.
2. __________ databases store data in key-value pairs, documents, or graphs instead
of
tables.
3. The __________ in a client-server architecture requests services from the server.
4. In a file processing system, __________ refers to the unnecessary duplication of
data.
5. The database administrator (DBA) is responsible for __________ and maintaining
databases.
6. Explain DBMS architecture with block diagrams
UNIT 2
1. Which of the following is used to define the structure of a database table?
(a) DDL
(b) DML
(c) TCL
(d) SQL
2. The `CREATE TABLE` statement is an example of a:
(a) DDL command
(b) DML command
(c) TCL command
(d) None of the above
3. Which of the following commands is used to insert a new record into a table?
(a) CREATE
(b) INSERT
(c) UPDATE
(d) DELETE
6. Which of the following is NOT a DDL command?
(a) CREATE TABLE
(b) ALTER TABLE
(c) INSERT
(d) DROP TABLE
7. `COMMIT` and `ROLLBACK` are examples of:
(a) DDL commands
(b) DML commands
(c) TCL commands
(d) None of the above
8. `COMMIT` is used to:
(a) Revert changes made within a transaction
(b) Permanently save changes made within a transaction
(c) Delete all data from a table
(d) View data from multiple tables
9. What does `ROLLBACK` do?
(a) Permanently save changes made within a transaction
(b) Revert changes made within a transaction
(c) Create a new database user(d) Grant permissions to a database user
Q1. Which of the following commands is used to permanently remove a table from
the database:
CREATE, ALTER, DROP?
Q2. What category of SQL commands (DDL, DML, TCL) is used to update existing
information
within a table?
Q3. If you made a mistake while entering data and want to undo the changes, which
TCL
command would you use?
Q4. What is date function? Explain its types.
UNIT 3
Fill in the Blanks
1. The network model is based on a __________ structure that allows many to many
relationships.
2. The hierarchical model supports __________ relationships, where each parent can
have
multiple children.
3. A __________ key in a table uniquely identifies each row in that table.
4. The concept of __________ allows an object to inherit properties and
behavior from another object.
5. A __________ attribute can be divided into smaller sub-parts.
6. A __________ attribute is calculated from other attributes.
7. __________ specifies the number of instances of one entity that can or
must be associated with each instance of another entity.
8. __________ participation means that all instances of an entity must
participate in the relationship.
9. A weak entity set can be identified uniquely only by considering the primary
key of the __________ entity set.
10. __________ is a bottom-up approach in which lower-level entities are
combined to form a higher-level entity.
11. Define Following Concepts: Entity, Attribute, Relationship
UNIT 4
1. An entity set attributes that does not have a primary key within them, is termed as a
.............weak entity............. set.
2. The ER model is important for its role in .......... database design.....................
3. ........... Rectangles.................. represent entity sets.
4. ............. Aggregation................ allows us to indicate that a relationship set
participates in
another relationship sets.
1. Explain the following terms: (i) Aggregation (ii) Generalization (iii) Super key (iv)
Candidate keys.
2. Explain the following terms briefly:
(i) Attribute (ii) Domain (iii) Entity (iv) Relationship (v) Entity set (vi) One to many
relationship (vii) Participation constraint (viii) Weak entity set (x) Composite key.
3. Explain the distinction among the terms—primary key, candidate key and the super
key.
4. What is entity, entity type, entity sets and attribute? What is mapping cardinalities?
Explain different cardinalities.
5. Explain the difference between a weak and a strong entity set.
Fill in the blanks:
1. A ___________ dependency is a constraint between two attributes in a database.
2. A functional dependency of the form A -> A is called a ___________ dependency.
3. Armstrong's axioms include Reflexivity, Augmentation, and ___________.
4. The closure of a set of functional dependencies is the set of all functional
dependencies that can be ___________ from the given set.
