Database - Interview Questions and Answers for 'Mindtree' | Search Interview Question

Database - Interview Questions and Answers for 'Mindtree' - 2 question(s) found - Order By Newest

Q1. What is difference between clustered and non clustered index?

Ans. The clustered index determines how the data is stored in the rows of a table.The non-clustered index stores the data at a single place and the indexes are stored at another place.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve clustered vs non clustered index index database index Asked in 1 Companies}

Related Questions

Which of the following exception is thrown when we try to access element which is beyond the size ?

What is ArrayIndexOutOfBoundException ?

What is meant by size and index of a collection ?

Write a Program to print index of first capital character in a string.

What does the property maxBackupIndex in Log4j means ?

Given a string and index for the opening bracket, find the index of matching closing bracket.

Which of the following - arrays or LinkedList allow elements to be accessed using index and how ?

Can we access elements at a particular index using LinkedList collection class ?

Q2. Describe SQL Joins

Database

Ans. Oracle having following types of joins these are also called 8i joins. There are:

1. Equi (or) Inner join
2. Non Equi join
3.Self join
4.Outer join

Oracle also support the 9i (or) ANSI standard joins.There are:

1.Inner join
2.Left outer join
3.Right outer join
4.Full outer join
5.Natural join

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql joins sql Asked in 2 Companies}

Related Questions

If Table A has 100 records and Table B has 50 records , how many records will the left join of Table A with Table B generate ?

If Table A has 100 records and Table B has 50 records , how many records will the right join of Table A with Table B generate ?

If Table A has 0 records and Table B has 50 records , how many records will the equi join of Table generate ?

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.