Few concepts and questions
- Hi all,
If any one can help me to understand these few questions and answers ?
1) What is the concept ensures the "all or nothing" nature of transactions ? Isolation or Consistency or some thing else ?2) What is the concept ensures the permenant nature of transaction ? Isolation or Consistency or completeness or some thing else ?
3) What kind of lock general select statment applies ? Shared or read or some thing else ?
4) What error will be displayed and how many transactions will be committed ?
Begin Transaction tr1
sql text
begin transaction tr2
sql commands
commit tr2
begin transaction tr3
Rollback
Can you explain what will happen and how many transaction will take place ?
5) What is the best way to shut down the computer when few users are still connected ? Pause or stop the sql service before shutting down ?
6) Which table will hold newly inserted rows for inspection by trigger ATrig which fires on insert statment ? #ATrig or ##ATrig or some thing else ?
7) When " Backup " option is used with backup statment ?
8) What type of SQL Srv 2k role has NO users assosiated with it ?
9) What is NOT a consequence of running disabled publishing and distribution wizard ?
a) All subscription databases receiving updates through the host server are dropped.
b) all subscriptions to the publication distributed through the host server are dropped.
c) all distribution databases on the host server are dropped.
d) all publishers using the host distributor are disabled.
10) Can nonclustered indexes can speed join statment ? are they effeciant then table scan ? can they avoid worktable creation if columsn matcher order by clause. ?
11) Which is better bcp utility or data transformation services ? when copying data from MS Access ? Basically upgrading ms access DB to SQL Server.
Thanks in advance.
Kindest Regards, -
Should we send the answer to you or directly to your professor
HTH
==============================
During times of universal deceit, telling the truth becomes a revolutionary act. -George Orwell, writer (1903-1950) -
1) I recommend cash and a handgun.
2) Google ACID transaction
3) Master (or Yale, but never Harvard)
4) Invalid command "sql text"
5) Always pull the plug, unless you can get to the breaker box.
6) Trick question: firing with a trigger inserts bullets, not rows.
7) When writing, sentence fragments.
8) Confidence Man 2 - not a popular role.
9) e. Misspoken spell turns all subscriber databases, into subscriptions to the Wall Street Journal.
10) Consider tableclothes.
11) That is an invalid upgrade path; you have to buy a new SQL Server license.
One or two of these might actually be helpful, if you think about them right.
R David Francis -
Let me tell the correct answers.
1.) Atomicity
2.) Durability
3.) Shared Lock
4.) No error will be displayed and no transaction will take place, as its one session.
5.) Pause the Service, shutting down while users are connected may make users lose data.
6.) #Atrigger, temerory tables are used to store values. ## means global temperory.
7.) Backup is not a valid switch.
8.) Application role dont have any users.
9.) All subscription databases receiving updates through the host server are dropped.
10.) They can speed up join. Yes they are efficent then tablel scan. Yes they can avoid work table creation.
11.) BCP Utility is better, because data will be transfered once, DTS will create a package.
Kindest Regards, -
Hi,
What do you mean "correct answers"? I and many of our friends can successsfully argue on each one.
For example, my correct answer to 5 as we do in production is to notify users in advance of the exact time when downtime will take place, notify them again 30 min before the fact, use Current Acvtivity window to see who is working, call each user who is still working personally and only after that shut down the service.
BCP versus DTS: you don't have to save a DTS package, it has the ability just to run once. BUT... DTS does have a user interface while you have to be very familiar with BCP to create a correct job from the first try. You may try it yourself. I bet, you will get data with DTS in 5 min versus 8 hours of tests with BCP
Yelena
Regards,Yelena Varsha
-
Hi veteran
Thanks for the comments but i was not looking for what individual DBA do or what people feels easy in. The main thing is the standard and right way to do.
Question number 6 : Data goes to " inserted " table. That was my mistake in typing.
In few hundred users you can sit and make phone calls, also You can pull out the network cable from the computer too and kick out connected users from job on not following orders. The standard is when you pause the SQL Server it makes a graceful shut down and saves data. Shuting down is mostly when you have any problem or want to change the configuration. ( reference books online)
You can use DTS or even can use Access Upsize wizard. The standard is when you already have created database and copying data from a file you use BCP utility, this is a standard way. If you study little bit i am sure you can learn to do diffecult things in standard way instead of using book " SQL Servers for dummies "
Since i noticed lot of DBA likes to make calls to users to stop using system, they can most probably sit and do data entry in tables directly.
No offence, just thought to provide some knowledge.
Syed
Kindest Regards, -
"Thanks for the comments but i was not looking for what individual DBA do or what people feels easy in. The main thing is the standard and right way to do."
There is no standard or right way that applies to all scenarios. Each individual site will have it's own standard or right way.
"In few hundred users you can sit and make phone calls, also You can pull out the network cable from the computer too and kick out connected users from job on not following orders. The standard is when you pause the SQL Server it makes a graceful shut down and saves data. Shuting down is mostly when you have any problem or want to change the configuration. ( reference books online)"
In one of my many DBA positions one of the servers was used by 6 people. The "standard" way of shutting down the server was to call the users.
"You can use DTS or even can use Access Upsize wizard. The standard is when you already have created database and copying data from a file you use BCP utility, this is a standard way. If you study little bit i am sure you can learn to do diffecult things in standard way instead of using book " SQL Servers for dummies ""
If you study a little bit you would know that BULK INSERT is much faster than BCP when importing data into SQL Server. When you use DTS to import data it uses the BULK INSERT engine.
Maybe instead of criticising other posters and trying to apply your "standard", when you have no idea what sort of position/scenario they work, you should take their comments on board and see if they can help you in performing difficult things.
No offence, just thought I'd provide some real knowledge.
--------------------
Colt 45 - the original point and click interface
-
Read the questions, i asked the concept which is maintained by vendor not at company IT policy hand book.
I didnt asked what is easy or diffecult.
I asked a question in which scenario was already given, not that what you do at your job.
This is useless discussion , answers are already there. You can read books online and if i have missed some thing then correct me too.
Syed
Kindest Regards, -
There is no reason for anyone to get bent out of shape. The question I have is what is the poitn of this discussion?
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply