what is indexing, searching and user interface?
Answer / suman
what is indexing
An index is a performance-tuning method of allowing faster retrieval of records. An index creates an entry for each value that appears in the indexed columns. By default, Oracle creates B-tree indexes.
| Is This Answer Correct ? | 4 Yes | 0 No |
Can ddl statements be used in pl/sql?
In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join.
Define join and name different types of joins?
How do I run a sql query?
why should required nested tables, Object types, partition tables and varying arrays. what is the difference between these are all. give me example with explanation.
Why are indexes and views important to an organization?
Explain character-manipulation functions?
What are the different types of constraints?
Can we use ddl commands in pl sql?
What is oracle ? why we should go for oracle database instead of diffrent databases available in the industry.
Does sql support programming?
what are the differences between require and include, include_once and require_once? : Sql dba
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)