Showing posts with label veirzon. Show all posts
Showing posts with label veirzon. Show all posts

Sunday, June 8, 2008

paper 5

RDBMS

1) When a single entity is related to itself then the relationship is termed as

A) ONE -TO-ONE
B) ONE-TO-MANY
C) RECURSIVE
D) MANY-TO-MANY
2) means allowing objects of different types to be considered as examples of higher level set

A) AGGREGATION
B) SPECIALIZATION
C) GENERALIZATION
D) DECOMPOSITION

3) The primary characteristic of a key field as that it must be

A) A NAME
B) TEXT
C) UNIQUE
D) ALL OF THE OTHER OPTION LISTED FOR THIS QUESTION

4) What kind of relationship exist between customers and salespersons if each customer may have one or more salespersons, and each salesperson may have one or more customers?

A) one-to-one
B) one to many
C) many to many
D) many to one

5) The following is a valid SET operation.

A) Join
B) Insert
C) Select
D) Difference

6) means allowing objects of different types to be considered as example of a higher level set.

A) Aggregation
B) Specialization
C) Generalization
D) Decomposition

7) A relation R is said to be in the , if it is in BCNF and there are non-trivial multi valued dependencies.

A) 1st NF
B) 2nd NF
C) 3rd NF
D) 4th NF
8) A occurs when a weak entity does not have a candidate key and its instances are indistinguishable without a relationship with another entity.

A) Existence dependency
B) Identifier dependency
C) Referential dependeny
D) None of the other option listed for this question
9) is / are sample(s) of data model.

A) Relational
B) Rational
C) Entity- relationship
D) None of the other option listed for this question
10) In hierarchical database,

A) There is one to many relationship
B) A child may have more than one parent
C) A parent may have more than one child
D) There is no restriction on the number of parents a child may have or the number of children a parent may have

11) The term "inner join" refers to:

A) Joins between two tables in the same schema.
B) An equality join based on one column from each table.
C) A table joined with itself.
D) A Cartesian product join.

12) Which type of join is used in this query?

SELECT last_name "Name", hire_date "Hire Date", loc "Location"

FROM employee, department

WHERE employee.deptno = department.deptno.

A) Outer join
B) Self join
C) Equijoin
D) Non-equijoin

13) A sales database has two table - SALESPERSON and CUSTOMERS as below:

SALESPEOPLE

snum NUMBER

sname VARCHAR2(10)



CUSTOMER

snum NUMBER

cname VARCHAR2(10)


The management wants to know the mapping of salespersons to their customers without excluding those salespersons that are not currently assigned. What would be the most appropriate condition, which can be applied on the Query to accomplish the above task?

A) salespeople.snum(+) = customers.snum
B) salespeople.snum = customers.snum(+)
C) salespeople.snum = customers.snum
D) salespeople.snum(+) = customers.snum(+)

14) join returns those rows from a table which have no direct match in the other table.

A) Outer join
B) inner join

C) Equijoin

D) Self join

15) To produce a meaningful result set without any Cartesian products, what is the minimum number of conditions that should appear in the WHERE clause of a four table join?

A) 1
B) 4
C) 2
D) 8
Further there were question from MATHS (in aptitude section), testing the working knowledge of WIN NT (how to change the page file size etc), then general terms related to computers like WORM, Trojan Horse etc.

paper 4

