How would you begin to troubleshoot an ORA-3113 error?
Answer / braj123
> Check the setup files for the Net8 driver.
> Net8 software is correctly installed on the server or not?
> Check the trace file for tracing the problem.
| Is This Answer Correct ? | 2 Yes | 2 No |
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
How can you rebuild an index?
Explain how you would restore a database using RMAN to Point in Time?
Explain what partitioning is and what its benefit is.
what functionality does oracle provide to secure sensitive information?
what is grd?
What are the commands used in dcl? : sql server DBA
Give two examples of how you might determine the structure of the table DEPT.
What are the steps you will take to improve performance of a poor performing query?
What are the ways tablespaces can be managed and how do they differ?
You have just compiled a PL/SQL package but got errors, how would you view the errors?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : 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)