How can you control the amount of free space in your index pages? : sql server DBA
No Answer is Posted For this Question
Be the First to Post Answer
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?
what is the use of ocr?
how can you initialize log miner?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
What are the steps you will take to improve performance of a poor performing query?
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
how can you process messages in order asynchronously?
what is the difference between catalog & nocatalog?
What the different components in replication and what is their use? : sql server DBA
SUPPOSE AS A DBA YOU CREATED ONE USER BY DEFAULT HOW MANY PRIVILIZES WILL COME TO USER & WHERE CAN YOU SEE THAT PRIVILIZES.
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
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)