Important Viva/Interview/ Short Question for C#
Ans: Connected= Data Reader, Disconnected= Data Adapter
Q2. What is difference between Data Adapter and Data Reader.
Ans: Data Adapter is disconnected approach in which we fetch
the entire table at once as XML packet and use that packet for rest of the
purpose.
Data Reader is connected approach in which data mode is
read-only. We can fetch one record at a time that why it is faster because it doesn’t
have memory fragmentation or shortange kinda of problem.
Q3. What the various Methods of Command Class?
Ans: ExecuteNonQuery,
ExecuteReader, ExecuteScalar, EndExecuteNonQuery, EndExecuteReader etc.
Q4. Who manages the code of C#?
Ans: CLR (Command Language Run Time)
Q5. What is the difference between list box and comboBox?
Ans: We can select
multiple values from the list box while comboBox allow only one item to be
selected a t a time. There are multiple
item visible in list box while only one item is visible in case of comboBox.
Q6. Difference between Radio Button and CheckBox?
Ans: We can select only one option at a time in case of
radio button while multiple checkboxes can be checked.
Q7. What are the various OOPS conecepts?
Ans: Class, Object, Inheritance, polymorphism,
encapsulation, dynamic binding, data abstraction etc.
Q8. What is the difference between overriding and
overshadowing?
Ans: Shadowing: The method called depends on the type of the
reference at the point the call is made
Overriding:
The method called depends on the type of the object at the point the call is
made.
Q9. What the various
way to transfer data from one form to another?
Ans: Using Object of the class
·
Using Constructor of the class
·
Using Method
·
Using Packet ( DataSet)
Q10. What is ADO.NET ?
Ans: ADO.NET is basically a utility of .NET framework that
provides us facility to connect with the remote machine or with database. This
enable application to interact with the database. In .Net framework ADO.NET is
used to design distributed application. . It is an integral part of the .NET
Framework, providing access to relational, XML, and application data. ADO.NET
supports a variety of development needs, including the creation of front-end
database clients and middle-tier business objects used by applications, tools,
languages, or Internet browsers.
Q11. Why do we use Connection String?
Ans: Connection string provide the way to connect with the database
server. It carry the information of the server along with the name, username
and password of the Database. During the
compilation it tells the CLR where the database is residing.
Q12. What the various application areas of C#?
Ans: Window Application, web Application, Web Services,
Console Application, Mobile Application.
Q13. What do you mean by MDI and SDI?
Ans: MDI= Multiple Document Interface, SDI = Single Document
Interface.
Q14. What is other name of properties in c#?
Ans: Smart Data Field.
Q15. What is the main feature of inheritance or nick name?
Ans: Reusablity
Q16. The help window which open during the coding which
provide list of properties and actions called?
Ans: Intellisense Window.
Q17. What is
abstract/Sealed/partial class?
Ans: Abstract class: This class is made for inheritance
purpose all the methods of this class must be overridden. We can’t have object
of this class.
Sealed Class: This class can’t be
inherited we can use its members by creating the object of this class. It provide
data abstraction kind of functionality.
Partial Class: A class which can be
defined or expended as per the requirement called partial class. We can define
new member of this class anywhere in the program any number of time.
Q18. What is namespace?
Ans: A namespace is nothing but a container which contains
number of classes, interfaces. User can combine number of classes or interfaces
of same category in one interface and then can use this namespace by importing
it the program. It is write once use anywhere kind of thing.
Q19. What is CLR, CTS and CLS?
Ans: The Common Language Runtime is the underpinning of the
.NET Framework. CLR takes care of code management at program execution and
provides various beneficial services such as memory management, thread management,
security management, code verification, compilation, and other system services.
The managed code that targets CLR benefits from useful features such as
cross-language integration, cross-language exception handling, versioning,
enhanced security, deployment support, and debugging.
Common Type System (CTS) describes how types are declared,
used and managed in the runtime and facilitates cross-language integration,
type safety, and high performance code execution.
The Common Language Specification (CLS) is an agreement
among language designers and class library designers to use a common subset of
basic language features that all languages have to follow.
If you have any other question or if you want to share your own view/Questions then Comment Below:
Thanks