NEW
Font size
WorksheetsCS10337 - Lectrure #1
Total questions: 10
Worksheet time: 5mins
What is the primary difference between data and information?
Data is raw and unprocessed, while information is processed and organized.
Data is always numerical, while information is always textual.
Data is more reliable than information.
Data is subjective, while information is objective.
What is the primary function of a Database Management System (DBMS)?
To create and edit spreadsheets
To handle, store, retrieve, and work with data in databases
To design websites
To manage network security
What capabilities does a DBMS provide to users or developers?
The ability to create, edit, and remove databases
The ability to design graphics
The ability to write code in multiple languages
The ability to manage email accounts
If DBMS stands for Database Management System, what does RDBMS stand for?
Relational Database Management System
Random Database Management System
Reliable Database Management System
Regional Database Management System
What was a major problem with the early navigational database models?
Applications were tightly coupled to the data structure
Data was difficult to access
Data was stored in a non-secure manner
Data was easily corrupted
What was the key breakthrough of E. F. Codd’s Relational Model introduced in 1970?
Query by content rather than by following a path
Store data in a single file
Use of hierarchical data structures
Data storage in binary format
What is a trade-off when using NoSQL databases?
They are slower but more reliable
They offer stronger transaction guarantees
They are faster and more scalable but may have weaker transaction guarantees
They are less flexible with data types
What is MySQL?
A type of programming language
An open-source relational database management system
A web browser
A cloud storage service
Who initially developed MySQL?
Oracle Corporation
Sun Microsystems
MySQL AB
Microsoft
What does the term "authentication" refer to in database security?
The process of backing up data
The process of verifying the identity of a user
The process of organising data
The process of deleting data
