Database Analyst

Explain the man feature of RDBMS ?

What are the package used in DBMS ?

what are primary key and foreign key ?

What are ACID properties?

Explain the key constraints and constraints on Null Values with examples?

Explain the classification of Database Management System?

What are the Roles and responsibilities of database administrator?

Write a note on File based system/ Data base system?

what is the difference between unique and primary key?

wat is meant by oracle?

wHAT IS THE difference between foreign key and reference key?

WHAT IS INDEXING?

what is dba_segment ?

what do u mean by canvases and alerts?

What is relational database ?

What are indexes ? What are the advantages ?

what is the difference between filters and conditions?

Explain about the critical recovery scenario you had experiencedE?

what do u mean by implementation?

write a query to Find the Maximun second value in table?

what are the differences you find when working with oracle 91 and sql server 2005?

What file is read by ODBC to load drivers ?

Can we assign Explicitly transaction to a rollback segment?

How the status of the Rollback segment can be viewed ?

What is the use of NOARCHIEVELOG parameter in Database?

Which parameters are optional in init.ora parameter file?

what is the use of EXP command ?

How the SMON process is used to write into LOG files ?

When the SYSTEM TABLESPACE can be made off-line ?

What are the different Sequence of events takes place while starting a Database ?

What are the types of Calculated columns available ?

What are the SQL clauses supported in the link property sheet ?

What is TERM ?

what Kind of COMMENT statements placed within SQL statements ?

Oracle precompiler translates the EMBEDDED SQL statemens into ?

How many number of columns can a RECORD GROUP have ?

Can we create an List of Values without an RECORD GROUP ?

Can an Alert message be changed at runtime ?

What is an ALERT ?

What is a RADIO GROUP ?

What is a Built_in subprogram ?

How do you pass values from one form to another form ?

Can we attach the same List of Values to different fields in Design time ?

When a form is invoked with CALL_FORM does Oracle forms issues?

What built_in procedure is used to get IMAGES in Forms 4.5 ?

What is Library in Forms 4.0?

what the List of Values (LOV) supports?

What do you mean by Checkbox ?

Can A CONTROL BLOCK can sometimes refer to a Basetable ?

what is GET_BLOCK property ?

What is built_in Subprogram?

When do you get a .PLL extension ?

How can you CALL Reports from Forms4.0?

What SYSTEM VARIABLE is used to refer DATABASE TIME?

What will the SHOW_ALERT function returns?

What built in subprogram is used to manipulate images in image items ?

What are the different events in Triggers ?

What are the the different Data Manipulation Language statements are?

what is Data Definiton Language ?

Explain different types of Views ?

Is it possible to modify a Datatype of a column when column contains values?

Does the Database trigger will fire when the table is TRUNCATED ?

what is "TABLE" datatype ?

PL/SQL supports which datatypes?

Explain about User_Defined Exceptions?

Explain what is an Exception ?

What does a COMMIT statement do to a CURSOR?

Which factors does not affect the size of the SGA ?

What is Dedicated server configuration ?

where a Database Procedure is stored ?

Can A column defined as PRIMARY KEY can have NULL values ?

What is a DATABLOCK ?

when A set of Dictionary tables are created ?

How the size of the table space can be increased?

when All datafiles related to a Tablespace are removed ?

Explain ERASE packaged procedure ?

What is a trigger?

Name the two files that are created when you generate a form ?

What is SQL FORMS ?

Which of the packaged procedure is UNRESTRICTED ?

What is the maximum size of the page ?

what is postback trigger?

What does DLL stands for ?

what are the advantages of a client or server model ?

Why is it better to use an Integrity Constraint to validate data ?

What is the difference between a LIST BOX and a COMBO BOX ?

what are the advantages of GUI systems ?

Can a DIALOG WINDOW have scroll bar attached to it ?

What is the difference between a MESSAGEBOX and an ALERT ?

What is difference between a DIALOG WINDOW and a DOCUMENT WINDOW ?

can Constraints cannot be exported through EXPORT command ?

