Define the SGA and:
How you would configure SGA for a mid-sized OLTP environment?
What is involved in tuning the SGA?
No Answer is Posted For this Question
Be the First to Post Answer
What are statistics, under what circumstances they go out of date, how do you update them?
How can you gather statistics on a table?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
Give two methods you could use to determine what DDL changes have been made.
What is RAID and what are different types of RAID configurations?
what is difference between user managed backup and rman backup?
Give the reasoning behind using an index.
How do you resize a data file?
I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?
how can you communicate with operating system files from oracle?
Explain the use of setting GLOBAL_NAMES equal to TRUE.
When creating a user, what permissions must you grant to allow them to connect to the database?
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)