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 |
What is checkpoint?
How would you best determine why your MVIEW couldn't FAST REFRESH?
what is the diffrence between core dba and apps dba?
Explain what partitioning is and what its benefit is.
Why does Oracle not permit the use of PCTUSED with indexes?
What are the different sql server versions you have worked on? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
How many memory layers are in the shared pool?
How do you add a data file to a tablespace?
Oracle (3253)
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)