Lets study something and try to remember it.
Sunday, July 4, 2010
5) Difference between Windows XP and 98?
Ans: -
For XP operating system
1. Auto Updated.
2. Help and Support features.
3. USB port automatically initialized.
4. Service Pack is updated.
5. Remote desktop collection.
6. System Restore Point.
For 98 Oprating system
1. No Auto Updated.
2. No Help and Support features.
3. No USB port automatically initialized.
4. No Service Pack is updated.
5. No Remote desktop collection.
6. No System Restore Point.
4) Some Dot Net Interview Questions.
1) What is the difference between .Net and Java/C/C++?
2) What are the types of application architecture?
3) On which type of architecture .Net is based?
4) What is .Net framework?
5) What are the main advantages of .Net framework?
6) What is CTS (Common Type System)?
7) Justify .Net is a platform independent?
8) Visual Basic is object oriented language or not?
9) .Net is object oriented language or not?
10) What is the difference between function overloading and function overriding?
11) What is CLR?
12) What is Assembly?
13) What is Namespace?
14) What is MSIL?
15) What is Language Interoperability?
16) What is Template?
17) How to declare an Array, Variable in .Net, C# etc?
18) How to resizing of Array?
19) What are the advantages of using Class and Object?
20) What is difference between Structure and Class?
21) What are Abstract Classes, Assembly, and Interfaces?
22) What is Object lifetime?
23) What are Constructor and Destructor?
24) What is Shared Constructor and shared variable?
25) What is Procedure and How many types of Procedure?
26) What is Optional Agreement and How to use it?
27) What is Parameter Array?
28) What is Procedure overloading and Procedure overriding?
29) Types of Common Dialog Classes?
ADO .Net Questions
30) What is ADO.Net?
31) Features of ADO.Net?
32) What is disconnected data architecture?
33) What is Dataset and what is its use?
34) Why you use the XML format for data transfer?
35) What is the Data Command?
36) What are Data Render, Object Connection Object, and Command Object?
37) Different types of Data Provider?
38) Which one is better for connection in SQL Server and Why?
39) Difference between Data Reader and Dataset?
40) Can you use Data Reader for updating database and why?
41) What is Data Adapter and Data Provider?
42) What are different properties of Data Adapter?
43) What is Table Mapping?
44) Why you use Execute Non Query?
45) What is the difference between Execute non query and Execute Scalar?
46) What is Dataset object model? Explain?
47) Types of Dataset? Differences and Advantages?
48) Which command do you use while using the stored procedure?
49) What is Data binding? Types of Data binding?
50) What is Binding Content Object?
51) How to Filtering a Dataset?
52) What is Data view and How to filter it?
53) How to create relationship between Dataset Tables?
54) What are the different methods to update a Dataset?
55) How to validate Data in Dataset using Event? (Column changing event, Data column change event , etc)
56) What is Row state property? What are the methods?
57) How to perform direct data updates?
58) Difference between Row Changing event and column changing event?
59) What are Row Changing Event and Column Changing Event?
60) What is Data Concurrency? Types of Concurrency Control?
3) SQL-Keys Defination
Ans: - The column or attribute that is uniquely identifying the row of the table is called as Primary Key.
2) What is Foreign Key?
Ans: - A column in one table whose values can be matches to the primary key of another table is called as Foreign Key.
3) What is Candidate Key?
Ans: - Any column or attribute that uniquely identifies a row in a table is a candidate for the primary key such as attribute or column is called as Candidate Key.
4) What is Alternate Key?
Ans: - Any column or attribute that is a candidate for the primary key but not the primary key is called as the Alternate Key.
5) What is Composite Key?
Ans:- When a Key that uniquely identifies the rows of the table is made up of more than one attribute is called as Composite Key.
2) Some Database defination
1) What is Index and types of Index?
Ans: - An index is an internal part of the database that provides a quick access to the rows of a tabl based on the value of one or more columns.
There are two types of index.
i) Cluster Index.
ii) Non Cluster Index.
2) What is Cursor?
Ans: - Cursor is a database object that can be helps tp accessing and manipulating the data in a given result set.
3) What is locking in database?
Ans:- Locking can be used in the database to ensure transactional integrity and database consistency.
4) What is Deadlock?
Ans: - Deadlock is a situation I which two users have locks on separate objects and each user is wetting for a Lock on the other objects.
5) What is Schema Locks?
Ans: - Schema Locks can be used by the database when any Data Definition Language (DDL) operation is being performed on a table.
6) What is Transactions?
Ans: - Transactions can be defined as a sequence of operations performed together as a single logical unit of work.
There are four types of properties i.e ACID.
i) Atomicity.
ii) Consistency.
iii) Isolations.
iv) Durability.
7) What is Trigger?
Ans: - A trigger is a block of code that are activate in response to certain action. i.e any DML statements (Insert, Update, Delete) can executed it is automatically fired.
8) What is Join and types of Join?
Ans: - It is a operation that includes the retrieval of data from more than one table at a time.
i) Inner Join..
ii) Outer Join.
iii) Cross Join.
iv) Equi Join.
v) Natural Join.
vi) Self Join.
9) What is View?
Ans: - View is a virtual table which gives access a subset of columns from one or more tables.
10) What is Database? How many types of system Database?
Ans: - A database is a collection of tables and objects such as Index, View, Stored Procedure and Triggers.
There are four types of System Databases.
i) Master
ii) Tempdb
iii) Model
iv) Msdb.
11) The Data and objects in a database are stored in hw many types of files and what are they?
Ans: - The data and objects in a database are stored in 3 types of files.
i) Primary Data File.
ii) Secondary Data File.
iii) Transaction Log File.
A database must consist of a Primary data file and Transaction Log File.
12) What is a constraint? Types of constraints?
Ans: - The constraints are creating to ensure the data integrity. It defines the rules that must be followed to main the consistency are correctness of data.
Types of Constraints: i) Primary Key Constraints.
ii) Unique Constraints.
iii) Foreign Key Constraints.
iv) Check Constraints.
v) Default Constraints.
13) What is Data Integrity and Types of Integrity?
Ans: - Data Integrity ensure the Consistency and correctness of data stored in a database.
Types of Integrity: - i) Entity Integrity.
ii) Domain Integrity.
iii) Referential Integrity.
iv) User-defined Integrity.
14) What is stored procedure? Types of procedure?
Ans: - A stored procedure is a collection of T-SQL statements and control of flow language that is store under one name and executed as a single unit. It helps in improving the performance of a query.
Types of stored procedure: - i) User defined stored procedure.
ii) System stored procedure.
iii) Temporary stored procedure.
iv) Remote stored procedure.
v) Extended stored procedure.
1) Fundamentals definition of the Software related things
Fundamentals definition of the Software related things.
1) What is Computer?
Ans: - Computer is an electronic device which accepts the data from the user and processing it then gives the output to the user.
2) What is program?
Ans: - A set of instruction to perform a task is called as Program.
3) What is Software?
Ans: - A set of program to perform a specific task is called as Software.
4) What is an I-con?
Ans: - The item which s available on the desktop is known as I-con.
5) What is Background?
Ans: - The ground which is seen behind the I-con is known as Background.
6) What is Folder?
Ans: - Folder is a container where w can keep ours files and folder.
7) What is Complier?
Ans:- A complier converts the code that can be written in a programming language into machine language.
8) What is Hardware?
Ans: - All the visible and tangible things of a system is called as Hardware.
9) What is Operating System?
Ans: - An operating system is a software program that acts as an interface between a user and a Computer.
10) What is Browser?
Ans: - A browser is an application software that is installed in the client machine.
11) What is Father of Computer?
Ans: - Charles Babbage.
12) What is the name of the first computer in the world?
Ans: - Abacus is the world’s first computer name.
13) What is Interpreter?
Ans: - An interpreter verifies and executes the code of a program line by line.
14) What is Java?
Ans: - Java is an interpreter that is used to execute compiled java application.
15) What is Java Beans?
Ans: - It is a specification developed by Sun Microsystems and defines interactions between java objects.
16) What is Java C?
Ans: - It is a tool which is used to connect Java source code into byte code. It converts Dot Java files into Dot Class files.
17) What is JVM?
Ans: - It stands for Java Virtual Machine. It is a software that interpreters and execute the byte code.
18) What is Internet?
Ans: - It is a network of network.
Or, It is the inter connection between several computers throughout the globe.
19) What is Intranet?
Ans: - It is the connection between several computers within a organization.
20) What is Web?
Ans: - It is a virtual space resides in the web server.
21) What is Web server?
Ans: - It is a server that store in websites.
22) What is Web Sites?
Ans: - It is a site and it contains the hypertext documents.
23) What is Web Browsers?
Ans: - It is a server which display the web pages.
24) What is Assembly?
Ans: - It contains all the information about the files on which the component depends and the contains on these files.
It consists of a manifest and the portable executables (PE).
25) What is Mainfest?
Ans: - It consists of information such as the name and version of the assembly.
26) What is portable executable (PE)?
Ans: - A portable executable consists of IL Code, Type, Information and Metadata.
27) What is Components?
Ans: - It is a reusable thing which can be used by any other application.
28) What is the mean of VIRUS?
Ans: - Virus stands for Vital Information Resources Under Seaze. It is a software program.