Section I - Unix Programming
1) works as a command interpretorA) Hardware B) Kernal C) Shell D) CPU
2) The major no for a floppy disk device is A) 1 B) 3 C) 2 D) 43) chown
A) Changes the mode of operation to kernel modeB) Creates a threadC) Changes the users and/or group ownership of each given fileD) Creates a child process
4) lilo
A) Uninstalls the boot loaderB) Installs the boot loaderC) Is a login utilityD) Invokes a daemon to logoff
5) netdevice
A) Provides low level access to Linux network devicesB) Provides low level access to Linux storage devicesC) Provides an interface to communicate with graphic devicesD) None of the other option listed for this question
6) The process which terminates before the parent process exits, is called as
A) ZombieB) OrphanC) ChildD) None of the other option listed for this question
7) Context switch means
A) Kernel switches from executing one process to another.B) Process switches from kernel mode to user mode.C) Process switches from user mode to kernel mode.D) None of the other option listed for this question
8) The following socket provides two way, sequenced, reliable and unduplicated flow of data with no record boundaries.
A) Sequential packet socketB) Datagram socketC) Stream socketD) Raw socket
9) Identify the point(s) that is not true w.r.t. signals
A) Signals are software generated interrupts that are sent to a process when an event happensB) Signal delivery is analogous to hardware interrupts in that a signal can be blocked from being delivered in the future.C) Most signals are synchronous by nature.D) Most signal cause termination of the receiving process if no action is taken by the process in response to the signal.
10) Identify the point(s) that is true wrt Semaphore
A) Only one process at a time can update a semaphore.B) All the other options listed for this quetionC) They are often used to monitor and control the availability of system resources such as shared memory segments.D) Is a process with exclusive use of a semaphore terminates abnormally and fails to undo the operation or free the semaphore, the semaphore stays locked in the state the process left it.

paper 3

VERIZON DATA PAPER HELD IN CUSAT 21 MAY 2004
test consist 4 section for each section there will be specific time limit n after time limit question paper collected by the invigilatorfirst section(25 question time 15 min. )
this section is dam easy .anyone solve it before the time it consist 2 type of questionfirstone is fill in the blanks (mostly abt the article, verb n noun)go through any grammar booksecond one is abt the passage ( 2 passage)simle passage..many pepole do it without reading the passagebecause the passage is based on DBMS n JAVA I also do it without reading…
second section (like bank apptitude 20 min. )
this section is also dam easyit consist questin like bank apptitude testmainly question based upon matchingfor this section u no need prepration
third section(quantitaive apptitude n logical reasoning min 35 )this section consist 25 question
simple airthmetic question .n logical reasoning logic like banking paper coding, manipulation, arithmetic etc
one question abt cube n dice (quite tough) that is given belowone hundred and twenty five small cube of equal size are arranged in a solid pile of dimension 5*5*5 .Then from one corner one cube is removed from the top.From the opposite corner 8 cubes(2*2*2)r removed from the third corner a column of three cubes and from the fourth corner a column of 4 cubes r removed the remaining solid r coloured red on all the exposed faces...
1. how many cubes in the secomd layer fron the top do not have any coloured faceans : 6
2: how many cubes in the third layer have at least two coloured faces eachans :8
3: how many cubes in the fourth layer from the top have only one colour face each..ans :10
4: how many cubes in the bottom layer have at least one coloured face eachans :16
5: how many cubes in the top four layers taken together have only one coloured face eachans:29
6: how many cubes donot have any colour face ans : 32
7: how many cubes have three colour faces eachans :12
8:how many cubes have only two colour faces each?ans :24
9:how many cubes have only one colour faces each?ans : 41
10:how many cubes are there in the top layer ?ans : 18
but remaining question were easy
fourth section(technical) 15 question 20 minabt 25 question (tough one)based on c programsBFS,DFS,Pointer concet,Linklist,Queue,stack etc
there is no negative marks for the wrong question ...so attempt as much as possible n guess the left question i qualified for the interview i. attempt 75% correctly my rank is 11 here that person who toped here attemt around 75-80 % paper
for written test try to get more marks bcas they select merit basisnot cut off basisprepare only technical section
ABOUT INTERVIEW
only one interview ..technical as well as HR ....
Panel consist only two person one tech and other r HRPrepare well for HR ....prepare all the question and counter question before the interview ....

paper 1

Why paging is used ?

Which is the best page replacement algo and Why ?

WHat is software life cycle ?

How much time is spent usually in each phases and why ?

What is testing ?

Which are the different types of testing ?

Which are the different phases in Software life cycle (asked again)

Why is analysis and testing phases very important ?

Why networks are layered ? What is the advantage of that ?

How many layers are there in OSI ? Why is it called OSI model ?

network topologies ?

Which are the different network toplogies ?

an example of bus type network.

What is the Bandwidth of ethernet ?

Explain the advantage and disadvantage of ethernet ?

Which is the protocol used in ethernet. (CSMA/CD) Why is it called so ?

