1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

Where would you look for errors from the database engine?

Question Posted / guest


Where would you look for errors from the database engine?..

Answer / Saumitra Sajwan

For errors originating from the database engine, you should consult the error messages returned by the SQL statements, database logs, or configuration files. Additionally, monitoring tools such as Database Administrator (DBA) software and performance dashboards can help identify issues related to the database engine.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

1 Answers  

how can a session indicate its interest in receiving alerts?

1 Answers   Oracle,

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

1 Answers  

Q. How to set ORACLE_HOME to my oracle software directory. Hi Friend I am installing oracle 10g Express Edition on Linux Fedora Core 6. Installation is success but when i run #sqlplus I getting command not found error. Then I have search sqlplus .i.e # find / -name sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin/sqlplus /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/sqlplus These above output from find i have doubt which is correct path of sqlplus. So doubtfully i have set path 1st one.i.e # PATH=$PATH:/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/bin Then I have run #sqlplus but still i have problem following Error 6 initializing SQL*Plus Message file sp1<lang>.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory How overcome this please answer m???

1 Answers  

How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.

4 Answers  

How can you rebuild an index?

6 Answers  

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA

1 Answers  

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

1 Answers  

What are the different types of database compression introduced in sql server 2008? : sql server DBA

1 Answers  

what is rebuild index??

2 Answers   IBM, Sapient,

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories