ASP.NET Questions Part-2

51. How do we get only edited/deleted/inserted records from a Dataset?
52. How Dataadapter.fill works?
53. How can we implement a Identity (SQL Server) call in an asp.net page?
54. What is Viewstate?
55. What is the life cycle of an asp.net page?
56. Can you give an example of what might be best suited to place in the Application_Start and Session_Start subroutines?
57. If I'm developing an application that must accomodate multiple security levels though secure login and my ASP.NET web appplication is spanned across three web-servers (using round-robbin load balancing) what would be the best approach to maintain login-in state for the users?
58. What are ASP.NET Web Forms? How is this technology different than what is available though ASP (1.0-3.0)?
59. How does VB.NET/Cachieve polymorphism?
60. Can you explain what inheritance is and an example of when you might use it?
61. How would you implement inheritance using VB.NET/C#?
62. What is an assembly
63. What is .NET remoting?
64. What are webservices?
65. What is CLR?
66. What is delay signing?
67. Which namespace is used by ADO.NET?
68. What are client activated objects and server activated objects?
69. What is difference between singleton and single call?
70. What is difference between OR and ORElse?
71. What are delegates?
72. Describe the difference between inline and code behind - which is best in a
73. Explain what a diffgram is, and a good use for one
74. Where would you use an iHTTPModule, and what are the limitations of any
75. What are the disadvantages of viewstate/what are the benefits
76. Describe session handling in a webfarm, how does it work and what are the > limits
77. How would you get ASP.NET running in Apache web servers - why would you even do this?
78. Whats MSIL, and why should my developers need an appreciation of it if at all?
79. In what order do the events of an ASPX page execute. As a developer is it important to undertsand these events?
80. What property must you set, and what method must you call in your code, in order to bind the data from some data source to the Repeater control?
81. How do you turn off cookies for one page in your site?
82. Which two properties are on every validation control?
83. How do you create a permanent cookie?
84. What tag do you use to add a hyperlink column to the DataGrid?
85. What is the standard you use to wrap up a call to a Web service
86. Which method do you use to redirect the user to another page without performing a round trip to the client?
87. What is the transport protocol you use to call a Web service SOAP
88. What does WSDL stand for?
89. What property do you have to set to tell the grid which page to go to when using the Pager object?
90. What tags do you need to add within the asp:datagrid tags to bind columns manually.
91. Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?
92. How is a property designated as read-only?
93. Which control would you use if you needed to make sure the values in two different controls matched?
94. How many classes can a single .NET DLL contain?
95. Name some of the Microsoft Application Blocks. Have you used any? Which ones?
96. Can a .NET web application consume Java web service ?
97. How to rename a table using sql queries?
98. Distinguish the differences between client-side and server-side data validations in web pages.
99. What is smoke testing?
100. What is the difference between a defect and an enhancement?

ASP.NET interview questions Part -1

1. What types of data validation events are commonly seen in the client-side form validation?
2. In A Page I have gridview with Options of select and delete using hyperlink when i am selecting any one of then it has to open another page how can it
3. Web service support a) Data set b) dataReader c) both of above d) none of above
4. How to create dynamic Gridview?
5. What is PreProcessor in .NET and type , where it use
6. Please brief not about XSD,XSLT & XML.
7. List of Words of PreProcessor in .NET?
8. If we remove web.config or machine.config from the application then, will the application still work?
9. How to reduce the width of textbox in EditCommandColumn of DataGrid?
10. Which dll handles the request of .aspx page?
11. What is event bubbling?
12. What is server infrastructure & Server components?
13. What is IPostBack? How to use it?
14. How to create a DB connection at one place/page so that we can use that connection for all pages/forms/windows.whatarethe steps ned to be performed. if question not clear,let me know.
15. What is diff. between abstract class and an interface? * What is shadowing? * Diff between Overriding and overloading
16. What is DLL hell?
17. Can you explain the difference between an ADO.NET Dataset and an ADO Recordset?
18. What is CLR? 2.1. Diff between CLR & CTS
19. Explain the differences between Server-side and Client-side code?
20. Which namespace is used to get assembly details?
21. What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?
22. What type of code (server or client) is found in a Code-Behind class?
23. ColumnMapping belongs to which namespaces?
24. Can you give an example of when it would be appropriate to use a web service as opposed to a non-serviced .NET component
25. Should validation (did the user enter a real date) occur server-side or client-side? Why?
26. What is an abstract class?
27. What tags do you need to add within the asp:datagrid tags to bind columns manually?
28. What method do you use to explicitly kill a user s session?
29. What base class do all Web Forms inherit from?
30. How can you provide an alternating color scheme in a Repeater control?
31. Which template must you provide, in order to display data in a Repeater control?
32. Can you edit data in the Repeater control?
33. Which method do you invoke on the DataAdapter control to load your generated dataset with data?
34. In order to get assembly info whcih namespace we should import?
35. What is the root namespace for all types?
36. Diff. betn Dataset and Recordset.
37. Diff between Dataset and Datareader?
38. Trace and Debug belongs to which namespaces?
39. What does the "EnableViewState" property do? Why would I want it on or off?
40. Let's say I have an existing application written using Visual Studio 6 (VB 6, InterDev 6) and this application utilizes Windows 2000 COM+ transaction services. How would you approach migrating this application to .NET
41. DIff. between Friend and Protected Friend.
42. How doyoudeclare static variable and how it is declared and what is its lifetime?
43. How doesyouget record no from 5 to 15 from a dataset of 100 records?
44. Why Datareader is useful?
45. How doesyoucall and execute a SP in .NET?
46. What is versioning in .NET?
47. Whatarethe ASP.NET list controls and diff. between them?
48. What is diff. between ASP State Management and ASP.NET State Management?(Imp) 19. How can we pass info between 2 asp.net pages?
49. Diff between Web User Control and Web Custom Control.
50. How do we Sort the data from a Dataset?

ADO.NET Questions

1. Does SQLClient and OLEdb class share the same functionality
2. How can we load multiple tables in to Dataset?
3. What is the difference between data reader & data set
4. Why edit is not possible in repeater?
5. Difference between SqlCommand and SqlCommandBuilder?
6. How many records can take clustured index in SQL Server?
7. Why can't we use Multiple inheritance and garbage collector in parallel in .NET?
8. What is ADO.NET?
9. Can we connect two datareader to same data source using single connection at same time?
10. What is the execution procedure in oracle ?
11. How to find the given query is optimised one or not?
12. How to copy the contents from one table to another table and how to delete the source table in ado.NET ?
13. What is the difference between data reader and data adapter.
14. How to copy the contents from one table to another table and how to delete the source table in ado .NET?

Oracle interview Questions ( Part-2)