What is the advantage of Ring network ?

Compare it with ethernet.

What is inheritance, encapsulation etc.

If there are too many page faults what is the problem?

To ensure one pgm. doesnt corrupt other pgm. in a Multi-pgm. enviornment

what you should do?

Which one you will use to implement critical section? Binary Semaphore

Which one is not needed for Multi-pgm. enviornment?

options are: virtual memory,security,time sharing,none of the above.

Which one is not done by Data link layer ? bit stuffing, LRC,CRC,parity check


Which one is not related to Data link layer?

Which one is not suitable for client-server application? tcp/ip,message passing,rpc,none of the above.

Term stickily bit is related to a)kernel b)undeletable file c) d)none

semaphore variable is different from ordinary variable by ?

unix system is

a)multi processing

b)multi processing ,multiuser

c)multi processing ,multiuser,multitasking

d)multiuser,multitasking

x.25 protocol encapsulates the follwing layers

a)network

b)datalink

c)physical

d)all of the above

e)none of the above

TCP/IP can work on

a)ethernet

b)tokenring

c)a&b

d)none

a node has the ip address 138.50.10.7 and 138.50.10.9.But it is

transmitting data from node1 to node2only. The reason may be

a)a node cannot have more than one address

b)class A should have second octet different

c)classB " " " " "

d)a,b,c

the OSI layer from bottom to top

for an application which exceeds 64k the memory model should be

a)medium

b)huge

c)large

d)none

the condition required for dead lock in unix sustem is

set-user-id is related to (in unix)

bourne shell has

a)history record

b)

c)

d)
wrong statement about c++

a)code removably

b)encapsulation of data and code

c)program easy maintenance

d)program runs faster
which is true
a)bridge connects dissimiler LAN and protocol insensitive

b)router " " " " "

c)gateway " " " " "

d)none of the above

const char *

char * const

What is the differnce between the above tow?.

In Unix inter process communication take place using?.

About i-node numbers

Max relaxable permisssion value with out giving write permission to others?.

About ln(linking)

Linking across directories?.

process id for kernell process

very first process created by kernell

function to repaint a window immediately?.

Function entry for DLL in win3.1

win 3.1 is a

win 3.1 supports which type of multi tasking?.

Message displayed when a window is destroyed

About fork()?

About send message and post message

Message to limit the size of window

System call executable binary file intoa process

About GDI object?.

API used to hide window

Initialize contents of a dialog?.

----------------C SKILL SET-------

How do you write a program which produces its own source code as its output?
How can I find the day of the week given the date?
Why doesn't C have nested functions?
What is the most efficient way to count the number of bits which are set in a value?
How can I convert integers to binary or hexadecimal?
How can I call a function, given its name as a string?
How do I access command-line arguments?
How can I return multiple values from a function?
How can I invoke another program from within a C program?
How can I access memory located at a certain address?
How can I allocate arrays or structures bigger than 64K?
How can I find out how much memory is available?
How can I read a directory in a C program?
How can I increase the allowable number of simultaneously open files?
What's wrong with the call "fopen("c:\newdir\file.dat", "r")"?

Verizon 2004 paper.

Verizon 2004 paper.

Section I - Unix Programming

1) works as a command interpretor

A) Hardware B) Kernal C) Shell D) CPU

2) The major no for a floppy disk device is
A) 1 B) 3 C) 2 D) 4

3) chown
A) Changes the mode of operation to kernel mode
B) Creates a thread
C) Changes the users and/or group ownership of each given file
D) Creates a child process

4) lilo
A) Uninstalls the boot loader
B) Installs the boot loader
C) Is a login utility
D) Invokes a daemon to logoff

5) netdevice
A) Provides low level access to Linux network devices
B) Provides low level access to Linux storage devices
C) Provides an interface to communicate with graphic devices
D) None of the other option listed for this question

6) The process which terminates before the parent process exits, is
called
as
A) Zombie
B) Orphan
C) Child
D) None of the other option listed for this question

7) Context switch means
A) Kernel switches from executing one process to another.
B) Process switches from kernel mode to user mode.
C) Process switches from user mode to kernel mode.
D) None of the other option listed for this question

