How do you increase the OS limitation for open files (LINUX
and/or Solaris)?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
How will u copy the objects of one schema to another schema in datapump & export/import?
What are the different types of indexes available in sql server? : sql server DBA
Give two examples of referential integrity constraints.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Explain what partitioning is and what its benefit is.
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?
How would you determine what sessions are connected and what resources they are waiting for?
Describe what redo logs are.
What background process refreshes materialized views?
2 Answers Accenture, FLSmidth,
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)