Interested to Buy Any Domain ? << Click Here >> for more details...
utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
- 2 Answers
- 5903 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / raj kumar
Explain
explain will give the optimizer plan for the query
explain select * from .......etc
| Is This Answer Correct ? | 2 Yes | 0 No |
What do you mean by cluster and non cluster index?
How to shrink a database?
How do database connections work?
Explain buffer manager?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
Explain alternate key?
WHAT IS CARDINALITIES OF JOIN?
What are the tools used for backup and ticketing?
write a query for the fifth highest salary?
17 Answers IBM, Matlabs, Ramco,
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?
What are the concurrency problems a database faces?
-
Oracle (3253) - 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)
