Interested to Buy Any Domain ? << Click Here >> for more details...
why we use cursors
- 1 Answers
- 3716 Views
- I also Faced
- E-Mail Answers
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 would you determine who has added a row to a table?
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
Explain the concept of the DUAL table.
why we use cursors
How many memory layers are in the shared pool?
Give two examples of referential integrity constraints.
A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?
What type of index should you use on a fact table?
Compare and contrast TRUNCATE and DELETE for a table.
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???
What are the different sql server versions you have worked on? : sql server DBA
-
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)
