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 you process messages in order asynchronously?
Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?
What are the different types of database compression introduced in sql server 2008? : sql server DBA
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
what is ora 24313?what is the procedure to exclude that error?
How many memory layers are in the shared pool?
how can you connect from 10g user to 11g user??
What are the steps you will take to improve performance of a poor performing query?
one datafile is lost in standy side how can you recover that??
What is the recommended interval at which to run statspack snapshots, and why?
Give two examples of referential integrity constraints.
How do you troubleshoot errors in a sql server agent job? : sql server DBA
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)