Types of indexes. What is the default key created when a
primary key is created in a table ?
Answers were Sorted based on User's Feedback
Answer / mahesh
Major indexes are B-tree and Bitmap indexes
When ever we create a primary key, B-tree index will be
created
| Is This Answer Correct ? | 15 Yes | 3 No |
Answer / sdp
A unique index is created when a primary key is created in
a table.
| Is This Answer Correct ? | 10 Yes | 3 No |
Answer / suren
while creating primary by default a unique index is created
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / manish_patil
There are main two types of indexes,
B-tree index
Bitmap index.
While creating Primary key by default cluster index get
crated.
| Is This Answer Correct ? | 7 Yes | 5 No |
What are tables in sql?
SELECT flavor, SUM (ice_cream_sales) FROM sales_detail GROUP BY flavor ORDER BY 2 DESC If the "sales_detail" table contains ten records with different values in the flavor column (two "vanilla," three "chocolate," four "strawberry," and one NULL), how many rows are returned by the sample code above? 1. 0 rows 2. 1 row 3. 3 rows 4. 4 rows 5. 10 rows
what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?
How do I use google cloud in sql?
How many tables can a sql database have?
Hi, Can anybody please explain me the flow of the below query. I am not able to understand how this query works. This query is for finding the Nth highest salary.. SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal); If N = 2 then second highest salary will be the o/p. If N = 3 then third highest salary will be the o/p. and so on.. Thanks, Nitin
5 Answers Deloitte, Ness Technologies,
can use the following like overloading concept in a single package: procedure p1(a varchar), procedure p1(a varchar2), procedure p1(a char)
What is normalization sql?
What do you mean by query optimization?
What is number function in sql?
can we delete the trigger in a view? if yes why if not why?
What are the two types of periodical indexes?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)