最新的WGU Data-Management-Foundations免費考試真題

問題1

Which SELECT statement uses valid syntax for SQL?

A. SELECT ALL column1, column2 FROM table_name;

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

C. SELECT column1, column2 WHERE condition FROM table_name;

D. SELECT column1, column2 FROM table_name;

正確答案: D

說明：（僅 Fast2test 成員可見）

問題2

Which term refers to a path from a top-level block to a bottom-level block?

A. Branch

B. Fan-out

C. Crow's foot

D. Sparse index

正確答案: A

說明：（僅 Fast2test 成員可見）

問題3

Which characteristic is true for non-relational databases?

A. They are optimized for big data.

B. They are ideal for databases that require an accurate record of transactions.

C. They support the SQL query language.

D. They store data in tables, columns, and rows, similar to a spreadsheet.

正確答案: A

說明：（僅 Fast2test 成員可見）

問題4

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

A. JOIN VIEWS

B. WITH CHECK OPTION

C. MATERIALIZED VIEW

D. BASE TABLE

正確答案: B

說明：（僅 Fast2test 成員可見）

問題5

Which term defines a column, or group of columns, that refers to a primary key in a different table?

A. Super key

B. Simple key

C. Composite key

D. Foreign key

正確答案: D

說明：（僅 Fast2test 成員可見）

問題6

What is the last step in the logical design process for designing a database?

A. Discover entities

B. Apply a normal form

C. Determine cardinality

D. Analyze data requirements

正確答案: B

說明：（僅 Fast2test 成員可見）

問題7

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

A. Comments

B. Keywords

C. Identifiers

D. Literals

正確答案: D

說明：（僅 Fast2test 成員可見）

最新的WGU Data Management – Foundations - Data-Management-Foundations免費考試真題

聯系我們

站內鏈接

最新更新