Question 1

What is the use of ANALYZE command?

Accepted Answer

To perform one of these function on an index, table, or cluster: - To collect statistics about object used by the optimizer and store them in the data dictionary - To delete statistics about the object used by object from the data dictionary - To validate the structure of the object - To identify migrated and chained rows off the table or cluster

Question 2

What are the database administrators utilities available?

Accepted Answer

SQL * DBA - This allows DBA to monitor and control an ORACLE database SQL * Loader - It loads data from standard operating system files (Flat files) into ORACLE database tables Export (EXP) and Import (imp) utilities allow you to move existing data in ORACLE format to and from ORACLE database

Question 3

What are the responsibilities of a Database Administrator?

Accepted Answer

- Installing and upgrading the Oracle Server and application tools - Allocating system storage and planning future storage requirements for the database system - Managing primary database structures (tablespaces) - Managing primary objects (table, views, indexes) - Enrolling users and maintaining system security - Ensuring compliance with Oracle license agreement - Controlling and monitoring user access to the database - Monitoring and optimizing the performance of the database - Planning for backup and recovery of database information - Maintain archived data on tape - Backing up and restoring the database - Contacting Oracle Corporation for technical support

Question 4

What is user Account in Oracle database?

Accepted Answer

An user account is not a physical structure in Database but it is having important relationship to the objects in the database and will be having certain privileges 95 When will the data in the snapshot log be used? - We must be able to create a after row trigger on table (ie, it should be not be already available) After giving table privileges We cannot specify snapshot log name because oracle uses the name of the master table in the name of the database objects that support its snapshot log The master table name should be less than or equal to 23 characters (The table name created will be MLOGS_tablename, and trigger name will be TLOGS name)

Question 5

What is the difference between OLE Server & OLE Container?

Accepted Answer

An OLE server application creates ole Objects that are embedded or linked in OLE Containers ex OLE servers are ms_word & ms_excel OLE containers provide a place to store, display and manipulate objects that are created by ole server applications Ex oracle forms is an example of an OLE Container

Question 6

What is relation between the window and canvas views?

Accepted Answer

Canvas views are the back ground objects on which you place the interface items (Text items), check boxes, radio groups etc,) and boilerplate objects (boxes, lines, images etc,) that operators interact with us they run your form Each canvas views displayed in a window

Question 7

What are the built-ins used for finding Object ID function?

Accepted Answer

FIND_GROUP(function) FIND_COLUMN(function)

Question 8

What is WHEN-Database-record trigger?

Accepted Answer

Fires when oracle forms first marks a record as an insert or an update The trigger fires as soon as oracle forms determines through validation that the record should be processed by the next post or commit as an insert or update Generally occurs only when the operators modifies the first item in the record, and after the operator attempts to navigate out of the item

Question 9

In a database table, the category of information is called

Accepted Answer

In a database table, the category of information is called Field.

Question 10

Tell me the importance of a flow chart?

Accepted Answer

The flow chart gives a clear graphical representation of an implemented process This makes the system simple to understand for all persons involved in the project

Question 11

What are the different types of diagrams and what do you know about them?

Accepted Answer

Use case diagram, activity diagram, Collaboration diagram Use case diagram : It describes the business environment Its primary goal is to show the series of events and actions within any given process that will be performed by an actor Activity diagram: The activity diagram is important because it gives an outline of the work flow within the business as well as the activities and action completed For instance with a company, there is likely to be more than one department In such a case each department, will have different access levels to the system So if there’s a Medical, HR and Accounts team they will only have access to screens that relate to each The activity diagram will highlight the differences within the departments which will be very helpful for developers when they are designing and coding Collaboration diagram: A collaboration diagram, also called a communication diagram or interaction diagram, is an illustration of the relationships and interactions among software objects in the Unified Modeling Language (UML) The concept is more than a decade old although it has been refined as modeling paradigms have evolved

Question 12

What documents are used for use cases?

Accepted Answer

There are 2 documents: FRD (functional requirement document) SDD (system design document) which can also be called TRS (Technical requirements specifications)

Question 13

What documents should be delivered by a Business Analyst should deliver?

Accepted Answer

The documents that a business analyst should deliver are functional specification documents, technical specification documents, Requirements traceability, BRD (business requirements document), Use case diagrams and Business flow documents

Question 14

What does a Business Analyst do, what are their responsibilities?

Accepted Answer

The most important responsibilities of a business systems analysts are as a communication conduit between the stakeholders and the team

Question 15

What are some of the common tools that a business Analyst uses?

Accepted Answer

The common tools that can be used by a business analyst are MS Visio, MS word, MS Excel, Power point, Quality center/test director MS Project There may be tools that are client specific also, but these will be supplied the client

Question 16

What is the difference between Business Analyst & System Analyst?

Accepted Answer

The business analyst must understand IT and also has to understand the stakeholder’s needs A systems analyst has the ability to look at a program or utility and see the code They can go in and pinpoint where changes need to be made

Question 17

What does INVEST stand for?

Accepted Answer

INVEST stands for Independent, Negotiable, Value, Estimable, Sized Appropriately and Testable It is a tool designed to assist technical teams and deliver quality products

Question 18

What does FMEA stand for?

Accepted Answer

FMEA is Failure Mode and Effects Analysis It is an analysis used to determine failure modes and how severe they are in a system or process

Question 19

What is Pareto Analysis?

Accepted Answer

Pareto analysis is otherwise known as the 80/20 rule It stipulates that 80%of problems will arise from 20% of causes – that few factors can create big problems

Question 20

What is Kano Analysis?

Accepted Answer

Kano analysis is a systems analysis tool used to identify its impact on customer’s satisfaction based on 3 key areas: unexpected delighters, performance attributes and must have attributes

Technology Questions