why do we give pctfree and pctused in create table statement?
Answer / arul
pctfree and pctused only used for DMT tablespace for extent management allocations
| Is This Answer Correct ? | 2 Yes | 2 No |
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
How would you determine what sessions are connected and what resources they are waiting for?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
Compare and contrast TRUNCATE and DELETE for a table.
How can you gather statistics on a table?
any body know about orawaves do they really provide placements in their unique placement program
how can you implement fine-grained auditing?
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
what are the differences of where and if in SAS?
What is the importance of a recovery model? : sql server DBA
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)