Font size
S
M
L
XL
WorksheetsFinal Exam
Total questions: 115
Worksheet time: 38mins
Name
Class
Date
1.
What does JSON stand for?
a)
Java Source Object Notation
b)
JavaScript Object Notation
c)
JavaScript Oriented Notation
d)
Java Serialized Object Notation
2.
Which data format is JSON based on?
a)
XML
b)
YAML
c)
CSV
d)
JavaScript
3.
What is the correct file extension for JSON files?
a)
.json
b)
.jsn
c)
.js
d)
.jso
4.
In JSON, data is represented as:
a)
Tables
b)
Arrays and objects
c)
Classes and objects
d)
Tags
5.
Which of the following is a valid JSON object?
a)
{name: 'Alice'}
b)
{'name': 'Alice'}
c)
{"name": "Alice"}
d)
{name = "Alice"}
6.
Which of these types are valid in JSON?
a)
String, Number, Boolean, Null, Object, Array
b)
Integer, Float, Character, Object
c)
String, Date, File
d)
List, Dictionary, Set
7.
Can JSON keys be numbers?
a)
Yes
b)
No
c)
Only if quoted
d)
Only in arrays
8.
Which symbol is used to enclose a JSON object?
a)
[ ]
b)
< >
c)
{ }
d)
( )
9.
Which symbol is used to separate key and value in a JSON object?
a)
.
b)
,
c)
:
d)
->
10.
What does a JSON array contain?
a)
Key-value pairs
b)
Objects only
c)
A list of values
d)
Strings only
11.
What is the MIME type of JSON?
a)
application/xml
b)
application/json
c)
text/javascript
d)
text/json
12.
JSON values can be:
a)
Functions
b)
Classes
c)
Objects, Arrays, Strings, Numbers, Booleans, or Null
d)
Only Strings and Numbers
13.
Is JSON case-sensitive?
a)
Yes
b)
No
14.
Which of the following is not a valid JSON value?
a)
null
b)
undefined
c)
true
d)
"text"
15.
JSON is primarily used for:
a)
Styling webpages
b)
Data storage and transfer
c)
Server hosting
d)
Image compression
16.
What function is used to convert a JSON string into a JavaScript object?
a)
JSON.toObject()
b)
JSON.parse()
c)
JSON.convert()
d)
parseJSON()
17.
What function converts a JavaScript object into a JSON string?
a)
JSON.stringify()
b)
JSON.parse()
c)
object.toJSON()
d)
JSON.encode()
18.
Can JSON have comments?
a)
Yes
b)
No
19.
JSON keys must be:
a)
Numbers
b)
Strings enclosed in double quotes
c)
Strings enclosed in single quotes
d)
Any valid identifier
20.
What is the default encoding of JSON text?
a)
UTF-16
b)
ASCII
c)
UTF-8
d)
ISO-8859-1
21.
What does API stand for?
a)
Application Programming Interface
b)
Advanced Protocol Interface
c)
Automated Program Interaction
d)
Application Protocol Interface
22.
Which of the following best describes an API?
a)
A programming language
b)
A user interface
c)
A set of rules for accessing web-based software
d)
A database system
23.
Which protocol is commonly used in web APIs?
a)
FTP
b)
SMTP
c)
HTTP
d)
SSH
24.
What format is commonly used to exchange data in APIs?
a)
HTML
b)
JSON
c)
PDF
d)
CSV
25.
What HTTP method is typically used to retrieve data?
a)
POST
b)
GET
c)
PUT
d)
DELETE
26.
What does REST stand for in RESTful APIs?
a)
Representational State Transfer
b)
Remote Execution Secure Transmission
c)
Representational Syntax Type
d)
Relational Endpoint System Transfer
27.
What status code indicates a successful GET request?
a)
200
b)
404
c)
500
d)
302
28.
Which HTTP method is used to create a new resource?
a)
GET
b)
PUT
c)
POST
d)
DELETE
29.
What status code indicates a resource was not found?
a)
403
b)
401
c)
404
d)
500
30.
Which tool is commonly used for testing APIs?
a)
Visual Studio
b)
Jenkins
c)
Postman
d)
Docker
31.
What is the primary purpose of an API key?
a)
To authenticate a user
b)
To store user data
c)
To format API responses
d)
To generate random IDs
32.
What is OAuth commonly used for in APIs?
a)
Data encryption
b)
User authentication and authorization
c)
Rate limiting
d)
Caching data
33.
Which response status code indicates 'Unauthorized'?
a)
200
b)
301
c)
401
d)
403
34.
Which of the following is NOT an HTTP method?
a)
PATCH
b)
CONNECT
c)
MERGE
d)
TRACE
35.
Which API architecture style is an alternative to REST?
a)
SOAP
b)
FTP
c)
SMTP
d)
HTTP
36.
What does a 500 status code indicate?
a)
OK
b)
Bad Request
c)
Internal Server Error
d)
Unauthorized
37.
What is the purpose of API rate limiting?
a)
To reduce server storage
b)
To prevent overuse of the API
c)
To speed up responses
d)
To improve UI design
38.
Which of the following is a REST constraint?
a)
Use of XML only
b)
Multiple endpoints for the same resource
c)
Stateless communication
d)
Stateful server design
39.
Which HTTP method is idempotent?
a)
POST
b)
PUT
c)
PATCH
d)
CONNECT
40.
What is GraphQL?
a)
A database language
b)
A query language for APIs
c)
A web browser
d)
A REST replacement for SQL
41.
What does SQL stand for?
a)
Structured Question Language
b)
Structured Query Language
c)
Simple Query Language
d)
Sequential Query Language
42.
Which of the following is used to retrieve data from a database?
a)
INSERT
b)
UPDATE
c)
SELECT
d)
DELETE
43.
Which MySQL command is used to change data in a table?
a)
SELECT
b)
MODIFY
c)
UPDATE
d)
SET
44.
What is the default port for MySQL?
a)
1433
b)
1521
c)
3306
d)
5432
45.
Which keyword is used to eliminate duplicate rows in a SELECT statement?
a)
UNIQUE
b)
DELETE
c)
DISTINCT
d)
FILTER
46.
What does the WHERE clause do in a SQL query?
a)
Filters columns
b)
Filters rows
c)
Groups results
d)
Sorts records
47.
Which of the following is not a valid MySQL data type?
a)
VARCHAR
b)
INTEGER
c)
STRING
d)
DATE
48.
What does the LIMIT clause do in a SELECT query?
a)
Groups records
b)
Restricts column output
c)
Restricts number of rows returned
d)
Defines permissions
49.
Which SQL statement is used to create a new table?
a)
MAKE TABLE
b)
INSERT TABLE
c)
CREATE TABLE
d)
ADD TABLE
50.
What type of key is used to uniquely identify a row in a table?
a)
Primary Key
b)
Unique Key
c)
Foreign Key
d)
Index Key
51.
What does AUTO_INCREMENT do?
a)
Automatically updates values
b)
Increments numeric values
c)
Automatically generates a unique number
d)
Adds records automatically
52.
Which keyword is used to define a constraint that ensures values in a column are unique?
a)
UNIQUE
b)
PRIMARY
c)
NOT NULL
d)
FOREIGN
53.
Which command adds a new column to an existing table?
a)
INSERT COLUMN
b)
UPDATE TABLE
c)
ALTER TABLE
d)
MODIFY TABLE
54.
Which is the correct syntax to delete a table in MySQL?
a)
DELETE TABLE tablename;
b)
REMOVE tablename;
c)
DROP TABLE tablename;
d)
CLEAR tablename;
55.
Which data type stores true or false values in MySQL?
a)
BOOLEAN
b)
INT(1)
c)
TINYINT
d)
All of the above
56.
What is the maximum length of a VARCHAR column?
a)
65,535
b)
255
c)
32,767
d)
16,384
57.
What type of JOIN returns all records from the left table and matched records from the right table?
a)
INNER JOIN
b)
LEFT JOIN
c)
RIGHT JOIN
d)
FULL JOIN
58.
Which clause is used to sort the result of a SELECT statement?
a)
GROUP BY
b)
ORDER BY
c)
SORT
d)
ARRANGE BY
59.
Which function counts the number of rows in a result set?
a)
SUM()
b)
COUNT()
c)
TOTAL()
d)
LENGTH()
60.
Which operator is used to combine multiple conditions in a WHERE clause?
a)
+
b)
AND
c)
THEN
d)
WITH
61.
What is the purpose of the GROUP BY clause?
a)
To combine rows with identical values
b)
To sort results
c)
To restrict data
d)
To join tables
62.
What will this query return: SELECT name FROM students WHERE age BETWEEN 18 AND 21;
a)
Students younger than 18
b)
Students 18 to 21
c)
Students over 21
d)
All students
63.
What is the function of NOW()?
a)
Displays current time
b)
Displays today's date
c)
Returns current date and time
d)
Creates a timestamp
64.
What does the LENGTH() function return?
a)
Number of words
b)
Size of the table
c)
Number of characters in a string
d)
Memory used
65.
Which clause is used to assign an alias to a column?
a)
RENAME
b)
ALIAS
c)
AS
d)
LABEL
66.
What command is used to switch to a different database?
a)
USE
b)
OPEN
c)
SELECT
d)
CHANGE
67.
Which of the following is not a valid aggregate function?
a)
AVG()
b)
SUM()
c)
MIN()
d)
FORMAT()
68.
In MySQL, which function is used to concatenate strings?
a)
CONCAT()
b)
JOIN()
c)
MERGE()
d)
UNION()
69.
What keyword is used to prevent duplicate entries in a column?
a)
NOT NULL
b)
INDEX
c)
UNIQUE
d)
FILTER
70.
Which character is used for wildcard in LIKE clause for multiple characters?
a)
_
b)
%
c)
*
d)
?
71.
What type of database is MongoDB?
a)
Relational
b)
NoSQL
c)
Graph
d)
Object-oriented
72.
Which data format is used to store documents in MongoDB?
a)
XML
b)
CSV
c)
JSON
d)
BSON
73.
A collection in MongoDB is similar to what in a relational database?
a)
Column
b)
Table
c)
Row
d)
Schema
74.
Which command is used to show all databases?
a)
SHOW DATABASES;
b)
db.showAll()
c)
show dbs
d)
list databases
75.
How do you insert a single document into a MongoDB collection?
a)
db.collection.add()
b)
db.collection.insertOne()
c)
db.collection.insert()
d)
db.insert(document)
76.
What command is used to find documents in MongoDB?
a)
db.collection.query()
b)
db.collection.get()
c)
db.collection.find()
d)
db.collection.select()
77.
Which of the following is NOT a valid data type in MongoDB?
a)
ObjectId
b)
Array
c)
Float
d)
DateTimeOffset
78.
Which method would you use to update a document?
a)
db.collection.modify()
b)
db.collection.updateOne()
c)
db.collection.set()
d)
db.collection.insert()
79.
How do you delete all documents from a collection?
a)
db.collection.remove()
b)
db.collection.deleteAll()
c)
db.collection.deleteMany({})
d)
db.collection.dropAll()
80.
What does the `db.collection.drop()` command do?
a)
Deletes all fields
b)
Drops the database
c)
Drops the entire collection
d)
Archives the collection
81.
MongoDB is best suited for:
a)
Structured data with complex relationships
b)
Applications requiring fixed schemas
c)
Rapid development and unstructured data
d)
Storing flat files
82.
Which command lists collections in the current database?
a)
list collections
b)
show collections
c)
display collections
d)
collections()
83.
Which shell command switches to a specific database?
a)
use dbname
b)
switch dbname
c)
db.use(dbname)
d)
connect dbname
84.
Which operator checks if a field exists?
a)
$has
b)
$exists
c)
$defined
d)
$available
85.
Which method adds multiple documents to a collection?
a)
insertMany()
b)
addAll()
c)
insert()
d)
pushMany()
86.
How do you limit results to 5 documents?
a)
db.find().top(5)
b)
db.find().first(5)
c)
db.find().limit(5)
d)
db.find().take(5)
87.
Which method sorts results in MongoDB?
a)
sortBy()
b)
db.sort()
c)
order()
d)
sort()
88.
Which method counts documents in a collection?
a)
db.count()
b)
countDocuments()
c)
getCount()
d)
collection.countAll()
89.
Which method updates many documents?
a)
updateAll()
b)
update()
c)
updateMany()
d)
setMany()
90.
Which command removes an entire database?
a)
db.delete()
b)
db.drop()
c)
drop database()
d)
db.remove()
91.
What does HTML stand for?
a)
Hyper Trainer Marking Language
b)
Hyper Text Markup Language
c)
Hyper Text Marketing Language
d)
Hyperlink and Text Markup Language
92.
Which tag is used to create a hyperlink in HTML?
a)
<a>
b)
<link>
c)
<href>
d)
<url>
93.
What does CSS stand for?
a)
Cascading Style Sheets
b)
Computer Style Sheets
c)
Creative Style System
d)
Colorful Style Sheets
94.
Which HTML attribute is used to define inline styles?
a)
style
b)
class
c)
font
d)
styles
95.
Which property is used in CSS to change text color?
a)
font-color
b)
color
c)
text-color
d)
foreground
96.
What does JavaScript primarily add to a website?
a)
Content
b)
Structure
c)
Styling
d)
Interactivity
97.
Which symbol is used for comments in JavaScript?
a)
//
b)
/*
c)
#
d)
<!--
98.
Which HTML tag is used to include JavaScript?
a)
<script>
b)
<js>
c)
<javascript>
d)
<code>
99.
How do you declare a variable in JavaScript?
a)
var myVar;
b)
variable myVar;
c)
int myVar;
d)
v myVar;
100.
Which method is used to get an element by ID in JavaScript?
a)
getElementByName()
b)
getElementById()
c)
querySelector()
d)
getID()
101.
Which CSS position value places the element relative to its normal position?
a)
absolute
b)
fixed
c)
relative
d)
static
102.
Which of the following is a front-end framework?
a)
Django
b)
Flask
c)
React
d)
Node.js
103.
Which HTTP method is typically used to retrieve data?
a)
POST
b)
GET
c)
PUT
d)
DELETE
104.
Which protocol is used to transfer web pages?
a)
FTP
b)
SMTP
c)
HTTP
d)
SSH
105.
What does URL stand for?
a)
Universal Resource Locator
b)
Uniform Resource Locator
c)
Uniform Read Locator
d)
Universal Routing Language
106.
Which language is used to style HTML pages?
a)
HTML
b)
CSS
c)
Java
d)
Python
107.
What is the default port for HTTP?
a)
80
b)
443
c)
21
d)
25
108.
Which tag is used to create an unordered list in HTML?
a)
<ul>
b)
<ol>
c)
<list>
d)
<li>
109.
Which HTML element is used to display a picture?
a)
<img>
b)
<image>
c)
<src>
d)
<pic>
110.
What is Bootstrap?
a)
A JavaScript library
b)
A CSS framework
c)
A CMS
d)
A database
111.
Which company developed JavaScript?
a)
Microsoft
b)
Mozilla
c)
Netscape
d)
Oracle
112.
Which CSS property controls the font size?
a)
text-size
b)
font-style
c)
font-size
d)
type-size
113.
What does DOM stand for?
a)
Document Object Model
b)
Data Object Method
c)
Digital Order Markup
d)
Document-Oriented Markup
114.
Which method is used to parse a JSON string in JavaScript?
a)
JSON.decode()
b)
JSON.parse()
c)
parse.JSON()
d)
JSON.read()
115.
Which element is used for creating a form in HTML?
a)
<input>
b)
<form>
c)
<action>
d)
<submit>
Reset
