in Education by
What are composite indexes? (a) Are those which are composed by database for its internal use (b) A composite index is a combination of index on 2 or more columns (c) Composite index can never be created (d) None of the mentioned The question was posed to me in an interview. I'd like to ask this question from Index Definition in SQL in section Indexing and Hashing of Database Management Select the correct answer from above options Interview Questions and Answers, Database Interview Questions and Answers for Freshers and Experience

1 Answer

0 votes
by
The correct answer is (b) A composite index is a combination of index on 2 or more columns Easiest explanation - A composite index is an index on two or more columns of a table.

Related questions

0 votes
    1. Name the term which is used to join two separate arrays into a single array. 2.How are the following ... ii) primitive type data Select the correct answer from above options...
asked Dec 13, 2021 in Education by JackTerrance
0 votes
    What are the different composite keys in Cassandra?...
asked Apr 15, 2021 in Technology by JackTerrance
0 votes
    Part of the series of controls I am working on obviously involves me lumping some of them together in to ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Mar 12, 2022 in Education by JackTerrance
0 votes
    I have a Composite Component that uses ajax to change multiple elements when an item is selected. I am ... Questions for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Feb 18, 2022 in Education by JackTerrance
0 votes
    Calling javax.persistence.criteria.Path.get(String name) fails for the simple class hierarchy detailed below. The ... for Interview, JavaScript MCQ (Multiple Choice Questions)...
asked Jan 15, 2022 in Education by JackTerrance
0 votes
    Identify the composite attributes (a) Salary (b) Credits (c) Section_id (d) None of the mentioned I ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    If an attribute of a composite key is dependent on an attribute of the other composite key, a ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    In the __________ normal form, a composite attribute is converted to individual attributes. (a) First (b) ... , Database Interview Questions and Answers for Freshers and Experience...
asked Oct 11, 2021 in Education by JackTerrance
0 votes
    A relation is in ____________ if an attribute of a composite key is dependent on an attribute of other ... for Decomposition topic in division Normalization of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
0 votes
0 votes
    What is Composite Entity pattern?...
asked Nov 7, 2020 in Education by Editorial Staff
0 votes
    What is Composite pattern?...
asked Nov 7, 2020 in Education by Editorial Staff
0 votes
    . Consider the following Dataframe Medals where row indexes are taken as the default values: House Gold Silver ... table in navol: Select the correct answer from above options...
asked Dec 29, 2021 in Education by JackTerrance
0 votes
    How many types of indexes are there in sql server? (a) 1 (b) 2 (c) 3 (d) 4 The question was ... Index Definition in SQL topic in chapter Indexing and Hashing of Database Management...
asked Oct 10, 2021 in Education by JackTerrance
...