8) The following socket provides two way, sequenced, reliable and
unduplicated flow of data with no record boundaries.
A) Sequential packet socket
B) Datagram socket
C) Stream socket
D) Raw socket

9) Identify the point(s) that is not true w.r.t. signals
A) Signals are software generated interrupts that are sent to a process
when
an event happens
B) Signal delivery is analogous to hardware interrupts in that a signal
can
be blocked from being delivered in the future.
C) Most signals are synchronous by nature.
D) Most signal cause termination of the receiving process if no action
is
taken by the process in response to the signal.

10) Identify the point(s) that is true wrt Semaphore
A) Only one process at a time can update a semaphore.
B) All the other options listed for this question
C) They are often used to monitor and control the availability of system
resources such as shared memory segments.
D) Is a process with exclusive use of a semaphore terminates abnormally
and
fails to undo the operation or free the semaphore, the semaphore stays
locked in the state the process left it.
RDBMS

1) When a single entity is related to itself then the relationship is
termed
as
A) ONE -TO-ONE
B) ONE-TO-MANY
C) RECURSIVE
D) MANY-TO-MANY

2) means allowing objects of different types to be
considered
as examples of higher level set
A) AGGREGATION
B) SPECIALIZATION
C) GENERALIZATION
D) DECOMPOSITION

3) The primary characteristic of a key field as that it must be
A) A NAME
B) TEXT
C) UNIQUE
D) ALL OF THE OTHER OPTION LISTED FOR THIS QUESTION

4) What kind of relationship exist between customers and salespersons if
each customer may have one or more salespersons, and each salesperson
may
have one or more customers?
A) one-to-one
B) one to many
C) many to many
D) many to one

5) The following is a valid SET operation.

A) Join
B) Insert
C) Select
D) Difference

6) means allowing objects of different types to be
considered
as example of a higher level set.
A) Aggregation
B) Specialization
C) Generalization
D) Decomposition

7) A relation R is said to be in the , if it is in BCNF and
there are non-trivial multi valued dependencies.
A) 1st NF
B) 2nd NF
C) 3rd NF
D) 4th NF

8) A occurs when a weak entity does not have
a
candidate key and its instances are indistinguishable without a
relationship
with another entity.
A) Existence dependency
B) Identifier dependency
C) Referential dependency
D) None of the other option listed for this question

9) is / are sample(s) of data model.
A) Relational
B) Rational
C) Entity- relationship
D) None of the other option listed for this question

10) In hierarchical database,
A) There is one to many relationship
B) A child may have more than one parent
C) A parent may have more than one child
D) There is no restriction on the number of parents a child may have or
the
number of children a parent may have

11) The term "inner join" refers to:
A) Joins between two tables in the same schema.
B) An equality join based on one column from each table.
C) A table joined with itself.
D) A Cartesian product join.

12) Which type of join is used in this query?

SELECT last_name "Name", hire_date "Hire Date", loc "Location"
FROM employee, department
WHERE employee.deptno = department.deptno.
A) Outer join
B) Self join
C) Equijoin
D) Non-equijoin

13) A sales database has two table - SALESPERSON and CUSTOMERS as below:

SALESPEOPLE
------------------------------------------------------
snum NUMBER
sname VARCHAR2(10)

CUSTOMER
------------------------------------------------------
snum NUMBER
cname VARCHAR2(10)

The management wants to know the mapping of salespersons to their
customers
without excluding those salespersons that are not currently assigned.
What
would be the most appropriate condition, which can be applied on the
Query
to accomplish the above task?

A) salespeople.snum(+) = customers.snum
B) salespeople.snum = customers.snum(+)
C) salespeople.snum = customers.snum
D) salespeople.snum(+) = customers.snum(+)

14) join returns those rows from a table which have
no
direct match in the other table.

A) Outer join
B) inner join
C) Equijoin
D) Self join

15) To produce a meaningful result set without any Cartesian products,
what
is the minimum number of conditions that should appear in the WHERE
clause
of a four table join?

A) 1
B) 4
C) 2
D) 8


Further there were question from MATHS (in aptitude section), testing
the
working knowledge of WIN NT (how to change the page file size etc), then
general terms related to computers like WORM, Trojan Horse etc.

