DELL SQL PLSQL Interview Questions

Questions
Answers
Views
Company
eMail

How do you retrieve set of records from database server. {Set max records = 100 & use paging where pager page no or records = 10 & after displaying 100 records again connect to database retrieve next 100 }

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

Post New ** DELL ** SQL PLSQL Interview Questions

Un-Answered Questions

What is the standard unit weight of Cast Iron pipe of 200MM Dia.(pipe specification is IS1538)

Project 2 - Magic Squares design2.txt - due 12/7 before 11:59 PM project2 - due 12/13, before 11:59 PM Orginally by Sue Evans Hit the space bar for next page The Objectives The purpose of this assignment is to give you practice with: recursion using command line arguments using the timing feature and file handling. The Background According to The Math Forum @ Drexel University, A Magic Square is an arrangement of the numbers 1 to n2 in an n x n matrix with each number occuring exactly once, and such that the sum of the entries of any row, any column, or any main diagonal is the same. It is not hard to show that this sum is n(n2 + 1)/2. The simplest magic square is the 1 x 1 magic square whose only entry is the number 1. 1 The next simplest is the 3 x 3 magic square. (8 + 1 + 6) or 3(32 + 1)/2 This is also just ONE of many examples for a 3 x 3 Magic Square!! This 3 x 3 square is definitely magic and satisfies the definition given above. There are 8 different arrangements of entries in a 3 x 3 matrix that fit the definition of a magic square. There are also magic squares of size 4 x 4, 5 x 5, etc. The Background - Continued For small n, say n <= 3, you could obviously sit down with pencil and paper and discover a magic square in a fairly short amount of time. Take a few minutes now and do that, remembering that each of the numbers, 1 through n2, appear only once in the square. Now try it for n = 4 ... Oh, there has to be a better way. :) Of course, the computer doesn't have a patience problem. It can solve the problem for us by using the brute force method. This means that the computer will accomplish its task by trying every single possible arrangement of the numbers in a square and check each of the resulting squares to see if it's a magic square. [6, 2, 7, 5, 4, 8, 3, 9, 1] [4, 2, 7, 6, 5, 8, 3, 9, 1] [7, 4, 2, 6, 5, 8, 3, 9, 1] ... The Task Your assignment will be to determine all of the magic squares when given an n, display permutations that match the magic squares to the screen AND write it to a file. You will only test when n == 3!!! But code it for n of ANY number!! It turns out that finding the magic squares for n >= 4 takes too long for us to run it on the shared machines (linux1, 2 & 3) Since if n == 1, the square is 1 (too easy!!) and since for n == 2 there is no answer!! Your program must come up with every possible arrangement (permutation) of numbers within the square. These are known as the permutations of that list of numbers. Each permutation needs to be checked to see if it has formed a magic square. Program Requirements Your program must: use command line arguments. At the command line the user must enter (in this order): the name of the executable file, n (which will ALWAYS be 3, but again could be run with other numbers) and the name of the output file in which to write the squares. use a recursive permute to give all of the permutations of the square. In other words, your function called "permute", must be a recursive function. So for each permutation, you should check to see if it is a magic square, display it and write it to the file write only the unique magic squares to the SCREEN and FILE. No duplicates allowed. HINT: Let your program produce duplicates first, then see how you can refrain from writing the duplicates. Then modify your code. use a list of size n2. The code for the recursive permute function will be much easier to write if you store the numbers in a list rather than a two-dimensional list (or array) of size n x n. How you print the data is not related. [6, 2, 7, 5, 4, 8, 3, 9, 1, ....] (size to n2) [4, 2, 7, 6, 5, 8, 3, 9, 1, ....] [7, 4, 2, 6, 5, 8, 3, 9, 1, ....] ... close any files that you have opened as soon as you have finished using them. Time how long your program takes to find the magic square and print that time at the end of the SAME file. Sample Run Here is a sample of output of this program. Please note that the sample output only shows what is expected from your program if the user is actually entering everything as instructed. This is not a test of the program at all, but just a sample for your clarification. 2 7 6 9 5 1 4 3 8 2 9 4 7 5 3 6 1 8 4 3 8 9 5 1 2 7 6 4 9 2 3 5 7 8 1 6 6 1 8 7 5 3 2 9 4 6 7 2 1 5 9 8 3 4 8 1 6 3 5 7 4 9 2 8 3 4 1 5 9 6 7 2 Total running time: 4.76 seconds.