Where the Databases overall structure is maintained ?

Where does the LGWR process writes information?

From where ENQUEUE resources parameter information is derived ?

From where the Transactions per rollback segment is derived ?

What is the use of Snapshot?

What are the factors causing the reparsing of SQL statements in SGA?

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

What is the mechanism provided by ORACLE for table replication ?

Describe two phases of Two-phase commit ?

What is Two-Phase Commit ?

What is Distributed database ?

What is cursor and where do you use them?

What is hot backup and how it can be taken ?

What are the different kind of export backups ?

What is cold backup ? What are the elements of it ?

What is a logical backup ?

What are the different methods of backing up oracle database ?

What are the steps involved in Instance Recovery ?

What is Log Switch ?

What is Archived Redo Log ?

What is Mirrored on-line Redo Log ?

What is On-line Redo Log?

What is Partial Backup ?

What is Full Backup ?

What are the different modes of mounting a Database with the Parallel Server ?

What is Restricted Mode of Instance Startup ?

Which parameters are optional in init.ora parameter file?

when All datafiles related to a Tablespace are removed ?

Explain the classification of Database Management System?

what is GET_BLOCK property ?

What do you mean by Checkbox ?

what do u mean by canvases and alerts?

What is a Built_in subprogram ?

what is the difference between filters and conditions?

What is SQL? 

What is SELECT statement?

How can you compare a part of the name rather than the entire name?

What is the INSERT statement?

How do you delete a record from a database?

How could I get distinct entries from a table?

How to get the results of a Query sorted in any order?

How can I find the total number of records in a table?

What is GROUP BY?

What are the Large object types suported by Oracle?

Difference between a "where" clause and a "having" clause ?

What's the difference between a primary key and a unique key?

What are cursors? Explain different types of cursors? What are the disadvantages of cursors? How can you avoid cursors?

What are triggers? How to invoke a trigger on demand?

What is a join and explain different types of joins?

What is a self join?

What is difference between stack and queue? 

Can you take Image Backups using RMAN?

What is Data Storage? Definition Language?

What is DML Compiler?

What is serialization? What is the difference between sql and oracle?

What is difference between oracle8i,oracle9i and oracle 10g?

What is the meaning for data base without using technical terms?

What is the difference between oracle 9i and 10g database?

What is basic difference between SQL Server2000 and oracle?

What is Trigger?

What magic table What happen when we run any command or stored procedure is it compile ?

What does OFA stands for?

What is dblink and how use it ?

What is oracle d2k? why we use it?

Explain about primary key?

How grid work? is it possible grid in 9i. how? 

How we determine index require rebuilding ?

Disadvantage in File Processing System?

Describe the three levels of data abstraction?

What is Data Independence?

What is Weak Entity set?

What is lock and latch?

What is data base?

what are Advantages of DBMS?

What is Data Model?

What is Object Oriented model?

What is an Entity?

What is a Relation Schema and a Relation?

What is degree of a Relation?

How to modify already created table?

What is DML (Data Manipulation Language)? 

What is Functional Dependency?

What is the difference between oracle and sql?

Explain about what a database is?

Explain about the database management systems?

EExplain about XML databases?

What is standard parameter at database creation?

Explain about the hierarchical model of database?

what is listner how u can change default name & port?

Explain about Network model?

What are the three basic rules which are to be followed for relational model of database?

Explain about relational database?

Explain about relational operator join?

Explain about the process of user request and data generating?

Explain about normal forms?

Explain about relational database management systems?

Explain about post relational databases?

what type of indexes?

Explain about the Storage and physical database design?

How data store in bitmap & btree index what is benefit?

Explain the role of indexing in databases?

State the ACID rules?

How you can determine query use full table scan?

How we determine index require rebuilding ? 

What is row changing how u eliminate ?

What is view is it possible to create index on view on view & how ?

What is primary & unique key which type index oracle create when we make those key ?

What is steps of cloning?

When is a database is not a database?

What is the difference between sql and pl/sql?

