CompTIA Tech+: Database Fundamentals

 

Question:

What command is used to add new data records into a database table?

• INSERT

Question

:

Which tasks can be performed using window functions in SQL?

• Calculate running totals

• Aggregate multiple rows into a single value

• Rank rows within partitions

Question

:

What is the main role of data in business decision-making?

Answer B.

• To supply objective information that supports sound decisions

Question

:

Which statements accurately describe the purpose of database normalization?

• To prevent update anomalies

• To reduce data redundancy

• To improve database design flexibility

Question

:

Which characteristics accurately describe relational databases?

• Enforces data integrity using constraints

• Supports SQL for querying

• Data organized into tables

Question

:

During a routine audit, suspicious activities were detected on a database server. Which action should be prioritized to secure the database?

• Implement strict access controls and enable auditing to monitor user activity

Question

:

What best describes the main characteristic of a relational database structure?

• Organizes data into tables with rows and columns linked by keys

Question

:

Which backup type captures all data and allows for complete database recovery?

• Full backup

Categories: CompTIA Tech+