What is the criteria while applying index to any column on
any table.
index syntax
-----------------
create index index_name on table_name (column_name)
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the meaning of disabling a trigger?
write sub query for eliminating duplicate rows using analytical function?
How do rank () and dense_rank () differ?
What is sqlerrd?
What are the basic sql commands?
What is pivot in sql?
what is the forward decleration in packages?
What is difference between sql and excel?
What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.
25.67,-1 Trunc = 20 Round= 30 HOW????
What are the types of join in sql?
what are the t string functions available in tsql? : Transact sql
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)