What is dynamic data replication?

What is DBMS?

Data Warehouse Analyst

What are the major differences between Informatica 7.1,8.1,8.5 and 8.6?

What are dimensions?

What is difference between stored procedure transformation and external procedure transformation?

What are aggregations?

What is OLTP?

Explain time series algorithm in data mining?

What are cubes?

What are measures?

What are fact tables?

What are the benefits of data warehousing?

What is a data mart?

What is the approximate size of a data warehouse?

How many ways U can update a relational source definition and what r they?

What are the types of External Loader available with Informatica?

Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?

Explain about Recovering sessions?

What is a time dimension? give an example.?

Can u copy the session to a different folder or repository?

How to use mapping parameters and what is their use?

What r the joiner caches?

How can u recover the session in sequential batches?

Explain about Recovering sessions?

What kinds of data belong in a data warehouse?

Why would I want to access the data warehouse when I have a mainframe computing system?

Definitions of decision tree on the Web?

What?s metadata? What?s a data dictionary?

Definitions of electronic data exchange on the Web?

Definitions of software agent on the Web?

Definitions of public key certificate on the Web?

What do you know about Datawarehousing ?

State some of the benefits of dataware housing?

What are the different interconnected layers of a dataware house?

Can a Data Warehouse also be used for Transaction Database?

What is the use of bridge table. Can give a simple example?

Explain about the top design?

How does replication takes place between two sites?

Explain about the time variant feature of Dataware housing?

What are the steps to build the data warehouse?

What is DATA integration?

Explain about the non-volatile feature of dataware house?

What are Data Marts?

Explain some disadvantages of dataware house?

What is real time data-warehousing?

Explain about hybrid design model?

What is data mining?

Explain about the bottom up design?

Which is the optimized method of extracting the data?

What are the similarities between ROLAP and MOLAP?

State some of the disadvantages of data ware houses?

What is the purpose of "Factless Fact Table"? How it is involved in Many to many relationship?

What do you think about the future of data warehousing?

How do you connect two fact tables ?Is it possible ?

What are the general stages of use of dataware house?

Can a dimension table contains numeric values?

State two major differences between a dataware house and operational dataware house?

What are the advantages data mining over traditional approaches?

Explain about the integrated dataware house stage?

What is the main difference between Inmon and Kimball philosophies of data warehousing?

What is junk dimension? What are junk dimension and degenerated dimension?

What is Data warehousing Hierarchy?

What is a look up table?

What is a CUBE in data warehousing concept?

How are the Dimension tables designed?

Is it correct/feasible develop a Data Mart using an ODS?

What is ODS?

Why should you put your data warehouse on a different system than your OLTP system?

Why is Data Modeling Important?

What is ETL?

What does level of Granularity of a fact table signify?

What is SCD1 , SCD2 , SCD3?

Why are OLTP database designs not generally a good idea for a Data Warehouse?

What are the various Reporting tools in the Market?

What are conformed dimensions?

What are the Different methods of loading Dimension tables?

What is conformed fact?

What are non-additive facts?

How Do I Make Remarks In My Code?

What type of Indexing mechanism do we need to use for a typical data warehouse?

What is a general purpose scheduling tool?

Name some of modeling tools available in the Market?

Explain the advanatages of RAID 1, 1/0, and 5. What type of RAID setup would you put your TX logs.?

What is VLDB?

What is the datatype of the surrogate key ?

What is degenerate dimension table?

What are the methodologies of Data Warehousing.?

What is a linked cube?

What are the different architecture of datawarehouse?

What are the possible data marts in Retail sales.?

What is the difference between view and materialized view?

What is active data warehousing?

What is the difference between Datawarehousing and Business Intelligence?

What is snapshot?

What are non-additive facts in detail?

What is a level of Granularity of a fact table?

What is Virtual Data Warehousing?

What is XMLA?

Why is SAS so popular?

What is data cleaning? How can we do that?

Explain in brief about critical column?

How to Add VB script to web pages ?

