Question 57: You have a Books database with following columns
BOOK_TITEL
BOOK_AUTHOR
BOOK_PRIMARY_KEYWORD
Assume, each book is written by individual author and one author has written only one book. Its possible that primary keyword can be shared among various books. There are almost 10M books in this table. Which of the following is correct with regards to index?
- You can create index on both BOOK_AUTHOR and BOOK_PRIMARY_KEYWORD
- Get all Questions and Answer from here
- You need to have paid subscription to access all questions
- Thanks for considering Python Certification Material
Correct Answer: 3
Explanation: If you create an index on a high-cardinality column, which has many distinct values, a query between the fields will incur many seeks for very few results.
You can access to full explanation to question and answer from this page.
