What are Aggregate and Scalar Functions available in SQL?

Ankur Kulhari

Aggregate and Scalar functions are in built function for counting and calculations. Aggregate functions operate against a group of values but returns only one value. AVG(column):- Returns the average value of a column COUNT(column):- Returns the number of rows (without a NULL value) of a column COUNT(*):- Returns the number of selected rows MAX(column):- Returns the highest value of a …

POD-26-Aug-2016

Ankur Kulhari

Write a Program to print following pattern # # ## ## ### ### #### #### ######### Number of rows should be entered by user at run time. Hint: Implement using array.

POD-24-Aug-2016

Ankur Kulhari

Write a Program to print following pattern # ## ### #### ##### ###### ####### Number of columns should be entered by user at run time. Hint: Implement using array.

Accenture Interview Questions-I

Ankur Kulhari

What is Dynamic Memory Allocation, example? How C/C++ and Java are different to each other? C program of Bubble Sort. Program of sum of a series. What is Object Oriented Programming? What is encapsulation? What is Inheritance? What is polymorphism? What is abstraction? What is Runtime Polymorhism? What is BCNF in RDBMS? What are inner and outer joins? Explain with …

Operating Systems Interview Questions – Part IV

Ankur Kulhari

What is the purpose of an I/O status information? Ans:I/O status information provides info about which I/O devices are to be allocated for a particular process. It also shows which files are opened, and other I/O device state. What is multitasking? Ans:Multitasking is the process within an operating system that allows the user to run several applications at the same …

Operating Systems Interview Questions – Part III

Ankur Kulhari

How does swapping result in better memory management? Ans:During regular intervals that are set by the operating system, processes can be copied from main memory to a backing store, and then copied back later. Swapping allows more processes to be run that can fit into memory at one time. Give an example of a Process State. Ans:Process may be in …

Operating Systems Interview Questions – Part II

Ankur Kulhari

What is asymmetric clustering? Ans:In asymmetric clustering, a machine is in a state known as hot standby mode where it does nothing but to monitor the active server. That machine takes the active server’s role if, the server fails. What is a thread? Ans:A thread is a basic unit of CPU utilization. In general, a thread is composed of a …

Operating Systems Interview Questions – Part I

Ankur Kulhari

Explain the main purpose of an operating system? Ans: Operating systems exist for: Easeness to use Efficient computational resource management Providing environment for the development and execution of programs. What is demand paging? Ans:Demand paging is a type of swapping in virtual memory management system in which pages of data are not copied from disk to RAM until they are …