NEW
Font size
WorksheetsCSE335_PracticeQuiz
Total questions: 71
Worksheet time: 36mins
What is the binary equivalent of the decimal number 10?
1010
1001
1100
1110
Which of the following is the hexadecimal representation of the decimal number 255?
FF
F0
00
1F
What is the result of adding the binary numbers 1011 and 1101?
10100
10000
11110
11000
In the octal number system, what is the value of the octal number 17?
15
13
14
17
Which of the following is NOT a valid binary number?
1010
1102
1111
1001
What is the result of the Boolean expression A + A' (where A' is NOT A)?
A
0
1
A'
Which of the following is the correct application of De Morgan's theorem?
(A + B)' = A' + B'
(A * B)' = A' + B'
(A + B)' = A' * B'
(A * B)' = A' * B'
What is the simplified form of the expression A + AB?
A
B
A + B
A'
Which of the following represents the AND operation in Boolean algebra?
+
*
-
/
What is the result of the expression A * 0?
A
1
0
A'
What does TCP stand for in networking?
Transmission Control Protocol
Transfer Control Protocol
Transport Control Protocol
Transmission Communication Protocol
Which layer of the OSI model is responsible for routing?
Application Layer
Transport Layer
Network Layer
Data Link Layer
What is the primary purpose of a firewall?
To increase network speed
To filter incoming and outgoing traffic
To provide wireless connectivity
To manage IP addresses
Which protocol is used for secure data transmission over the internet?
HTTP
FTP
HTTPS
SMTP
What is the maximum length of a CAT5 Ethernet cable?
50 meters
100 meters
200 meters
300 meters
What is the primary purpose of a digital signature?
To encrypt data
To verify the authenticity of a message
To compress data
To format data
Which algorithm is commonly used for creating digital signatures?
RSA
DES
AES
MD5
What does the term 'hash function' refer to in digital signatures?
A method of encrypting data
A function that converts data into a fixed-size string
A way to compress data
A method of generating random numbers
Which of the following is NOT a property of a good hash function?
Deterministic
Fast computation
Collision resistance
Reversible
What is the role of a Certificate Authority (CA) in digital signatures?
To encrypt messages
To issue digital certificates
To store data
To manage network traffic
Which of the following is an example of a functional dependency?
A → B
A + B → C
A * B → A
A + B → A + B
What is a trivial functional dependency?
A dependency that holds true for all values
A dependency where the dependent attribute is a subset of the determinant
A dependency that cannot be derived from existing dependencies
A dependency that is always false
Which of the following is NOT a type of functional dependency?
Partial dependency
Transitive dependency
Trivial dependency
Circular dependency
What is the purpose of identifying functional dependencies in a database?
To improve query performance
To ensure data integrity and reduce redundancy
To encrypt sensitive data
To manage user access
If A → B and B → C, what can be inferred?
A → C
C → A
A → B → C
B → A
What is the main goal of normalization in databases?
To increase data redundancy
To reduce data redundancy and improve data integrity
To speed up data retrieval
To simplify SQL queries
Which normal form eliminates transitive dependencies?
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Boyce-Codd Normal Form (BCNF)
What is a characteristic of a relation in First Normal Form (1NF)?
No repeating groups
No partial dependencies
No transitive dependencies
All attributes are functionally dependent on the primary key
Which of the following is a requirement for a relation to be in Second Normal Form (2NF)?
It must be in 1NF
It must have a composite primary key
All non-key attributes must be fully functionally dependent on the primary key
It must have no transitive dependencies
What is the main difference between 3NF and BCNF?
BCNF allows transitive dependencies
3NF allows partial dependencies
BCNF requires that every determinant is a candidate key
3NF requires that every determinant is a candidate key
Which SQL statement is used to retrieve data from a database?
GET
SELECT
FETCH
RETRIEVE
What does SQL stand for?
Structured Query Language
Simple Query Language
Standard Query Language
None of the above
Which SQL statement is used to retrieve data from a database?
GET
SELECT
FETCH
PULL
What is the purpose of the WHERE clause in SQL?
To specify the table to query
To filter records
To sort records
To group records
Which of the following is a valid SQL command to create a table?
CREATE TABLE Employees (ID INT, Name VARCHAR(100));
NEW TABLE Employees (ID INT, Name VARCHAR(100));
MAKE TABLE Employees (ID INT, Name VARCHAR(100));
TABLE CREATE Employees (ID INT, Name VARCHAR(100));
What is a primary key?
A key that allows duplicate values
A unique identifier for a record in a table
A key that is used to encrypt data
A key that links two tables
Which SQL statement is used to update existing records in a table?
MODIFY
UPDATE
CHANGE
ALTER
What does the JOIN clause do in SQL?
Combines rows from two or more tables
Deletes rows from a table
Updates rows in a table
Creates a new table
Which of the following SQL commands is used to delete a table?
REMOVE TABLE table_name;
DELETE TABLE table_name;
DROP TABLE table_name;
CLEAR TABLE table_name;
What is the purpose of the GROUP BY clause?
To filter records
To sort records
To aggregate data
To join tables
Which of the following is an aggregate function in SQL?
COUNT
SUM
AVG
All of the above
What is a foreign key?
A key that uniquely identifies a record
A key that links two tables together
A key that is used for encryption
A key that allows duplicate values
Which SQL statement is used to sort the result set?
ORDER BY
SORT BY
GROUP BY
FILTER BY
What does the DISTINCT keyword do in a SQL query?
Returns all records
Returns unique records
Returns sorted records
Returns aggregated records
Which of the following is used to add a new column to an existing table?
ADD COLUMN
ALTER TABLE
MODIFY TABLE
CHANGE TABLE
What is the result of the following SQL query: SELECT COUNT(*) FROM Employees;?
The total number of columns in the Employees table
The total number of unique records in the Employees table
The total number of records in the Employees table
The total number of tables in the database
Which SQL clause is used to filter records based on a condition?
HAVING
WHERE
ORDER BY
GROUP BY
What does the UNION operator do?
Combines the results of two or more SELECT statements
Deletes records from a table
Updates records in a table
Creates a new table
Which of the following is NOT a valid SQL data type?
VARCHAR
INTEGER
STRING
DATE
What is the purpose of the HAVING clause?
To filter records before grouping
To filter records after grouping
To sort records
To join tables
Which SQL function is used to find the maximum value in a column?
MAXIMUM()
MAX()
HIGHEST()
TOP()
What is the primary purpose of IP addressing?
To identify devices on a network
To encrypt data
To manage network traffic
To provide security
What is the maximum number of hosts in a Class C network?
254
256
512
1024
Which of the following is a valid IPv4 address?
192.168.1.256
172.16.0.1
10.0.0.999
256.100.50.25
What is the subnet mask for a Class B network?
255.0.0.0
255.255.0.0
255.255.255.0
255.255.255.255
In CIDR notation, what does /24 represent?
24 bits for the network part
24 bits for the host part
24 hosts in the network
24 subnets
What is the purpose of a subnet mask?
To identify the network and host portions of an IP address
To encrypt IP packets
To route packets between networks
To assign IP addresses dynamically
Which of the following IP addresses is a private IP address?
192.168.1.1
172.31.255.255
10.0.0.1
All of the above
What is the broadcast address for the subnet 192.168.1.0/24?
192.168.1.0
192.168.1.255
192.168.1.1
192.168.1.254
How many bits are used for the host part in a Class A address?
8
16
24
32
What is the first valid host address in the subnet 192.168.10.0/24?
192.168.10.0
192.168.10.1
192.168.10.255
192.168.10.2
Which of the following is NOT a valid class of IP addresses?
Class A
Class B
Class C
Class D
What is the subnet mask for a Class A network?
255.255.255.0
255.0.0.0
255.255.0.0
255.255.255.255
How many subnets can be created from a Class C network with a subnet mask of /26?
2
4
8
64
What is the last valid host address in the subnet 10.0.0.0/8?
10.0.0.0
10.255.255.254
10.255.255.255
10.0.0.255
Which of the following is a valid subnet mask for a Class C network?
255.255.255.128
255.255.0.0
255.0.0.0
255.255.255.192
What is the purpose of the default gateway in a network?
To provide a route for packets to leave the local network
To assign IP addresses to devices
To filter incoming traffic
To manage network security
What is the total number of usable IP addresses in a /30 subnet?
2
4
6
8
Which of the following IP addresses is a loopback address?
127.0.0.1
192.168.1.1
10.0.0.1
172.16.0.1
What is the subnet mask for a network with 512 hosts?
255.255.255.0
255.255.254.0
255.255.255.128
255.255.255.192
In a subnetted network, what does the term "subnetting" refer to?
Dividing a larger network into smaller, manageable sub-networks
Combining multiple networks into one
Assigning IP addresses dynamically
Encrypting data packets
