DBMS QUIZ SET2

BCA DBMS Quiz (20 Questions)

Time Left: 10:00

COMPUTER NETWORK QUESTION SET 2

Computer Networks Quiz

Student Name *

College Name (Optional)

Email ID *

Time Left: 10:00

1. What does LAN stand for?

Local Area Network
Long Area Network
Large Area Network
Link Area Network

2. Which device connects different networks?

Hub
Switch
Router
Repeater

3. Which layer of OSI model handles routing?

Session Layer
Network Layer
Data Link Layer
Transport Layer

4. How many layers are there in the OSI model?

5
6
7
8

5. What does IP stand for?

Internet Protocol
Internal Protocol
Internet Process
Internal Process

6. Which protocol is used for web browsing?

FTP
SMTP
HTTP
DNS

7. Which device works at Layer 2?

Router
Switch
Gateway
Repeater

8. DNS is used for?

Email Transfer
File Transfer
Domain Name Resolution
Encryption

9. Which protocol is used to send email?

SMTP
HTTP
FTP
TCP

10. TCP stands for?

Transfer Control Protocol
Transmission Control Protocol
Terminal Communication Protocol
Transport Communication Protocol

COMPUTER NETWORK QUIZ SET 1

Computer Networks Quiz

Student Name *

College Name (Optional)

Email ID *

Time Left: 10:00

1. What does LAN stand for?

Local Area Network
Long Area Network
Large Area Network
Link Area Network

2. Which device connects different networks?

Hub
Switch
Router
Repeater

3. Which layer of OSI model handles routing?

Transport
Network
Session
Data Link

4. How many layers are there in OSI model?

5
6
7
8

5. What does IP stand for?

Internet Protocol
Internal Process
Internet Process
Internal Protocol

6. Which protocol is used for web browsing?

FTP
SMTP
HTTP
DNS

7. Which device operates at Layer 2?

Router
Switch
Gateway
Modem

8. What does DNS do?

Transfers files
Sends emails
Resolves domain names
Encrypts data

9. Which protocol is used to send emails?

SMTP
HTTP
FTP
TCP

10. TCP stands for?

Transfer Control Protocol
Transmission Control Protocol
Transport Communication Protocol
Terminal Control Protocol

COMPUTER ARCHITECTURE SET 1

Computer Architecture Quiz

Enter Student Name

Time Left: 10:00

1. Which register stores the address of the next instruction?

MAR
PC
MDR
IR

2. ALU stands for?

Arithmetic Logic Unit
Automatic Logic Unit
Arithmetic Local Unit
None

3. Which memory is fastest?

RAM
ROM
Cache
Hard Disk

4. CPU consists of?

ALU and CU
RAM and ROM
Cache and RAM
None

5. CU stands for?

Control Unit
Central Unit
Core Unit
Common Unit

6. Which memory is non-volatile?

RAM
Cache
ROM
Register

7. Fetch-Decode-Execute cycle is performed by?

Printer
CPU
Scanner
Monitor

8. Which bus transfers data?

Address Bus
Data Bus
Control Bus
Memory Bus

9. Binary of decimal 10 is?

1001
1111
1010
1100

10. Which component stores instructions temporarily?

RAM
HDD
DVD
Printer

DBMS QUESTION SET 1

DBMS Quiz

Student Name:

1. DBMS stands for?

Database Management System
Data Backup Management System
Database Mapping System
Data Management Service

2. Which language is used to interact with databases?

HTML
SQL
CSS
Java

3. Which command is used to retrieve data?

INSERT
UPDATE
SELECT
DELETE

4. Which key uniquely identifies a record?

Foreign Key
Candidate Key
Primary Key
Composite Key

5. Which normal form removes partial dependency?

1NF
2NF
3NF
BCNF

6. Which SQL command adds a new record?

INSERT
SELECT
ALTER
DROP

7. What is a foreign key?

Unique identifier
Duplicate key
Key linking two tables
Temporary key

8. Which SQL clause filters records?

ORDER BY
GROUP BY
WHERE
HAVING

9. Which operation combines rows from two tables?

JOIN
DELETE
UPDATE
TRUNCATE

10. Which command removes all rows from a table?

DELETE
DROP
REMOVE
TRUNCATE

OPERATING SYSTEM QUIZ SET 1

Operating System Quiz

1. What is the primary function of an Operating System?

Manage hardware and software resources
Create documents
Browse the internet
Compile programs

2. Which of the following is an Operating System?

MS Word
Windows
Photoshop
Chrome

3. Which scheduling algorithm follows First Come First Serve?

FCFS
Round Robin
Priority
SJF

4. Which memory is volatile?

ROM
Hard Disk
RAM
SSD

5. Which component manages files in an OS?

File System
CPU
Cache
Compiler

6. What is a deadlock?

Fast execution
Process waiting indefinitely for resources
Memory allocation
File deletion

7. Which scheduling algorithm gives each process a fixed time slice?

FCFS
Priority
Round Robin
SJF

8. Which of the following is system software?

Operating System
MS Excel
PowerPoint
Paint

9. What is paging used for?

CPU scheduling
Memory management
File compression
Device management

10. Which part of the OS interacts directly with hardware?

Shell
Compiler
Kernel
Editor

C LANGUAGE QUIZ SET 1

C Language Quiz

