Administration officer

What is a deadlock ? Explain ? 

What is the difference between DATABASE ADMINISTRATION & ORACLE?

What is a Database instance ? Explain ?

What is a Schema ?

Can we decrease the Datafile size?

What is a database instance and Explain ?

What is the use of control file ?

What is a segment

How do you sort a table?

What are clusters ?

What does a control file contains ?

How can you find all the tables created by an user?

What is a redo log ?

Different types of table join. ?

What is DDL, DML?

What is cluster key ?

Whats the difference between indexes,views,synonyms?

What are the basic element of Base configuration of an oracle Database ?

What is Parallel Server ?

What is an Index ? How it is implemented in Oracle Database ? 

What is data block ?

What are the uses of rollback segment ?

Name some built-in functions that can be used in SQL queries?

What is public database link ?

What is private database link ?

What are the basic element of base configuration of an Oracle database?

What is a cluster key ?

What is an index and How it is implemented in Oracle database ?

What is a schema ?

What is Parallel Server ?

Is it possible to disable the connection sys as sysdba. If yes, does violates oracle 9i Any attempts would be appreciated

What is a lookup table in database? where can we use these type of table?

Whenever a DBA creates a user in which datafile that will be get created ?

What is the use of redo log information ?

How is locking implemented?

What is the function of redo log ?

Do you need a commit after DDL statements?

What are the characteristics of data files ?

Is it advisable to force an index when you want to select mostof the entries in the table?

What is a datafile ?

What is a temporary segment ?

What is a cursor? Why do you need them? What are the different kinds of cursor?

What is rollback segment ?

What is an index segment ?

What is a data segment ?

What are the different types of segments ?

What rule optimizations are possible in SQL query tuning?

How would you pass hints to the SQL processor?

What is an extent ?

How do you handle exceptions / errors in stored procedures?

What is row chaining ?

How to define data block size ?

What is network database link ?

What are the types of database links ?

What is database link ?

When can hash cluster used ?

What is hash cluster ?

What is index cluster ?

What are clusters?

How are the index updates ?

What is an Oracle index ?

What are synonyms used for ?

What is a public synonym ?

What is a private synonym ?

What are the types of synonyms ?

What is a synonym ?

What is an Oracle sequence?

What are the advantages of views ?

Do a view contain data ?

What is an Oracle view ?

What is Oracle table ?

Can a tablespace hold objects from different schemes ?

Can objects of the same schema reside in different tablespaces ?

What are Schema Objects ?

Explain the relationship among database, tablespace and data file.What is schema

What is SYSTEM tablespace and when is it created ?

What is a tablespace ?

What are the components of logical database structure of Oracle database

What are the components of physical database structure of Oracle database 

What is the relation between free list and buffer busy wait?

What is ORA-1555?

What ll be in the redolog file after deleting the table ,will it stores the table or any thing else? 2)Can we resize the redolog files?

What is a cluster Key ?

What is clusters ?

What is a deadlock and Explain?