Please Interview Me
-
I am having an interview on Friday 25 March. Most of the subject matter I am comfortable with, but my SQL is a bit rusty due to not using it for around 7 years. Now I pose to you denizens to ask me a question. 0. Something that would be likely for an interview, 1. Concerning SQL - restrict it to Oracle or SQL Server, 2. That I can try to answer. I won't use any search, but will try and answer from the thick region of me head. Thank you guys [and gals].
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
-
I am having an interview on Friday 25 March. Most of the subject matter I am comfortable with, but my SQL is a bit rusty due to not using it for around 7 years. Now I pose to you denizens to ask me a question. 0. Something that would be likely for an interview, 1. Concerning SQL - restrict it to Oracle or SQL Server, 2. That I can try to answer. I won't use any search, but will try and answer from the thick region of me head. Thank you guys [and gals].
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
SQL Server Question (taken from sql server central question of the day!)
CREATE TABLE #Money
(ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Date DATETIME,
Amount INT,)SET IDENTITY_INSERT #Money ON
INSERT INTO #Money(ID,Date,Amount)
SELECT '1', ' 2/10/2010 ','12' UNION ALL
SELECT '2', ' 2/11/2010 ','13' UNION ALL
SELECT '3', ' 2/12/2010 ','14' UNION ALL
SELECT '4', ' 2/13/2010 ','15' UNION ALLSELECT SUM(AMOUNT) FROM #Money
Will the create statement fail? will the insert statement fail? will the select sum(amount) from #money fail? Possible answers 1. The CREATE TABLE statement will fail, and hence so will all the following sql statements. 2. The INSERT INTO statements will fail and hence so will all the following sql statements 3. The SELECT SUM(Amount) will return a value of 54 4. The SELECT SUM(Amount) .. statement will fail
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
SQL Server Question (taken from sql server central question of the day!)
CREATE TABLE #Money
(ID INT IDENTITY(1,1) PRIMARY KEY CLUSTERED,
Date DATETIME,
Amount INT,)SET IDENTITY_INSERT #Money ON
INSERT INTO #Money(ID,Date,Amount)
SELECT '1', ' 2/10/2010 ','12' UNION ALL
SELECT '2', ' 2/11/2010 ','13' UNION ALL
SELECT '3', ' 2/12/2010 ','14' UNION ALL
SELECT '4', ' 2/13/2010 ','15' UNION ALLSELECT SUM(AMOUNT) FROM #Money
Will the create statement fail? will the insert statement fail? will the select sum(amount) from #money fail? Possible answers 1. The CREATE TABLE statement will fail, and hence so will all the following sql statements. 2. The INSERT INTO statements will fail and hence so will all the following sql statements 3. The SELECT SUM(Amount) will return a value of 54 4. The SELECT SUM(Amount) .. statement will fail
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
0. I'm not sure
#Moneyis a valid table name; but I'll accept it for now. 1. The end of theCREATEstatement is invalid, there is an extra comma -Amount INT,), so it and everything else fails. 2. If theCREATEwas okay then I think the rest is fine and theSELECTwill return54.
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
-
I am having an interview on Friday 25 March. Most of the subject matter I am comfortable with, but my SQL is a bit rusty due to not using it for around 7 years. Now I pose to you denizens to ask me a question. 0. Something that would be likely for an interview, 1. Concerning SQL - restrict it to Oracle or SQL Server, 2. That I can try to answer. I won't use any search, but will try and answer from the thick region of me head. Thank you guys [and gals].
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
Simon's question is a good one, and you can probably expect more than one of that sort of tests if the use of SQL is an integral part of the job. If SQL is just "good to know" for this job, you can expect some simple questions measuring your basic understanding of SQL: - What does
USE OUR_COMPANY_LTD_DATABASEdo? - What is the difference betweenUNIONandUNION ALL? - What doesCOALESCEdo ? - What is the difference betweenINNER JOINandLEFT OUTER JOIN? - How willISNULL()help you in getting reliable results in queries using theSUM()function.My advice is free, and you may get what you paid for.
-
0. I'm not sure
#Moneyis a valid table name; but I'll accept it for now. 1. The end of theCREATEstatement is invalid, there is an extra comma -Amount INT,), so it and everything else fails. 2. If theCREATEwas okay then I think the rest is fine and theSELECTwill return54.
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
0. Tables names with # in sql server are temporary tables. 1. I thought the same but sql sever ignores this and creates the table and tested the actual create table statement myself, but dont know why! the correct answer is 54. Explanation: From CAST and CONVERT (Transact-SQL)[^] Implicit Conversions: Implicit conversions are those conversions that occur without specifying either the CAST or CONVERT function. Explicit conversions are those conversions that require the CAST or CONVERT function to be specified. Scroll down to the illustration which shows all explicit and implicit data type conversions that are allowed for SQL Server system-supplied data types. These include xml, bigint, and sql_variant. There is no implicit conversion on assignment from the sql_variant data type, but there is implicit conversion to sql_variant.
As barmey as a sack of badgers Dude, if I knew what I was doing in life, I'd be rich, retired, dating a supermodel and laughing at the rest of you from the sidelines.
-
I am having an interview on Friday 25 March. Most of the subject matter I am comfortable with, but my SQL is a bit rusty due to not using it for around 7 years. Now I pose to you denizens to ask me a question. 0. Something that would be likely for an interview, 1. Concerning SQL - restrict it to Oracle or SQL Server, 2. That I can try to answer. I won't use any search, but will try and answer from the thick region of me head. Thank you guys [and gals].
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
-
I am having an interview on Friday 25 March. Most of the subject matter I am comfortable with, but my SQL is a bit rusty due to not using it for around 7 years. Now I pose to you denizens to ask me a question. 0. Something that would be likely for an interview, 1. Concerning SQL - restrict it to Oracle or SQL Server, 2. That I can try to answer. I won't use any search, but will try and answer from the thick region of me head. Thank you guys [and gals].
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
And few other collections to enjoy: - SQL Server Interview Questions - Part 1[^] - SQL Server Interview Questions and Answers Complete List Download[^] - SQL SERVER - Data Warehousing Interview Questions and Answers Complete List Download[^]
The need to optimize rises from a bad design.My articles[^]
-
I am having an interview on Friday 25 March. Most of the subject matter I am comfortable with, but my SQL is a bit rusty due to not using it for around 7 years. Now I pose to you denizens to ask me a question. 0. Something that would be likely for an interview, 1. Concerning SQL - restrict it to Oracle or SQL Server, 2. That I can try to answer. I won't use any search, but will try and answer from the thick region of me head. Thank you guys [and gals].
Panic, Chaos, Destruction. My work here is done. or "Drink. Get drunk. Fall over." - P O'H OK, I will win to day or my name isn't Ethel Crudacre! - DD Ethel Crudacre
http://guru-code.blogspot.com/[^] Its a very good blog . Select Sqlserver from the tab.