최신 Courses and Certificates Data-Management-Foundations 무료샘플문제:
1. Which database operation locates the needed table blocks?
A) Table scan
B) Binary search
C) Index scan
D) Fan-out
2. Which keyword can be used as a clause in an ALTER TABLE statement?
A) STOP
B) DELETE
C) CHANGE
D) AGGREGATE
3. What is the role of the transaction manager within the database system architecture?
A) The transaction manager logs insert, update, and delete queries, and the result is sent back to the application.
B) The transaction manager is composed of a query processor, storage manager, transaction manager, log, and catalog.
C) The transaction manager uses information from the catalog to perform query optimization.
D) The transaction manager translates the query processor instructions into filesystem commands and uses an index to quickly locate the requested data.
4. Which property of an entity can become a column in a table?
A) Modality
B) Non-null values
C) Attribute
D) Uniqueness
5. Which operation finds an entry containing a search value by repeatedly splitting the index in two?
A) Table scan
B) Binary search
C) Index scan
D) Fan-out
질문과 대답:
질문 # 1 정답: C | 질문 # 2 정답: C | 질문 # 3 정답: A | 질문 # 4 정답: C | 질문 # 5 정답: B |