Which factors does not affect the size of the SGA ?
Answers were Sorted based on User's Feedback
Answer / guest
Stored procedure does not affect the size of the SGA
| Is This Answer Correct ? | 2 Yes | 4 No |
What is the default '-sort' order for a sql?
What is " group by " clause?
What is data modelling explain?
I want to export the data date to date from oracle database then what can i do?
I have 2 tables with 1 million rows each. I have updated 1 row in first and 1 million update on second table. Now I commit both the updates. Which one will commit fast and Why?
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
Explain about the properties of cursors?
what is datapump? Difference between exp and expdp?
2 Answers Capital IQ, TCS, WNS,
Explain what are the two types of oltp?
Explain the scenarios or situations under which progress database creates new index entry for a record?
How to improve query performance using index hunting?
What is db flush?
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)