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
How would you extract DDL of a table without using a GUI tool?
What the different topologies in which replication can be configured? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What is replication? : sql server DBA
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
how can you implement fine-grained auditing?
how can you record information about current session?
what functionality does oracle provide to secure sensitive information?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?