Answer Posted / vijay
Dual is like a dummy table which consists of one row and one column
select sysdate from dual;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
who owns the operating system files created by the utl_file package?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
how can you schedule a job in database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What is the difference between dropping a database and taking a database offline? : sql server DBA
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
how to restore files with rman?
How can you control the amount of free space in your index pages? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
What is transparent data encryption? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what do you understand by fine-grained auditing?
You create a private database link and upon
connection, fails with: ORA-2085: connects to