What is source qualifier?

Difference between DSS & OLTP?

Explain grouped cross tab?

Hierarchy of DWH?

How many repositories can we create in Informatica?

What is surrogate key?

What is difference between Mapplet and reusable transformation?

What is aggregate awareness?

Explain reference cursor?

What are parallel querys and query hints?

DWH architecture?

What are cursors?

Advantages of de normalized data?

What is operational data source (ODS)?

What is meta data and system catalog?

What is factless fact schema?

What is confirmed dimension?

What is the capacity of power cube?

Difference between PowerPlay transformer and power play reports?

What is IQD file?

What is Cognos script editor?

What is difference macros and prompts?

What is power play plug in?

Which kind of index is preferred in DWH?

What is hash partition?

What is DTM session?

How can you define a transformation? What are different types of transformations in Informatica?

What is mapplet?

What is query panel?

Data Quality Analyst

What is meant by the term 'accuracy'?

What is meant by the term 'precision'?

What is meant by the term 'data quality'?

What is a mental map?

What is positional error?

What is attribute uncertainty?

What is the MAUP?

What are sliver polygons?

What is Monte Carlo simulation?

Cartographic generalization will not produce errors in map data.?

Data Management Analyst

Why is a UNION ALL faster than a UNION?

What are some advantages to using Oracle’s CREATE DATABASE statement to create a new database manually?

What are three rules of thumb to create good passwords? How would a DBA enforce those rules in Oracle? What business challenges might you encounter?

Describe the Oracle Wait Interface, how it works, and what it provides. What are some limitations? What do the db_file_sequential_read and db_file_scattered_read events indicate?

How do you return the top-N results of a query in Oracle? Why doesn’t the obvious method work?

Can Oracle’s Data Guard be used on Standard Edition, and if so how? How can you test that the standby database is in sync?

What is a database link? What is the difference between a public and a private database link? What is a fixed user database link?

Explain what are Oracle Catalog and Oracle Archive log?

What is dump destination? What are bdump, cdump and udump? Explain in detail. ?

What are four errors found in an alert (error) log that can ruin a DBA's appetite and how can you avoid them?

What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?

What are the different scenarios for rebuilding indexes... ?

How to convert local management tablespace to dictionary managed tablespace?

As a Oracle DBA what are all the UNIX file you should be familar with? 

When the developer trying to compile the package. But the database gets hanged? What will you check? 

When yesterday developer gives the following command: select count(*) from [table name]it gives the output within minutes, today the same command takes hours? What will you check?

How will you rectify if one of the rollback segments gets corrupted ?

When exporting using filesize parameter, if three files is generated. How the Oracle name this three files? 

When you execute: alter tablespace begin backup; How can Oracle engine can identify that the corresponding datafiles are in backupmode? 

What are the differences between database designing and database modeling? 

In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why? 

How to check to memory gap once the SGA is started in Restricted mode? 

If the SQL * Plus hangs for a long time, what is the reason?

How do you increase the performance of %LIKE operator?

What is mutated trigger?

How to estimate the size of SGA?

What do you do when the server cannot start due to a corrupt master database?

Explain how will you setup Replication Server & sync it?

How to load data into multiple tables at once?

What should you do when you find a stacktrace in the server errorlog?

Is it possible to resize tablespaces and data files? If yes, how?

How does one use the import/export utilities?

What tuning indicators can one use?

Why and how the deadlock situation arises?

Why use materialized view instead of a table?

Difference between 9i OEM & 10G OEM.?

How the data is processed in DB Buffer Cache. ?

What are the changes that happen in Database buffer cache(List of all changes in DB Buffer Cache) ?

Why do you take tablespaces in backup mode.?

What is stored in Oratab file ?

What is OERR Utility ?

How many max datafiles can there be in an Oracle Database. ?

How do you see how many memory segments are acquired by Oracle Instance. ?

How many max datafiles can there be in an Oracle Database.?

How do you control No. of Datafiles one can have in an Oracle Database. ?

How to write script for export backup in shell. ?

