Interested to Buy Any Domain ? << Click Here >> for more details...
which is the most efficient tablespace??
a.simple tablespace.
b.partitioned tablespace.
c.segmented tablespace.
d.none of the above.
please post answer with the reason.?
- 3 Answers
- 6399 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / jaydeep c
C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jaydeep c
C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.
| Is This Answer Correct ? | 0 Yes | 0 No |
What do the initials DDL and DML stand for and what is their meaning?
What is -904 sql code? How to resolve it?
What is the difference between SYNONYM and ALIAS?
Explain what a plan is?
What is sqlcode -922 ?
Which transaction use a command thread ?
Explain about rct.
how can we retrieve the 100 records of the file ?
Explain dclgen.
What is the difference between Primary key and unique index?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
Why select is not preferred in embedded sql programs?
COBOL 
