The terms "bitmap," "b-tree," and "hash" refer to which type of database structure?

Correct Answer: Stored procedure

One reason to add an index is to:

Correct Answer: Improve performance of select statements.

You have a table that contains the following data. You break the table into the following two tables. This process is referred to as:

Correct Answer: denormalization

At 3:00 P.M. (1500 hours), you create a backup of your database. At 4:00 P.M. (1600 hours), you create a table named Customer and import data into the table. At 5:00 P.M. (1700 hours), your server fails. You run a script to apply only the 3:00 P.M. backup to your database. What is the result of the script?

Correct Answer: The script fails.

In which situation do you need to perform a restore on a database?

Correct Answer: when data needs to be deleted from the database

One reason to create a stored procedure is to:

Correct Answer: Give the user control of the query logic.

In SQL, an insert statement is used to add a:

Correct Answer: Row of data to a table.

A database contains two tables named Customer and Order. You execute the following statement: DELETE FROM Order - WHERE CustomerID = 209 - What is the result?

Correct Answer: All orders for CustomerID 209 are deleted from the Order table, and CustomerID 209 is deleted from the Customer table.

Which category of SQL statements is used to add, remove, and modify database structures?

Correct Answer: Data definition language (DDL)

You have a table named Student that contains 100 rows. Some of the rows have a NULL value in the FirstName column. You execute the following statement: DELETE FROM Student - What is the result?

Correct Answer: All rows in the table will be deleted.

Denormalization is performed in order to:

Correct Answer: Reduce redundancy.

One difference between a function and a stored procedure is that a function:

Correct Answer: Cannot contain a transaction.

Welcome to awslagi.com – Sharing AWS, Google Cloud, Microsoft Azure IT Exams. It's free for all!

Database Fundamentals

Understand database fundamentals for data careers.

4.8★★★★★(279 ratings)

12,115 studentsBeginner

Build an introductory understanding of databases, data storage, and relational concepts. The exam provides a foundation for working with structured information in modern business and technology environments. This certification is useful for learners starting in data-related fields. It helps you understand how databases support applications, analysis, and business operations.

What you'll learn

Learn database basics- Understand relational concepts- Study data storage- Explore queries and tables- Support data literacy

98-364

Lectures2

Quizzes0

Duration30 week

Students12,115

$20.00

📢 Unlock Full Access to Success!

"The content displayed here is a promotional preview and contains only 50% of the actual exam database. To access the complete set of updated questions, please upgrade to the Full Version."

👉 Click the button and follow the instructions to secure your full access immediately!