GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

SQL Server Interview Questions


SQL Server Interview Questions

Questions: 94
Comments: 292
 SQL Server Tags
 Showing Questions 61-70 of 94 Questions
<< Previous 3 4 5 6 [7] 8 9 10 Next >>
 Sponsored Links

 
 SQL Server Interview Questions
Sorting Options :  

How many column maximum we can add in one table and how many foreign key maximum we can use in one table?
Read Answers (14) | Asked by : Rado mathan Kumar

1. Types of Triggers in Oracle 2. Can we relate two different tables from two different users in ORACLE,PL/SQL? 3. How can I combine sequence with select statement which is used in another insert statement. i.e.Insert 4. if records are inserted into table without committing.How to refer to these values in a procedure? 5. when we need to use USING clause in the sql?For example in this below:SELECT emp_name, department_name
Read Answers (1) | Asked by : lavanya

Latest Answer: Select Columnname from Tablename Groupby Columnname Having Count*>1 ...
Read Answers (10) | Asked by : Srinu

1)What is the maximum value that can be stored for a datetime field? a. Dec 31, 9999 b. Jun 6, 2079 c. Jan 1, 2753 d. Jan 1, 2100 2)What is the correct SQL syntax for returning all the columns from a table named "Persons" sorted REVERSE alphabetically by "FirstName"? a. SELECT * FROM Persons WHERE FirstName ORDER BY FirstName DESC b. SELECT * FROM Persons SORT REVERSE 'FirstName' c. SELECT * FROM Persons ORDER BY -'FirstName' d. SELECT
Read Answers (3) | Asked by : samir khan

Latest Answer: SQL*Loader is strictly an ORACLE product.  Most of not all vendors provide some kind of utility to load tables from flat files. It's not a question of comparison; you can't use SQL Loader in DB2, neither can you use the DB2 Load Utility in Sybase. ...
Read Answers (2) | Asked by : rammoha

I need to set up a named set within a cube selecting only 2 members, can anyone out there provide me with a simple piece of MDX that will achieve this?
View Question | Asked by : shurl

I did not took backup for a database.My colleague had mad some changes to some Stored procedures and I want to roll back to the original codr.Since he did not used the begin transaction i am not able to rollback the changes.>How can I get back to my original code?
Read Answers (1) | Asked by : rajkasa
Tags : Backup

What is the use of database index (apart from fast searching of records);What is use of composite key ?
Read Answers (2) | Asked by : forces

Latest Answer: It's a tool that ships with SQL Server to profile sql querie and fine tune slow performance degrading sql queries by looking at how sqlsever executes them . It contains tools like index tuning wizard to improve performance.Go to http://microsoft.msdn.com ...

Latest Answer: Create [shared/public] database link connect To identified by using Any problem Don't hesitate write to rahultripathi@myway.com ...
Read Answers (1) | Asked by : Beena

View page << Previous 3 4 5 6 [7] 8 9 10 Next >>

Ask A Question
Go Top
 Sponsored Links

 
Ask Question
You must login to Ask Question or Register your free account

Category:

 
Question Title:


Question in Detail:

Add this to my Subscribed Questions (?)
Send me email when new answer is posted (?)

 
Subscribe
Get Latest Updates Via RSS Reader or by Email
 Forum Discussion Subscribe to Forum Discussions Via E-Mail Latest Forum Discussions Subscribers
 Knowledge Base Subscribe to Knowledge Base Series Via E-Mail Knowledge Base Subscribers
 Learning Series Subscribe to GeekInterview Learning Series Via EMail Learning Series Subscribers
 Freelance Jobs Subscribe to GeekInterview Freelance Jobs Via EMail Latest Freelance Jobs Subscribers
 GeekInterview Blog Subscribe to GeekInterview Blog Via EMail GeekInterview Blog Subscribers
 Testing Interview Questions Subscribe to Testing Interview Questions Via EMail Testing Interview Questions Subscribers
 Oracle Interview Questions Subscribe to Oracle Interview Questions Via EMail Oracle Interview Questions Subscribers
 Java Interview Questions Subscribe to Java Interview Questions Via EMail Java Interview Questions Subscribers
 Latest Placement Papers Subscribe to Latest Placement Papers Placement Papers Subscribers
 Free Training Subscribe to Free Training Via EMail Free Training Subscribers
 Learn AJAX Subscribe to AJAXwith.com Via EMail AJAXwith Subscribers
Sponsored Links

 




About Us  |   Privacy Policy  |   Terms and Conditions  |   Contact  |   Site Map  |   Add Question  |   Propose Category  |   RSS Feeds  |   Articles Sitemap  |   Site Updates  |   Add Resource

Copyright © 2005 - 2008 GeekInterview.com. All Rights Reserved
Page copy protected against web site content infringement by Copyscape