Oracle placement paper 3

ORACLE Job Placement Paper

Paper Type : General - other

1. Tech + Aptitude written
2. Programming written ( main theme is to test our data structure knowledge, proficiency
sorting searching algorithms will clear this round )
3. Technical interview
4. Puzzle solving

Friends if u clear all this four rounds u are ready for ORACLE.

SQL AND SQL*Plus

Which of the following statements contains an error?
a.. SELECT * FROM emp WHERE empid = 493945;
b. SELECT empid FROM emp WHERE empid= 493945;
c. SELECT empid FROM emp;
d. SELECT empid WHERE empid = 56949 AND lastname = 'SMITH';

Which of the following correctly describes how to specify a column alias?
a. Place the alias at the beginning of the statement to describe the table.
b. Place the alias after each column, separated by white space, to describe the column.
c. Place the alias after each column, separated by a comma, to describe the column.
d. Place the alias at the end of the statement to describe the table.

The NVL function
a. Assists in the distribution of output across multiple columns.
b. Allows the user to specify alternate output for non-null column values.
c. Allows the user to specify alternate output for null column values.
d Nullifies the value of the column output

Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR,is shown below.Which of the following SQL statements produced it?
PLAY_TABLE
"Midsummer Night's Dream", SHAKESPEARE
"Waiting For Godot", BECKETT
"The Glass Menagerie", WILLIAMS

a SELECT play_name || author FROM plays;
b SELECT play_name, author FROM plays;
c SELECT play_name||', ' || author FROM plays;

d SELECT play_name||', ' || author PLAY_TABLE FROM plays;

Issuing the DEFINE_EDITOR="emacs" will produce which outcome?
a. The emacs editor will become the SQL*Plus default text editor.
b. The emacs editor will start running immediately.
c. The emacs editor will no longer be used by SQL*Plus as the default text editor.
d. The emacs editor will be deleted from the system.

The user issues the following statement. What will be displayed if the EMPID selected is 60494? SELECT DECODE(empid,38475, "Terminated",60494, "LOA", "ACTIVE")FROM emp;
a. 60494
b. LOA
c. Terminatedd. ACTIVE

SELECT (TO_CHAR(NVL(SQRT(59483), "INVALID")) FROM DUAL is a valid SQL statement.
a. TRUE
b. FALSE

The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is
a. EMP
b. The table containing the column values
c. DUALD. An Oracle-defined table

Which of the following is not a group function?
a. avg( )
c. sqrt( )
c. sum( )
d. max( )

Once defined, how long will a variable remain so in SQL*Plus?
a. Until the database is shut down
b. Until the instance is shut down
c. Until the statement completes
d. Until the session completes

The default character for specifying runtime variables in SELECT statements is
a. Ampersand
b. Ellipses
c. Quotation marks
d. Asterisk

A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?
a. select e.empid, d.head from emp e, dept d;
b. Select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;
c. Select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);
d. Select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * fromMASTER.ANIMALS; What is the effect of this statement?
a. A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU
b. A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER
c. A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
d. A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.

User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID,LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?
a. INSERT INTO employee VALUES (59694,'HARRIS', NULL);
b. INSERT INTO employee VALUES (59694,'HARRIS');
c. INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,'HARRIS');
d. INSERT INTO employee (SELECT 59694 FROM 'HARRIS');

Which three of the following are valid database datatypes in Oracle? (Choose three.)
a. CHAR
b. VARCHAR2
c. BOOLEAN
d. NUMBER

Omitting the WHERE clause from a DELETE statement has which of the following effects?
a. The delete statement will fail because there are no records to delete.
b. The delete statement will prompt the user to enter criteria for the deletion
c. The delete statement will fail because of syntax error.
d. The delete statement will remove all records from the table.

Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.
a. TRUE
b. FALSE

Dropping a table has which of the following effects on a nonunique index created for the table?
a. No effect.
b. The index will be dropped.
c. The index will be rendered invalid.
d. The index will contain NULL values.

To increase the number of nullable columns for a table,
a. Use the alter table statement.
b. Ensure that all column values are NULL for all rows.
c. First increase the size of adjacent column datatypes, then add the column.
d. Add the column, populate the column, then add the NOT NULL constraint.

Which line of the following statement will produce an error?
a. CREATE TABLE goods
b. (good_no NUMBER,
c. good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),
d. CONSTRAINT pk_goods_01
e. PRIMARY KEY (goodno));
f. There are no errors in this statement.

MAXVALUE is a valid parameter for sequence creation.
a. TRUE
b. FALSE

Which of the following lines in the SELECT statement below contain an error?
a SELECT DECODE(empid, 58385, "INACTIVE", "ACTIVE") empid
b. FROM emp
c. WHERE SUBSTR(lastname,1,1) > TO_NUMBER('S')
d. AND empid > 02000
e. ORDER BY empid DESC, lastname ASC;
f. There are no errors in this statement.

Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?
a. SQRT
b. DECODE
c. NEW_TIME
d. ROWIDTOCHAR

Which two of the following orders are used in ORDER BY clauses? (choose two)
a. ABS
b. ASC
c. DESC
d. DISC

You query the database with this command SELECT name FROM employee WHERE name LIKE ‘_a%’; Which names are displayed?
a. Names starting with “a”
b. Names starting with “a” or “A”
c. Names containing “a” as second character
d. Names containing “a” as any letter except the firs

PL/SQL

Which of the following statements is true about implicit cursors?
a. Implicit cursors are used for SQL statements that are not named.
b. Developers should use implicit cursors with great care.
c. Implicit cursors are used in cursor for loops to handle data processing.
d. Implicit cursors are no longer a feature in Oracle.

Which of the following is not a feature of a cursor FOR loop?
a. Record type declaration.
b. Opening and parsing of SQL statements.
c. Fetches records from cursor.
d. Requires exit condition to be defined.

A developer would like to use referential datatype declaration on a variable. The variable name is EMPLOYEE_LASTNAME, and the corresponding table and column is EMPLOYEE, and LNAME, respectively. How would the developer define this variable using referential datatypes?
a. Use employee.lname%type.
b. Use employee.lname%rowtype.
c. Look up datatype for EMPLOYEE column on LASTNAME table and use that.
d. Declare it to be type LONG.

Which three of the following are implicit cursor attributes?
a. %found
b. %too_many_rows
c. %notfound
d. %rowcount
e. %rowtype

If left out, which of the following would cause an infinite loop to occur in a simple loop?
a. LOOP
b. END LOOP
c. IF-THEN
d. EXIT

Which line in the following statement will produce an error?
a. cursor action_cursor is
b. select name, rate, action
c. into action_record
d. from action_table;
e. There are no errors in this statement.

The command used to open a CURSOR FOR loop is
a. open
b. fetch
c. parse
d. None, cursor for loops handle cursor opening implicitly

What happens when rows are found using a FETCH statement
a. It causes the cursor to close
b. It causes the cursor to open
c. It loads the current row values into variables
d. It creates the variables to hold the current row values

CREATE OR REPLACE PROCEDURE find_cpt (v_movie_id {ArgumentMode}NUMBER, v_cost_per_ticket {argument mode} NUMBER)IS
BEGIN
IF v_cost_per_ticket > 8.5 THEN
SELECT cost_per_ticket
INTO v_cost_per_ticket
FROM gross_receipt
WHERE movie_id = v_movie_id;
END IF;
END;
Which mode should be used for V_COST_PER_TICKET?
a. IN
b. OUT
c. RETURN
d. IN OUT