51. Which data dictionary view shows information about the status of a procedure?
52. How do you correct a procedure that has become invalid when one of the tables it is referring to was altered to drop a constraint?
53. Which event trigger from the following cannot be created at the database level?
54. How many data files can be specified in the DATAFILE clause when creating a database?
55. Who owns the data dictionary?
56. What is the default password for the SYS user?
57. Which data dictionary view provides information on the version of the database and installed components?
58. What is the prefix for dynamic performance views?
59. Which clauses in the CREATE DATABASE command specify limits for the database?
60. Which clauses in the CREATE DATABASE command specify limits for the database?
61. Which optional component in the database creation process sets up functions and procedures to store, access, and analyze data needed for Geographical Information Systems (GIS)?
62. What is the best method to rename a control file?
63. What piece of information is not available in the control file?
64. When you create a control file, the database has to be:
65. Which data dictionary view provides the names of the control files?
66. The initialization parameter file has LOG_CHECKPOINT_INTERVAL = 60; What does this mean?
67. Which data dictionary view shows that the database is in ARCHIVELOG mode?
68. What is the biggest advantage of having the control files on different disks?
69. Which file is used to record all changes made to the database and is used only when performing an instance recovery?
70. What will happen if ARCn could not write to a mandatory archive destination?
71. How many ARCn processes can be associated with an instance?
72. What are the valid status codes in the V$LOGFILE view?
73. If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?
74. What happens if you issue the following command? ALTER DATABASE ADD LOGFILE ('/logs/file1¡ä REUSE, '/logs/file2¡ä REUSE)
75. Which two parameters cannot be used together to specify the archive destination?
76. What packages are associated with the LogMiner utility?
77. Querying which view will show whether automatic archiving is enabled?
78. If you need to have your archive log files named with the log sequence numbers as arch_0000001, arch_0000002, and so on (zero filled, fixed width), what should be the value of the LOG_ARCHIVE_FORMAT parameter?
79. List the steps needed to rename a redo log file.
80. Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery?
81. Create a statement that will add a member /logs/redo22.log to log file group 2.
82. When does the SMON process automatically coalesce the tablespaces?
83. Which operation is permitted on a read ¨C only tablespace?
84. How would you drop a tablespace if the tablespace were not empty?
85. Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?
86. 13. The database block size is 4KB. You created a tablespace using the following command. CREATE TABLESPACE USER_DATA DATAFILE 'C:/DATA01.DBF'; If you create an object in the database without specifying any storage parameters, what will be the size of the third extent that belongs to the object?
87. 14. Which statement is false? A. Dictionary-managed temporary tablespace can be made permanent. B. The size of the locally managed temporary tablespace file cannot be changed. C. Once created, the extent management of a tablespace cannot be altered. D. A locally managed permanent tablespace cannot be made temporary.
88. Which statement is true regarding the SYSTEM tablespace? A. Can be me made read only. B. Can be offline. T C. Data files can be renamed. D. Data files cannot be resized
89. What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?
90. How would you determine how much sort space is used by a user session?
91. 19. If you issue ALTER TABLESPACE USERS OFFLINE IMMEDIATE, which of the following statements is true? A. All data files belonging to the tablespace must be online. B. Does not ensure that the data files are available. C. Need not doe media recovery when bringing the tablespace online. D. Need to do media recovery when bringing the tablespace online.
92. Place the following logical storage structures in order-from the smallest logical storage unit to the largest. A. Segment B. Block C. Tablespace D. Extent
93. When a table is updated, where is the before image information (which can be used for undoing the changes) stored?
94. Which parameter specifies the number of transaction slots in a data block?
95. What happens if you create a rollback segment in the same tablespace where application data is stored? Choose the best answer. A. The tablespace will be fragmented. B. Performance improves, because when changes are made, undo information can be written to the same tablespace. C. There should be a minimum of two data files associated with the tablespaces when rollback segments are created. D. None of the above is true.
96. 5. Which storage parameter is applicable only to rollback segments? A. PCTINCREASE B. MAXEXTENTS C. TRANASACTIONS D. None of the above.
97. 6. Choose the statement used to manually de-allocate the extents used by a rollback segment. A. ALTER ROLLBACK SEGMENT R01 DEALLOCATE; B. ALTER ROLLBACK SEGMENT RO1 DROP EXTENTS; C. ALTER ROLLBACK SEGMENT RO1 SHRINK; D. ALTER ROLLBACK SEGMENT RO1 SIZE 10K.
98. Which data dictionary view would you query to see the free extents in a tablespace?
99. What is the minimum number of extents a rollback segment can have?
100. Which portion of the data block stores information about the table having rows in this block?

Oracle interview Questions ( Part-1)

