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?

Data Analyst

Are programs client dependent?

Name a few system global variables you can use in ABAP programs?

What are internal tables? How do you get the number of lines in an internal table? How to use aspecific number occurs statement?

How do you take care of performance issues in yourABAP programs?

What are datasets?

How to find the return code of a stmt in ABAPprograms?

Have you used SAP supplied programs to load masterdata?

What are logical databases? What are the advantages/disadvantages of logical databases?

What specific statements do you using when writinga drill down report?

What are different tools to report data in SAP?What all have you used?

What are the advantages and disadvantages of ABAPquery tool?

What are the functional areas? User groups? and how does ABAP query work in relation to these?

Is a logical database a requirement/must to writean ABAP query?

What is the structure of a BDC sessions.?

What are Change header/detail tables? Have you used them?

What do you do when the system crashes in the middle of a BDC batch session?

What do you do with errors in BDC batch sessions?

How do you set up background jobs in SAP? What are the steps? What are the event driven batch jobs?

Is it possible to run host command from SAP environment? How do you run?

What kind of financial periods exist in SAP? Whatis the relavent table for that?

What is a currency factoring technique?

How do you document ABAP programs? Do you useprogram documentation menu option?

What are the ABAP commands that link to a layoutset?

What is output determination?

What are IDOCs?

What are screen painter? menu painter? Gui status?

What is screen flow logic? What are the sectionsin it? Explain PAI and PBO.?

What are step loops? How do you program pagedown pageup in step loops?

Is ABAP a GUI language?

Normally how many and what files get created when a transaction program is written? What is the XXXXXTOP program?

What are the include programs?

Can you call a subroutine of one program from another program?

What are user exits? What is involved in writing them? What precations are needed?

What are RFCs? How do you write RFCs on SAP side?

What are the general naming conventions of ABAP programs?

How do you find if a logical database exists for your program requrements?

Crime Analyst

What types of Identity Theft are you?

Credit Analyst

What is the most complicated function in MS?

According to you, which effects will have?

Which specific balance sheet items would you look at to determine a company's credit worthiness?

give you a page of c++ codes, you need to write the output

Just standard accounting questions related to the balance sheet and income statement.

What can you do to increase your value as an analyst?

What are the reporting tools used?

Tell about your experience as a credit analyst?

As a Credit Analyst you will be required to provide quality service to internal customers through undertaking risk assessment analysis of various types of lending proposals. Tell us about your experience working with various lending proposals? Did you create the process?

Provide us with an example of a time as a credit analyst where you analyzed financial information, such as statements, management accounts and cash flow statements? What were some of the complex challenges you faced analyzing financial information?

Have you ever used specialist statistical software in your role as a credit analyst? If so, tell us about models of credit information you have developed to predict patterns and trends using specialist statisticalsoftware?

The credit analyst will be required to liaise with other staff within the company, such as account managers and product specialists? Provide us with an example of a team project you have worked on with various other staff members? What were your responsibilities? How do you build strong rapport with other team members?

What do you do to staying informed about the legal, compliance and market-risk-related issues involved in the approval of credit and other various requirements for acredit analyst?

What metrics would you expect to use to determine the on-going success of your project?

How can we lend cliets money? What should we use for evaluating small, mediem, and big loan size?

can someone with a statistics backbround be credit analyst?

Cost Analyst

Describe some of the methods used to allocate support costs?

What is the difference between Expenses and Expenditure?

Explain some of the methods used to allocate support costs?

Explain the information about cost sheets?

What is CMM?

What is CMMI?

What is chargeback? 

What are fixed costs?

What is the difference between cost accounting and financial accounting?

What is marginal cost?

What are variable costs?

Describe some of the methods used to allocate support costs ?

What is BEP?

Describe some of the methods used to allocate support costs ?

What are fixed costs?

What are variable costs?

What is marginal cost?

What are the freight charges ?

What is CMM?

why is interest on loan not included in cost sheet ?

What does the name costing mean and What are the importance of costing?

What are fixed costs?

What is the cost sheet?

What are the variable costs?

What is BEP in Cost Accounting?

What is meant by Debtors Reconciliation. Explain in detail about it ?

What is meant by Three Way Matching Concept. Which is related to Invoice, Purchase order, Voucher, Vendor ?

What is meant by ERS. Explain in detail about ERS?

