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 |
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.
which background process will run @ the time of creation of catalog database
What the different types of replication and why are they used? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
how can a session indicate its interest in receiving alerts?
Name two files used for network connection to a database.
how can you initialize log miner?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
What are the different types of upgrades that can be performed in sql server? : 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)