1. List components of an Oracle instance?
2. Which background process and associated database component guarantees that committed data is saved even when the changes have not been recorded in the data files?
3. What is the maximum number of database writer processes allowed in an Oracle instance?
4. Which background process is not started by default when you start up the Oracle instance?
5. Describe a parallel server configuration.
6. Choose the right hierarchy, from largest to smallest, from this list of logical database structures.
7. Which component of the SGA contains the parsed SQL code?
8. Name the stages of processing a DML statement. What stages are part of processing a query?
9. Which background process is responsible for writing the dirty buffers to the database files?
10. Which component in the SGA has the dictionary cache?
11. When a server process is terminated abnormally, which background process is responsible for releasing the locks held by the user?
12. What is a dirty buffer?
13. If you are updating one row in a table using the ROWID in the WHERE clause (assume that the row is not already in the buffer cache), what will be the minimum amount of information read to the database buffer cache?
14. What happens next when a server process is not able to find enough free buffers to copy the blocks from disk?
15. Which memory structures are shared? Name two.
16. When a SELECT statement is issued, which stage checks the user's privileges?
17. Which memory structure records all database changes made to the instance?
18. What is the minimum number of redo log files required in a database?
19. When are the system change numbers assigned?
20. Name the parts of the database buffer pool.
21. List all the valid database start-up option?
22. Which two values from the V$SESSION view are used to terminate a user session?
23. To use operating system authentication to connect the database as an administrator, what should the value of the parameter REMOTE_LOGIN_PASSWORDFILE be set to?
24. What information is available in the alert log files?
25. Which parameter value is use to set the directory path where the alert log file is written?
26. Which SHUTDOWN option requires instance recovery when the database is started the next time?
27. Which SHUTDOWN option will wait for the users to complete their uncommitted transactions?
28. How do you make a database read-only?
29. Which role is created by default to administer databases?
30. Which parameter in the ORAPWD utility is optional?
31. Which priviledge do you need to connect to the database, if the database is started up by using STARTUP RESTRICT?
32. At which stage of the database start-up is the control file opened?
33. 13. User SCOTT has opened a SQL * Plus session and left for lunch. When you queired the V$SESSION view, the STATUS was INACTVE. You terminated SCOTT's session in V$SESSION?
34. Which command will "bounce" the database-that is, shut down the database and start up the database in a single command?
35. 15. When performing the command SHUTDOWN TRANASACTIONAL, Oracle performs the following tasks in what order?
36. How many panes are there in the Enterprise Manager console?
37. Using SQL*Plus, list two options which show the value of the parameter DB_BLOCK_SIZE?
38. When you issue the command ALTER SYSTEM ENABLE RESTRICTED SESSION, what happens to the users who are connected to the database?
39. Which view has information about users who are ghranted SYSDBA or SYSOPER privilege?
40. Which DB administration tools are included in the DBA Studio Pack?
41. How many control files are required to create a database?
42. Which environment variable or registry entry variable is used to represent the instance name?
43. . What is the recommended configuration for control files?
44. You have specified the LOGFILE clause in the CREATE DATABASE command as follows. What happens if the size of the log file redo0101.log, which already exists, is 10MB?
45. Which command should be issued before you can execute the CREATE DATABASE command?
46. Which initialization parameter cannot be changed after creating the database?
47. What does OFA stand for?
48. When creating a database, where does Oracle find information about the control files that need to be created?
49. Which script creates the data dictionary views?
50. Which prefix for the data dictionary views indicate that the contents of the view belong to the current user?

Interview Questions

Are you prepared to work: at weekends or on statutory holidays? Or rotating shift patterns including nights? Give me examples of when you have had to do this.

What is the most significant impact you've made at your organisation in the last year?

How do you feel about working overtime?

Do you prefer regular hours?

What motivates you?

Describe self-improvements you�d like to make in the workplace.

Aren't you a bit old (or over-qualified) for this position?

How have you improved yourself in the last year?

Can you tell me about a time when you did work and tasks above and beyond the call of duty?

Do you often suggest improvements to your supervisor/manager? Give me some examples.

How do you cope with your ideas not being implemented, especially when you know they would be worthwhile?

Give me some examples demonstrating you can work under pressure.
What projects and activities have you or your team undertaken and seen through that were your idea?

Which was your most challenging project? What difficulties did you meet? How did you overcome them?

How do you take criticism?

What supervisory or leadership roles have you held?

Have you any unspent convictions?

You have 2 minutes. Think of as many uses for a paper clip as you can in that time.

What is the 5th letter of the alphabet? How many ping-pong balls fit into a Volkswagen?
If you had to choose an actor (or actress) which would you be and why?

You have five minutes to tell me why you should have the job.

Why were you out of work for so long?

Why have you changed jobs so many times in the past?

Why are you interested in a position with our company?

What steps have you taken to be more successful in your career?

Tell me about a time you became angry at work.

Where/how do you vent your frustrations at work?

Tell me about a poor performing team that you were a member off.
What would you do if a member of a group you were a part of wasn't pulling their weight?

Give examples of charity work you have done.

What degree of autonomy would you like in the job?

Give examples of when you had to work as part of a team. Why is teamwork important?
Tell me about unpopular decisions you have made in the past.

How can you contribute to the success of this company?
Give examples of when you had to work with a multi-cultural team.

What were your duties in your last employment?

Give me some KPIs (Key Performance Indicators) and trends you would expect to see within a successful business. Name some characteristics of a good business.
If you were running this or another business, what changes would you make? Why?
If you had to dismiss 30 people, how would you decide whom to let go?
How do you feel about working for a line manager who is much younger than you?
Which position in our company do you aspire to?

Interview Questions

What do you know about our company?

Who are our competitors? What are our products? Who are our customers?

Why have you applied for this particular position?

How did you learn of the vacancy?

What are your salary/wage expectations?

Tell me about the issues in the general press that relate to the industry/vocation for which you are applying.

Tell me about yourself.


What is your attitude towards unions in a workplace?

What is your current salary or remuneration package?

Why do/did you want to leave your current/last job?

