What is the use of COMPRESS option in EXP command ?
Answer / chaudhry
Flag to indicate whether export should compress
fragmented segments into single extents.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the use of drop command and what are the differences between drop, truncate and delete commands?
What is index hunting and how does it help in improving query performance?
Define join and enlist its types.
How does a database store data?
Explain the terms database and dbms. Also, mention the different types of dbms.
what is the location of oracle inventory?
Which dbms is best?
Define identity and uniqueidentifier property of column?
What are the characteristics of dbms?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
Why not phenix, the zelinka/otwinoski libraries, etc?
Give us a non-computer example of preemptive and non-preemptive scheduling?
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)