utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
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 |
please tell me the informatica telecom projects interview question? like if they ask about project explanation and the difficulties and the solutions taken to solve the issues for telecom projects,e.g i am workin for a vodafone project handlin postpaid section,pls tell me wat wud be the process if i work in this ? thanks
What happens when shared and exclusive locks are applied on data item?
Explain entity type?
utility used to obtain inform regarding the optimizes choice of access strategy for SQL stmts A) LOAD B) REORG C) COPY D) EXPLAIN
List some advantages of dbms.
Which database does facebook use?
You are creating a Index on EMPNO column in the EMPLOYEE table. Which statement will you use?
define primary key index, bitmap index, hash index,virtual indwx
What are different types of blocks used in stored procedure?
Which is the best sorting method if i have to sort the students of Harvard University according to their first name?
What is a Transformation?
What is difference between data and database?
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)