utility used to obtain inform regarding the optimizes
choice of access strategy for SQL stmts
A) LOAD
B) REORG
C) COPY
D) EXPLAIN
Answer Posted / akoman
D) EXPLAIN
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Which is the most reliable programming language for RDBMS Relational Database Management System for Multi user applicaton. For PC application or web application ?
Difference between sql and mysql?
What are the types of indexes that are present inside a database?
how do you do sql tuning?
What is difference between data and database?
Explain entity set?
What is table scan and index scan?
What is database schema name?
What do you mean by database?
What are the types of joins?
During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?
First input columns brand, mt, re values are ov, 1,re vg, 2,re wu ,3,re. Second input columns are brand, mt, cx their records are ov,4,vg ,5,cx Wu, 6,cx and third input columns brand, mt, rt values are ov,7,rt vg, 8,rt wu, 9,rt but my output is brand, re, cx,rt values are ov, 1,4,7 vg, 2,5,8 wu, 3,6,9
List various types of log-based recovery in DBMS.
Explain about ur projets on teradata???
Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it