CONVERGYS Technical Placement Paper - Questions from previous years
CONVERGYS Technical Placement Paper
Q. _______ performs as a command interpreter
a) Unix shell
b) kernel
c) demon
d) none of the above
Q. What is the output of the code
echo hello
Eval echo Hello
Eval echo eval Hello
Q. What does $* signify?
Q. Combine $x=1;[x -ge 10] into a single statement
Q. What is the difference between a member function and a constructor?
Q. Which statement is correct for DBMS?
a) Collection of interrelated data and set of programs are required to access that data
b) Collection of data and set of programs
c) Collection of inter related data and there is no need of any programs
d) Collection of data
Q. Value should be dependent on primary key in which of the following normalized form?
a) 1 NF
b) 2Nf
c) 3Nf
d) 4Nf
Q. What do you understand by View in Database theory? What are the advantages of view over table?
Q. What is the purpose of Normalisation?
a) Reducing redundancy
b) little storage space
c) make the data model more informative to users
d) all the above
Q. What r the types of joins below
a) self join
b) inner join
c) outer joins
d) all of the above
Q. How do you group data objects subject to constraints?
Q. What is the difference a structure and union?
Q. What is the difference between a class and a structure?
Q. What is Open Database Connectivity? What is an ODBC-to-JDBC bridge?
Q. The code to raise exceptions could be written in which block?
a) Catch
b) finally
c) try
d) none of the above
Q. What all keywords can be used to change the value after initialization?
Q. What is RDBMS?
Q. Why “ifstream” and “ofstream” are to be added to “std” while fstream can serve both the purposes?
Q. How the bourne is used shell under C shell
Q. What does $# signify?
Q. Relation of an entity with itself is known as
a) one to many
b) one to one
c) Recursive
d) None of the above
Q. A relation in RDBMS can exist between how many entities?
a) Minimum 2
b) At least 1
c) three
d) None of the above
Q. 5th Normal Form depends upon
a) Multivalued Dependencies
b) Functional Dependencies
Q. Which of the following is not true about the joint and the union
a) Union always acts upon columns
b) Join is always costlier than union
c) Union always acts upon rows
d) Join always acts upon columns
Q. In a Left outer joint operation what is returned
a) Right table returns NULL
b) Left table returns all rows
c) Right table returns all rows
d) both tables return all rows
Q. A function in a Class, by default, is
a) Virtual
b) Inline
c) Pure Virtual
d) None of these
Q. What would be the output of the following program?
#include
void main()
{
Int a= 320;
char*ptr;
ptr=(char*)&a;
printf(“%d”,*ptr);
getch();
}
Q. Which of the following are unary operations in context with relational algebra?
a) Union
b) Project
c) Select
d) Product
Q. Explain how a file name is given and how arrays are declared?
Q. Which one of the following is not a command in tcl?
a) COMMIT
b) ROLLBACK
c) SAVEPOINT
d) REVOKE
Q. Data redundancy may be reduced by which of the normalization forms?
a) 1nf
b) 2nf
c) Cod-normal
d) All of the above
Q. Which of the following is not a command of SQL?
a) Truncate
b) Insert
c) Delete
d) Remove
Q. What are the main features of Primary Key?
Q. How is a Foreign Key different from a Primary key?
Q. What do you understand by Inheritance in Object Oriented Programming?
Q. MERGE is a combination of
a) Insert and Delete
b) Insert and Update
c) Delete and Update
Q. What is a virtual member function?
Q. Cin and Cout are
a) Objects
b) class
c) keywords
d) methods
