WGU Data-Management-Foundations 問題集

質問 1：
Which keyword is used to introduce a limiter in a SELECT statement?
A. DROP
B. FROM
C. INTO
D. WHERE
正解：D
解説: (Topexam メンバーにのみ表示されます)

質問 2：
Which command is used to filter group results generated by the GROUP BY clause?
A. HAVING
B. REPLACE
C. WITH
D. WHERE
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 3：
Which description defines a data type?
A. It has a name and a varying set of rows.
B. It is a named set of values.
C. It has values corresponding to columns.
D. It is an unnamed tuple of values.
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 4：
Which expression can be used to create a temporary name for a table?
A. HAVING
B. ALIAS
C. NEW
D. UNION
正解：B
解説: (Topexam メンバーにのみ表示されます)

質問 5：
Which type of join is demonstrated by the following query?
sql
SELECT *
FROM Make, Model
WHERE Make.ModelID = Model.ID;
A. EQUIJOIN
B. CROSS JOIN
C. SELF JOIN
D. NON-EQUIJOIN
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 6：
What is the role of the transaction manager within the database system architecture?
A. The transaction manager is composed of a query processor, storage manager, transaction manager, log, and catalog.
B. The transaction manager logs insert, update, and delete queries, and the result is sent back to the application.
C. The transaction manager translates the query processor instructions into filesystem commands and uses an index to quickly locate the requested data.
D. The transaction manager uses information from the catalog to perform query optimization.
正解：B
解説: (Topexam メンバーにのみ表示されます)