-
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.
-
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.
-
How do you create a primary key to existing table with duplicate records?
hemant.agarwal03
- Mar 17th, 2008
Alter table add constraint primary key ()DEFERRABLE initially immediate enable novalidate
-
Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i?
kashyap_aseem
- Feb 14th, 2008
In 10g there is a option to lock an acount we can lock system user through this correct me if i am wrong
Ritesh Raj Singh
- Jul 12th, 2006
There is no possibilities of disabling the connection as sysdba because sys is the owner of the database who has all the powers of the database so you can disable the account of sys what u can do is y...
-
What is the default sort order in oracle?
-
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...
-
What is an intelligent agent?
azam.irshad
- Jan 2nd, 2008
A process that runs on each of the nodes. It functions as the executor of jobs and events sent by the console by way of the mangement server. High availability is ensured since the agent can function regardless of the status of the cosole or network connections
-
What is free list group?
azam.irshad
- Jan 2nd, 2008
Sets of free lists available for use by one or more instances.When data is frequently inserted into a table from multiple nodes and the table is not partitioned, use free list groups to avoid performa...
-
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.
-
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.
-
Oracle Referential Backup
what is Referential Backup? Which case we use Referential Backup and which case we use Incremental backup?
-
-
What is a full table scan and what is the ideal rate/min for a FTS?
parthokonar1
- Sep 26th, 2007
FTS means the oracle server reads all the records from the concerned table. And it all depends on the size of the table/ partitioned table. What you say if a table consists of 10 million of records. so we musr avoid FTS. And after all Oracle is build for searching.
-
What is the difference between DSS and OLPT
kodaliprakash
- Sep 7th, 2007
DSS is desicion support system. This is mainly useful for tking appropriate decisions based on existing data. All the data is already available in the DB. And we have to get reports according to the n...
-
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...
-
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; ...
-
-
-
-
Database Admin Interview Questions
Ans