Interested to Buy Any Domain ? << Click Here >> for more details...
why do we give pctfree and pctused in create table statement?
- 1 Answers
- 5325 Views
- CTS, I also Faced
- E-Mail Answers
Answer / arul
pctfree and pctused only used for DMT tablespace for extent management allocations
| Is This Answer Correct ? | 2 Yes | 2 No |
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?
Why would you use sql agent? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Datapump backup steps?
Explain materialized views and how they are used.
Give the two types of tables involved in producing a star schema and the type of data theyhold.
What is dcl? : sql server DBA
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
why we use cursors
What types of replication are supported in sql server? : sql server DBA
How to make a replica of existing oracle server to another server?
-
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)
