Font size
S
M
L
XL
WorksheetsCIT 283 CH 1 to 6 MCQS
Total questions: 101
Worksheet time: 34mins
Name
Class
Date
1.
Which of these is not DBMS?
a)
SQL Server
b)
Microsoft Access
c)
MS Word
d)
Oracle
2.
What is the main difference between data and information?
a)
Data is raw, information is processed
b)
Information is stored, data is not
c)
Data is organized, information is ramdom
d)
Data is meaningful, information is not
3.
what is metadata?
a)
File extension
b)
Data about data
c)
A programming language
d)
A security method
4.
Which of the following is NOT a component of DB application?
a)
Hardware
b)
Printer
c)
Procedures
d)
Software
5.
What is the role of SQL in DBMS?
a)
Querying database
b)
Designing webpages
c)
Drawing diagrams
d)
Managing OS
6.
What kind of relationship does a relational database use?
a)
Random
b)
Symbolic
c)
File-based
d)
Table-based
7.
which software allows graphical access and development in DBMS?
a)
Notepad
b)
Excel
c)
Microsoft Access
d)
Paint
8.
Which is a disadvantage od DBMS?
a)
Expensive software
b)
Reduced redundancy
c)
Security control
d)
Backup facility
9.
Which component of a DB application includes instructions for use?
a)
Data
b)
Procedures
c)
Software
d)
Hardware
10.
What is a major advantage of DBMS?
a)
Poor performance
b)
High redundency
c)
Data sharing
d)
Uncontrolled access
11.
What is the function of DBMS?
a)
Manages, stores and retrives data
b)
Only stores data
c)
Organizes files
d)
Deletes information
12.
What features of DBMS helps multiple users to access data?
a)
Manual input
b)
Efficient data sharing
c)
Data isolation
d)
File locking
13.
Who uses queries and dashboards in DBMS?
a)
DBA
b)
Data Analyst
c)
Developer
d)
End User
14.
Which component includes physical devices?
a)
Hardware
b)
Software
c)
Data
d)
Access language
15.
Which of the following is a limitation of triditional file system?
a)
Data redundency
b)
Easy data sharing
c)
High security
d)
No data duplication
16.
What is the key role of Data Administrator?
a)
Coding applications
b)
Managing database system
c)
Making websites
d)
Designing logos
17.
Which DBMS is developed by Oracle Corporation?
a)
Oracle
b)
SQL server
c)
Access
d)
MySQL
18.
Which terms refers to raw facts before processing?
a)
Information
b)
Data
c)
Query
d)
Program
19.
Which DBMS is known for ease of use and speed?
a)
Access
b)
SQL server
c)
MySQL
d)
Oracle
20.
Which of the following is an example of a database access language?
a)
XML
b)
CSS
c)
HTML
d)
SQL
21.
What is the main purpose of a database model?
a)
To store files
b)
to define data structure and relationships
c)
to print reports
d)
to create web pages
22.
which language defines the structure of a database ?
a)
DDl
b)
DCL
c)
DML
d)
HTML
23.
what is stored in a physical data model?
a)
Entity names
b)
Datatypes only
c)
user interface
d)
Storage formats and access paths
24.
whish model is represented using and an ER diagram?
a)
Record-Based model
b)
conceptual model
c)
cliuod model
d)
physical model
25.
in a ghraph database, data is stored as,
a)
files
b)
nodes &edges
c)
columns
d)
tables
26.
which command is part of DDL?
a)
Grant
b)
select
c)
Update
d)
Create
27.
in three-Tier architecture ,the middle tier is known as:
a)
Data layer
b)
Bussiness logic layer
c)
web Tier
d)
Client Tier
28.
what layer stores data in a Two -Tier Architecture?
a)
Server layer
b)
Middle ware
c)
Client Tier
d)
Presentation layer
29.
what is "Truncate " used for?
a)
Merge tables
b)
Grant permisstions
c)
Remove All records
d)
modify a comlmns
30.
which architecture is more secure?
a)
File -based
b)
Three- Tier
c)
Two-tier-
d)
Pysical
31.
which model represents real world entities and relationships?
a)
Record-Based model
b)
physical model
c)
Object -basied
d)
logical Model
32.
which command is used is used to give access in DCL?
a)
Dorp
b)
Turncate
c)
Delete
d)
Grant
33.
what does N-tier architecture promote ?
a)
Slower performance
b)
Data loss
c)
Complex errors
d)
Flexoblillity and scaleablility
34.
which command is used to delete records in DML?
a)
Delete
b)
Rename
c)
Turncate
d)
Dorp
35.
what is the role of the Appliction layer in N-Tier?
a)
Dsplay ul
b)
hardware control
c)
Execute bussiness rules
d)
Store data
36.
which is an advantage of cloud database ?
a)
Manual backup
b)
Expensive
c)
Complex access
d)
Scalable and Accsessibble
37.
which command is used to retrieve data?
a)
Insert data
b)
Drope data
c)
Update data
d)
Select
38.
which databace type distributes data across mutiple sites ?
a)
Hierarchical DB
b)
Distributet DB
c)
cloud DB
d)
Centralized DB
39.
which database is managed on a cloud?
a)
Cloud DB
b)
Flat file DB
c)
Traditional DB
d)
Distributed DB
40.
which distributed database has same DBMS on all nodes?
a)
homogeneous
b)
Heterogeneous
c)
Graph
d)
Cloud
41.
Which shortcut key is used to copy selected text in MS Word?
a)
Ctrl + X
b)
Ctrl + C
c)
Ctrl + V
d)
Ctrl+Z
42.
What does RDBMS stand for?
a)
Relational Data Basic Management system
b)
Relational Database Management system
c)
Relible DatabaseManagement System
d)
None of above
43.
Which attribute identifies each entity uniquely?
a)
Foreign key
b)
primary key
c)
Alternate key
d)
Composite key
44.
What is combination of two or more attribute called in keys?
a)
Primary key
b)
candidate key
c)
Foreign key
d)
Composite key
45.
Who designed the RDBMS model?
a)
Bill Gates
b)
E.F Codd
c)
James Gosling
d)
Larry page
46.
What is Entity?
a)
A person
b)
A place
c)
A thing about which data is stored
d)
A process
47.
Which of these is a type of database relation?
a)
Self-referencing
b)
one-to-one
c)
one-to-many
d)
All of these
48.
which type of attribute cannot be divided further?
a)
Composite
b)
Simple
c)
Complex
d)
Multti-valued
49.
Which of the following is NOT an RDBMS?
a)
MYSQL
b)
SQL
c)
Windows
d)
Oracal
50.
One-to-One relation means:
a)
Many rows in one table match one in another
b)
Each row in one table matches only one in another
c)
No relation
d)
Recursive relation
51.
Which of these keys can have duplicate value?
a)
Primary key
b)
Foreign key
c)
Secondary key
d)
Candidate key
52.
A relation in a database is a?
a)
Row
b)
Table
c)
Column
d)
Key
53.
What is a stored attribute?
a)
An attribute calculated on the fly
b)
A temporary attribute
c)
An attribute saved directly in the database
d)
None of above
54.
A child data contains which key?
a)
Primary key
b)
Super key
c)
Foreign key
d)
Composite key
55.
What is a derived attribute?
a)
An attribute stored in database
b)
An attribute having physical exisstence
c)
None usable
d)
Calculation from other attribute
56.
which type of integrity ensure uniqueness of primary key values?
a)
Referential
b)
Entity
c)
Domain
d)
User-defined
57.
What is database schema?
a)
A design of programs
b)
A data entry form
c)
A blueprint of database structure
d)
A backup plan
58.
Which integrity relates to foreign keys?
a)
Domain integrity
b)
primary integrity
c)
referential integrity
d)
Entity integrity
59.
Which type of relationships links rows within the same table?
a)
Many-to-one
b)
one-to-one
c)
Self-refrencing
d)
None of above
60.
Composite key consists of:
a)
One attribute
b)
No attribute
c)
More than one attribute
d)
All attribute
61.
What is the main purpose of cascading delete?
a)
To backup data
b)
To delete child records with parent
c)
To update all recoord
d)
None of above
62.
What is Relation Algebra?
a)
A Programing language
b)
A data type
c)
A theoretical query language
d)
A report generator
63.
Which operation is used to filter rows in a relation?
a)
projection
b)
join
c)
Rename
d)
Selection
64.
what does the symbol ? represent in relational algebra?
a)
Rename
b)
selection
c)
join
d)
projection
65.
Which operation rename attributes in a relation?
a)
p
b)
u
66.
Which operation combines rows from two tables?
a)
rename
b)
selection
c)
projection
d)
join
67.
What is the symbol for union operation?
a)
u
b)
n
c)
_
d)
*
68.
Which set operation retrieves common rows in two relation?
a)
union
b)
set difference
c)
projection
d)
intersection
69.
What is the output of a cartesian product?
a)
Common Rows
b)
Filtered rows
c)
All combinations of rows
d)
All columns
70.
Which join returns rows that have matching values in both tables ?
a)
left join
b)
right join
c)
full join
d)
inner join
71.
Which join includes all rows from the left table?
a)
inner join
b)
left join
c)
right join
d)
cross join
72.
Which join retrieves all rows from both tables?
a)
left join
b)
right join
c)
full join
d)
self join
73.
Which join is used to match a table with itself?
a)
self join
b)
cross join
c)
full join
d)
right join
74.
Which join is also known as Cartesian product?
a)
Inner join
b)
cross join
c)
natural join
d)
equi join
75.
Which join matches columns with same name and data type?
a)
natural join
b)
cross join
c)
inner join
d)
left join
76.
Which join uses only quality comparison?
a)
theta join
b)
cross join
c)
equi join
d)
right join
77.
Which join uses general comparison operator like >,<?
a)
cross join
b)
equi join
c)
theta join
d)
self join
78.
What does division operation return?
a)
All combinations
b)
matching rows
c)
rows related to all in another table
d)
non-matching rows
79.
Which function return total of a numeric columns?
a)
avg()
b)
Count()
c)
max()
d)
sum()
80.
Which SQL clause is used for grouping data?
a)
order by
b)
group by
c)
where
d)
having
81.
Which aggregate function count non-nill values?
a)
max()
b)
avg()
c)
count()
d)
sum()
82.
What does DDL stands for?
a)
Data Definition Language
b)
Data Drawing Language
c)
Data Description Language
d)
Data Detail Language
83.
What is concatenation used for?
a)
Joining tables
b)
Deleting rows
c)
Sorting data
d)
Joining strings
84.
Which SQL command is used to create a table?
a)
Drop
b)
Update
c)
Insert
d)
Create
85.
What does DML stands for?
a)
Data Manipulation Language
b)
Data Multiple Language
c)
Data Module Language
d)
Data Managing Language
86.
What command is used to delete all data from a table?
a)
Delete
b)
Remove
c)
Erase
d)
Truncate
87.
What is the purpose of the UPDATE command?
a)
To retrieve data
b)
To remove data
c)
To modify data
d)
To copy data
88.
Which SQL command is used to add data to a table?
a)
Select
b)
Insert
c)
Update
d)
Delete
89.
What does NOT EXIST return?
a)
Existing records
b)
Deleting rows
c)
Common rows
d)
Non existing rows
90.
What does EXCEPT return?
a)
Rows in first not in second
b)
All rows
c)
Rows in second query
d)
Matching rows
91.
Which operation returns common records?
a)
Union
b)
Except
c)
Intersect
d)
Delete
92.
What does the UNION operation do?
a)
Sorts data
b)
Finds duplicate
c)
Updates rows
d)
Combines and remove duplicate
93.
What does EXIST check?
a)
Column types
b)
Existence of rows in subquery
c)
Table size
d)
Row duplicate
94.
What is the use of the WHERE clause?
a)
To filter rows
b)
To join tables
c)
To select column
d)
To count values
95.
Which clause specifies the source table?
a)
Where
b)
Having
c)
Select
d)
From
96.
What does the SELECT clause specify?
a)
Table name
b)
Conditions
c)
Columns to retrieve
d)
From
97.
Which clause filters grouped data?
a)
Where
b)
Having
c)
Select
d)
From
98.
Which clause groups rows with the same values?
a)
Order by
b)
Group by
c)
Having
d)
Where
99.
Which function calculates the average?
a)
AVG()
b)
SUM()
c)
COUNT()
d)
MAX()
100.
What is the default order of sorting in SQL?
a)
Descending
b)
Random
c)
No order
d)
Ascending
101.
Which clause is used to sort query result?
a)
Group by
b)
Having
c)
Order by
d)
Select
Reset