What do you think determines a person's progress within a company?

Why should we hire you?

Have you ever made a mistake at work?

What irritates you the most in the workplace/with colleagues?

Have you ever been dismissed/ or disciplined? Why?

Why do you think you might like to work for our company?

Are you looking for a permanent or temporary position with the company?

How many days leave/sickness have you had in the last year? Why?

Do you prefer any particular geographic location? Why? Are you prepared to re-locate?

Would you be prepared to travel nationally/abroad? Are you prepared to go where the company sends you?

Are you married? If so, does your partner work? Do you have children? Do you have a mortgage?

If cr�che facilities were available would you want to apply to use them?

What are your strengths and weaknesses?

What would you like to be doing and earning in 5 years time?

What are your most redeeming qualities?

Our company and staff like working to systems. Training our staff to become experts in these systems has been one of the reasons for our success. We don't leave anything to chance and we even have a system for answering the phone that we will teach you. How do you feel about this?

What are your hobbies or interests?

What did you like/dislike about your previous employer?

What did you like/dislike about your previous manager?

If we phoned your previous employer/manager, what would they tell us about you?
If you were given a task to do but didn't how to go about it, what would you do?

If you lack experience, what do you have to offer?

How would manage poor performance?

What do you understand about a disciplinary procedure? How is it generally applied?

What characteristics do you think an employer looks for in an employee?

For what sort of a company would you like to work?

How many jobs have you applied for in the last three months? How many interviews have your attended? For what types of positions have you applied? Why?

What kind of work interests you?

Which five words most describe you?

What sort of things frustrated you in your last job?

Do you work best on your own or in a team?

Can you get recommendations from previous employers? Can we see them?

Which jobs have you enjoyed the most /least? Why?

What personal characteristics are necessary for success in your chosen field?
What is 15*15?

In your opinion, what are the most important factors in running a business?

What types of people seem to rub you the wrong way?

What types of books do you read?

Does your spouse work?

Tell me about your home life?

Do you drive? If so, what type of car and what colour?

Which companies have you worked for in the past. How did you get the positions?

Tell me about your IT skills?

What are your best friends� occupations?

To what extent do you drink alcohol? Smoke?

Have you ever had any serious illness or injury? How many days absence have you had in the last year?

Which of your parents had the most profound influence on you? Why?

Explain your choice of subjects at school/college/university.

Do you have any major financial debts?

Your CV indicates that you did poorly in your exams (degree, college exams, and secondary school exams). Why?

Can you tell me about your biggest failures and how you dealt with them?

Blue tooth Questions

# Why is Bluetooth called a cable replacement technology?
# Give a generic description of Bluetooth?
# Why can Bluetooth equipment integrate easily in TCP/IP network?
# Is it possible to connect multiple Bluetooth hubs?
# What is FCC and how does it relate to Bluetooth?
# Under what frequency range does Bluetooth work?
# Do Bluetooth devices need line of sight to connect to one another?
# Which technology is used in Bluetooth for avoiding interference?
# What is Airport?
# What is Piconet?
# What is FEC in Bluetooth?
# Which method is primarily used for Voice transfer?
# What is the frequency range used for Bluetooth in Europe and United States?
# List some Technology characteristic of Bluetooth?
# Which company originally conceived and developed Bluetooth?
# How does Bluetooth use frequency hopping for security?
# What is a Bluetooth dongle?
# What are the other (competing or not) wireless technologies?
# Which Bluetooth version uses adaptive frequency hopping? Why?
# How many SCO links are there in a piconet?
# what is the total number of masters and slaves in a piconet?
# Which method is used for Data transfer?
# What is the frequency range used for Bluetooth in Japan?
# What is the strength of the signal transmitted by powerful cell phones?
# What is RJ-45 and full name of RJ-45?
# What is LDAP? Where all can it be used
# Difference between TCP and UDP
# What is 802.11b, Bluetooth
# What types of routing are possible in a wireless network
# How does traceroute work
# What are the different types of routing possible at layer 3
# Explain TCP connection establishment and tear down
# What is ICMP, ARP, Multicast, Broadcast
# When are packets passed from TCP layer to application layer? What if some IP packets are lost
# Describe TCP flow control
# Explain DNS, IP address allocation
# What is IP Spoofing? What do hackers do with it
# What is DOS attack
# Explain SSL
# How can you keep a TCP connection from tearing down when no data will be sent for a long time?