Chuyển đến phần nội dung
Luyện Nghe Tiếng Anh Chất
Tiếng Anh Chuyên Ngành
Listening Quiz: Tìm Ra Index Bị Thiếu Trong Database – Advanced Level
Th2 6, 2024
—
bởi
Anna Phạm
trong
Tiếng Anh dành cho Kiến trúc sư hệ thống (English for Systems Architect)
‹
1
2
3
4
5
›
1.
What is the main topic of the conversation?
A debate about changing the query language
A plan to move the database to a new server
A discussion about fixing a slow database query by adding an index
A report about deleting old data from the database
Explanation:
Paul and Mia discuss a critical query that is slow because the schema is missing an index, and they plan to add the index to improve performance.
2.
What did Paul check to discover the problem?
The query plan
The server logs
The user permissions
The backup files
Explanation:
Paul says, ‘I checked the query plan and saw no index use.’
3.
What is causing the query to be slow?
The network connection is down
The table has been deleted
The database has too many users
The database schema is missing an index
Explanation:
Paul explains that the query is slow because ‘the database schema is missing an index.’
4.
What can be inferred about the query after the index is added?
It will become slower because of testing
It will stop using the database entirely
It should run much faster than before
It will require a full table scan every time
Explanation:
Paul says the new index will ‘speed up the query a lot,’ so it can be inferred that the query should run much faster.
5.
What will Paul do next?
Ignore the problem for now
Delete the slow query
Create the missing index
Replace the database schema
Explanation:
Mia asks if they can add the missing index, and Paul replies, ‘Yes, I will create it now.’
Previous
Check
Next
Finish
Reset
Luyện tập thêm về bài học này:
Listening Lesson
Vocabulary Flashcards and Quiz
←
Trước đó:
Listening Quiz: Bài tập lập bản đồ chuỗi cung ứng – Medium Level
Tiếp theo:
Listening Quiz: Tư Vấn VAT Cho Công Ty Con Kinh Doanh Của Tổ Chức Từ Thiện – Medium Level
→