SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Questions that were asked during my interview


Questions that were asked during my interview

Author
Message
prakashr.r7
prakashr.r7
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 197
Hi Friends,

I had an interview last week and I was asked few questions "1.What is the difference between OLEDB and OLAP and OLTP ? " I was not able to give exact answer difference OLEDB and OLAP. "2. Difference between dimension and fact table ? " , "3. Difference between transaction option in SSIS b/w supported and required ? "

Can any one please explain me what are they ?
stevefromOZ
stevefromOZ
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

Group: Moderators
Points: 3460 Visits: 3757
For questions 2&3, I recommend you Google those and come back to the forum if you find answers you can't seem to grasp.

Question 1 - either you took down the info incorrectly or it was a "trick" question that unfortunately you failed. Oltp and olap are four letter acronyms, which again if you Google them will give you vast volumes of description. Oledb is a driver technology, used for accessing data in a database ( ie part of the plumbing)

Steve.
prakashr.r7
prakashr.r7
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 197
Sorry Steve...

I was just telling the questions, I was asked. But I am really not having answer for the first and third question.
1. Difference between OLEDB and OLAP....May be I was tricked like you said...:-)
2. for the 3rd question he asked me "there are two containers contains two SQL tasks. One container is set to option required and other one to supported. When one task in each container fails, whether other task would roll back or not?"
I told "both will roll back"
and he siad "If both of them rolled back, then what is the difference between setting options to required and supported? "

Steve, Could you please clarify me ?
GilaMonster
GilaMonster
SSC Guru
SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)SSC Guru (87K reputation)

Group: General Forum Members
Points: 87071 Visits: 45267
prakashr.r7 (5/5/2014)
1.What is the difference between OLEDB and OLAP and OLTP ?


I suspect you either misheard or that was a trick question. OLEDB is something completely, totally different from OLAP and OLTP. Like asking "What's the difference between an airplane, an apple and an orange?"

Regardless, a google search for each of the three acronyms will give you their definitions, from their definitions you can get the differences.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass


prakashr.r7
prakashr.r7
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 197
I am very sure, that they asked me like that. Because , I asked them twice to make sure that I heard what exactly they asked.
I told them the answer of What we do with OLEDB. And you know, a month ago, there was another interview, and this guy asked me diff b/w OLEDB and OLTP.
I know that there are no differences, and they are totally different like you said but I was very confused since I was asked these questions in two interviews.
Since then I started to think, "is there really any relation b/w OLEDB with OLAP and OLEDB and OLTP.....?? "

So that's why I just came here so that you gurus will clarify me....
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27307 Visits: 13268
prakashr.r7 (5/5/2014)

I am very sure, that they asked me like that. Because , I asked them twice to make sure that I heard what exactly they asked.
I told them the answer of What we do with OLEDB. And you know, a month ago, there was another interview, and this guy asked me diff b/w OLEDB and OLTP.
I know that there are no differences, and they are totally different like you said but I was very confused since I was asked these questions in two interviews.
Since then I started to think, "is there really any relation b/w OLEDB with OLAP and OLEDB and OLTP.....?? "

So that's why I just came here so that you gurus will clarify me....


OLAP and OLTP are architectural designs of a database. The first is optimized for analytical queries, the second one for doing as much transactions as fast as possible. Hence their names...

OLEDB is a type of provider used to connect to databases. It is something completely different. But it is possible that an ETL system that loads data into database (be it OLAP or OLTP) uses OLE DB connections.

The answer to the transaction question is: it depends. The required one will roll back, the second one might roll back if its parent container has a transaction setting to Required. If not, it will not roll back.

"If both of them rolled back, then what is the difference between setting options to required and supported? "
--> depends on the settings of the parent container


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
Koen Verbeeck
Koen Verbeeck
One Orange Chip
One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)One Orange Chip (27K reputation)

Group: General Forum Members
Points: 27307 Visits: 13268
Just some friendly advice: if you didn't know the answer to those questions, you might want to look for junior positions.
You have some catching up to do.


How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?
My blog at SQLKover.

MCSE Business Intelligence - Microsoft Data Platform MVP
prakashr.r7
prakashr.r7
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 197
Thank you for the answers and for the advise too..I take it for sure.

Koen, I have told them the answers. The answers I told them are not exactly like you told but some how I managed to tell them correctly. But they were starring at me like I was wrong. So I got to doubt myself. So that's why I posted these questions in here to clarify myself. And more over I got selected for the position. :-)

I really thank and appreciate you for your time that you took to reply my questions (stupid, may be :crazySmile
herladygeekedness
herladygeekedness
Mr or Mrs. 500
Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)Mr or Mrs. 500 (512 reputation)

Group: General Forum Members
Points: 512 Visits: 813
Congrats!! Spotting the trick questions may have grabbed that job for you as another candidate that really didn't know might have started down some path of mumbo jumbo in order to equate OLE DB with OLAP.

Best of luck in new job!!
prakashr.r7
prakashr.r7
SSC Veteran
SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)SSC Veteran (230 reputation)

Group: General Forum Members
Points: 230 Visits: 197
Thanks Herald...It was ma luck that I also did not try to relate it...:-)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search