1. Who developed the C language?

Dennis Ritchie
James Gosling
Bjarne Stroustrup
Guido van Rossum

2. Which symbol is used to end a statement in C?

:
;
,
.

3. Which function is the entry point of a C program?

start()
run()
main()
init()

4. Which header file is required for printf()?

math.h
stdio.h
string.h
conio.h

5. Which data type stores a single character?

int
float
char
double

6. What is the size of char in C?

1 byte
2 bytes
4 bytes
8 bytes

7. Which loop executes at least once?

for
while
do-while
nested for

8. Which operator is used for address-of?

*
&
%
#

9. Which keyword is used to return a value from a function?

break
continue
exit
return

10. Which operator is used for equality comparison?

=
:=
==
!=

QUIZ IN COMPUTER SCIENCE

BASIC LEVEL 1. DATA STRUCTURE SET 1 - CLICK C LANGUAGE SET 1 - CLICK OPERATING SYSTEM SET 1 : CLICK COMPUTER ARCHITECTURE QUIZ SET 1 : CLICK COMPUTER NETWORK QUIZ SET 1 : CLICK

DATA STRUCTURE QUIZ -1

Data Structure Quiz

1. Which data structure follows FIFO?

Stack
Queue
Tree
Graph

2. Which data structure follows LIFO?

Queue
Linked List
Stack
Tree

3. Which searching algorithm requires sorted data?

Linear Search
DFS
Binary Search
BFS

4. Which data structure is used for recursion?

Queue
Stack
Graph
Array

5. Which traversal order is Root → Left → Right?

Inorder
Postorder
Preorder
Level Order

6. Which data structure consists of nodes connected by links?

Array
Linked List
Stack
Queue

7. Which data structure is used in BFS traversal?

Stack
Queue
Tree
Array

8. Which data structure is used in DFS traversal?

Queue
Linked List
Stack
Graph

9. What is the index of the first element in an array?

0
1
-1
Depends on size

10. Which data structure represents hierarchical data?

Queue
Stack
Tree
Array

Convolutional Neural Network (CNN)

A Convolutional Neural Network (CNN) is a type of Deep Learning algorithm specifically designed to process structured arrays of data, such as images. Unlike standard Neural Networks, CNNs automatically learn to detect features (like edges, shapes, and objects) without manual feature engineering.

Layers of a CNN 

A. Input Layer

• Takes raw image data as input.
• Represented as a 3D Matrix: (Height × Width × Channels).
• B. Convolutional Layer (The Brain)
  • Purpose: To extract features from the input image.
  • Operation: A small matrix called a Filter (or Kernel) slides (convolves) over the image. It performs element-wise multiplication and sums up the results to create a Feature Map.
  • Terminology:
    • Stride: The number of pixels the filter moves at a time.
    • Padding: Adding zeros around the image border to keep the output size the same.
  C. Activation Layer (ReLU)
  • Purpose: To introduce non-linearity into the network (since real-world data is non-linear).
  • Function: Most common is ReLU (Rectified Linear Unit). It converts all negative pixel values to zero
  • D. Pooling Layer (Downsampling)

    • Purpose: To reduce the dimensionality (size) of the feature maps while keeping important information. This reduces computational power and prevents overfitting.
    • Types:
      • Max Pooling: Picks the maximum value from a portion of the image (most common).
      • Average Pooling: Calculates the average value.

    E. Flattening

    • Purpose: Converts the final 2D feature map matrix into a 1D Linear Vector. This vector is then fed into a standard Neural Network.

    F. Fully Connected (FC) & Output Layer

    • FC Layer: Connects every neuron in one layer to every neuron in another. It performs the final classification based on features extracted.
    • Softmax/Sigmoid: Functions used in the final layer to give a probability score (e.g., 90% chance it's a "Cat").

    ---

     How CNN Works

    1. Forward Propagation: The image passes through Convolution, ReLU, and Pooling layers. Each layer learns more complex features (e.g., Layer 1 learns edges; Layer 10 learns faces).
    2. Loss Function: The model compares its prediction to the actual label (e.g., predicted "Dog" but it was a "Cat").
    3. Backpropagation: The "error" is sent back through the network to adjust the Weights of the filters.
    4. Optimization: The process repeats thousands of times until the error (Loss) is minimized

    
    

    
    

    
    

    Input → [Conv + ReLU] → [Pooling] → [Flatten] → [Fully Connected] → [Output]

IMAGE PROCESSING

 1. OPEN CV

2. CNN

R language : Read data from txt file

 

Type conversion in R language

 Type conversion

1.as.numeric 

2. as.logical 

3. as.integer 

4. as.factor 

5. as.character 

6. as.ordered

DATA / SUBSET FROM CSV FILE IN R LANGUAGE

DATA / SUBSET FROM CSV FILE IN  R LANGUAGE 

 

WRITE DATA TO CSV FILE IN R LANGUAGE

WRITE DATA TO CSV FILE IN R LANGUAGE

 

WRITE DATA TO CSV FILE IN R LANGUAGE

WRITE DATA TO CSV FILE IN R LANGUAGE

 

5. Read data from CSV files - FIND LARGEST AND SMALLEST

 

4. Read data from CSV files - FIND LARGEST AND SMALLEST

 

3. Read data from CSV files

 

Read data from CSV files