Why does the experimental lattice enthalpy of NaI differ greatly from the theoretical lattice enthalpy?

How to prepare serum from plasma?

What is higher heating value and lower heating value? Is it positive or negative?

write a c program for swapping two strings using pointer

BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

Explain your Organizational Skills?

#include

could you please send me the ISTQB Material to my mail id ankurcsc@gmail.com

what is 'macro' in excel? how to make use of it ?

Why every time that I hit the microphone or when I speak louder the amplifier is switched of?

can any give an exact example about, resolving the sql errorcode -305

what is moisture probe? What are there types? What is there working principle and how they works? guys this is one of technical question I had ask in interview. If you know its answer please let me know. The interviewers were more interested in microwave moisture probe, so if you find its any link please just forward me on my mail id.avinash1200@gmail.com Thanks in advance.

How does PLC work for sychronising of Two or more DG sets?

DELL SQL PLSQL Interview Questions

- C (4)
- OOPS (2)
- Delphi (2)
- CGI Perl (1)
- JavaScript (1)
- TCP IP (3)
- Protocols AllOther (1)
- Networking Administration (4)
- Networking AllOther (4)
- ASP.NET (15)
- COM+ (3)
- ADO.NET (2)
- Dot Net Remoting (9)
- Dot Net WindowsForms (1)
- Oracle General (2)
- SQL Server (4)
- DB Administration (1) SQL PLSQL (6)
- SDK (1)
- Linux Threads (1)
- Linux AllOther (1)
- Unix Commands (1)
- Solaris Commands (1)
- Solaris General (1)
- Vxworks (1)
- Operating Systems General Concepts (1)
- Load Runner (2)
- QTP (3)
- Automation Testing AllOther (2)
- Manual Testing (11)
- Test Documents Reporting (1)
- Testing AllOther (1)
- Servers AllOther (2)
- COBOL (14)
- JCL (4)
- CICS (1)
- DB2 (4)
- IBM MainFrame AllOther (1)
- RPG400 (1)
- Core Java (6)
- Advanced Java (1)
- EJB (1)
- MQSeries (1)
- Middleware AllOther (1)
- HTML DHTML (1)
- Cognos (6)
- Informatica (18)
- Data Stage (1)
- SAS (2)
- ETL (1)
- HR Questions (13)
- Project Management (1)
- VoIP IP Telephony (1)
- Telecom General (1)
- SAP Basis (1)
- SAP ABAP (4)
- SAP SD (1)
- SAP CRM (1)
- PeopleSoft Financials (1)
- Siebel (1)
- Oracle Apps Financial (6)
- General Physics (2)
- General Chemistry (1)
- Dermatology (1)
- Anatomy (6)
- Mechanical Engineering (2)
- Electrical Engineering (3)
- Electronics Communications (8)
- Engineering AllOther (6)
- Business Administration (1)
- Marketing Sales (4)
- Banking Finance (2)
- Human Resources (5)
- Business Management AllOther (1)
- Audit (2)
- CompanyAffairs CS (2)
- Taxation (3)
- Accounting General (5)
- Accounting AllOther (4)
- Call Centre AllOther (108)
- RRB (1)
- NDA (1)
- BSRB Clerical (1)
- Group I (1)
- General Knowledge_Current Affairs (2)
- Government AllOther (1)
- Teaching (1)
- Funny Interview Questions (1)
- Everything Else AllOther (4)
- English (1)
- General Aptitude (4)
- Puzzles (1)
- Placement Papers (6)
- CCNA (2)
- Microsoft Certifications (2)
- USA Dependent Visa H4 Visa (1)
- GATE (1)