-
Which tool you have used for monitoring the databases?
Akbar Yuldoshev
- Jun 18th, 2016
Oracle Enterprise Manager
-
Slow Performance in Production Database
What is the solution if some users are encountering slow performance in production db?
-
How is locking implemented?
Raghunathan Asari
- Jul 22nd, 2007
Whenever an SQL is issued for execution, DB2 checks for lock avoidance by checking the SQL.Eg. SELECT ...... WITH UR or BIND with ISOLATION (UR) (UR Uncommitted Read)If not DB2 checks&nbs...
Culver_lake
- Mar 19th, 2006
Locking in most modern database management systems is implemented implicitly. That is you never have to ask for a lock nor will you ever fail to release a lock. In DB2 this is all controll...
-
Is it advisable to force an index when you want to select most of the entries in the table?
John Netherwood
- Nov 14th, 2007
No it isn't. If you are going to select most of the entries then you will have to read through the entire table anyway. Forcing the use of an index will just be an extra overhead.
-
-
What is addressing modes? What is a node, How to insert into nodes?
kumar1974
- Jan 22nd, 2008
Dear Pooja your answer is correct. And please write the answer in steps wise or by paragraphs wise.Regardskumar
Pooja Chaturvedi
- Nov 19th, 2006
Addressing modes, a concept from computer science, are an aspect of the instruction set architecture in most central processing unit (CPU) designs. The various addressing modes that are defined in a g...
-
Different types of table join.
dhampack
- Nov 24th, 2008
In Sybase(T-SQL), there are 3 types of joins1) Equi Join2) Natural Join3) Outer Join (left & right)Joins based on equality (=) are called equijoins. Equijoins compare the values in the columns bei...
Bobby
- Sep 14th, 2006
There are 3 types of joins basis on Oracle 8i Simple join ?????1. Equi join : Equi join is one which contains comparision operator '=' in where clause. ?????2. Non Equi join: If the com...
-
If you have an open cursor on a table, modify the same tableand commit, what would happen?
AK
- Jul 3rd, 2007
Depends on when you commit the changes. If u are processing like above (in a for loop) you should commit post processing, after the cursor is closed. But that's often not useful on huge amount of data...
kishore_m_k
- Apr 19th, 2007
it updates the table without any problem.CREATE TABLE dept1 AS SELECT * FROM dept;declare r1 dept1%rowtype; cursor c1 is select * from dept1 for update of deptno;begin open c1; ...
-
What is the default sort order in oracle?
-
Fractured Block
What is mean by fractured block in terms of manual hot backup?
ganesh
- Mar 12th, 2013
In case of hot backup we get fractured blocks, because of this reason hot backups is called Inconsistent backup. let say in hot backups our operating system copies OS block by OS block while copy is g...
alok83
- Apr 11th, 2008
The concept of fractured block occrus when backup is under process.It means you are taking backup and some other session is updating it.Then backup process can not get the consistent image of the block and it will be inconsistent right thats why it is called fractured block.
-
Logical online backup
Can you take online backup of a Control file if yes, how? Explain about Logical Backup?
bapiora
- Jun 29th, 2009
During database online you perform logical online backup for control file. ALTER DATABASE CONTROLFILE TO TRACE Through this command you perform? control file trace backup which is logical.
impalor
- Dec 9th, 2008
You could use alter database backup controlfile for a binary copy of control file.
-
Where should you place Archive logfiles, in the same disk where DB is or another disk ?
poojap
- Oct 6th, 2010
Yes, Archive log files should be on different disk?because?in case of database failure we can get ?the data from the Archive logfiles.
dhs01
- Apr 15th, 2009
In addition to the previously stated reason that if there is a disk problem, not having them on that disk is a good idea, another issue might be contention. Putting them on the same disk would keep th...
-
How to provide much and more security to my users in the database?
rajendra_thanekar
- Apr 9th, 2008
Hi,create role in database with proper permission. then assign that role to the user. This is the simplest method to implement secuirty in database.
Yogesh
- Feb 6th, 2007
By providing proper Grants on tables such a (select ,update delete..) to different user a DBA can have a better control over his database and if he finds some problem he can Revoke the given rights of the specified user.
-
What happens if i kill a mandatory background processes?
krish_makkena
- Aug 4th, 2010
If we kill the mandatory background processes the db should be shutdown i.e, instance is terminated.
-
-
Whenever a DBA creates a user in which datafile that will be get created ?
None
gbansal4
- Dec 17th, 2007
When the user is created without mentioning default tablespace, then it will be created in SYSTEM tablespace. If Temporary tablespace is also not mentioned then it will automatically take the default temporary tablespace mentioned by the DBA.
Sundar
- Oct 25th, 2007
In MS SQL Server it gets stored in master db.
-
What is Dedicated Server and Shared Server?
ianilreddy
- Aug 7th, 2010
Dedeicated server: For one user one server processsesShared server: Where multiple user and one server process. In shared server whenever user request, server hands over the request to dispatcher and...
sharmme
- Feb 17th, 2010
In a Dedicated server mode, listener spawns a dedicated server process for each user process where as in shared server mode, listener assigns a dispatcher to each user process from the available ...
-
What is the difference between a system crash and a media failure?
dbashashi
- May 20th, 2008
In simple terminology, combination of S/w(Operating system et all) and hardware(Disk Drives) on which these S/W(OS) are loaded, are vital for smooth runing of system. Failure of any of ...
stepwil
- Apr 16th, 2008
A system crash is when an operating system or an application fails corrupting or deleting database objects or the database itself. Media failure is when the hardware that houses the database fails ie: hard disk failure.
-
TNS-03505: Failed to resolve name
HI I installed RHEL4 on my home pc.and I created 2 databases of oracle 10g (same vesrion)The problem is while iam establishing connectivity between these 2 databases iam getting error like TNS-03505: Failed to resolve namemy listerner.ora file isLISTENER=(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST= (ADDRESS=(PROTOCOL=IPC)(KEY=CHANDU)) (ADDRESS=(PROTOCOL=TCP)(HOST=127.0.0.1)(PORT=1521))...
mb.appsdba
- Sep 2nd, 2010
The issue usually occurs when the tns entiries we provide has some unwanted characters or spaces etc.Please also check the tns entry(alias) is pointing to the correct database with sid,hostname etc.If...
maniswamy
- Oct 3rd, 2009
Just check your port number if two database are in one PC the port number is changed.
-
Database Connections
How will you determine the number of connections connected to your database?
Anupama Kanakam
- May 29th, 2011
We can also see these connections on Activity monitor. But you need permissions to see it.
jsavarin
- Nov 8th, 2010
We can determine the number of connections by using this - SELECT COUNT(*) FROM v$session;
Database Admin Interview Questions
Ans