internal architecture
No Answer is Posted For this Question
Be the First to Post Answer
1)how to Take Backup in sql server 2005 from Flash Drive
What is the importance of a recovery model? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Where in the Oracle directory tree structure are audit traces placed?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How do you resize a data file?
How do you add a data file to a tablespace?
Give the reasoning behind using an index.
Explain materialized views and how they are used.
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
When creating a user, what permissions must you grant to allow them to connect to the database?
How many packages we have in db
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)