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 the role of dip user in our database?
How would you begin to troubleshoot an ORA-3113 error?
what r the types of backup?
What is the dataguard background process??
How would you extract DDL of a table without using a GUI tool?
Why would you use sql agent? : sql server DBA
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
Give two examples of how you might determine the structure of the table DEPT.
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
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)