sitemap

By
Loading, please wait for a moment...

Popular posts from this blog

Asp Interview Questions and Answers Part 4

By
Image
What are the collections of Session Object? Contents collection contains all the variables established for a session without using the tag. Static collection contains all the objects created What is the difference between ASP and HTML? Or Why ASP is better than HTML? - ASP executes code on the server side whereas the browser interprets HTML. - ASP can use any scripting languages - Gets feedback from the user and return information to the user - Create pages that will be customized to display only things that will be of interest to a particular user - Can edit contents of a web page by updating a text file or a database rather than the HTML code itself What are the event handlers of Application Object? Application_OnStart- This event will be fired when the first visitor hits the page. Application_OnEnd- This event runs when the server is stopped. Name some of the ASP components? Ad Rotator component- a way to manage advertisements on the web site. Content Linker component - a techn...
Read more

Oracle Interview Questions&Answers Part 5

By Unknown
Image
What is SGA? The System Global Area in an Oracle database is the area in memory to facilitate the transfer of information between users. It holds the most recently requested structural information between users. It holds the most recently requested structural information about the database. The structure is database buffers, dictionary cache, redo log buffer and shared pool area. What is a shared pool? The data dictionary cache is stored in an area in SGA called the shared pool. This will allow sharing of parsed SQL statements among concurrent users. What is mean by Program Global Area (PGA)? It is area in memory that is used by a single Oracle user process. What is a data segment? Data segment are the physical areas within a database block in which the data associated with tables and clusters are stored. What are the factors causing the reparsing of SQL statements in SGA? Due to insufficient shared pool size. Monitor the ratio of the reloads takes place while executing SQL statem...
Read more

The Least k Numbers - Interview Question&Answer

By
Image
Question:  Please find out the least  k  numbers out of  n  numbers. For example, if given the 8 numbers 4, 5, 1, 6, 2, 7, 3 and 8, please return the least 4 numbers 1, 2, 3 and 4. Analysis:  The naïve solution is sort the  n  input numbers increasingly, and the least  k  numbers should be the first  k  numbers. Since it needs to sort, its time complexity is  O(n log n) . Interviewers will ask us explore more efficient solutions. Solution 1: O( n log k ) time efficiency, be suitable for data with huge size A data container with capacity  k  is firstly created to store the least  k  numbers, and then a number is read out of the  n  input numbers at each time.   If the container has less than  k  numbers, the number read at current round (denoted as  num ) is inserted into container directly. If it contains  k numbers already,  num  canno...
Read more