What are the steps you will take to improve performance of
a poor performing query?
No Answer is Posted For this Question
Be the First to Post Answer
I lost one datafile i dont have backup how can you recover that???
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How to start SQL Server in minimal configuration mode?
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
How would you go about increasing the buffer cache hit ratio?
What is RAID and what are different types of RAID configurations?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
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?
What is fill factor? : sql server DBA
How does Oracle guarantee data integrity of data changes?
What the different topologies in which replication can be configured? : 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)