Convergys Placement Question Paper 2017.
Online Mock Test Reasoning and Aptitude, GK etc- Free1) Which statement is true to dbms?
a) Collection of data
b) Collection of interrelated data and set of programs to access that data
c) Collection of inter related data no need of any programs
d) Collection of data and set of programs
Ans) b
2) Values should dependant on primary key in which normal form?
a) 1 NF b) 2nf c) 3nf d) 4nf
3) Mathematical representation of joining tables ———-
a) Union b) c) Cartesian product d)
4) A Question on view
5) Question on data objects and constraints
6) Use of normalization?
a) Reducing redundancy b) little storage space c) d) all the above
ANS)d
7) What r the types of joins below
A) Interior & outer b) inner and outer joins c) d)
Ans) b
The code that could be written in which block to raise exceptions?
A) Catch b) try c) finally d) none
Ans) b
2) Some programs on pointers some tricky questions
3) By using which keyword we can’t change value after initialization?
a) Int b) c) d) const
4) Class one
{
enum {name1,name 2, name 3}
}
Wt is the value of name 2
a) 0 b) 2 c) 1 d) 3
(this question is not full, like this only) ans) c
5) Which of the following is true for constructor?
a) b) c) d) constructor can not be inherited
1) which of the following is the correct declaration of a function pointer
2) how will u retrieve the value stored in pointer variable a
1.a
2.&a
3.*a
Ans : a
3) How to pass two arguments to a function prompted to by function pointer
a) g -> (1,2) b)*g(1,2) c)(*g)(1,2) d)g(1,2)
Ans: c) (*g)(1,2)
4) Encapsulation
a)Aggregation of member objects
b)Aggregation of member functions
c)Used to incorporate data hiding
Ans: c)
5) Float_ptr = new float[100]
In order to deallocate this memory use
a)delete float_ptr
b)delete [] float_ptr
c)delete float_ptr [100]
d)delete float_ptr []
Ans:b)
6) i = 12
int *p = &I;
print (“%d %d”, p/p,*p**p)
Output
a) 1144
b) 144144
c) O/p Error
d) Junk
Ans:c)
7) What is Virtual member function?
8) Cin, Cout are
a)Class
b)Objects
c)Methods
d)Keywords
Ans: objects
9) cout << ( cout << “Hello” )<< “World”
Ans: HelloWorld
10) i=0;
a = 1;
b = 4;
swap(int a, int b)
{
int temp;
temp = a;
a = b;
b = a;
i = 1;
}
Output
a)4 0 0
b)0 4 1
c)1 4 1
d)Error
Ans: 4 0 0
11)difference between member function and a constructor?
Ans: constructor cannot return value.
12)class B is the subclass of class A.which of the following describes the relationship?
a)…..is a……
b)….has a…..
c)…..implemented as……
d)
1) How will u keep the exisiting values of a array when enlarging it
Ans : Using Redim Preserve
2) for i = 0 to 5
a[i] = i
print a[i]
next i
how would it get printed in the form?
1.012345
2.0
1
2
3
4
5
3.12345
4.1
2
3
4
5
Ans : guess the choice is 2
Note : the question is some what similar to this, have a look at how print stmt’s
result
would be
3) Resume used in conjunction with
a)On Error b)Error c)Error GOTO
Ans:On Error
4) Creating a new object using
a)New b) New, Create Object
c)New, Create Object, Set
d) New, CreateObject, Set Get Object
Ans: a) New
5) DIM x, y, z as Integer
Ans: X, Y variants, Z – Integer
6) Dim Counter;
For Counter = True to False
Print Counter
Next
Output :
a)Error msg b) True False c) -1 0 d) True
Ans: c) -1 0
7) Form load
textbox.text = “Hello”
on form load what all events will take place
a) Initialise b) Initialise, load c) Initialise, load, activate
d) Initialise, load, activate, validate
Ans: (c)
8) Connection object, command objection. How can u
associate both?
a)Set command object.activeconnection = connectionobject
9)some code segment was given (I don’t remember that) but the question was about
this statement.
Print A A (A is a variable)
How VB will react?
10) var1 is declared as global variable.proc1( ) and proc( ) have local variables.when
a call is made from proc1( ) to proc ( ) which are the variables will be displayed in
locals window?
11)how do u unregister a COM from registry?
Ans) I think the third option .the answer will start with regsvr32 /u …..
12)what will happen when Require Variable Declaration option is checked?
a) existing undeclared variables are converted to variant by VB
b) this comes into effect for the new code segment
13)A global module called global. as is creates. which part of the program can access
this module? The options were ambigous.be clear about the scope of the global. as
module and the application which access it
1) Combine $x=1;[x –ge 10] into a single statement
Don’t remember the options
2) cmd line1: prompt1= â€oeEmployee Idâ€
cmd line2:x=1
cmd line3:________________
Ans: eval $prompt$x
3) Wats the output of the code snippet
echo hello
Eval echo Hello
Eval echo eval Hello
Ans: hello
Hello
Hello
4) How to use the bourne shell under C shell
There were 4 options beginning with #!/bin/usr (something like this)
5) What does $# represent
6) What does $* represent
1) Relation of an entity to itself is known as
A) one to many B) one to one 3) Recursive 4)??
2) A relation in RDBMS can exist between_______ entities
A) min 2 B) Atleast 1 3)three 4)none of these
3) 5th Normal Form depends upon
A) Multivalued Dependencies B) Functional Dependencies C) ?? D) ??
4) Which of these is not TRUE abt the joint and the union
A) Join is always costlier than union
B) Union always acts upon columns
C) Union always acts upon rows
D) Join always acts upon columns
(The options were similar to this one not exactly these)
5)In a Left outer joint operation what will be returned
A) Left table returns all rows
B) Right table returns all rows
C) Both tables return all rows
D) Right table returns NULL
6) 1 Question on ODBC
1) A function in a Class by default is
A) Virtual B) Inline C) Pure Virtual D) None of these
Technical Interview Questions – Exchange 2003 1. Tell me a bit about the
capabilities of Exchange Server.
2. What are the different Exchange 2003 versions?
3. What’s the main differences between Exchange 5.5 and Exchange 2000/2003?
4. What are the major network infrastructure for installing Exchange 2003?
5. What is the latest Exchange 2003 Service Pack? Name a few changes in
functionality in that SP. 6. What are the disk considerations when installing Exchange
(RAID types, locations and so on).
7. You got a new HP DL380 (2U) server, dual Xeon, 4GB of RAM, 7 SAS disks, 64-bit.
What do you do next to install Exchange 2003? (you have AD in place)
8. Why not install Exchange on the same machine as a DC?
9. Are there any other installation considerations?
10. How would you prepare the AD Schema in advance before installing Exchange?
11. What type or permissions do you need in order to install the first Exchange
server in a forest? In a domain?
12. How would you verify that the schema was in fact updated?
13. What type of memory optimization changes could you do for Exchange 2003?
14. How would you check your Exchange configuration settings to see if they’re
right?
15. What are the Exchange management tools? How and where can you install
them?
16. What types of permissions are configurable for Exchange?
17. How can you grant access for an administrator to access all mailboxes on a
specific server?
18. What is the Send As permission?
19. What other management tools are used to manage and control Exchange 2003?
Name the tools you’d use.
20. What are Exchange Recipient types? Name 5.
21. You created a mailbox for a user, yet the mailbox does not appear in ESM. Why?
22. You wanted to change mailbox access permissions for a mailbox, yet you see the
SELF permission alone on the permissions list. Why?
23. What are Query Based Distribution groups?
24. What type of groups would you use when configuring distribution groups in a
multiple domain forest?
25. Name a few configuration options for Exchange recipients.
26. What’s the difference between Exchange 2003 Std. and Ent. editions when
related to storage options and size?
27. Name a few configuration options related to mailbox stores.
28. What are System Public Folders? Where would you find them?
29. How would you plan and configure Public Folder redundancy?
30. How can you immediately stop PF replication?
31. How can you prevent PF referral across slow WAN links?
32. What types of PF management tools might you use?
33. What are the differences between administrative permissions and client
permissions in PF?
34. How can you configure PF replication from the command prompt in Exchange
2003?
35. What are the message hygiene options you can use natively in Exchange 2003?
36. What are the configuration options in IMF?
37. What are virtual servers? When would you use more than one?
38. Name some of the SMTP Virtual Server configuration options.
39. What is a Mail Relay? Name a few known mail relay software or hardware
options.
40. What is a Smart Host? Where would you configure it?
41. What are Rou
ting Groups? When would you use them?
42. What are the types of Connectors you can use in Exchange? 43. What is the cost
option in Exchange connectors?
44. What is the Link State Table? How would you view it?
45. How would you configure mail transfer security between 2 routing groups?
46. What is the Routing Group Master? Who holds that role?
47. Explain the configuration steps required to allow Exchange 2003 to send and
receive email from the Internet (consider a one-site multiple server scenario).
48. What is DS2MB?
49. What is Forms Based Authentication?
50. How would you configure OWA’s settings on an Exchange server?
51. What is DSACCESS?
52. What are Recipient Policies?
53. How would you work with multiple recipient policies?
54. What is the “issue” with trying to remove email addresses added by recipient
policies? How would you fix that?
55. What is the RUS?
56. When would you need to manually create additional RUS?
57. What are Address Lists?
58. How would you modify the filter properties of one of the default address lists?
59. How can you create multiple GALs and allow the users to only see the one
related to them?
60. What is a Front End server? In what scenarios would you use one?
61. What type of authentication is used on the front end servers?
62. When would you use NLB?
63. How would you achieve incoming mail redundancy?
64. What are the 4 types of Exchange backups?
65. What is the Dial-Tone server scenario?
66. When would you use offline backup?
67. How do you re-install Exchange on a server that has crashed but with AD intact?
68. What is the dumpster?
69. What are the e00xxxxx.log files?
70. What is the e00.chk file?
71. What is circular logging? When would you use it?
72. What’s the difference between online and offline defrag?
73. How would you know if it is time to perform an offline defrag of your Exchange
stores?
74. How would you plan for, and perform the offline defrag?
75. What is the eseutil command?
76. What is the isinteg command?
77. How would you monitor Exchange’s services and performance? Name 2 or 3
options.
78. Name all the client connection options in Exchange 2003.
79. What is Direct Push? What are the requirements to run it?
80. How would you remote wipe a PPC?
81. What are the issues with connecting Outlook from a remote computer to your
mailbox?
82. How would you solve those issues? Name 2 or 3 methods
83. What is RPC over HTTP? What are the requirements to run it?
84. What is Cached Mode in OL2003/2007?
85. What are the benefits and “issues” when using cached mode? How would you
tackle those issues? 86. What is S/MIME? What are the usage scenarios for S/MIME?
87. What are the IPSec usage scenarios for Exchange 2003?
88. How do you enable SSL on OWA?
89. What are the considerations for obtaining a digital certificate for SSL on
Exchange?
90. Name a few 3rd-party CAs.
91. What do you need to consider when using a client-type AV software on an
Exchange server?
92. What are the different clustering options in Exchange 2003? Which one would
you choose and why.