SECTION A
Multiple Choice Questions
Attempt All Questions [30x1=30]
1. Which term refers to a collection of related data stored in an organized manner?
a. Database
b. Spreadsheet
c. File System
d. Data Warehouse
2. What is the primary purpose of a Primary Key in a table?
a. Uniquely identify each record
b. Store duplicate values
c. Link to external files
d. Sort data alphabetically
3. Which SQL clause filters records before grouping?
a. WHERE
b. HAVING
c. GROUP BY
d. ORDER BY
4. In a relational database, a row is also called a:
a. Tuple
b. Attribute
c. Schema
d. Index
5. Which normal form eliminates repeating groups?
a. 1NF
b. 2NF
c. 3NF
d. BCNF
6. Which constraint ensures a column cannot have NULL values?
a. UNIQUE
b. NOT NULL
c. CHECK
d. DEFAULT
7. What does the SQL operator LIKE 'A%' retrieve?
a. Values ending with 'A'
b. Values starting with 'A'
c. Values containing 'A'
d. Values equal to 'A'
8. Which join returns all rows from both tables, filling NULLs for non-matches?
a. INNER JOIN
b. FULL OUTER JOIN
c. LEFT JOIN
d. CROSS JOIN
9. The GROUP BY clause is often used with which aggregate function?
a. CONCAT()
b. COUNT()
c. UPPER()
d. ROUND()
10. Which command permanently removes a table?
a. TRUNCATE
b. DROP
c. DELETE
d. REMOVE
11. Age calculated from Date of Birth is a:
a. Simple attribute
b. Composite attribute
c. Derived attribute
d. Multi-valued attribute
12. In relational algebra, σ represents:
a. Project
b. Join
c. Select
d. Union
13. Which datatype stores large binary objects?
a. VARCHAR
b. TEXT
c. BLOB
d. INT
14. The property "all or nothing" in transactions is:
a. Consistency
b. Isolation
c. Atomicity
d. Durability
15. OLAP is used for:
a. Real-time processing
b. Data entry
c. Business analytics
d. Backup recovery
16. Which SQL command permanently removes a table?
a. DELETE
b. TRUNCATE
c. REMOVE
d. DROP
17. In ER diagrams, double ellipses represent:
a. Weak entities
b. Relationships
c. Derived attributes
d. Multi-valued attributes
18. The correct SQL to filter groups is:
a. WHERE
b. FILTER
c. GROUP
d. HAVING
19. A web crawler browses the:
a. Database
b. Local files
c. Intranet
d. World Wide Web
16. OLAP is used for:
a. Real-time transactions
b. Data entry
c. Backup recovery
d. Business analytics
21. Which SQL keyword removes duplicate rows in results?
a. DISTINCT
b. UNIQUE
c. DIFFERENT
d. ONLY
22. A self-referencing table has a foreign key pointing to:
a. Its own primary key
b. Another database
c. A NULL value
d. A composite key
23. Which SQL keyword ensures a transaction is permanently saved?
a. COMMIT
b. ROLLBACK
c. SAVEPOINT
d. END
24. The HAVING clause filters records:
a. After grouping
b. Before grouping
c. During insertion
d. Before sorting
25. In an ER diagram, a diamond shape represents:
a. Relationship
b. Attribute
c. Entity
d. Constraint
26. The goal of normalization is to:
a. Increase redundancy
b. Reduce redundancy
c. Speed up queries
d. Simplify backups
27. A Client-Server system has:
a. Only one server
b. One or more servers
c. No clients
d. Decentralized control
28. The Durability property ensures:
a. Fast transactions
b. Permanent changes
c. Concurrent access
d. Data consistency
29. Black Box testing focuses on:
a. Code structure
b. Inputs/outputs
c. Database schema
d. Query execution
30. Web queries seeking actions (e.g., purchases) are:
a. Navigational
b. Transactional
c. Informational
d. Connectivity
SECTION B
Short Answer Questions
Attempt any five (5) questions out of eight (8) questions [5x6=30]
1. The relational and network database models represent two distinct approaches to
structuring data within a database. Provide a brief explanation of the relational and network
database models.. (Unit-1 Introduction to Database Systems)
2. In Relational Algebra, union and intersection operations are used to combine or compare
two data sets. Describe how these operations are carried out in Relational Algebra, supporting
your explanation with suitable examples. (Unit – 3 Relational Algebra & Calculus).
3. In database design, logical design refers to the process of defining the structure of the data
based on the requirements and constraints of the system, without considering how the data
will be physically stored. Present an example of logical design in databases and provide a
brief explanation of it. (Unit - 5 Conceptual and Logical Design)
4. Deep Learning and Augmented Intelligence are two advanced concepts in the field of
artificial intelligence that have gained significant attention. Introduce the concepts of Deep
Learning and Augmented Intelligence. (Unit – 8 Database Technology)
5. DDBMSs provide several benefits over traditional centralized database systems. Explain
the advantages and disadvantages of using a DDBMS. (Unit – 9 Distributed Architecture)
6. Database evaluation refers to the process of assessing the quality and effectiveness of a
database. It plays a crucial role in the overall database development lifecycle. Provide a brief
explanation of database evaluation. (Unit – 10 Database Evaluation and Transaction)
7. Data analysis involves inspecting, cleaning, transforming, and modeling data to extract
meaningful insights. There are several steps in the data analysis process. Provide a brief
explanation of the data analysis steps you are familiar with. (Unit-11 Data Analysis)
8. The internet contains vast amounts of information, and web queries help users retrieve
specific data efficiently. Could you explain what web queries are, how they work? (Unit – 12
Database and the World Wide Web)
SECTION C
Long Answer Questions
Attempt any two (2) questions CASE STUDY is compulsory. [2x20=40]
1. Texas University maintains records of students enrolled in the College of
Engineering and Computer Science. The data is currently stored in the following
format:
Addr
Name Courses Instructors
ess
Austi Java, Smith,
Alex
n Algorithms Johnson
Houst
Maria Algorithms Johnson
on
Is this an appropriate way to store the data? Identify any issues related to database
design. If problems exist, explain how 1NF, 2NF, and 3NF can be applied to fix
them.
2. Explain in short, the types of Attributes in ER-D. Design an Entity Relationship
Model for an online store that supplies products to its customers. Include the following
Entities:
o Customer
o Order
o Product
o Supplier
Include the following relations:
o One Customer places many orders.
o One Order contains multiple products.
o Multiple Suppliers can supply multiple products
Show different types of Attributes in the above ER-D
(CASE STUDY)
3. Nepal Film Development Board is trying to store the list of the Board Members in a
table. Below is the table ‘Actor’ with some data in it.
Id Name Address Mobile DOB
1 Rajesh Main Street, Kathmandu 9841234567 1964-01-01
2 Saugat New Road, Kathmandu 9847890123 1980-02-02
3 Manisha Durbar Marg, Kathmandu 9845678901 1970-03-03
4 Dayahang Kadaghari, Bhaktapur 9843210987 1975-04-04
Write SQL queries for the following scenarios:
a. Create a table named ‘Actor’ with primary key Id; Set NOT NULL property to
Name and Address; Default date for DOB should be current date; Length of
‘Mobile’ should always be greater or equal to 10.
b. Insert two rows into the table.
c. Display the output as shown in the above table.
d. ‘Manisha’ moved to ‘Imadole, Lalitpur’ and her Mobile changed to
‘9851012345’. Update the table with this data.
e. Find all the details of Actor born between 1970 and 1980.
f. Find the Age of each actor and sort them by their Age.
g. Find the name and Address of the oldest Actor.
h. Show the Name, Address and Mobile of the Actors whose name starts with
‘S’.
i. If Manisha is no longer associated with the Development Board, delete all her
records.
j. Delete all the records from table without changing its existing structure after
which no rollback could be done.
**** BEST OF LUCK ****