What is Control Accounting? What is the use of it?

What is meant by EOQ?

How to calculate Break Even Analysis (BEP)?

Is cost accounting subset of management or is management account subset of cost accounting? Why?

What is margin of safety (MOS)?

What is cost control? What are the duties of a cost controller?

How machine hour rate is calculated?

What are the freight charges ?

What is the meaning Contribution Margin ?

Explain the process of cost reporting ?

What is the difference between cash flow statement and funds flow statement ?

What is the basis of Purchasing?

What is limited liability clause?

What is the difference between cost accounting and management account ?

Explain about real account, personal accounts and nominal accounts?

What`s the difference between Marginal cost and Oppurtunity cost?

What do you mean by Margin of Safety (MOS)?

What is the difference between cash flow statement and funds flow statement?

What is T&E and who files it?

What is back flash costing? Target costing, Just in time costing and Activity based costing?

Explain about variable cost along with few situations where you would use variable cost ?

How to prepare the cash flow statement using the AS-3?

What is the difference between cost accounting and management accounting?

What is authorised share capital?What is paid up share capital?What is contingent liability?

How can one inflate its profits to sHow increased profits for any financial year ending?

What do you mean by LC ?

Describe some of the methods used to allocate support costs?

What is chargeback?

What is the purpose of chargeback?

Have you implemented or administered a chargeback system?

What are fixed costs?

What are variable costs?

What is marginal cost?

What is the difference between Expenses & Expenditure?

Tell us about your experience in cost accounting?

Describe some of the methods used to allocate support costs?

What is charge back?

What is the purpose of charge back?

Have you implemented or administered a charge back system?

Name some components of an effective charge back system?

What are fixed costs?

What are variable costs?

What is marginal cost?

How to make a table for to calculate the prime cost, factory cost, total cost of production and cost of sales?

What is meant by cost accounting?

why is interest on loan not included in cost sheet?

What does the name costing mean and What are the importance of costing?

What is BEP? BEP-Break Event Point. It indicates no Loss and no Profit?

Describe some of the methods used to allocate support costs?

What is charge back?

What are fixed costs?

What is marginal cost?

Explain fixed cost, variable cost and marginal cost?

What is Break Even Point? What does it signify?

What is the purpose of charge back?

What is MIS report and do you prepare it?

What is CST ?

What is the Difference Between Sales Tax and VAT ?

What is the Difference Between Income Tax and TDS ?

Why we Deduct TDS ?

What is Statory Books ?

What is the Difference Between Income Tax and TDS ?

What is LIFO and FIFO ?

What is the Basics of Bank Reconcialiation ?

What is Double Entry System ?

How many types of Methods of Depreciation Calculation ?

What is Depreciation ?

What are the variable costs?

What is the cost sheet?

What is the Meaning of Value Date in Bank Statement ?

What is taxation ?

What is cash profit

What is the fullform of WCT?

What is meaning of MAT?

What is FBT & where it is used?

What is GST and How it work?

What is amortization?

What is Journal Entry for Booking & paid Telephone Expenses?

What is difference between depriciation and depriciation reserve ?

What is the meaning of Contingent Liability?

How to calculate operating and financial leverages?

What is market capitalisation?

What is absorbtion costing?

What is contigent liabilities?

What is buy bach shares?

Explain the information about cost sheets?

What is CMMI?

What is chargeback?

What are fixed costs?

What is the difference between cost accounting and financial accounting?

Explain cost sheet?

What is marginal cost?

What are variable costs?

Describe some of the methods used to allocate support costs?

What is BEP?

Consultant Analyst

What are the skills required for the post of Consultant analyst?

What is Model-View-Controller?

What is SWOT Analysis?

We have met several candidates. Why are you the one we should hire?

What are various types of testing methodologies used in developing an application?

case study on a production facility

Describe a time when you had to be flexible

Computer Programmer Analyst

Mutable object and Synchronized key words

Diff between Outer and inner classes

Computer Network Analyst

About the bts installations & monitoring in telecom

what s difference between GSM & BSM

How hash function works in router?

What are digital signatures and smart cards?

What are digital signatures and smart cards?

What does CIA stand for in security management?

What is classful and classless routing ? Difference between RIPv1 & RIPv2 ? What is multic...

Is it possible to connect two private networks through Internet using VPN concentrator?

what is the difference between router ACLs and Firewall ACLs?

How do you use RSA for both authentication and secrecy?

What are the different types of network security?

how to provide ip address permanent by using DHCP Server?

Write the purpose of vnp and name the vnp technology supported by windows 2000.

What is the difference between BOOTP and RARP?

Difference between discretionary access control and mandatory access control?

What is the role of Single Sign On in authentication technologies?

What is the connection between socket and session?

What is ARP and how does it work?

what is dora process in DHCP and how it works?

how to restore flash memory of cisco 2600 series router if IOS is currupt ?

what are the different encryption types and tools available.

Difference between routing protocol and routed protocol?

Basis for OSPF protocol?

Explain Kerberos Protocol ?

What is the difference between IARP and RARP?

What is meant by port blocking within LAN ?

Can traceout command work across the firewall? If No then why? If Yes then why?

Why are proxy servers useful?

What is IDS or IDP, and can you give me an example of one?

What is a log host?

What is DNS Hijacking?

What would you do if you discovered a Windows system on your network has been comrpromised...

What would you do if you discovered a UNIX or Network device on your network has been comp...

What is SSL? How do you create certificates?

What is SSH?

What is GPG/PGP?

What is a SYN Flood?

What is a “spoofed” packet?

What is a Denial of Service attack?

Describe, genrally, how to manage a firewall

What is a firewall?

How many memory layers are in the shared pool?

Compliance Analyst

what are methodologies/processes used.?

Compensation Analyst

What is the probability of breaking a stick

How many resumes does Google receive each

What is the yearly standard deviation of

Commission Analyst

How would you go about prioritizing your job?

Commercial Credit Analyst

what is a lognormal random variable times a lognormal random variable?

What is the specific balance sheet items to determine a company's credit worthiness?

CIA Analyst

Where the methodology of Intelligence agency is applicable?

What do you mean by Direct Information?

What do you mean by Indirect Information?

What do you mean by Direct Data?

What do you mean by Indirect Data?

What do you mean by the Linchpin Analysis?

Chemical Analyst

What is Unit Process  and Unit Operations? How they are different from one another?

What is the important properties of biodegradable plastics?

How does Chromium  improve property of Steel when added as an alloy element?

When salt is added to water, what happens to its freezing point? 

What is the density of water at 0C?

What is the life time of FRP tank? Explain about it specifications & other details? 

Why 'S' sub-shell has a spherical structure?

Why Iron Carbide diagram can be established upto 6.67% only?

What is the solid angle?

Explain What is Wilson Equation?

How does actual Capillary Action takes place?

What is Pointage in Chemistry?

explain me what is floudas in detail?

Difference between Distillation and Fractionation?

Why we use Flairing in the crude oil refining industry?

What is proplan, prodyne?

What is the difference between unit operation and unit process?

What is physical significance of chemical potential & fugacity?

Chartered Financial Analyst

When should a firm be shut down?

What constitutes insider trading and why is it wrong?

What are the principles of accounts? What does dy/dx mean? What is a point of influx?

What is capital account convertibility?

What are 'double entry accounts'? Give a definition that your grandmother would understand?

What is 'single entry' ?

Explain the entry for unpaid/accrued interest. Where is the double entry?

What are the principles of costing? If I had a factory and wanted to undertake a costing exercise, how would I go about it?

What is break-even analysis?

Give examples of fixed, variable and semi-variable costs?

What is net present value?

What is internal rate of return?

What is sunk cost?

What is the difference between accounts and finance?

What is working capital ratio? Acid test ratio? Proprietary ratio? What is the ideal acid test ratio?

Is a bank loan a current liability ?

What are the things you would look for in a balance sheet if you are analysing the performance of a company?

What is the difference between owned and borrowed capital? For a company with a long gestation period, which kind is better?

What is capital gearing ratio?

What is costing?

What is marginal costing? What are its applications?

After an asset has been fully depreciated, how should its cost be allocated to the product?

Draw the various cost curves. Is the fixed cost curve always downward sloping?

What is the difference between preference shares and equity shares?

What is working capital?

What are direct and indirect taxes? When was excise started?

What is a presumptive tax ?

What is discounted cash flow? How is it used? Why is depreciation not deducted from profit after tax for the purposes of discounting?

What is transfer pricing?

What is SLR ? CRR ? What is the difference between the two?

What are the other ways to raise funds from public other than shares and debentures?

What is a brand? Do you think you can have brands in the service sector? Name three product categories which have better sales in the rural areas than the urban areas.

What do you understand by ‘Value for Money’? What is India’s  BOP figure for the last quarter?

What is Gold Bond Scheme? Why was it introduced?

What is MODVAT? Professional tax? Corporation tax?

Differentiate between excise and customs duty?

What is to be done to improve the BOP situation?

What is the difference between growth and development?

Where does India figure in world trade?

What is the difference between IMF and the Word Bank? Name some projects that the World Bank has taken up in India?

Which is the largest company in the world? In India? Which do you think is a better index of measuring size  profits,  sales, assets?

Difference between cash and funds. Break even point definition and plotting.

What does a chartered accountant do?

What is meant by legal entity of a company? Can a shareholder be an employee/creditor of a company?

What is the maximum number of companies a chartered accountant can audit? In a CA firm, if there are 20 partners, how many companies can be audited?

What is full convertibility? Who will gain from it? Exporters or importers?

What is the difference between finance and accounts, shares and debentures?

What does the ISI mark stand for?

What is rupee convertibility?

What is black money? Who has worked on it?

What are transfer earnings?

What do you mean by trade account?

What is the effect of depreciation on the balance sheet and a P & L a/c (cash flow)? What is working capital? How do you control the flow of stocks?

Different tools used in capital budgeting. Which is the best? When can IRR and NPV methods contradict? What is a cash flow? What is NPV, IRR? Can there be more than one IRR ?

Differentiate between fiscal, revenue and budgetary deficits?

What do you mean by double entry accounts? How does it differ from single entry? What is a balance sheet? How is it related to a P&L a/c? What is an accrued expenditure?

What is Break-even analysis? Explain as if I were a layman by drawing a graph.

What is the MRTP Act? How do you define monopolistic trade practices and restrictive trade practices?

Draw the demand curve for petroleum products considering that their demand has been continuously growing inspite of a high rate of rise in their prices.

When will deficits not be harmful (budget deficits, fiscal deficits)?

What is budget deficit? How is deficit met? Is budget deficit a boon or curse for commerce?

What is annuity? When is present value more than future value?

What are the various items of information required for calculation under the net present value method of capital budgeting?

How do economic theories help in creating value in real world?

Define economics of scale?

Define economics of scope?

Make a break-even point diagram?

What is GDP of India?

Give the equation of straight curve?

What is Linear programming?

How will economics help in becoming a good manager?

Derive the consumer's demand curve from his preferences?

DIfferentiate between Normal goods and Giffin' goods?

What subjects do you have in 3rd year economics?

Discuss the theory of money?

What are determinants of money multiplier?

What is elasticity of demand? What is marginal utility?

How will you link call money rates and exchange rates?

Compare monetary and fiscal policy. How are they related?

What does RBI do?

What is shadow pricing?

Draw the Hicks-Allen price-substitution effect?

How is the interest rate determined in a free market?

What is opportunity cost?

What is the parallel economy?

What is classical economics?

What do you think went wrong with the Mahalanobis strategy of planning?

What is Giffen's Paradox?

What is perfect competition? How is price determined under perfect competition?

Explain the accounts payable cycle?

What is the difference between the accrual accounting and cash accounting?

What is the distinction between cost accounting and management accounting?

What is the difference between financial accounting and management accounting?

Call Center Analyst

What is the difference between BPO and CALL CENTRE ?

What is B.P.O ?

What is Call Center ?

What is Inbound and Outbound ?

What is CDMA?

What is Smart Work and Hard Work ?

What is a Customer service ?

What is the abbreviation of WNS?

Business System Analyst

What is compression?

What is a business system? How will you implement it?

What is the most important thing about business system?

What is information system?

How many types of information system are there?

Business Intelligence Analyst

What are the various modules in Business Objects product?

What is OLAP, MOLAP, ROLAP, DOLAP, HOLAP? Examples?

How do u determine or evaluate success? In what ways you think you can contribute to our organisation? Why should we hire you over the others waiting to be interviewed?

Define the Non-Voice Accounting Process and Semi-Voice Non-accounting process in BPO?

Why an infocube has maximum of 16 dimensions?

Why we can't create an aggregate on an ODS Object?

Is the increase in CRR rate a good sign for Indan economy and why?

What is Hyperion? Is it an OLAP tool? what is the difference between OLAP and ETL tools? What is the future for OLAP and ETL market for the next five years?

What is Business Intelligence?

What is a Universe?

What is OLAP?

How do you define multiple queries in a document?

How open document syntax works?

How do we Tune the BO Reports for Performance Improvement?

What is BAS? What is the function ?

Name some of the standard Business Intelligence tools?

How do we enhance the functionality of the reports in BO?

What is one major characteristic or skill that you possess which you believe will complement our current management team?

What are dashboards?

Can anyone explain about Auditing in BO XI R2?What is the use of it??

How to Import universes and user from business object 6.5 to XI R2, it is showing as some ODBC error is there any setting to change?

How do we Tune the BO Reports for Performance Improvement?

What is hierarchy relationship in a dimension. whether it is: 1. 1:1 2. 1:m 3. m:m?

How to connect GDE to Co>Operating system in Abinitio?

What is Business Intelligence?

Name some of the standard Business Intelligence tools in the market?

What are the various modules in Business Objects product Suite?

How to develop our business category?

Business analyst

What is Sharepoint and How does BA work with sharepoint?

How do you handle a requirement that is not feasible?

What are the tools used by the Business Analyst for Requirement gathering and fitment studies?

How will You determine a good Document?

How is R U P used to analyse a process?

Explain What is Interface / Integration mapping?

How would you use Requirements Modeling and when? 

What approaches do you need when 2 companies merge?

How did you assign task and/or hold testers accountable for their work?

What type of push back have your received from the business users in relation to QA?

When does a BA use Test Director tool and for what purpose in a project? 

What does a BA do when DEV Team recommends a better solution in the application?

What are HIGH/MED/LOW Use Cases?

Which phase of the project does a BA complete preparing all USE CASES?

What role does a BA play in the End User Support?

How does a BA validate all the requirements?

How to calculate the perfomance date on portfolio?

What are the artifacts that you create?

How do you make sure the requirements are tested and work fine? 

How do you document the requirments?

What should be the approach to resolve conflicts during JAD Sessions?

Explain How do you use Traceability Matrix when using the Unified Process?

How do you go about working in an area with which you have not worked before?

What are components of UML

How do you create Use Case

How to handle end user if he is very much opposed to change in the process??

What are the characteristics of a hands-on BSA?

What analysis and modeling techniques do you use to translate business objectives into system requirement?

Explain how RUP is used and its different from Agile?

How to differentiate a Agile diagram and RUP diagram?

What types of requirements should not be documented in use cases?

What are the list of documents that a Business Analyst needs to maintain?

What Business System Concept is?

How do you estimate timeline for a BRD/usecase/SRS?

What is the difference between BRD, SRS and Use Case documents?

What is the difference between Agile and Unified Process methodology?

How do you use traceability matrix when using Unified process?

How do you manage risk for a project?

What types of questions do you ask when gathering data for requirements?

How would you handle a scenario when requirements change midway in the project?

How do you ensure that you have focused on all the necessary details of a task?

What is the difference between analysis model and design model?

How do you come up with non-functional requirement?

What is control, boundary and entity class? how does a business analyst use it in a project?

What step would you follow to come up with a sequence diagram for a particular scenario?

How do a business analyst contributes in doing control flow in a project?

How do you follow business rules in a project while working on a project?

What would you do if the client says that you and the other analysts cannot directly talk to the users?

What is the relationship between use case and test case?

Where would you document Functional and Non Functional Requirements (i.e. deliverable)?

How is business plan evaluated?

What is UML?

How is requirement analysis done by business analyst?

What are the professional certifications a business analyst must possess?

What are the quality procedures followed normally by a business analyst?

What are the industry and professional standards followed by business analyst?

Budget analyst

How do I find out about funding for Federal agencies?  How do I start to research their budgets?

What are the Types of dollars and what they mean - outlays, authority, constant, real, and actual?

What is the Federal budget for every year?

What is the Federal budget deficit this year?
a
How do I find historical information about the budget?

Where can I find out about what makes up the government's income?

Where can I find information on Social Security?

How Much Money is Spent on Foreign Aid?   Who gets the most?

How Much is Grants Funding for the National Endowment for the Arts?

What is the income distribution of those who pay taxes?

What is the money in the budget used for?  What is the tax per person?

Where can I find information about OMB's guidance to agencies?

Is there a difference between the way the Department of Defense (DOD) prepares its budget and the process you outline?

How does a CR affect hiring?

How does a CR affect contract awards?

What should we use the surplus for?

What are the informal parts of the budget process?

How do I find out about outsourcing?

What is franchising?  What are Fee-for-Service Operations?  Working capital funds?

Why is Budgeting so controversial and confrontational?

How do you treat annual leave accruals in the accounts of an agency?

Where can I find definitions of economics terms?

How do you budget for banks?

BSA Analyst

Explain equivalence class?

What have you done to decompose functional requirements to bring to the testing teams?

What are the reporting tools used by BA?

What are the various forms of security implemented at hardware software?

Explain what is Business Procedure How it is different from Business requirement?

What is high level use case?

What should be the approach to resolve conflicts during JAD Sessions?

What does a BA do when DEV Team recommends a better solution in the application?

What are components of UML?

How is R U P used to analyse a process?

What are the primary steps to create use cases?

Which phase of the project does a BA complete preparing all USE CASES?

How do you estimate timeline for a BRDusecaseSRS?

What are HIGHMEDLOW Use Cases?

Explain What is Interface  Integration mapping?

What approaches do you need when 2 companies merge?

What is the difference between Agile and Unified Process methodology?

How to calculate the perfomance date on portfolio?

What are the characteristics of a hands-on BSA?

What is the relationship between use case and test case?

When does a BA use Test Director tool and for what purpose in a project?

What are the challenges faced by BA in Credit Risk projects?

Mention some of the tools commonly used by business analyst?

How do you decide that which reports you have to extract or on what basis you extract the report?

What is the difference between analysis model and design model?

What is Data Modeling?

What is the difference between BRD SRS and Use Case documents?

Explain How do you use Traceability Matrix when using the Unified Process?

What are the fields or the data when you extract in a report?

Bioinformatics Analyst

How to identify highly mutated aminoacid from clustalw?

what is an active ?

Can isolation of DNA done with perfection?

How is the respiratory system applied to the sport paintball?

What are the responsible factors for extinction of flora and fauna ?

what is e value?

what is the length of the exon and intron?

which instrument is most commonly used to observe the external features of grasshopper's abdomen?

How you caluculate sensitivity and selectivity of Blast?

What is the main idea of maximum parsimony in phylogenetic tree construction?

What are the drawbacks?

What are the main approaches of predicting protein interactions using genomic context analysis?

What are the main signals used for gene finding in prokaryotic genomes?

How are these signals introduced into the search algorithms?

How to run DOCK 6 using cygwin?

Explain Homology modelling?

Derive e-value ?

How to find coexpressed genes on NCBI GEO?

Explain microarray data clustering ?

How to caculate coordinates of each atoms on 3 D HP model?

What is C-compliator?

How to assign alpha helix & beta sheets?

How to find patterns in noisy data?

Define perl and clustalW problem?

What is the most abundant element in the universe ?

How many bonds are present in CO2 molecule?

What is the most abundant element in the universe ?

How many bonds are present in CO2 molecule?

What is the idea behind weighting?

sequences in the package CLUSTAL W for multiple alignment?How are these weights calculated?

What two possibilities are there to describe how gene fragments may have evolved?

What is the difference in terms of connectivity between a scale free network and random network?

What does the ultrametric property of a tree tell us about the evolutionary process?

Explain about needleman-wunsch algorithm?

What is the input and outpit of a distance based algorithm?

What are the main differences between parsimony,distance and likelihood-based algorithms?

How the Algorithm works?

What is the aim of Blast software?

How a cluster algorithm works?

Describe the aim of microarray data analysis?

What is a homologue?

What is a scoring matrix?

What is an alignment?

What is a DNA array?

How to predict the structure of a sequence?

How to predict the function of a gene (product)?

How to align two sequences?

How to find a sequence of dna molecule?

How do ESTs work?

What is enzyme-ligand interaction?

What is PPAR gamma pathway?

What is the Sequence for cd44v6?

How to identify common acc.numbers from among a set of files ?

What is chimera check ?

How to find flanking region ?

What is the criteria for LTQ (LC-MS/MS) SEQUEST search?

What is Far Western Screening ?

What is the Equation for cell diffusion?

What is the difference between SE(Standard Error) and SEM (Standard Error of Mean) ?

What are oesophageal molecular markers?

How many base pairs does the simplest bacteria have?

What is the secondary structure of intron ?

How to Count number of nucleotide substitutions ?

How to Draw a 3D structure of a Protein from its amino acid sequece?

What is Phantom Gene Sequence?

How to Insert Genomic DNA into yeast ?

Define COG and KOG ?

Can DeCypher be used for protein struc-ture modeling?

What are the advantages of molecular cloning tools?

Define toxicogenomics?

what is Glycomics?

when is a Genome project finished?

what is QSAR (quantitative structure-activity relationship?

what is the use of Morphometrics?

Explain the Protein expression analysis?

what is Gene expression analysis?

what is Genome annotation?

Why use PatternHunter instead of Blast?

Exactly how fast is PatternHunter when comparing two DNA sequences?

What is the largest DNA sequence comparison achieved on PatternHunter?

How to compare a DNA sequence to itself by using it for both the 1st and 2nd sequence?

How do you find repeats within one DNA sequence?

How to compare two DNA sequences?

Why was the PatternHunter software program developed?

What is PatternHunter?

What is Pharmacogenetics?

What is Proteomics?

What is Mathematical Biology?

What is Cheminformatics?

How many grams of NaOH will react with 0.2 equivalent of HCl?

How long will a train 100m long traveling at 72kmph take to overtake another train 200m long traveling at 54kmph?

what is the Reaction intermediate in Reimer-Tiemann?
s reaction?

How many bonds are present in CO2 molecule?

what is the image of point (3,8) in the line x + 3y = 7 ?

What are the current challenges in the Pharmaceutical and biotechnology sectors?

What is an ontology?

What is Medical Informatics?

What is Pharmacogenomics?

What is bioinformatics?

what is a Homologue?

How can you have an accession number?

What is a clean and run reaction?

How much template do you need for sequencing?

How do you customise database for blast?

How do you find the most recent human sequence data in the data bases inorder to determine physical maps?

what is a qi number?

what is FASTA format?

How would you value a biotech company as opposed to a consumer products company?

what is the principle involved in Biometry?

Billing Analyst

What is the difference between Supply Chain & Logistics?

What is bifferences between core banking and cooperative banking?

What is iso 9001?

What is your biggest strength ?

Define marketing in your words except book definition ?

How does Regulatory Compliance and Right to Information Act help in the growth of Business Intelligence in India ?

What is the impact of us recession in india in regard to different sectors?

Is challan billing allowed in inter state transfer of goods between two companies?

What is the difference between SAP and other ERP products?

What do you mean by the Demographics of Medical Billing?

Banking Analyst

What is Model-View-Controller?

What do you mean by Use- Case Models and Class Model?

Bank Analyst

Expected value of a 6 sided die?

What metrics do you look at when valuing a company?

What can you infer from the following - Walmart has an average accounts payable turnover rate of 90 days?" Answer: they are using trade credit to finance their operations, and thus, given their likely short average accounts receivable turnover, Walmart should be flush with cash

Why Banking?

DCF based question

If depreciation is understated by 100, how does that change the three financial statements?

Should a company offer debt or equity?

What's 28 x 14?

What do you like about Wells Fargo?

Last deals the firm have being involved in?

What would you do on a random Saturday?

Describe a time when you received a constructive feedback. How did you react to that ?

Could you walk me through the cash flows statement? What are some items that would be found under each heading?

What is an example of a market multiple?

Why IB ?

What do you think about current MAs ?

How would you explain the causes of the recent economic crisis to a layman?

Are you conscious of the real challenge that UBS is facing at that time? We will all have to work very hard, are you ready for this?

Why IBD? and what about the life you will have

Why Little Rock

What is 7^4 (no paper just mental math)

What is the probability that two people in NYC have exactly the same number of hairs on their head

There weren't really any difficult/surprise questions. When asked what the major valuation methods were, they pushed me further on how to perform a dcf

If there were to be a biography written about you, what would the title be?

Describe a merger between Sears and KMart?

How are the three main financial statements related?