DBA scenarios asked in interviews???
-
Hello friends!
How to deal with such scenarios
1) what is minimum size of DB that should server creates by default??
2) how do you know that database size is full and what happened then and what is your next step of action you will take??
3) how do you decide your temp database size???
4) If you have database of size say 100GB and if your daily data coming is about 2.5 GB then how much period it will take to full database size.
5) what are initial stages you will decide before creating any database?? as well as installing sql server 2000..
Regards,
Papillon
-
Papillon
Come on, you must be able to work out the answers to at least some of those! Let us know what you think the answers might be, and we'll comment. For instance, if those are questions you've actually faced, how did you answer? Otherwise it's a bit too much like we're doing your homework for you!
John
-
I don't understand the significance of the post - if you can't answer these questions then you cannot be a dba and if it's in regard to an interview then you're wasting the interviewer's time!
These are simple questions, in fact so simple I wouldn't ask them at an interview, maybe with the exception of Q2 - which I would pose in a much more interesting way!!
I figure most of this would be in BOL or covered in the admin training course.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
I would agree with Colin. Answering these in an interview and getting the job lets you and the employer down. Especially if you cannot even find the answers in Books Online. Having us answer them doesn't do you any good.
I would ask some of these, but it would be abvious if you knew what the answer meant. I actually like 3 and 5 as well because I could see how you think. There is no "answer" for these, but merely a philosophy and explanation of why you'd go down a particular path.
-
yeah, agreed on 3 & 5, I usually tend to ask questions which explore, hopefully, how a candidate thinks - questions without clear cut answers are good for that. I did actually look at my post afterwards and wonder if I'd been a bit harsh, so apologies if I casued any upset.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Hello Friends!!
I walked through some very good articles that cleared my doubts....
Thanks for your pointing
http://www.sql-server-performance.com/faq/sqlviewfaq.aspx?faqid=26
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_access.htm
http://www.databasejournal.com/features/mssql/article.php/3087841
http://www.mssqlcity.com/Articles/Compare/sql_server_vs_oracle.htm
http://www.informit.com/articles/article.asp?p=19710&rl=1
Regards,
Papillon
-
hmmm .. I'd be slightly wary of the first and last references, the articles are not complete , in fact you'd probably fail an interview if you followed one route in the last article.
Although BOL isn't always a totally complete answer I think you'd do better starting there, probably followed by the SQL Admin companion, or the inside sql books.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
Hmmm.. thanx
I will again walk through web articles
Regards,
Papillon
-
The answer to question one is the default database size will be whatever the size of the model database is; at least for the data portion. The log file is actualy 63 pages for 504kb.
How do you know when the database is full. Here we have to define full. Assuming default setting you'll know your database is full when their is no free disk space left on the drive/s allocated to the database. If the database is not set to autogrow then what the allocation has no free space left then sql server will send an error message for anyone trying to insert into that database, or log a transaction.
-
The answer to question one is the default database size will be whatever the size of the model database is; at least for the data portion. The log file is actualy 63 pages for 504kb.
How do you know when the database is full. Here we have to define full. Assuming default setting you'll know your database is full when their is no free disk space left on the drive/s allocated to the database. If the database is not set to autogrow then what the allocation has no free space left then sql server will send an error message for anyone trying to insert into that database, or log a transaction.
-
Actually, the log file will default to the larger of 504Kb or 25% of the total size of all data files in the database. So if the model database has a data file of 1 GB, then the default log file size would be .25 GB.
I think the interviewer would want to know how you would determine that there is no more allocated space in the database or drive rather than just defining the concept of a full database.
Colin brings up a good point about the articles not being complete. A good interviewer will be able to tell the difference between someone that knows the answer and someone that is simply repeating what they read. Try to learn as much as a you can and give complete answers.
For example, when I interviewed for my current job, one of the questions asked of me was what kind of index would be created by the statement "Create Index ix_MyIndex on MyTable(MyColumn)". Most people they interviewed said that it created a standard index and when asked for more information, many were able to define it further. They told me that I was the only person interviewed who gave a complete answer. My answer was, "it creates a nonclustered, non-unique index".
My blog: SQL Soldier[/url]
SQL Server Best Practices: SQL Server Best Practices
Twitter: @SQLSoldier
My book: Pro SQL Server 2008 Mirroring[/url]
Microsoft Certified Master: SQL Server, Data Platform MVP
Database Engineer at BlueMountain Capital Management[/url] -
Where was the interview at ??? Maybe they need some consulting services ...
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply