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 |
Give the reasoning behind using an index.
Explain about your sql server dba experience? : sql server DBA
What is the difference between clustered and non-clustered index? : sql server DBA
Which autogrowth database setting is good? : sql server DBA
how can you enable flashback feature?
What is the difference between online backup & offline backup?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the steps you will take, if you are tasked with securing an SQL Server?
one datafile is lost in standy side how can you recover that??
Is it possible to run 32 bit sql server 2000 on64bit windows platform.if how much memory is available to sql server?
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
what is the use of ocr?
Oracle (3259)
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)