why we use cursors
Answer / pallavi
cursor is a mechanism by which we can assign a name to a select statement and manipulate the information within sql statement
Is This Answer Correct ? | 1 Yes | 2 No |
How can we see the database version in os level
How would you begin to troubleshoot an ORA-3113 error?
If CPU is very slow What can u do to speed up?
Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode? 4. Can you take Online Backups if the the database is running in NOARCHIVELOG mode?
Name three advisory statistics you can collect.
what is logical system in sap basis
mssqlserver 2005 Backup Advantages & Disadvantages? mssqlserver 2005 Restore Advantages & Disadvantages? mssqlserver 2005 Recovery mode Advantages & Disadvantages? mssqlserver 2005 Mirroring Advantages & Disadvantages? mssqlserver 2005 Replication Advantages & Disadvantages? mssqlserver 2005 Logshpping Advantages & Disadvantages? mssqlserver 2005 Job Advantages & Disadvantages?
what is grd?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are statistics, under what circumstances they go out of date, how do you update them?
why Datapump is faster than traditional export and import