Solved

Need a handful or practice queries for an upcoming live test

Posted on 2008-09-29
2
237 Views
Last Modified: 2013-12-07
I'm  studying  for a live test in  which I'll be put in front of  a  computer and given queries to write.  This is not for a DBA position, it's a C# developer's role.

What kinds of questions would you pose?

I'd love to see them and see how many I could write without getting stumped.  I expect at least a few joins, and imagine at least one where the query is embedded in another querie.  (What's that  called?)



thnks  for  the help,
newbieweb
0
Comment
Question by:newbieweb
2 Comments
 
LVL 59

Accepted Solution

by:
Kevin Cross earned 250 total points
Comment Utility
0
 
LVL 1

Assisted Solution

by:Digitasupport
Digitasupport earned 250 total points
Comment Utility
What you are referring to is called a 'Nested query'
A query within a query
You need to look at possibly the following query methods:-
Simple selects
Joins (Left , right , inner , outer , Union)
Nested queries.
Updates , Inserts , Deletes , maybe you need to know how to updtae system catalogues as well.
As mentioned above , W3schoools is good , but the beolw i feel is more relavant to you:-
http://msdn.microsoft.com/en-us/library/ms189826.aspx
This is where i would start to research certain query methods , as this will go by the 'Microsoft grian'
Hope that helps you:)
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

This post first appeared at Oracleinaction  (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now