What is standby databases? Difference between Physical and logical standby databases ?

Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?

What is simple replication  and advance replication? What is the difference between simple replication and advance replication? How can we do simple replication?

What is Cache Fusion Technology?

What kind of backup  you take Physical / Logical? Which one is better and Why?

What is Oracle Reserved Memory and Unreserved Memory?

How you spend a day as a DBA. Explain DBA activities in detail. ?

While Installing Oracle9i/10g at unix (RedHat) environment , which parameter needs to be set at OS level, to login as a sysdba in Oracle for the first time? 

What is the difference between Cloning and Standby databases?

What are the fixed memory structures inside the SGA?

Is VARCHAR2 size optimization worthwhile ?

How to manager Memory in Oracle Database? How to maximize nos. of user in Oracle Database?

How to find which tablespace belongs to which datafile ?

What is difference between base table and data dictionary views?

Explain about Oracle Statistics parameter in export?

What is directory naming in oracle9i ?

What is the difference between Pctused and PctFree?

What is the difference between local managed tablespace & dictionary managed tablespace ?

Database Auto extend question?

How can the problem be resolved if a SYSDBA, forgets his password for logging into enterprise manager?

How to handle data curreption for ASM type files?

When a database is started, Which file is accessed first?

What is difference between latch,locks and enqueue ?

What is the difference between materialized view and snapshots?

What is RAP?

What is RAC? What is Data Migration? What is Data Pumping?

How to estimate size of database?

What is the difference between .ora and net file or .ora and .net or tnsnames.ora sqlnet.ora listener.ora?

How to Estimate the size of Tablespace???

How to query to know the structure of a single Database and from more than one database.?

Where does the SCN resides (system change number)?

How to know which query is taking long time?

How do sql statement processing oracle database?

What is ORA-1555?

What is the database holding Capacity of Oracle ?

What are the diffrent file types that are supported by SQL*Loader?

How to find how many database reside in Oracle server in query?

How many memory layers are in the shared pool?

Where we use bitmap index ?

What is an extent?

What are the components of physical database structure of Oracle database?

What are the components of logical database structure of Oracle database?

Can you name few DBMS packages and their use?

How can be determine the size of the log files.?

How can be determine the size of the database?

How can you check which user has which Role.?

Can you start a database without SPfile in oracle 9i?

What is Oracle table?

What is an Oracle index?

Can we create index on long raw column?

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

What are clusters?

What is the function of redo log?

What are the characteristics of data files?

What is a temporary segment?

What are the uses of rollback segment?

What process writes from data files to buffer cache?

What is a redo log?

Name init.ora parameters which effects system performance.?

What is a database instance and Explain?

What are the Advantages of Using DBCA?

How do you find wheather the instance was started with pfile or spfile ?

What is an index segment?

What is public database link?

What is rollback segment?

What is a data segment?

What is network database link?

What is private database link?

What are the types of database links?

When can hash cluster used?

What is cluster key?

What is a private synonym?

What is a private synonym?

What are the advantages of views?

What is an Oracle view?

What is SYSTEM tablespace and when is it created?

What is a tablespace?

What is database link?

What is a segment?

What is row chaining?

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

What is a schema?

What does a control file contains?

How to define data block size?

What is hash cluster?

What is index cluster?

What are clusters?

How are the index updates?

What is a public synonym?

What is a synonym?

What is an Oracle sequence?

What is a latch?

What is difference between Logical Standby Database and Physical Standby database?

Waht is the frequency of log Updated?

How do you pin an object?

How do you rename a database?

What is the use of redo log information?

What is the correct sequence among FETCH, EXECUTE, And PARSE?

Which process writes data from data files to database buffer cache?

What are memory structures in Oracle?

What is a datafile?

What is data block?

What are synonyms used for?

What does database do during mounting process?

What is Parallel Server ?

What is a Schema ?

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

What is clusters ?

What is a cluster Key ?

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

What is a deadlock ? Explain ?

What is a deadlock and Explain?