Verizon consists of 4 sections.

Verizon consists of 4 sections.

1.general English(20)
2.analytical ability(25)
3.mental ability(20)
4.c&ds bits(10)

total marks 75.duraton 1&1/2 hours,
I remember some bits,test code is 953.all r having same set,if ur test match the same code.then follow

English:
prepositions r of 10M.
2 comprehension passages ,each of 5 M

anylytical:
1.some questions on set theory i.e 220peoples know English,150 know French,both 85 then we have to find Aunion B
2.there r 11 members in which 5 couples&1bachelor is there,they have to sit in one row
such that no 2 mens r sit together(ans is 6!5!)
3.qn on directions (ans is N-W position)

mental ability:
this section is very easy but time factor is imp.qns like
we have to caluculate *,/,+.- operations
and there r some passages.
One is on to become Quiz master ,selection procedure is there.qns asked
Ans are 1.data insufficient
2,written test eligible
3.rejected

technical:

1,int x[]={1,3,5,7,9,11}
int *ptr,
ptr=x;
for(I=0;I < 6,I++)
prints("%d",*(ptr+I)0;
printf('\n");
for(I=0,I < 6,I++)
(ptr+I)=*(ptr+I)+1;
printf('%d",*(ptr+I)0;
ans is 1,3,5,7,9,11
2,4,6,8,10,12

one qn on command line arguments
one qn o/p is "digits in words"(b)
int f(int x)
{
int I,j=0;
if(x==0)
rteturn 1;
for(I=0;I < x/2;I++)
j=j+f(i);
return j;
}
write o/p?
char *buff="1234"
int atoi(char s[])
for(I=0;s[I]!=null;I++)
n=n*10+(s[I]-'0');
return n;
}this is the ans for one qn.

qn on connected graph,which one is right
find node 'accentricity'
infix order ans is left,root,right

paper 2

1) When a single entity is related to itself then the relationship is termedas A) ONE -TO-ONEB) ONE-TO-MANYC) RECURSIVED) MANY-TO-MANY
2) means allowing objects of different types to be consideredas examples of higher level setA) AGGREGATIONB) SPECIALIZATIONC) GENERALIZATIOND) DECOMPOSITION
3) The primary characteristic of a key field as that it must beA) A NAMEB) TEXTC) UNIQUED) ALL OF THE OTHER OPTION LISTED FOR THIS QUESTION
4) What kind of relationship exist between customers and salespersons ifeach customer may have one or more salespersons, and each salesperson mayhave one or more customers?A) one-to-oneB) one to manyC) many to manyD) many to one
5) The following is a valid SET operation.
A) JoinB) InsertC) SelectD) Difference
6) means allowing objects of different types to be consideredas example of a higher level set.A) AggregationB) SpecializationC) GeneralizationD) Decomposition
7) A relation R is said to be in the , if it is in BCNF andthere are non-trivial multi valued dependencies.A) 1st NFB) 2nd NFC) 3rd NFD) 4th NF
8) A occurs when a weak entity does not have acandidate key and its instances are indistinguishable without a relationshipwith another entity.A) Existence dependencyB) Identifier dependencyC) Referential dependencyD) None of the other option listed for this question
9) is / are sample(s) of data model.A) RelationalB) RationalC) Entity- relationshipD) None of the other option listed for this question
10) In hierarchical database,A) There is one to many relationshipB) A child may have more than one parentC) A parent may have more than one childD) There is no restriction on the number of parents a child may have or thenumber of children a parent may have
11) The term "inner join" refers to:A) Joins between two tables in the same schema.B) An equality join based on one column from each table.C) A table joined with itself.D) A Cartesian product join.
12) Which type of join is used in this query?
SELECT last_name "Name", hire_date "Hire Date", loc "Location"FROM employee, departmentWHERE employee.deptno = department.deptno.A) Outer joinB) Self joinC) EquijoinD) Non-equijoin
13) A sales database has two table - SALESPERSON and CUSTOMERS as below:
SALESPEOPLEsnum NUMBERsname VARCHAR2(10)
CUSTOMERsnum NUMBERcname VARCHAR2(10)
The management wants to know the mapping of salespersons to their customerswithout excluding those salespersons that are not currently assigned. Whatwould be the most appropriate condition, which can be applied on the Queryto accomplish the above task?
A) salespeople.snum(+) = customers.snumB) salespeople.snum = customers.snum(+)C) salespeople.snum = customers.snumD) salespeople.snum(+) = customers.snum(+)
14) join returns those rows from a table which have nodirect match in the other table.
A) Outer joinB) inner joinC) EquijoinD) Self join
15) To produce a meaningful result set without any Cartesian products, whatis the minimum number of conditions that should appear in the WHERE clauseof a four table join?
A) 1B) 4C) 2D) 8
16)Output of 'select Instr(Decode(str1,str2,-1)) from dual'A) B) C) D) were single digit numbers
MATHEMATICS
Quantitative -- Problems involoving Venn Diagrams , Completion of series etc. (30 MIN)Analytical -- Alligation or mixture problems, Problem on Ages(10 MIN)Verbal -- Two Comprehension passages, Antonym , Sentence completion(10 MIN)
Example for sentence completionI got ___________ in the traffica. stuck upb. struckc. Both a and bd. None of theseWINNT(10 MIN)
1. Which tag will you select for changing the page size?(below will be displayed a screen shot of CONTROL PANEL SETTINGS for changing the page size)Ans:Performance
NOTE: The questions in this section might contain multiple answers and you aresupposed to shade all the correct answers.C++(30 MIN)
TOPICS COVERED1. Input-output stream2.Templates3.Abstract classes4.Virtual Functions
Further there were question testing general terms related to computers like WORM, Trojan Horse etc.

