In index matching,the condition in the WHERE clause can never contain pattern matching (using the keyword LIKE),regardless of whether the index is a single-column or a composite index.
Correct Answer:
Verified
Q1: The ideal Btree structure is wide,i.e.it has
Q2: In a hash file,if two keys hash
Q4: A logical record may be split across
Q5: Unordered sequential files are sometimes known as
Q6: To improve the response time to access
Q7: A Sequential File is a simple file
Q8: A bitmap join index is actually a
Q9: In a Btree structure,the height of the
Q10: Physical records are synonymous to blocks or
Q11: INSERT and DELETE statements affect only the
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents