Weekend Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium WGU Data-Management-Foundations Dumps Questions Answers

WGU Data Management – Foundations Exam Questions and Answers

Question 1

Which optional clause is used to reject inserts and updates that do not satisfy the WHERE clause of a view query?

Options:

A.

WITH CHECK OPTION

B.

JOIN VIEWS

C.

MATERIALIZED VIEW

D.

BASE TABLE

Buy Now
Question 2

Which statement is associated with two separate entities?

Options:

A.

Reflexive relationship

B.

Entity type

C.

Relationship

D.

Attribute

Question 3

Which relationship exists between occurrences of the same entity types?

Options:

A.

Modality

B.

Unary

C.

Cardinality

D.

Binary

Question 4

Which clause is used to specify the join columns when performing a join in MySQL?

Options:

A.

AS

B.

JOIN

C.

ON

D.

AND

Question 5

Which phase of entity-relationship modeling refers to the maxima and minima of relationships and attributes?

Options:

A.

Cardinality

B.

Physical design

C.

Attribute minimum

D.

Partition

Question 6

Which operation finds an entry containing a search value by repeatedly splitting the index in two?

Options:

A.

Table scan

B.

Binary search

C.

Index scan

D.

Fan-out

Question 7

Which property is associated with a one-field primary key?

Options:

A.

Simple

B.

Duplicate

C.

Numeric

D.

Composite

Question 8

Which syntax feature classifies the explicit string, numeric, or binary values used in SQL queries?

Options:

A.

Literals

B.

Comments

C.

Identifiers

D.

Keywords

Question 9

Which database operation locates the needed table blocks?

Options:

A.

Binary search

B.

Table scan

C.

Fan-out

D.

Index scan

Question 10

What is the role of the database administrator?

Options:

A.

The database administrator is a consumer of data in a database.

B.

The database administrator is responsible for securing the database system against unauthorized users.

C.

The database administrator determines the format of each data element and the overall database structure.

D.

The database administrator develops computer programs that utilize a database.

Question 11

What is the role of the transaction manager within the database system architecture?

Options:

A.

The transaction manager uses information from the catalog to perform query optimization.

B.

The transaction manager is composed of a query processor, storage manager, transaction manager, log, and catalog.

C.

The transaction manager logs insert, update, and delete queries, and the result is sent back to the application.

D.

The transaction manager translates the query processor instructions into filesystem commands and uses an index to quickly locate the requested data.

Question 12

What is the role of a query processor in the database system architecture?

Options:

A.

It uses information from the catalog to perform query optimization.

B.

It writes log records before applying changes to the database.

C.

It translates instructions into file system commands.

D.

It sends results back to the application that requested the queries.

Question 13

Which type of entity only exists in a logical sense?

Options:

A.

Concrete entity

B.

Tangible entity

C.

Intangible entity

D.

Physical entity

Question 14

How can a primary key constraint be added after the table is created?

Options:

A.

By using an ALTER clause

B.

By using the CREATE TABLE statement

C.

By using an UPDATE clause

D.

By using an INSERT INTO clause

Question 15

Which type of join selects all the rows from both the left and right table, regardless of match?

Options:

A.

Full Join

B.

Outer Join

C.

Inner Join

D.

Cross Join

Question 16

Which SELECT statement uses valid syntax for SQL?

Options:

A.

SELECT "column name", "column name" FROM "table name" WHERE "column name"

B.

SELECT column1, column2 WHERE condition FROM table_name;

C.

SELECT ALL column1, column2 FROM table_name;

D.

SELECT column1, column2 FROM table_name;

Question 17

What does the aggregate function do?

Options:

A.

It computes values over a set of rows.

B.

It selects rows that appear in one table but not another.

C.

It eliminates one or more columns of a table.

D.

It lists combinations of rows in two tables.

Question 18

Which keyword can be used as a clause in an ALTER TABLE statement?

Options:

A.

DELETE

B.

CHANGE

C.

STOP

D.

AGGREGATE