paper 2

This is the pattern and paper for verizon in campus interview selection.i dont hv idea abt offcampus selection.
Pattern:
7 papers test for more than 2 hrs
1.analytical2.quantitative ability3.verbal4.c++5.windows NT6.RDBMS7.UNIX
next shortlisted candidates undergo technical and HR interviews
PAPER:
Verizon 2003 paper.
Section I - Unix Programming
1) __________ works as a command interpretor
A) Hardware B) Kernal C) Shell D) CPU
2) The major no for a floppy disk device supported by a PC is _______A) 1 B) 3 C) 2 D) 4
3) chown A) Changes the mode of operation to kernel modeB) Creates a threadC) Changes the users and/or group ownership of each given fileD) Creates a child process
4) liloA) Uninstalls the boot loaderB) Installs the boot loaderC) Is a login utilityD) Invokes a daemon to logoff
5) The process which terminates before the parent process exits, is called as A) ZombieB) OrphanC) ChildD) None of the other option listed for this question
6) Context switch means A) Kernel switches from executing one process to another.B) Process switches from kernel mode to user mode.C) Process switches from user mode to kernel mode.D) None of the other option listed for this question
7) The following socket provides two way, sequenced, reliable andunduplicated flow of data with no record boundaries.A) Sequential packet socketB) Datagram socketC) Stream socketD) Raw socket
8) Identify the point(s) that is not true w.r.t. signalsA) Signals are software generated interrupts that are sent to a process whenan event happensB) Signal delivery is analogous to hardware interrupts in that a signal canbe blocked from being delivered in the future.C) Most signals are synchronous by nature.D) Most signal cause termination of the receiving process if no action istaken by the process in response to the signal.
9) Identify the point(s) that is true wrt SemaphoreA) Only one process at a time can update a semaphore.B) All the other options listed for this questionC) They are often used to monitor and control the availability of systemresources such as shared memory segments.D) Is a process with exclusive use of a semaphore terminates abnormally andfails to undo the operation or free the semaphore, the semaphore stayslocked in the state the process left it.

Pattern:

Pattern:
7 papers test for more than 2 hrs
1.analytical2.quantitative ability3.verbal4.c++5.windows NT6.RDBMS7.UNIX
next shortlisted candidates undergo technical and HR interviews

7 papers test for more than 2 hrs
1.analytical2.quantitative ability3.verbal4.c++5.windows NT6.RDBMS7.UNIX
next shortlisted candidates undergo technical and HR interviews