WorksheetsSet 1 Quiz
Total questions: 20
Worksheet time: 7mins
What is the primary key constraint used for?
Foreign key
Uniqueness
Redundancy
Index
Which SQL clause is used to filter records?
WHERE
SELECT
GROUP BY
ORDER BY
What type of database follows a table-based structure?
NoSQL
Document-based
Relational
Key-value
Which normal form eliminates partial dependencies?
1NF
2NF
3NF
BCNF
What is the full form of ACID in databases?
Atomicity, Consistency, Isolation, Durability
Atomicity, Confidentiality, Integrity, Durability
Access, Control, Integrity, Data
Application, Configuration, Isolation, Database
Which SQL keyword is used to retrieve unique values?
DELETE
DISTINCT
UNIQUE
FILTER
Which JOIN returns only matching rows from both tables?
OUTER JOIN
LEFT JOIN
INNER JOIN
RIGHT JOIN
What is the default port number of MySQL?
8080
1433
5432
3306
What is the purpose of the HAVING clause?
Filter aggregated data
Sort records
Group rows
Select unique records
What does the GROUP BY clause do?
Groups rows with common values
Sorts records
Deletes duplicates
Filters data
What does SaaS stand for?
System as a Service
Software and Storage
Software as a Service
Storage as a Solution
Which cloud model is a combination of private and public clouds?
Multi Cloud
Hybrid Cloud
Public Cloud
Community Cloud
What does IaaS provide?
Virtual Machines
Web Hosting
Cloud Storage
Networking
What is the main advantage of cloud computing?
Scalability
Expensive infrastructure
Fixed storage
Static deployment
What is the primary concern in cloud security?
Data Privacy
Speed
Cost
Performance
Which cloud service model provides a platform for app development?
PaaS
IaaS
SaaS
DaaS
Which type of cloud deployment is used for a single organization?
Public Cloud
Private Cloud
Hybrid Cloud
Shared Cloud
What does the term "serverless" mean?
No infrastructure management
No need for servers
Free cloud services
Self-hosted servers
What is the full form of AWS?
Amazon Web Services
Advanced Web Solutions
Artificial Web System
Automated Workflow Solutions
What does PaaS provide?
Development platforms
Storage solutions
Hardware components
Networking tools
