Database Quiz

What is a database commonly used as?

• A) A container for data

• B) A programming language

• C) A type of computer hardware

• D) A user interface design

A database could be used for which of the following?

• A) Only one specific application

• B) One or more applications

• C) Only non-business related systems

• D) Only as a personal storage system

What is a database typically accessed through?

• A) A management system

• B) A web browser only

• C) A standalone software

• D) A physical switch

Which of the following is NOT typically associated with database tables?

• Indexes

• Views

• Stored Procedures

• Graphs

What are the components that can be related to a database table according to the image?

• Indexes, Views, Functions

• Colors, Shapes, Sizes

• Animals, Plants, Bacteria

• Languages, Frameworks, Libraries

Which of the following is a string data type?

• INT

• DATE

• CHAR

• DECIMAL

What data type would you use to store a whole number in a database?

• VARCHAR

• NUMERIC

• TINYINT

• DATE

Which data type is specifically used for storing date and time information with a time zone offset?

• TIME

• DATETIMEOFFSET

• SMALLDATETIME

• NVARCHAR

What does the term "Denormalized" refer to in the context of database design?

• A process to optimize database performance by combining tables

• A technique to ensure data integrity by separating data into multiple tables

• A method to reduce the complexity of a database by increasing redundancy

• A strategy to secure data by encrypting the database contents

Based on the diagram, which of the following is a characteristic of a denormalized database table?