1) Which type of database stores all data in a single table without any links to other tables? a) Relational database b) Online database c) Local network database d) Flat-file database 2) What is the primary advantage of a relational database over a flat-file database? a) Faster data entry for simple tasks b) Less storage space required c) Elimination of data redundancy d) Easier to manage without specialized knowledge 3) Which of the following is an example of a flat-file database? a) A customer management system using MySQL b) A company's employee data stored on a local server c) A list of products in an Excel spreadsheet without links to other spreadsheets d) A social media platform's user data stored on the cloud 4) What is the key mechanism used to link tables in a relational database? a) Hyperlinks b) Primary and foreign keys c) Shared columns with the same name d) Data redundancy 5) Which database type is better suited for a business that needs to manage a massive amount of structured data with complex relationships? a) Flat-file database b) Relational database c) Local network database d) Online database 6) An employee database for a small business is stored on a server in the company office and can only be accessed by computers within the office network. This is an example of what type of database? a) Online database b) Relational database c) Flat-file database d) Local network database 7) Which of the following describes an advantage of a local network database? a) Easy access from anywhere in the world b) Dependence on internet speed c) Lower initial setup costs d) Greater control over data and security 8) A team of remote employees needs to access and edit the same project data simultaneously. What type of database deployment is best suited for this? a) Local network database b) Flat-file database c) Relational database d) Online database 9) Which of the following is a disadvantage of an online database? a) High initial setup costs b) No ability to scale with a growing business c) Reliance on a stable internet connection d) Increased security and control 10) What type of query language is commonly used with relational databases to retrieve and manipulate data? a) HTML b) JavaScript c) SQL d) XML

Database Types

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?