Interested to Buy Any Domain ? << Click Here >> for more details...
why do we give pctfree and pctused in create table statement?
- 1 Answers
- 5476 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / arul
pctfree and pctused only used for DMT tablespace for extent management allocations
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What are statistics, under what circumstances they go out of date, how do you update them?
what are the differences of where and if in SAS?
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 do you understand by flashback feature of oracle?
Explain materialized views and how they are used.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you find out if a table can be redefined?
How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?
What are the steps you will take to improve performance of a poor performing query?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
