D426 DATA MANAGEMENT FOUNDATIONS - NEW

PDF Download

D426 DATA MANAGEMENT FOUNDATIONS - NEW

PRE-ASSESSMENT EXAM QUESTIONS

Actual Qs and Ans - Expert-Verified Explanation -Guaranteed passing score -58 Questions and Answers

-Format: Multiple-choice / Flashcard

Question 1: How will the database optimize query execution if the filter factor is high?

• It will scan the index sequentially.
• It will look for an indexed column in the WHERE clause.
• It will create a new table index.
• It will perform a table scan.

Answer:

• It will perform a table scan.

Question 2: Which expression can be used to create a temporary name for a table?

A. SET

B. UPDATE

• AS

D. CREATE

Answer:

• AS

Question 3: Which type of join includes a result for every row in both the left and right tables?

A. INNER JOIN

B. CROSS JOIN

C. SELF JOIN

D. FULL JOIN

Answer:

D. FULL JOIN

Question 4: Which DROP statement deletes a column from an existing table?

• DROP COLUMN column_name FROM table_name;
• DROP table_name COLUMN column_name;
• ALTER TABLE DROP COLUMN column_name FROM table_name;
• ALTER TABLE table_name DROP COLUMN column_name;

Answer:

• ALTER TABLE table_name DROP COLUMN column_name;

Question 5: Which type of join is demonstrated by the following query?

SELECT *

FROM Make, Model WHERE Make.ModelID != Model.ID

• non-equijoin
• self join
• natural join
• cross join

Answer:

• non-equijoin

Question 6: Which scenario exemplifies a ternary relationship?

• Suppliers providing products to customers
• Students enrolled in multiple college courses
• Authors writing books
• Employees supervising other employees

Answer:

• Suppliers providing products to customers

Question 7: What is an example of an expression in SQL?

• City = 'Beijing'

B. 134

C. INSERT

• 'Welcome'

Answer:

• City = 'Beijing'

Question 8: How is a one-to-one relationship represented between two entities in an entity-relationship diagram?

• A crow's foot on both ends of the relationship line connecting the two entities
• A less-than sign and a greater-than sign on each end of the relationship line connecting the

two entities

• A bar on both ends of the relationship line connecting the two entities
• A bar on one end and a crow's foot on the other end of the relationship line connecting the

two entities

Answer:

• A bar on both ends of the relationship line connecting the two entities

Question 9: You are inserting a new record into a table. The primary key column is using an auto-incrementing integer. What value should you specify for the primary key column in your INSERT statement?

• Omit the primary key column from the INSERT statement
• Include the primary key column and specify a value of 0
• Include the primary key column and specify a negative value
• Omit any column with an integer data type

Answer:

• Omit the primary key column from the INSERT statement

Question 10: Which strategy can be used to find primary keys when investigating data relationships?

• Trend analysis
• Unique identifier analysis
• Normalization
• Visualization

Answer:

• Unique identifier analysis

Question 11: What is combined by an aggregate function in an SQL query?

• An aggregate function combines the results of multiple simple functions.
• An aggregate function combines multiple tables in its result.
• An aggregate function combines values from a set of rows in its calculations.
• An aggregate function combines equal values into a group and provides outcomes from each

group.

Answer:

• An aggregate function combines values from a set of rows in its calculations.