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 are the different modes of mounting a Database with the Parallel Server ?
What is the difference between delete and truncate command in dbms?
What is hot backup (in case of oracle)?
Can we linked SharePoint to a SQL databasebe?
0 Answers Sans Pareil IT Services,
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?
What is the structure of a database?
Define a relation schema and a relation.
What do you understand by the view and mention the steps to create, update and drop a view?
What are foreign keys in database?
What is stored procedure in database?
Explain how RDBMS software deals with deadlocks.
Explain a join between tables?
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)