CREATE OR REPLACE TRIGGER update_show_gross {trigger information}
BEGIN
{additional code}
END;
The trigger code should only execute when the column, COST_PER_TICKET, is greater than $3.75. Which trigger information will you add?
a. WHEN (new.cost_per_ticket > 3.75)
b. WHEN (:new.cost_per_ticket > 3.75
c. WHERE (new.cost_per_ticket > 3.75)
d. WHERE (:new.cost_per_ticket > 3.75)

What is the maximum number of handlers processed before the PL/SQL block is exited when an
exception occurs?
a. Only one
b. All that apply
c. All referenced
d. None

For which trigger timing can you reference the NEW and OLD qualifiers?
a. Statement and Row
b. Statement only
c. Row only
d. Oracle Forms trigger

CREATE OR REPLACE FUNCTION get_budget(v_studio_id IN NUMBER) RETURN number
ISv_yearly_budget NUMBER;
BEGIN
SELECT yearly_budget
INTO v_yearly_budget
FROM studio
WHERE id = v_studio_id;
RETURN v_yearly_budget;
END;
Which set of statements will successfully invoke this function within SQL*Plus?
a VARIABLE g_yearly_budget NUMBER EXECUTE g_yearly_budget := GET_BUDGET(11);
b. VARIABLE g_yearly_budget NUMBER EXECUTE :g_yearly_budget := GET_BUDGET(11);
c. VARIABLE :g_yearly_budget NUMBER EXECUTE :g_yearly_budget := GET_BUDGET(11);
d. VARIABLE g_yearly_budget NUMBER :g_yearly_budget := GET_BUDGET(11);

CREATE OR REPLACE PROCEDURE update_theater (v_name IN VARCHAR2, v_theater_id IN NUMBER) IS
BEGIN
UPDATE theater
SET name = v_name
WHERE id = v_theater_id;
END update_theater;
When invoking this procedure, you encounter the error: ORA-00001: Unique constraint (SCOTT.THEATER_NAME_UK) violated.How should you modify the function to handle this error?
a. An user defined exception must be declared and associated with the error code and handled in the EXCEPTION
section.
b. Handle the error in EXCEPTION section by referencing the error code directly.
c. Handle the error in the EXCEPTION section by referencing the UNIQUE_ERROR predefined exception.
d. Check for success by checking the value of SQL%FOUND immediately after the UPDAT statement.

CREATE OR REPLACE PROCEDURE calculate_budget IS v_budget studio.yearly_budget%TYPE;
BEGIN
v_budget := get_budget(11);
IF v_budget < 30000000 THEN
set_budget(11,30000000);
END IF;
END;
You are about to add an argument to CALCULATE_BUDGET. What effect will this have?
a. The GET_BUDGET function will be marked invalid and must be recompiled before the next execution.
b. The SET_BUDGET function will be marked invalid and must be recompiled before the next execution.
c. Only the CALCULATE_BUDGET procedure needs to be recompiled.
d. All three procedures are marked invalid and must be recompiled.

Which procedure can be used to create a customized error message?
a. RAISE_ERROR
b. SQLERRM
c. RAISE_APPLICATION_ERROR
d. RAISE_SERVER_ERROR

The CHECK_THEATER trigger of the THEATER table has been disabled. Which command can yo issue to enable this trigger?
a. ALTER TRIGGER check_theater ENABLE;
b. ENABLE TRIGGER check_theater;
c. ALTER TABLE check_theater ENABLE check_theater;
d. ENABLE check_theater;

Examine this database trigger CREATE OR REPLACE TRIGGER prevent_gross_modification {additional trigger information}
BEGIN
IF TO_CHAR(sysdate,’DY’) = ‘MON’ THEN
RAISE_APPLICATION_ERROR(-20000,’Gross receipts cannot be ‘ || ‘deleted on Monday’);
END IF;
END; This trigger must fire before each DELETE of the GROSS_RECEIPT table. It should fire only once for the entire
DELETE statement. What additional information must you add?
a. BEFORE DELETE ON gross_receipt
b. AFTER DELETE ON gross_receipt
c. BEFORE (gross_receipt DELETE)
d. FOR EACH ROW DELETED FROM gross_receipt

Examine this function CREATE OR REPLACE FUNCTION set_budget (v_studio_id IN NUMBER,
v_new_budget IN NUMBER) IS
BEGIN
UPDATE studio
SET yearly_budget = v_new_budget
WHERE id = v_studio_id;
IF SQL%FOUND THEN
RETURN TRUEl;
ELSE
RETURN FALSE;
END IF;
COMMIT;
END;
Which code must be added to successfully compile this function?
a. Add “RETURN;” right before the “IS” keyword.
b. Add “RETURN number” right before the “IS” keyword.
c. Add “RETURN boolean” right after the “IS” keyword.
d. Add “RETURN boolean” right before the “IS” keyword.

Under which circumstance must you recompile the package body after recompiling the package specification?
a. Altering the argument list of one of the package constructs
b. Any change made to one of the package constructs
c. Any SQL statement change made to one of the package constructs
d. Removing a local variable from the DECLARE section of one of the package constructs

Procedure and Functions are explicitly executed. This is different from a database trigger. When is
a database trigger executed?
a. When the transaction is committed
b. During the data manipulation statement
c. When an Oracle supplied package references the trigger
d. During a data manipulation statement and when the transaction is committed

Which Oracle supplied package can you use to output values and messages from database triggers, stored procedures and functions within SQL*Plus?
a. DBMS_DISPLAY
b. DBMS_OUTPUT
c. DBMS_LIST
d. DBMS_DESCRIBE

What occurs if a procedure or function terminates with failure without being handled?
a. Any DML statements issued by the construct are still pending and can be committed or rolled back.
b. Any DML statements issued by the construct are committed
c. Unless a GOTO statement is used to continue processing within the BEGIN section, the construct terminates. The
construct rolls back any DML statements issued and returns the unhandled exception to the calling environment.

Examine this code
BEGIN
theater_pck.v_total_seats_sold_overall := theater_pck.get_total_for_year;
END;
For this code to be successful, what must be true?
a. Both the V_TOTAL_SEATS_SOLD_OVERALL variable and the GET_TOTAL_FOR_YEAR function must exist only in the body
of the THEATER_PCK package.
b. Only the GET_TOTAL_FOR_YEAR variable must exist in the specification of the THEATER_PCK package.
c. Only the V_TOTAL_SEATS_SOLD_OVERALL variable must exist in the specification of the THEATER_PCK package.
d. Both the V_TOTAL_SEATS_SOLD_OVERALL variable and the GET_TOTAL_FOR_YEAR function must exist in the specification of the THEATER_PCK package.

A stored function must return a value based on conditions that are determined at runtime. Therefore, the SELECT statement cannot be hard-coded and must be created dynamically when he function is executed. Which Oracle supplied package will enable this feature?
a. DBMS_DDL
b. DBMS_DML
c. DBMS_SYN
d. DBMS_SQL

ORACLE PLACEMENT PAPER 2

Interview Question at ORACLE for JAVA platform holding 3 yrs of Exp
-------------------------------------------------------------------

Questions that remembered are,
Difference between Vector and ArrayList?
What is controller in your project?
How will u authentication a user?
Some servlet calls JSP and in JSP will initialize a servlet this way
Servlet1 s=new Servlet1();
s.doPost(request,response);
and this in turn calls a jsp and this JSP calls another Servlet what will be the output?
Any 2 errors and exceptions?
Difference between SAX and DOM?
Have u ever used <xsl:include>. How to include an xslt in another xslt ?
How will u get connection in ur project?
Which loads driver classloader or JVM?
Difference between Statement and PreparedStatement?
ResultSet points to which location by default?
What is ResultSetMetaData?
Types of Drivers in JDBC?
Difference between 3rd and 4th type java?
What is class?what is object?
What is object ? what is instance? What is the difference between object and instance?
What is encapsulation?
What is polymorphism? Types of polymorphism ? how will u achieve all types of polymorphism?
What is the difference between vector and Array?
What is the difference between HashTable and HashMap?
Are servlets and JSP's threadsafe ? how can u make them threadsafe?
What is multithreading? What Is synchronized?
How can u stop a thread?
Is stop()=sleep()
How to kill a thread?
Describe the design of ur project as MVC ? Methodologies? Flow of ur project?
How will u make transactions with creditcard? Ie will u deduct money from the card
Immediately after making transaction?
How will u insert and delete with a single java connection when u have referential integrity?
What is serialization? Any methods in serialization? What is externalization?
How will u achieve threads?
How will u set priorities of threads?

These r all the basic questions generally u will face at the round which is easy to get through.

Coming to the second round where u have to thorough with ur current project and interviewer will go deep into the concepts that u r using in ur project...

some of them which i remembered..

How to implement connection pooling by ourself?
Will service all doget , dopost or the reverse?
How can u implement cocoon on ur own?
How can u implement hashmap if u r not having it in java?
What is the difference between static binding and dynamic binding?

below r u some questions generally we will face at the interview...

What is synchronization? Why is it used? What are its disadvantages?

How will u enforce synchronization?
How will u declare a synchronized block? What does this represent in the
Declaration of synchronized block?

Can u assign an instance of a class which implements an interface to an interface type?

What is servlet chaining?

Describe the life cycle of servlet starting from the request from a browser to the response it get?

If service method is used then doGet() and doPost() stand for what?

If we can access a sevlet through both GET and POST methods then which methods will u declare in
The sevlet class?

What is dynamic binding?Can u explain with an example?

Can u read all elements from an array?

If aaaa is an array then why aaaa.length why not aaaa.length()?

Is array an object?

Class A{

Public void meth(){
}
}

class B extends A{
Public void meth(){

}
public static void main(String args[]){
A a=new A();
a.meth();//which method will this call
}
}

if u want to call a method of class B then how can u achieve this?

What is static variable? What is static method?
Can u call a static method on a class object,can u access
Static variables through class objects?

What is the diffrenence between AWT and Swing?

How will u add a button to a frame?

Cant we add a component directly to a frame? Why?

What are the different types of panes available?
What are the uses of different types of panes?

What is a layered pane?

What is event delegation model?describe it with an example?

Public void Methos(){
Int I;

Int a[]=new int[10];
S.O.P(i);

For(int k=0;k<a.length;k++)
S.O.P(a[ k]);
}
What will be the output of this method

What is the difference between getActionCommand()
And getSource() on event object?

If u have a table with columns empid,empname,salary,
Write a query to get maximum 5 salary drawing employees?

What is a tier? What is the difference between tier and system or computer?

What do u mean by portability?

What do u mean by platform independence?

Completely view of MVC and n tier architecture and differences?

What is the difference between JradioButton and Jradiobuttongroup.

If u add 2 Jradiobuttons to a panel and check the first one and then the second one
Then which one will be selected

What are the methods of authorization in jsp or servlets?

What is webapplication?

What are the various methods of declaring a TLD in a taglib directive in jsp?

What is TLD?

Implicit objects of jsp are available in destroy() method or not?

What is translation unit in jsp?

What is context in webapplication?

What are multiple and single processor servers? How session is handled
When the server is multi processor server?

If server crashes the threads will continue running or will they stop?
what happens to the sevlet?

Explain MVC pattern by taking any one component ex JtextField or Jbutton?

What is GridBagLayout?

If we want to change the entire path of the server ,where should we touch in a application server?

If we have 3 jsp's as model.jsp, controller.jsp, view.jsp then will it be a MVC architecture?

What is a classloader?

What is dynamic typing, static typing ?

Is java dynamic typed language?

What are the types of sevlet containers?

What is web.xml?

What is pooling of sevlets?

If we have two abstract classes A,B then can we extend both the classes in a single class?

What are the different types of thread priorities?

What is SAX?

What is the difference between SAX and DOM?

What is the difference between RequestDispatcher.forward(request req,response res)
And response.sencRedirect("url");?

What are implicit objects in jsp?

Why cocoon ?why not struts?what is cocoon?

How are u implementing session in ur application?

What is serialization? What are the methods in implementing serialization?

If u have a single table in database how to normalize it?

Is servlet thread safe ? life cycle of JSp?

What is the difference between checked exception an runtime exception?

Interrupt() method throws which exception?

Why jsp is used if we have sevlets>

Difference between a String and Stirng Buffer?

How to increment the capacity of a StringBuffer?

If String S="x";
S+"y";
Then what is S?

How can u set the priorities of thread ? What are the priorities available?

Difference between Vector and ArrayList other than Synchronization?

Which JDBC dirver are u using?

What are the drivers available?

What do u mean by precompiled statement? What is the difference between
Statement and PreparedStatement?

Difference between HashMap and HashTable?

What is context?

Difference between application server and webserver ?

Can we have a try without catch and with a finally?
What is the use of having finally?

If there is try{
Return x;
}finally{
S.O.P("Yes");
}

then finally will execute or not

what is the superclass of an exception?

Is sevlet threadsafe?

What is synchronization?

Sleep() throws which exception?

This is the oracle paper

Technical section:

its very easy any one can answer 25 qns without preperation. some are
1. how compiler treats variables of recursive functions
2. what is orthogonal matrix?
3. given two tables and asked 2 qns on those table ,
one is on join and another is on NOT IN
4. given some qns on pointers( pretty easy)
5. given five qns on data structures like , lifo, fifo
6. qtn on primary key
7. how NULL in sql is treated?
8. given a doubly linked list and asked r->left->right->data
ans: r->data
9:explain const char *ptr and char *const ptr
remaining i didn`t remember

Aptiude

15 quant apti from rs agrval
15 verbal apti,
in this 4 are odd word out
and 4 are sentese ordering when jumbled senteses given
and 4 are reasoning

ORACLE PLACEMENT PAPER 1

Directions for questions 1-3:Each question consists of six statements
followed by 3 statements put together in a specific order .Choose the option
where the third statement is a conclusion drawn from the previous 2
statements.

1) A. Final Year students would like a good career.

B. All final year students are eligible as candidates for MBA entrance
exam.
C.Final Year students are entitled to work towards a good career.
D.Some of those who are candidates for an MBA entrance exam are final
year students
E.All those eligible as candidates for an MBA exam are eligible for a
good career
F.All those who would like a good career are entitled to it.

1. AEF 2. EBC 3.BCF 4.CDF

2) A. All bright people acknowledge brains in others
B. Some knowledgeable men are bright
C. Some knowledgeable men do not acknowledge brains in others
D.Some knowledgeable men are persons who are bright
E.Some knowledgeable men are not bright
F.All bright people do not necessarily acknowledge brains in others

1. ABE 2. ACF 3.ADE 4. ACE

3) A.Some thoughts lack clarity
B.Anything unclear is not worth writing about
C.Some thoughts are worth writing about
D.All thoughts lack clarity
E.Some thoughts are clear
F. No thought is worth is writing about

1. ABF 2.BCD 3.BEF 4.BDF

Directions for questions 4 to 6:Arrange the sentences A,B,C,D in a logical
sequence to form a coherent paragraph.

4) A. How do you set your mental co-ordinates vis a vis the external
variables if every-
thing changes so fast ?
B. Modern life is about managing the prices and consequences of changes
C. That is creating a problem
D. The pace of the changing process seems to be getting quicker overtime

1. ABDC 2.DCAB 3.BDCA 4.BCDA

5) A. Infact trying to calculate an element of chance
B. The rather fanciful idea of Lady Luck favouring her own can be traced
back to
Pagan times when lucky gamblers were thought to be the beloved of
the goddess of
Good fortune
C.Risks were taken in order to gain her approval ,and one of these risks
was trying to
Guess what would happen -for example ,which way a leaf would fall
,which way a
Frog would jump
D.She was seen as being capricious and prone ,occasionally ,to mockery

1. BCAD 2.BDCA 3.BADC 4.BDAC

6) A.It is because Japanese companies do not have to pay the consultancies'
inflated fees
the argument goes ,that companies have more money to devote to
'real' investment
and because they are not tempted to follow the latest management
fashions that they
can develop a coherent ,long term strategy.
B.The average salary man,relaxing after a ten hour day over yakitori
and sake ,hardly
Spends his time talking about Drucker -san and Peter-san .
C.It might seem far fetched to argue that Japan's post war growth has
anything to do
With management theory.
D.Critics of management theory happily point out that thirty years after
arriving ,
Western consultancies are still to make ends meet ,and that Japan
has few business
Schools ,none of them very prestigious.

1. CADB 2. CBDA 3. DBAC 4. DBCA

Directions for questions 7 to 9 :Each question consists of a sentence ,part
of which is underlined .Choose the option that best replaces the underlined
part

7) Nearly everyone know that exercise has numerous health benefits for
people of all ag-
es and physical conditions .

1. Nearly everyone know that exercise has numerous .
2. Nearly everyone knows that exercise has numerous
3. Everyone nearly knows that exercise having numerous
4. Everyone nearly have know that exercise has numerous

8) The researchers hope to study a large patient group to investigate the
effect further and
finding out how long the effects last

1. finding out
2. to find out
3. for finding
4. to finding

9) Having failed to work out a viable marriage with the BSP twice in the
past ,another
hasty alliance shouldn't have been entered into by the BJP

1. another hasty alliance shouldn't have been entered into by the BJP
2. a hasty alliance should have been avoided by the BJP

3. the BJP's entering into hasty alliance shouldn't have been done by them.
4. the BJP should not have entered into a hasty alliance

Directions for questions 10 to 12: Choose the word that is least related to
the question word.

10) Mighty
1. puny 2. colossal 3.prodigious
4.towering

11) Ordeal
1. tribulation 2. copious 3. .affliction
4.torment

12) Pen
1. enclosure 2.corral 3. coop 5.nib

Direction for questions 13 to 15:Read of the following short passages and
answer the question that follows

13) The Mahauti tribe that inhabited the Himayalan region had a personal
relationship with their deities .This gave support and protection to the
tribe most of whom were hunters ; the support might otherwise be lacking
.The absence of each support left tye individual weak and vulnerable .So
,important was this spititual relation that when the tribes lost their
beliefs in the spirit ,their culture disintegrated.

The passage suggests that a primary motivation for members of hunting
cultures to seek firm bonds with the spirit world was the

1. ambition to be better at huntung than others
2. wish to secure an afterlife
3. need for cpmfort in times of sorrow
4. desire to obtain and maintain skill and strength

14) Cosmetologists trying to make ultimate hair care product have found that
when the did not treat hair with a quaternary compound,on combing ,the
combing force remained high This happened even when the electrostatic charge
was substantially reduced by high humidity.

It can be inferred from the above that ,the cosmetologist did which of the
following to reduce the electrostatic charge generated when hair not treated
with a quaternary compound was combed ?

1. decreased the combing speed
2. increased humidity
3. tangled the hair
4. dried the hair.

15) No thorough consideration of the metropolis can overlook either its
social organization or its governmental institutions .The informal means of
social control that once regulated communal affairs of settlement have given
way to the more formal methods of modern society .As metropolitan grew more
complex governmental organizations have evolved as instruments of control
and direction

Which of the followinf situations in a city is most clearly an example of
the developments described in the passage ?

1. City officials no longer control the allocation of water rights :instead
state governments distribute water rights
2. Delinquent children are not verbally chastised by community elders
:instead ,they are brought before a court of law
3. The local government has retained its autonomy thereby preventing central
governments from providing solutions for population problem
4. Community cohesion has decreased ,leading to a sense of isolation on the
part of city residents.

Questions 16 and 17 are based on the following

a/b = (a+b)/(a-b)
a*b = (a+b)(a-b)
a@b = a/b - b/a (implies subtracting the smaller of the two from the other
one )
a#b = a/b + b/a

16) Find (((a@b) + (a#b)) * 1)/ 1, where a=5.91 and b= 17.73

1. 35 2. 18/17 3.17/18
4.None of these

17) State which of the following is/are true
I. 7@(a*b) is undefined if a = b
II. [(a/b)/1 * [(b/a)/1. = (a@b) x (a#b)

1.I only 2. II only 3. Both I and II
4. Neither I or II

18) What is the maximum area that can be enclosed by a wire 44cm long ?

1. 77 2. 154 3. 308 4.None of
these

19) If A(2,3) ,B(-2,-3) and C(1,2) are three vertices of a triangle ,which
among the following is the largest angle ?

1. ABC 2. BCA 3. CAB 4. All three angles
are equal
20) f(x) = 2(x*x) +1 when x<0
= -2x when x>=0
What is f(f(f(2))) ?

1. 66 2. -33 3. 33
4. None of these

21) One sells 30 kg rice with cost Rs.22.87/kg at 20% profit and 50kg rice
with cost price Rs 20.92/kg at 30% profit .What is the total percentage
profit ?

1. 26.25% 2. 24.72% 3. 26.5% 4. 28%

22) Ravi buys 100 5% shares of face value Rs.100 at Rs.15000 .If he sells
them off after a year at Rs 155 a share ,what is his yield ?

1. 8.33% 2. 6.67% 3. 5% 4. 3.33%

23) Amit and Meghna went to New York for a 63 day holiday .Each day ,Amit
spent as many as hundred dollar bills as the remaining number of days in the
trip (excluding the current day ) ,and Meghna spent as many as hundred
dollar bills as the number of days already spent (including current day).
How much per day would they have spent together during the holiday ?

1. $12,600 2. $10000 3. $6300 4. $5000

24) Bacteria reproduce in such a manner that every hour their number
doubles In a controlled experiment that started with a certain number of
bacteria in a jar at 12noon on Tuesday ,30 million were found at 12noon on
Wednesday .At what time were there 15 million bacteria ?

1. Midnight ,Tuesday
2. 6a.m on Wednesday
3. 10 a.m Wednesday
4. None of these

25) Take a number 'x' and follow these steps :
1. Find the sum of its digit
2. If the sum has only one digit , STOP
3. Else , go back to step 1 with the new number.
If x = 1684 ,what is the end result ?

1. 19 2. 10 3. 1
4. None of these

26) A number consisting of five digits 5,6,7,8 and 9 each coming once but
not necessarily in that order is taken ,and an algorithm specified in the
previous question is run on it .How many different end results are possible
?

1. One 2.Three 3.Five
4. Nine

Directions for questions 27 and 28 :Each question is followed by two
statements A and B. Mark
1. If statement A alone is sufficient to answer the question
2. If statement B alone is sufficient to answer the question
3. If both statements A and B are required to answer the question
4. If neither A or B are sufficient to answer the question

27) What is the height of the tower ?
A. A man standing at a distance of 1km from the bottom of the tower
makes an angle
300 degrees with the top of the tower .
B. An insect starts from the bottom of the tower and reaches the top in
25sec.

28) Distance between A and B is
A. A and B two points on the circumference of the circle with center O and
radius 5.2 cm
B. Angle AOB = 450

Additional instructions for questions 29 and 30:

For any activity , X, year Ao dominates year Bo if organized retail business
in activity X in year Ao is greater than organized retails business in
activity X is year Bo .For any two activities in the organized retail
business ,A and B ,year Xo dominates year Yo if
a. The organized retail business in activity A ,in the year Xo is greater
than equal to the organized retail business activity A in the year Yo: and
b. The organized retail business in activity B ,in the year Yo is less than
or equal to the organized retail business in activity B in the year Xo.

29) For the organized retail business activity in children's clothing ,which
one of the following is true ?

1. 1994-95 dominates 1995-96
2. 1995-96 dominates 1994-95
3. 1997-98 dominates 1996-97
4. 1998-99 dominates 1997-98

30) For the organized retail business activity in children 's clothing and
footwear ,which of the following is true ?

1. 1995-96 dominates 1994-95
2. 1994-95 dominates 1995-96
3. 1996-97 dominates 1995-96
4. None of these

QUESTION : 1

EVALUATE THESE TWO SQL COMMANDS:

1. SELECT DISTINCT OBJECT_TYPE FROM USER_OBJECTS;

2. SELECT OBJECT_TYPE FROM ALL_OBJECTS;

HOW WILL THE RESULTS DIFFER?

A. STATEMENT 1 WILL DISPLAY THE DISTINCT OBJECT TYPES IN THE DATABASE, STATEMENT 2 WILL DISPLAY ALL THE OBJECT TYPES IN THE DATABASE.

B. STATEMENT 1 WILL DISPLAY THE DISTINCT OBJECT TYPES OWNED BY THE USER, STATEMENT 2 WILL DISPLAY ALL THE OBJECT TYPES IN THE DATABASE.

yC. STATEMENT 1 WILL DISPLAY THE DISTINCT OBJECT TYPES OWNED BY THE USER, STATEMENT 2 WILL DISPLAY ALL THE OBJECT TYPES THE USER CAN ACCESS.

D. STATEMENT 1 WILL DISPLAY ALL THE OBJECT TYPES THE USER CAN ACESS, STATEMENT 2 WILL DISPLAY ALL OBJECT TYPE THAT THE USER OWNS.

QUESTION : 2

The EMPLOYEE table contains these columns:

LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) SALARY NUMBER(7,2)

You need to display the names of employees that earn more than the average salary of all employees.

Evaluate this SQL statement:

SELECT last_name,first_name FROM employee WHERE salary > AVG(salary);

Which change should you make to achieve the desired results?

A. Change the function in the WHERE clause. B. Move the function to the SELECT clause and add a GROUP BY clause. yC. Use a subquery in the WHERE clause to compare the average salary value. D. Move the function to the SELECT clause and add a GROUP BY clause and a HAVING clause.

QUESTION : 3

You need to remove all the data from the employee table while leaving the table definition intact. You don't care about being able to undo this operation. How would you accomplish this task?

yA. Use the DELETE command. B. Truncate the table. C. Drop the table and recreate it. D. This task cannot be accomplished.

QUESTION : 4

Click on the EXHIBIT button and examine the table instance chart for the sales table.

You attempt to change the database with this command:

SALES ****** _______________________________________________________________ | Column Name | PURCHASE_NO | CUSTOMER_ID | CAR_ID | MODEL | |_______________|_______________|_____________|________|________| | Key Type | PK | FK | FK | FK | |_______________|_______________|_____________|________|________| | Nulls/Unique | NN, U | NN | NN | NN | |_______________|_______________|_____________|________|________| | FK Table | | PURCHASE | S_ORD | S_ITEM | |_______________|_______________|_____________|________|________| | FK Column | | CUST_ID | C_ID |MODEL_ID| |_______________|_______________|_____________|________|________| | Datatype | NUM | NUM | NUM | NUM | |_______________|_______________|_____________|________|________| | Lenght | 6 | 6 | 6 | 6 | |_______________|_______________|_____________|________|________|

INSERT INTO sales(purchase_no, customer_id, car_id) VALUES (1234 , 345 , 6);

If this statement fails , which condition would explain the failure?

A. The statement has invalid datatypes. B. The sales table has too many foreign keys. yC. A mondatory column value is missing. D. This statement does not fail at all.

QUESTION : 5

Which ALTER command would you use a disabled primary key constraint ?

A. ALTER TABLE cars ENABLED PRIMARY (id) ; B. ALTER TABLE cars ADD CONSTRAINT cars_id_pk PRIMARY KEY (id) ;

yC. ALTER TABLE cars ENABLE CONSTRAINT cars_id_pk;

D. ALTER TABLE cars ENABLE PRIMARY KEY (id) CASCADE;

QUESTION : 6

You need to create the patient_id_seq sequence to be used with the patient table's primary key column. The sequence should begin at 1000, have a maximum value of 999999999, increment by 1 , and cache 10 number which statement would you use to complete this task ?

yA. CREATE SEQUENCE patient_id_seq START WITH 1000 MAXVALUE 999999999 CACHE 10 NOCYCLE;

B. CREATE SEQUENCE patient_id_seq ON patient (patient_id) MINVALUE 1000 MAXVALUE 999999999 INCREMENT BY 1 CACHE 10 NOCYCLE;

C. CREATE SEQUENCE patient_id_seq START WITH 1000 MAXVALUE 999999999 INCREMENT BY 1 CYCLE 10;

D. This task cannot be accomplished.

QUESTION : 7

Evaluate this SQL statement:

CREATE INDEX emp_dept_id_idx ON employee (dept_id);

Which result will the statement provide ?

A. Store an index in the EMPLOYEE table. B. Increase the chance of full table scans. yC. May reduce the amount of disk I/O for SELECT statements. D. May reduce the amount of disk I/O for INSERT statements. E. Override the unique index created when the FK relationship was defined.

QUESTION : 8

Evaluate this SQL script:

CREATE ROLE manager; CREATE ROLE clerk; CREATE ROLE inventory; CREATE USER scott IDENTIFIED BY tiger; GRANT inventory TO clerk; GRANT clerk TO manager; GRANT inventory TO scott;

How many roles will user SCOTT have access to ?

A. 0 yB. 1 C. 2 D. 3

QUESTION : 9

Within a PL/SQL loop, you need to test if the current fetch was successful. Which SQL Cursor attribute would you use to accomplish this task ?

A. SQL%ROWCOUNT B. A SQL cursor attribute cannot be used within a Pl/sql loop. yC. SQL%FOUND D. SQL%ISOPEN E. This task cannot be accomplished with a SQL cursor attribute.

QUESTION : 10

The EMPLOYEE table contains these columns:

BONUS NUMBER(7,2) DEPT_ID NUMBER(9)

These are 10 departments and each department has at least 1 employee. Bonus values are greater than 5 not all employees receive a bonus.

Evaluate this PL/SQL block:

DECLARE v_bonus employee.bonus%TYPE :=300; BEGIN UPDATE employee SET bonus = bonus + v_bonus WHERE dept_id IN(10 , 20 , 30); COMMIT; END:

What will be the result ?

A. All employees will be given a 300 bonus. B. A subset of employees will be given a 300 bonus. C. All employees will be given a 300 increase in bonus. yD. A subset of employees will be given a 300 increase in bonus.

QUESTION : 11

In which situation should you use an outer join query ?

A. The employee and region tables have no corresponding columns. yB. The employee and region tables have corresponding columns. C. The employee table column corresponding to the region table column constains null Values for rows need to be displayed. D. The employee table has two columns that correspond.

QUESTION : 12

You query the database with this command:

SELECT lot_no "LOT NUMBER" ,COUNT (* ) "NUMBER OF CARS AVAILABLE" FROM cars WHERE model = 'Fire' GROUP BY lot_no HAVING COUNT (*) > 10 ORDER BY COUNT( * );

Which clause restricts which groups are displayed ?

A. SELECT lot_no "LOT NUMBER" ,COUNT (* ) "NUMBER OF CARS AVAILABLE" B. WHERE model = 'Fire' C. GROUP BY lot_no yD. HAVING COUNT ( * ) > 10 E. ORDER BY COUNT ( * )

QUESTION : 13

IN PL/SQL BLOCK WE QUERRY THIS STATEMENT

FOR EMP_RECORD IN CURSOR_EMP LOOP EMP_RECORD:='JIM'; END LOOP; CLOSE CURSOR_EMP; WHICH TASK WILL BE ACCOMPLISHED

1.NO FETCH STATEMENTIS ISSUED. 2.THERE IS NEED TO OPEN A CURSOR. y3.THERE IS NO NEED TO CLOSE THE CURSOR. 4.THE LOOP TERMINATING CONDITION IS MISSING.

QUESTION : 14

WHICH PL/SQL BLOCK USER_DEFINED EXCEPTION RAISED ?

y1. EXCEPTION 2. EXECUTEABLE 3. DECLARATIVE 4. HEADER

QUESTION : 15

WHAT SHOULD YOU TO DO AFTER FETCH STATEMENT

1. CLOSE THE CURSOR y2. TEST TO SEE THE CURSOR ATTRIBUTE 3. OPEN THE CURSOR 4. IDANTIFY THE ACTIVE SET

QUESTION : 16

IN PL/SQL BLOCK

IF V_VALUE >100 THEN V_VALUE_INCREASE := 2*V_VALUE; IF V_VALUE >200 THEN V_VALUE_INCREASE := 3*V_VALUE; IF V_VALUE <300 THEN V_VALUE_INCREASE := 4*V_VALUE; ELSE V_VALUE_INCREASE := 4*V_VALUE;

WHICH VARIABLE V_VALUE_INCREASE ASSIGN A VALUE IF V_VALUE IS 250

1. 500 2. 750 y3. 1000 4. 1250

QUESTION : 17

EVALUATE THIS STATEMENT

SELECT UPPER(FIRST_NAME),UPPER(LAST_NAME), LENGTH(CONCAT(FIRST_NAME,LAST_NAME)) NAME FROM EMPLOYEE WHERE UPPER(LAST_NAME) LIKE '%J' OR UPPER(LAST_NAME) LIKE '%A' OR UPPER(LAST_NAME) LIKE '%N' ;

SELECT INITCAP(FIRST_NAME),INITCAP(LAST_NAME), LENGTH(FIRST_NAME) + LENGTH(LAST_NAME) FROM EMPLOYEE WHERE UPPER(SUBSTR(LAST_NAME,1,1) IN ('J','A','N');

HOW WILL THE RESULT DIFFER

y1. BOTH STATEMENT RETRIVED DIFFERENT DATA FROM THE DATABASE 2. STATEMENT 1 WILL EXECUTE AND STATEMENT 2 WILL NOT 3. STATEMENT 2 WILL EXECUTE AND STATEMENT 1 WILL NOT 4. BOTH STATEMENT RETURNS SAME DATA

QUESTION : 18

HOW MANY ELEMENT CONSISTS OF WHERE CLAUSE

1. USER_SUPPLIED LITERALS 2. ALIAS 3. COLUMN NAME 4. COMPARISION OPERATOR 5. COLUMN POSITION

QUESTION : 19

IN PL/SQL BLOCK

BEGIN FOR I IN 1..10 LOOP IF I=4 OR I=6 THEN NULL; ELSE INSERT INTO CARS(ID) VALUES(I); END IF; COMMIT; END LOOP; ROLL BACK; END;

HOW MANY VALUES WILL BE INSERTED

1. 2 2. 1 3. 5 4. 6 y5. 8 6. 10

QUESTION : 20

EVALUATE THIS STATEMENT

CREATE SYNONYUM CARS FOR ED.MARYLIN;

WHICH TASK WILL BE ACCOMPLISH?

1. SYNONYUM IS CREATED FOR ALL USER. y2. SYNONYUM IS CREATED FOR YOU. 3. SYNONYUM IS CREATED FOR ED 4. SYNONYUM IS CREATED FOR THOSE EMPLOYEES WHO HAS ACCESS THE DATABASE.

QUESTION : 21

DISPLAY ENAME,JOB AND SALARY OF ALL EMPLOYEES. ORDER OF SALARY IS DESCENDING, IF SALARY IS MATCHED THEN ORDER THE ENAME.

A. SELECT ENAME,JOB,SAL FROM EMP ORDER BY SAL,ENAME

yB. SELECT ENAME,JOB,SAL FROM EMP ORDER BY SAL DESC,ENAME

C. SELECT ENAME,JOB,SAL FROM EMP ORDER BY SAL DESC,ENAME ASCENDING

QUESTION : 22

EVALUATE THIS STATEMENT:

SELECT ENAME,JOB FROM EMP WHERE EMPNO NOT IN(SELECT MGR FROM EMP);

WHICH OPERATOR IS EQUAL TO 'NOT IN':

A. != B. NOT ALL yC. != ALL D. NOT LIKE

1. In SQL*Plus environment ,you want to store the result of your query in a text file, which command will you use; a. Spool Out. yb. Spool filename.txt. c. Spool out to filename.txt.

2. You are informed that cost of your product has by 25% and price of the product is increased by 10%. Now you have to determine the actual net profit for that product, you issued this query Select Price*1.10-Cost*1.25 from product How will this statement execute; a. This will give more result than you want yb. This will give desired result. c. This will give less result than you want.

3. Which characteristic applies to SQL. ya. When sorted in ascending order null values come in last b. When sorted in descending order null values come in last c. When sorted in ascending order null values come first

4. You have to find a name, but you don't know the case of stored data, which query will give the desired result. a. Select * from product Where ename=upper('&ename');

b. Select * from product Where ename=lower('&ename');

c. Select * from product Where upper(ename)='&ename';

yd. Select * from product Where upper(ename)=upper('&ename');

5. You have to find the name Smith. But you don't have any idea that which case user will use, which command will give the desired result. a. Select * from product Where ename=initcap('&ename');

b. Select * from product Where intioap(ename)=('&ename');

c. Select * from product Where upper(ename)='&ename';

yd. Select * from product Where ename = upper('&ename');

6. You have to find the total service period of employee in months as whole number, which query will give the result. ya. Select round(months_between(sysdata,hiredate)) from emp; b. Select round(months_between(hiredate,sysdate)) from emp;

7. If you want to join table without direct matching of their columns, which type of join will you use. a. Equi Join b. Self Join. c. Outer Join yd. Non EquiJoin.

8. Click on Exhibit Button ID Number(4) Name Varchar2(20) Manager_ID Number(4) You want to see name with their manager name which query will you use?

9. Which order is advised in SQL a. Where , Having ,Group By b. Group By, Having,Where c. Group By, Where ,Having yd. Where, Group By, Having

10. What is a nonpairwise subquery. ya. Cross Product applies to them. b. Cross product doesn't applies to them.

11. Click on Exhibit Button Table User_Tab ID Number(4) Name Varchar2(20) Hired Date You have to insert a row in this table, which query will give the desired result. ya. Insert into User_tab Values('asd',23,sysdate); b. Insert into User_tab(Name,Id,Hired) Values(123,'asd',sysdate); c. Insert into User_tab(Name,id,hired) Values('asd','123',sysdate)

12. Click on Exhibit Button Table is User_Tab Ino Number(4)

You use this PL/Sql program Begin For I in 1..5 loop Insert into user_tab Values (I); Commit; End Loop; RollBack; End; How many values will be inserted in User_tab table? a. 0. b. 1. c. 3. yd. 5.

13. To see which table you can access, which data dictionary is used. a. User_Objects. b. Dba_Ojbects. yc. All_objects.

14. To add a comment on table abc, syntax is a. Alter Table abc Add Comment b. Alter abc Add Comment. c. Commnent on abc. yd. Comment on table abc.

15. In SQL*Plus, you issued this command DELETE FROM dept WHERE DEPT_ID=30; You received an Integrity Constraint Error. What could you do to make the statement execute? a. Add the FORCE keyword to the command. b. Add the CONSTRAINTS CASCADE option to the command. c. You cannot make the command execute. yd. Delete the child record first.

16. You are updating the employee table, Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you issue a COMMIT command. What can Jane do to the employee table? a. Jane can access the table and verify your changes. b. Jane cannot access the table. c. Jane can access the table, but she cannot see your changes. She can make the changes for you. yd. Jane can access the table, but she cannot see your changes and cannot make the same changes.

17. You created the patient_vu view based on id_number and last_name from the patient table. What is the best way to modify the view so that the rows can only be accessed b/w 8:00 A.M to 5:00 P.M. a. Use the ALTER command to add a WHERE clause to verify the time. b. Replace the view adding a WHERE clause. c. Drop the patient_vu and create a new view with a WHERE clause. d. Drop th epatient_vu and create a new view with a HAVING clause. ye. This task cannot be accomplished.

18. You issued this command CREATE SYNONYM e FOR ed.employee; Which task has been accomplished? a. The need to qualify an object name with its schema was eliminated for user Ed. yb. The need to qualify an object name with its schema was eliminated for only you. c. The need to qualify an object name with its schema was eliminated for all users. d. The need to qualify an object name with its schema was eliminated for users with access.

19. In the declaration section of a PL/SQL block , you create this variable; abc employee%rowtype; Which task has been accomplished? a. The abc variable was declared with the same datatype as the employee column. b. The abc table was created. c. A scalar table was created. yd. A composite variable was created based on the employee table.

ORACLE
------

section 2:

1. what is sparese matrices?. give (at least) two methods for implemetation
rather than two dimentional array.
2.what are cheap locks/latches?.
3.what is two phase locking?. Name two locks.
4. What are volatile variables in C?. What is their significance ?.
5. will these two work in same manner
#define intp int *
typedef int * inpp;
6. what are binary trees?. what is its use?.
7.

section 3 :

A). write header file containing functions used, etc (C),
problem is to maitain a Queue. user has to give size and type of Queue.
This problem is like this I don't remember exactly.
B). C++
1. What is polymorphism?
2. What is Inheritence?.
3. Mention four Object Oriented Programming Languages?>
4. Mention basic concepts of OOP.
5. What are messages in OOP?.
6. What is garbase collection?.
7.what is object?.
8. what is a class?.

section 4:
1. expand the following:
a.SEI b. ISO
2. what are different levels of SEI?.
3. What is significance of ISO?>
4. Expand the following:
a. WWW
b. HTTP
c. HTML
d. TCP/IP
5. what is Black box testing?.
6. explain the following:
1. white box testing
2. white box testing
3. boundary testing
4 stress
5. negative
6. system
7. unit
8.module
9.destructive

RBI BANK EXAM APTITUDE QUESTIONS WITH ANSWER

RBI Grade B officer Previous Years solved question papers
1. How many meaningful English words can be formed with the letters MASTE
using each letter only once in each word
(1)None
(2) One
(3)Two
(4) Three
(5) More than three-Answer
'
2. Four of the following five are alike in a certain way and so form a group. Which
is the one that does not belong to that group?
(1)78-Answer
(2) 48
(3) 72
(4)54
(5) 42
3. In a certain cede SAFER is written as 5@3#2 and RIDE is written as 2©%#.
How is FEDS written in that code ?
(1)3#©5
(2) 3@%5
(3)3#%5-Answer
(4) 3#%2
(5)None of these
4.. Pointing to a woman, Nirmal said, "She is the daughter of my wife's
grandfather's only child". How is the woman related to Nirmal
(1)Wife-Answer
(2)Sister-in-law
(3)Sister
(4)Data inadequate
(5)None of these
5. Four of the following five are alike in a certain way and so form a group. Which
is the one that does not belong to that group ?
(1)Sweet-Answer
(2) Cake
(3)Pastry
(4) Bread.
(5) Biscuit
6. In a certain code CONFUSED is written as EMNBEFTV. How is SECLUDED
written in that code
(1) RDBKEFEV
(2) KBDRCDCT
(3) KBDREFEV-Answer
(4) MDFTCDCT
(5) None of these
7. What should come next in the following letter series ?
Z XVT R P N U YW T J S Q O
(1)M-Answer
(2)K
(3)N
(4)J
(5)None of these
8. Flow many such digits are there in the number 9254716 each of which is as
far away from the beginning of the number as when the digits are rearranged in
ascending order
(1)None
(2) One-Answer
(3)Two
(4) Three
(5) More than three
9. In a certain code language' bring the board' is written as ka na di pa' and
'white and black board' is written as 'na di sa ra'. How is 'the' written in that
code ?
(l)ka
(2) pa
(3) ka or pa-Answer
(4) Data inadequate
(5) None of these
10. Among B, F, J, K and W each having a different weight, F is heavier than only
J. B is heavier than F and W but not as heavy 35 K. Who among them is the third
heaviest among them ?
(1) B
(2)F
(3) K
(4)W -Answer
None of these
Directions (Q. 11 to 16) Study the following arrangement carefully and answer the
questions given below:
Y 4 8 A @ D F 3 # R N 1 M © W
P % J 2 E 5 Z * 6 Q B 7 $ H U 9 I K
11. Which of the following is the seventh to the right of the nineteenth from the
right end of the above arrangement P
(1)1
(2)D
(3)Z-Answer
(4)$
(5)None of these
12. Four of the following five are alike in a certain way based on their positions in
the above arrangement and so form a group. Which is the one that does not
belong to that group
(1)D#A
(2)JWE-Answer
(3)562
(4) $9B
(5)RM3
13. How many such consonants are there in the above arrangement each of
which is immediately preceded by a symbol and immediately followed by a letter?
(1)None
(2) One
(3) Two-Answer
(4) Three
(5) More than three
14. How many such numbers are there in the above arrangement each of which
is immediately preceded by a letter and immediately followed by a symbol P
(1)None
(2) One
(3)Two-Answer
(4) Three
(5) More than three
15. What should come next in the following series based on the above
arrangement ?
8@D #N1 W%J 5*6
(1) 7HU-Answer
(2) 7$U
(3) 7#9
(4) B$#
(5) None of these
16. If all the numbers are dropped from the above arrangement, which of the
following will be the fourteenth from the left end?
(1)W
(2)P
(3)6
(4)J-Answer
(5)None of these
Directions (Q. 17 to 20) In each question below are four statements followed by
four conclusions numbered I, II, II and IV. You have to take the four given
statements to be true even if they seem to be at variance from commonly known
facts and then decide which of the given conclusions logically follows from the
four given statements disregarding commonly known facts. Then decide which of
the answers (1), (2), (3), (4) and (5) is correct.
17. Statements
All belts are rollers.
Some rollers are wheels.
All wheels are mats.
Some mats are cars.
Conclusions
I. Some mats are rollers.
II. Some mats are belts.
III. Some cars are rollers.
IV Some rollers are belts.
(1) Only I and II follow
(2) Only I, III and IV follow
(3) Only I and IV follow-Answer
(4) Only II, III and IV follow
(5) None of these
18. Statements
Some tyres are rains.
Some rains are flowers.
All flowers are jungles.
All jungles are tubes.
Conclusions
I. Some jungles are tyres.
II. Some tubes are rains.
III. Some jungles are rains.
IV. Some tubes are flowers.
(1) Only I, II and III follow
(2) Only II, III and IV follow-Answer
(3) Only I, III and IV follow
(4) All follow
(5) None of these
19. Statements
All desks are chairs.
All chairs axe tables.
All tables are boxes.
All boxes are trunks.
Conclusions
I. Some trunks are tables.
II. All chairs are boxes.
III. Some boxes are desks.
P All desks are trunks.
(1) Only I ,II and III follow
(2) Only I, II and IV follow
(3) Only II, III and IV follow
(4) All follow-Answer
(5) None of these
20. Statements
Some birds are goats.
Some goats are horses.
Some horses are lions.
Some lions are tigers.
Conclusions
I. Some tigers are goats.
II. No tiger is goat.
III. Some lions are birds.
IV No lion is bird.
(1) Only either I or II follows
(2) Only either III or IV follows
(3) Only either I or II and either III or IV follow-Answer
(4) Only I and III follow
(5) None of these

RBI BANK EXAM APTITUDE 1

RBI Grade B Previous Years Quantitative Aptitude Solved Question paper
Directions (11-5) : In each of these questions a number series is given. Below the
series one number is given followed by(a), (b), (c), (d) and (e). You have to
complete this series following the same logic as in the original series and answer
the question that follows.
1. 5 9 25 91 414 2282.5
3 (a) (b) (c) (d) (e)
What will come in place of (c)?
a)63.25
b)63.75
c)64.25
d)64.75-Answer
e)None of these
2. 15 9 8 12 36 170
19 (a) (b) (c) (d) (e)
What will conic in place of (b)?
a)18
b)16 -Answer
c)22
d)24
e)None of these
3. 7 6 10 27 104 515
9 (a) (b) (c) (d) (e)
What will come in place of (d) ?
a)152 -Answer
b)I56
c)108
d)112
e)None of these
4. 6 16 57 244 1245 7506
4 (a) (b) (c) (d) (e)
What will come in place of (d)?
a)98S
b)980
c)1004
d)1015
e)None of these-Answer
5. 8 9 20 63 256 1285
5 (a) (b) (c) (d) (e)
What will come in place of (e)?
a)945
b)895
c)92S Answer
d)84S
e)None of these
Directions (6 -10): What approximate value will come in place of the question
mark (?) in the following questions?
(You are not expect ed to calculate exact value.)
6. (32.51) 2-(17.4S)2 =?
a)780
b)8SO
c)680
d)820
e)750 Answer
7. 88.25% of 450 =?% of 530
a)70
b)68
c)75 Answer
d)80
e)6S
8. Square root (12.005)2+? =5000
a)680 Answer
b)720
c)750
d)620
e).630
9.9. 3745 ÷ 24.05 X 17.98 =?
a)2860
b)2800 Answer
c)2760
d)2720
e)2840
10.117.95 X 8.017 X 4.98 = ?
a)4670
b)4780
c)4840
d)4720 Answer
e)4800
Directions (11--15) : In these questions, a question is, given followed by
information in three statements. You have to consider the information in all the
three statements and decide the information in which of the statement(s) is not
necessarily required to answer the question and therefore can be dispensed with.
Indicate your answer accordingly.
11. How many students from Institute 'A'got placement?
I. Number of students studying in Institutes A & B are in the ratio of 3 : 4
respectively.
II. Number of students who got placement from Institute B is 120% of the number
of students who got placement from InstituteA.
III . 80% of the students studying in Institute B got placement.
a)None of the statements can be dispensed with
b)Only I
c)Only II
d)Any one of the three
e)Question cannot be answered even with the information in all three statements
Answer
12. What is the monthly income of Mr. X?
I. Mr. X spends 85% of his income on various items and remainingamount is
saved.
II. Monthly savings of Mr. X are Rs. 4,500/-.
III.Out of-the total ·money spent byMr. X in a month, one-fifth is' spenton food
and remaining amount of Rs. 20.400 onother items.
a)Only II
b)Only III
c)Only either II or III
d)Question cannot be answered even with the information in air three statements
e)None of theseAnswer
13. What is Suchitra's present age?
I.Suchitra's present age is double the age of her son.
II. Ratio between present ages of Suchitra and her mother is 2: 3respectively.
III. Four years hence the ratio between Suchitra's age and her son's age will be
13: 24 respectively.
a)Only II
b)Only III
c)Either I orIIIOnly
d)Either II or III Only
e)None of theseAnswer
14. What is Neeta's share in the profit earned at the end of 2 years in a joint
business run by Neeta, Seeta and Geeta?
I. Neeta invested Rs. 85,000/-to start the business.
II. Seeta and Geeta joined Neeta's business after six months investing amounts in
the ratio of 3 : 5 respectively.
III . Total amount invested by Seeta and Geeta is Rs. 2.5 lacs
a)Only II
b)Only III
c)Only either II or III
d)Information in all three statements is required for answering thequestion.
e)Question cannot be answered even with the information in all three
statements. Answer
15. What is the labeled price of the article?
I. Cost price of the article is Rs. 500/-.
II. Selling price after offering 5% discount on the labeled price is Rs. 608/
III. Profit earned would have been 28% if no discount was offered.
a)Only I
b)Only III
c)Only II & Ill
d)Only I and IllAnswer
e)Only I and II
16 Directions (16-20) : · Study the following information carefully to answer these
questions .
An Institute having 450 employees has sent all its employees for training in one
or more are as out of HRM,Computer Skillsand Financial Skills. Employees are
classified into two categories officers and clerks, which are in the ratio of 4 : 5
respectively. 10% of the officers take trainingonlyin Computer skills. 16% of the
clerks take trainingonly in HRM which is equal to the number of officers
takingtraining only in F inancial Skills and 50% of thnumber of officers taking
training in HRM and Financial Skills both 6% of the total-employees take training
in all three of which two-third are officers. 10% of the total employees take
training in HRM and Computer Skills both which is five times the number of
Clerks taking training in Computer Skills and Financial Skills. 10% of the Clerks
take training in HRM and Computer Skills both Number of officers taking train.ing
only in HRM is 25% of the number of Clerks taking training only in HRM. 20% of
the total number of employees takes training only in Computer Skills . Number of
clerks taking training in HRM and Financial skills both is 20% of the total number
of Clerks.
16.Total how many officers take-trainingin HRM?
a)110
b)128
c)118
d)98
e)None of theseAnswer
17. Total how many Clerks take training in Computer Skills but not in HRM?
a)113
b)104
c)88
d)79
e)None of theseAnswer
18. Total how many employees take training in Financial Skills but not inHRM?
a)106
b)135
c)127
d)134
e)None of theseAnswer
19. Total how many Clerks take training in Financial Skills?
a)115
b)106
c)47
d)97
e)None of theseAnswer
20. What percent of the total number of Officers take training in Computer Skills
but not in Financial Skills?
a)25
b)40
c)20
d)15
e)None of theseAnswer

Cisco paper 2

CISCO PAPER ON 26th AUGUST
1. Find perimeter of a trapezium with 3 sides given and distance between parallel
sides given.
2. A triangle ABC is given, a line DE is paralel to base side and that cuts the
triangle. The ratio of area of triangle to the area of trapezium .given DE/BC=3/5.
3. Four concentric circles are given. The radius of 1st circle is x.next is 2x,then
3x and 4x. given that area b/w 2nd and 1st is A and 4th and 3rd circles being
B.find ratio of A to B
4. What is the Difference between the perimeteres of two concentric circles is 66.
Find the difference between radius
answer 10.5
5. 3/p=6,3/q=15. Find p-q
Cisco Technical questions
6. #define clrscr() 100
main()
{
clrscr();
printf(?%d?,clrscr());
}
7. which of the followin is used for avoiding network congestion
bufferin
cachin
sourcequench
all of de above
8. main()
{
int a;
printf(?%d?,scanf(%d,&a));
}
wats o/p of this pgm. What will b printed
ans :0
9. main()
{
printf(?as?);
printf(?\bhi?);
printf(?is\n?);
} wat will b printed.
10. main()
{
unsigned short a=-1;
unsigned char b=a;
printf(?%d %d ?,a,b);
}
wat is o/p of the program
a. 65535 -1
b. 65535 65535
c. -1 -1
11. arrays base address is 1000?.array is a[5][4]..then wat is de
correct address of a[4][3]?
ans:1056
12. one packet is 64bytes..no of pkts send is 16000..then total no of bytes send
is
ans 1024000
13. #define maxval 5 (programming / computer science engineering technical
questions)
int main (void)
{
int i=1;
if(i-maxval)
{
printf(?inside?);
}
else
{
printf(?out?);
}
find o/p???
14. #define a 3+3
#define b 11-3
main()
{
printf(?%d?,a*b);
}
wat is o/p?????
15. A question in which segment address is given. logical address is 800. Base
addresses also given. You have 2 find physical address
16. There was a question on processor speed in nanocycles. Then it performs a
instruction in x cycles. like this..
17. main()
{
int *i;
int s=(int *)malloc(10*sizeof(int));
for (i=0;i<10;i++)
{
printf(?%d?,i*i)
}
whats the output?

CISCO QUESTION PAPER 1

Cisco aptitude questions
1 What is the probability of getting at least one six in a single throw of three
unbiased dice?
(1) 1 / 6
(2) 125 / 216
(3) 1 / 36
(4) 81 / 216
(5) 91 / 216
Correct choice is (5) and Correct Answer is 91 / 216
Explanatory Answer
Every die has got six sides. Each of the sides is numbered from 1 to 6.
When a single unbiased die is thrown you can have six possible outcomes.
When two dice are thrown simultaneously, the total number of outcomes will be 6
* 6 = 36
Similarly, when three dice are thrown simultaneously, the total number of
outcomes will be 6*6*6=216.
We need to find out the number of cases in which at least one of the facing sides
shows 6.
At least one means - either one dice or two dice or all three.
Case 1: Let us take the easiest case first - all three dice showing '6' - There is
only one such possibility.
Case 2: The number of cases in which two of the dice show 6 and one of them is
a different number.
For eg an event like 6 6 5 will be one of the outcomes for case 2.
As two of the dice show '6' , it can happen in only one way. The third die shows a
different number, a number other than 6, and it can be any of the 5 other
numbers. Therefore, there will 5 possible options i.e. (1, 6, 6), (2, 6, 6), (3, 6, 6),
(4, 6, 6), (5, 6, 6).
However, each of these possibilities can have three different arrangements
depending upon where the third different digit appears. For example take (1, 6, 6)
case - it will have three options (1, 6, 6), (6, 1, 6), (6, 6, 1).
Therefore, the total number of events in which 2 of the dice will show '6' and one
will show a different number = 5*3 = 15 cases.
Case 3: When only one of the die shows '6' and the other two show numbers
other than '6'.
The die showing '6' has only one option. The other two dice can have any of the
'5' options. Therefore, the total number of possibilities = 1*5*5 = 25.
However, the die showing '6' can either be the first die or the second die or the
third die.
Therefore, there are a total of 25 * 3 = 75 possibilities.
Total possible outcomes where at least one die shows '6' = Case 1 + Case 2 +
Case 3 = 1 + 15 +75 = 91.
Therefore, the required probability = 91/216
Alternate approach:
Find the number of cases in which none of the digits show a '6'.
i.e. all three dice show a number other than '6', 5 * 5 *5 = 125 cases.
Total possible outcomes when three dice are thrown = 216.
The number of outcomes in which at least one die shows a '6' = Total possible
outcomes when three dice are thrown - Number of outcomes in which none of
them show '6'.
= 216 - 125 = 91.
The required probability = 91/216
2 When two dice are thrown simultaneously, what is the probability that the
sum of the two numbers that turn up is less than 11?
(1) 5 / 6
(2) 11 / 12
(3) 1 / 6
(4) 1 / 12
Correct Answer - (2)
Solution:
Instead of finding the probability of this event directly, we will find the probability
of the non-occurrence of this event and subtract it from 1 to get the required
probability.
Combination whose sum of 12 is (6,6)
Combinations whose sum of 11 is (5,6), (6,5).
Therefore, there are totally 3 occurrences out of 36 occurrences that satisfy the
given condition.
Probability whose sum of two numbers is greater than or equal to 11 = 3 / 36 =
1 / 12.
Hence probability whose sum of two numbers is lesser than 11 = 1 - 1 / 12 = 11 /
12.
3 The average monthly salary of 12 workers and 3 managers in a factory was
Rs. 600. When one of the manager whose salary was Rs. 720, was replaced with
a new manager, then the average salary of the team went down to 580. What is
the salary of the new manager?
Rs 570
Rs 420
Rs 690
Rs 640
Rs 610
Correct Answer - Rs 420. Choice (2)
Explanatory Answer
The total salary amount = 15 * 600 = 9000
The salary of the exiting manager = 720.
Therefore, the salary of 12 workers and the remaining 2 managers = 9000 - 720 =
8280
When a new manager joins, the new average salary drops to Rs.580 for the total
team of 15 of them.
The total salary for the 15 people i.e., 12 workers, 2 old managers and 1 new
manager = 580 *15 = 8700
Therefore, the salary of the new manager is 9000 - 8700 = 300 less than that of
the old manager who left the company, which is equal to 720 - 300 = 420.
An alternative method of doing the problem is as follows:
The average salary dropped by Rs.20 for 15 of them. Therefore, the overall salary
has dropped by 15*20 = 300.
Therefore, the new manager's salary should be Rs.300 less than that of the old
manager = 720 - 300 = 420.
Correct answer choice (2)
4 If the letters of the word CHASM are rearranged to form 5 letter words such
that none of the word repeat and the results arranged in ascending order as in a
dictionary what is the rank of the word CHASM?
(1) 24
(2) 31
(3) 32
(4) 30
Correct Answer - (3)
Solution:
The 5 letter word can be rearranged in 5! Ways = 120 without any of the letters
repeating.
The first 24 of these words will start with A.
Then the 25th word will start will CA _ _ _. The remaining 3 letters can be
rearranged in 3! Ways = 6. i.e. 6 words exist that start with CA.
The next word starts with CH and then A, i.e., CHA _ _. The first of the words will
be CHAMS. The next word will be CHASM.
Therefore, the rank of CHASM will be 24 + 6 + 2 = 32.
5 The time in a clock is 20 minute past 2. Find the angle between the hands of
the clock.
(1) 60 degrees
(2) 120 degrees
(3) 45 degrees
(4) 50 degrees
Correct choice (4). Correct Answer - 50 degrees
Solution:
Time is 2:20. Position of the hands: Hour hand at 2 (nearly).
Minute hand at 4
Angle between 2 and 4 is 60 degrees [(360/12) * (4-2)]
Angle made by the hour hand in 20 minutes is 10 degrees, since it turns through
½ degrees in a minute.
Therefore, angle between the hands is 60 degrees - 10 degrees = 50 degrees
6 .A 12% stock yielding 10% is quoted at:
A.Rs. 83.33
B.Rs. 110
C.Rs. 112
D.Rs. 120
Answer: Option DExplanation:
To earn Rs. 10, money invested = Rs. 100.
To earn Rs. 12, money invested = Rs.100x 12= Rs. 120.
10 Market value of Rs. 100 stock = Rs. 120
7 A and B take part in 100 m race. A runs at 5 kmph. A gives B a start of 8 m and
still beats him by 8 seconds. The speed of B is:
A.5.15 kmph
B.4.14 kmph
C.4.25 kmph
D4.4 kmph
Answer: Option BExplanation:
8 100 oranges are bought at the rate of Rs. 350 and sold at the rate of Rs. 48 per
dozen. The percentage of profit or loss is:
9 What was the day of the week on 28th May, 2006?
A.Thursday
B.Friday
C.Saturday
D.Sunday
Answer: Option DExplanation:
28 May, 2006 = (2005 years + Period from 1.1.2006 to 28.5.2006)
Odd days in 1600 years = 0
Odd days in 400 years = 0
5 years = (4 ordinary years + 1 leap year) = (4 x 1 + 1 x 2)  6 odd days
Jan. Feb. March April May
(31 + 28 + 31 + 30 + 28 ) = 148 days
148 days = (21 weeks + 1 day)  1 odd day.Total number of odd days = (0 + 0 + 6
+ 1) = 7  0 odd day.Given day is Sunday.
10 The H.C.F. of two numbers is 11 and their L.C.M. is 7700. If one of the
numbers is 275, then the other is:
A.279
B.283
C.308
D.318
Answer: Option C
Other number =11 x 7700 = 308.275
11 How many digits will be there to the right of the decimal point in the
product of 95.75 and .02554 ?
A.5
B.6
C.7
D.None of these
Answer: Option BExplanation:
Sum of decimal places = 7.
Since the last digit to the extreme right will be zero (since 5 x 4 = 20), so there
will be 6 significant digits to the right of the decimal point.
12 One pipe can fill a tank three times as fast as another pipe. If together the two
pipes can fill the tank in 36 minutes, then the slower pipe alone will be able to fill
the tank in:
A.81 min.
B.108 min.
C.144 min.
D.192 min.
Answer: Option CExplanation:
Let the slower pipe alone fill the tank in x minutes.
13 A man purchased a cow for Rs. 3000 and sold it the same day for Rs. 3600,
allowing the buyer a credit of 2 years. If the rate of interest be 10% per annum,
then the man has a gain of:
A 0%
B.5%
C.7.5%
D.10%
Answer: Option AExplanation:
C.P. = Rs. 3000.
S.P. = Rs.
3600 x 100
= Rs. 3000.
100 + (10 x 2)
Gain = 0%.
14 Find out the wrong number in the series.
6, 12, 48, 100, 384, 768, 3072
A.768
B.384
C.100
D.48
E.12
Answer: Option CExplanation:
Each even term of the series is obtained by multiplying the previous term by 2.
2nd term = (1st term) x 2 = 6 x 2 = 124th term = (3rd term) x 2 = 48 x 2 =
96.6th term = (5th term) x 2 = 384 x 2 =768. 4th term should be 96 instead of
100
15 David gets on the elevator at the 11th floor of a building and rides up at the
rate of 57 floors per minute. At the same time, Albert gets on an elevator at the
51st floor of the same building and rides down at the rate of 63 floors per minute.
If they continue travelling at these rates, then at which floor will their paths
cross ?
A.19
B.28
C.30
D.37
Answer: Option C

DELL PLACEMENT PAPER 2

DELL verbal ability practice questions
1. Read the Passage carefully and answer the questions given below
But I did not want to shoot the elephant. I watched him beating his bunch of
grass against his knees, with the preoccupied grandmotherly air that elephants
have. It seemed to me that it would be murder to shoot him. I had never shot an
elephant and never wanted to. (Somehow it always seems worse to kill large
animal.) Besides, there was the beast's owner to be considered. But I had got to
act quickly. I turned to some experienced-looking Burmans who had been there
when we arrived, and asked them how the elephants had been behaving. They all
said the same thing; he took no notice of you if you left him alone, but he might
charge if you went too close to him.
I. The author did not want to shoot the elephant because he
A. was afraid of it
B. did not have the experience of shooting big animals
C. did not wish to kill animal which was not doing anybody any harm
D. did not find the elephant to be ferocious
Ans-B
II. The phrase 'Preoccupied grandmotherly air' signifies
A. being totally unconcerned
B. pretending to be very busy
C. a very superior attitude
D. calm, dignified and affectionate disposition
Ans-D
III. From the passage it appears that the author was
A. an inexperienced hunter B. kind and considerate
C. possessed with fear D. a worried man
Ans-B
2. Read the passage carefully and answer the questions given below
In the world today we make health and end in itself. We have forgotten that
health is really means to enable a person to do his work and do it well. a lot of
modern medicine and this includes many patients as well as many physicians
pays very little attention to health but very much attention to those who imagine
that they are ill. Our great concern with health is shown by the medical columns
in newspapers. the health articles in popular magazines and the popularity of
television programmes and all those books on medicine. We talk about health all
the time. Yet for the most part the only result is more people with imaginary
illness. The healthy man should not be wasting time talking about health: he
should be using health for work. The work does the work that good health
possible.
I. A healthy man should be concerned with
A. his work which good health makes possible
B. looking after his health
C. his health which makes work possible
D. talking about health
Ans-A
II. The passage tells us
A. how medicine should be manufactured
B. what healthy man should or should not do
C. what television programmes should be about
D. how best to imagine illness
Ans-B
III. Talking about the health all time makes people
A. always suffer from imaginary illness
B. sometimes suffer from imaginary illness
C. rarely suffer from imaginary illness
D. often suffer from imaginary illness
Ans-D
IV. The passage suggests that
A. health is an end in itself
B. health is blessing
C. health is only means to an end
D. we should not talk about health
Ans-C
3. Read the passage carefully and answer the questions given below
At this stage of civilisation, when many nations are brought in to close and vital
contact for good and evil, it is essential, as never before, that their gross
ignorance of one another should be diminished, that they should begin to
understand a little of one another's historical experience and resulting mentality.
It is the fault of the English to expect the people of other countries to react as
they do, to political and international situations. Our genuine goodwill and good
intentions are often brought to nothing, because we expect other people to be like
us. This would be corrected if we knew the history, not necessarily in detail but in
broad outlines, of the social and political conditions which have given to each
nation its present character.
I. The need for a greater understanding between nations
A. was always there B. is no longer there
C. is more today than ever before D. will always be
there
Ans-C
II. The character of a nation is the result of its
A. mentality B. cultural heritage
C. gross ignorance D. socio-political conditions
Ans-D
III. According to the author his countrymen should
A. read the story of other nations
B. have a better understanding of other nations
C. not react to other actions
D. have vital contacts with other nations
Ans-B
IV. Englishmen like others to react to political situations like
A. us B. themselves
C. others D. each others
Ans-D
4. Read the passage carefully and answer the questions given below
The strength of the electronics industry in Japan is the Japanese ability to
organise production and marketing rather than their achievements in original
research. The British are generally recognised as a far more inventive collection
of individuals, but never seem able to exploit what they invent. There are many
examples, from the TSR Z hovercraft, high speed train and Sinclair scooter to the
Triumph, BSA and Norton Motorcycle which all prove this sad rule. The Japanese
were able to exploits their strengths in marketing and development many years
ago, and their success was at first either not understood in the West or was
dismissed as something which could have been produced only at their low price.
They were sold because they were cheap copies of other people's ideas churned
out of a workhouse which was dedicated to hard grind above all else.
I. It is evident from the passage that the strength of a country's industry depends
upon
A. original research B. international cooperation
C. dedicated workforce D. electronic development
Ans-C
II. According to the passage, prosperity in industry depends upon
A. productivity B. inventiveness
C. marketing ability D. official patronage
Ans-C
III. The main theme of this passage is
A. electronic industry in Japan
B. industrial comparison between Japan and Britain
C. the role of marketing efficiency in industrial prosperity
D. the importance of original research in industry
Ans-C
5. Read the passage carefully and answer the questions given below
Piccadilly Circus was full of loneliness.It seethes and echoes with it. To live near
it. Looking down on it is a discomforting exercise. You can't feel the pulse of
London here, though people expect to. To Londoners it is a maddening
obstruction between one place and another, and few voluntarily linger there. The
only locals are those who live off the lingerers; the lingerers are primarily
sightseers, with a fair sprinkling of people hoping to draw attention to themselves
- both typically from the provinces. They have come to see the heart of London
and expect to see spectacle, glamour and vice.
I. Piccadilly circus is
A. the name of a circus company
B. a lonely and resounding old building
C. a centrally located area in London
D. a huge heap of ruins
Ans-C
II. The passage implies that
A. some Londoners love to spend their time near the Piccadilly
circus
B. Piccadilly circus is a hazardous place
C. no Londoner wants to be in Piccadilly circus
D. Piccadilly circus is place of vice
Ans-B
III. According to this passage, people from outside London go to Piccadilly circus
because it is
A. a historical place B. full of glamour
C. full of exciting people D. the pulse of London
Ans-B
Computer hardware
1. How many devices can be used on a single SCSI bus? Keep in mind that the
SCSI host adapter counts as a device.
A. 1
B. 8
C. 20
D. 10
E. All of the above
Ans-B
2. To install a second IDE drive into a computer, you must:
A. Set the master-slave jumper to slave on the second drive
B. Use the IDE configuration software to set the new drive as slave
C. Verify that you define the new drive as D: in the CMOS setup
D. Verify that you attach the drive to the connector at the end of the ribbon
cable
E. None of the above
Ans-A
3. In ROM BIOS, the acronym BIOS stands for:
A. Basic Intuitive Output Set
B. Basic Input Organizational System
C. Basic Input Output System
D. Basic Industry Operating System
E. None of the above
Ans-C
4. How many pins on a VGA?
A. 15.
B. 9
C. 25
D. 32
E. None of the above
Ans-A
5. What is modified when changing the system start-up boot sequence?
A. BIOS/CMOS
B. CONFIG.SYS
C. autoexec.bat
D. COMMAND.COM
E. None of the above
Ans-A
6. Which is NOT typically a Field Replaceable Unit?
A. System ROM
B. Power supply
C. System chassis
D. Video controller
E. None of the above
Ans-C
7. What are the most likely conditions for ESD?
A. Cold and wet
B. Cold and dry
C. Hot and wet
D. Hot and dry
E. None of the above
Ans-B
8. Which type of cable is most likely in use with rj-45 connectors?
A. 10base2
B. 10base5
C. 10baseT
D. 10baseFL
E. None of the above
Ans-C
9. Which controller would support an external CD-ROM drive?
A. ESDI
B. ARLL
C. MFM
D. SCSI
E. None of the above
Ans-D
10. You should never put floppy drives, hard drives, or even VCR tapes or
cassette tapes on top of speakers (or near any other source of magnetism)
because of:
A. RFI
B. EMI
C. EXE
D. FYI
E. IOU
Ans-B
11. RS-232 is a standard that applies to?
A. Parallel port
B. Serial port
C. Game port
D. All of the above
E. None of the above
Ans-B
12. How would you allow device drivers and TSR's to be loaded into Upper
Memory Blocks ?
A. DOS=High
B. devicehigh=
C. loadhigh=
D. DOS=UMB
E. None of the above
Ans-D
13. RTS stands for:
A. ready to start
B. ready to switch
C. request to send
D. request to scan
E. ready to set
Ans-C
14. What can you use to ensure power is not interrupted, resulting in corrupted
data?
A. UPS
B. Proper grounding
C. Surge protector
D. Nuclear powered thermal protective underwear
E. None of the above
Ans-A
15. MSD exe does not have information on:
A. cache
B. video
C. operation system
D. com ports
E. None of the above
Ans-A
16. The standard IRQ for the floppy drive is?
A. 9
B. 6
C. 10
D. All of the above
E. None of the above
17. Ans-B
To find out how much memory is available, you could type _____
A. EMM
B. MEM
C. CHKDSK
D. MEMMAKER
E. None of the above
Ans-B
18. A PC with a 486DX2 processor runs internally at SOMhz. What speed would
its external logic be running?
A. l0Mhz
B. 25Mhz
C. 50Mhz
D. 100 Mhz
E. None of the above
Ans-B
19. Upper Memory blocks are located where?
A. Conventional Memory
B. Extended Memory
C. Expanded memory
D. Reserved Memory
E. None of the above
Ans-D
20. Which of the following are SCSI issues?
A. unique id settings
B. limited cable length
C. parity
D. passive termination
E. active termination
Ans-A
21. What is the name of the printed circuit board?
22. How much data will a high density (HD) floppy disk hold?
23. After trying to unload a TSR, you get an error message saying that other
TSRs were loaded after the one you tried to remove. Which of the following
commands could you use to see the current load order?
A. MEM /P
B. MEMMAKER
C. MEM /C (A SYS:
D. None of the above
Ans-C
24. IDE cables have how many pins?
A. 25 B. 50
C. 100 D. 40
E. 65
Ans-D
25. The DC voltage on most circuit boards is:
A. -12 volts
B. 0 volts
C. +5 volts
D. +12 volts
E. None of the above
Ans-C

DELL PLACEMENT QUESTIONS

Dell Written test-software Engineer Trainee
Note : Answer all Questions in Section I, I and III maximum correct attempts in
this section will be qualified
Section I : Programming
Answer any 5 of the following
1. Write a program that ask for user input from 5 to 9 then calculate the average
2. Implement strcat {} function with out using string function and optimize the
function for speed and space
3. Write a function to reverse a linked list
4. Write a recursive function to get the factorial of a given number only if it is
prime
5 Write a C++ programme without using any loop {if,for,while etc}to print number
form 1 to 1-- and 100 to 1
6. Write a programme to Exchange two number without using a temporary
variable
7 Write a function to find if the given number is a power of 2
8. Write a function in 2 different ways that will return f{7} = 4 and f (4) = 7
9. Write a function to remove duplicates in array
10. convert integer number in binary without loops
Section II -Oops
1. What are the main features of OOPS ? Explain them briefly
2. What is a virtual function ? Explain with an example?
3. What is the difference between overloading and overriding?
4. In inheritance explain the public private protected modifiers behaviors on data
members.
5 What is a factory method, give reference to any example class
Section III : analytical
1..If you have a 5 liter and a 3 liter measuring can, how would you measure
exactly 4 liters of liquid?
2 Suppose you had 8 billiard balls, and one of them was slightly heavier, but the
only way to tell was by putting it on a scale against another. What's the fewest
number of times you'd have to use the scale to find the heavier ball?
3 a magical pond has one lotus flower in it begin with. At the end of every day
the number of flowers doubles. It takes 30 days to fill the complete pond.. How
many days will it take to fill half the pond with lotus flowers?
4 In an analog clock how many days each day do both the hour hand and minute
hands overlap?
5.. There is a room with a door {closed} and three light bulbs. Outside the room
there are three switches connected to the bulbs. You may manipulate the
switches as you wish, but once you open the door you cant change them. Identify
each switch with its bulb
Section IV Fundamentals
1. What is composition and aggregation?
2 What is the difference between pointers and references? why?
3. What is the order of calling of constructors and destructors in class hierarchy?
Explain
4. What is RITI?
5. difference between array, vector,list and dequeue?
6. Explain "Passing by value","passing by pointer" and "passing by reference"?
7. what is the difference between thread ad a processing are the used?
8. What is the difference between heap and stack memory? when are they used?
9. Implement a algorithm to sort an array?
10. Explain pre-order,post-order and in-order binary tree traversal?
11 What is the difference between char a [] ="string";and char .p ="star";?
12 What is the difference between union and struct?
13 Explain compling and linking in brief?
14 What is a DLL? Explain a few advantages of using DLL's.
15 What is an interrupt?
16. What is the difference between UDP and TCP protocols?
17. Explain in brief Client Server technology?
18 How will you get the no. of instances created for a class from within the
class?
19 What are RAM and ROM also explain difference between them?
20 What is the difference between HTTP GET and HTTP Post?Explain

ISRO QUESTION PAPER

1. How many NAND gates required to implement AB+CD+EF
ANS. 4

2. Transparent latch is seen in which type of flip flop
ANS. D flip-flop.

3. Odd parity generator uses which logic?
1. Digital     2.Analog     3. Sequential     4.none

4. One question based on Ripple counter.

5. Which diagram corresponds to D-flip-flop?

6. Which type of ADC is fastest?
ANS-flash/Parallel

7. Which one of the following is fastest read/writable memory?
1. PROM 2. EEPROM 3. Flash 4.none

8. In array programming which one is used
1. SISD 2. PISD 3. MISD 4. None

9. DSP uses the computer architecture derived from- 4 options. I don?t remember.

10. Solve ?(t2?(t-2)dt ?

11. they given the Bargraph and asked to find the voltage from it?

12.find laplace transform of e-2t?
ANS- 1/s+2.

13. Which one of the following is correct-4 options i dont remember?

14. Given VSWR=2 find reflection coefficient?
ANS-1/3

15.There are 2 seats to fill in a office a wife and husband came for the interview. For overall competition the probability of a wife to get selected is 1/7. The probability of husband to be selected is 1/5. Then find the probability of either wife/husband to get selected?
16.given matrix 4 -3 -3
1 0 1
-5 -5 x find x?

17. Find the differential equation of y=Ae3x+Be2x ?

18. one problem based on determination of resistance and one on inverting and non inverting Amplifier.

19. two Questions based on capacitor and one question based on inductance?

20. The Unit step signal is given to inductance what is the output?

21. what is the difference b/w switch and HUB?
1. switch avoids flooding
2. HUB stops broadcasting.

22. one question related to Energy signal and time signal (Depending on amplitude and Phase)?

23.a question related to switch to find resistance if switch is closed?

24. A question based on SI and GE?

25. one question based on Enhancement MOSFET?

26. problem to find Iceo?

27.what is the advantage of using 4 diodes in Bridge rectifier compared to full wave rectifier?

28. Question related to PIV of bridge rectifier compared to Full wave rectifier?

29.Which one of the following has high I/p impedance
1. CC     2. CB     3. CE     4. None

30. one question based on FET And JFET?

31. where does operating point located in B type power amplifier?

32. which type of power amplifier is used in satellite communication
1.Amplitron     2. Klystron     3. Magnetron     4. TWT

33. de-emphasis is used to
1. Attenuate low signals.
2. Attenuate High signals.
3.Attenuate middle signals.
4. none.

34. Envelope detector is an .....? Ans- Asynchronous detector.

35.which one of the following produce modulated signal as i/p signal?
1. FM     2. PM     3. AM     4. None

36. they asked to find the gain? Given o/p power and i/p power.-4 options

37. Asked a question from EMfield on HEBD something.. i dont rem...?

38. find the modulous of 1+cosA+isinA?
I like to give advise to every one, dont refer only to these questions its better to see all the topics which i mentioned and best to follow GATE material (GK publications).