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
What is dcl? : sql server DBA
how can you communicate with operating system files from oracle?
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
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you schedule a job in database?
Where would you look for errors from the database engine?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What the different topologies in which replication can be configured? : sql server DBA
What is the default fill factor value? : sql server DBA
what is the use of ocr?
Explain materialized views and how they are used.
