Admin Exam Question And Study Notes Require
Jun 13, 1999pls .send me sql admin exam question and study notes.
View 1 Replies
ADVERTISEMENT
Need Help Setup Volumes On Home Computer For Exam 70-431 Study
May 6, 2007Newbie here. I need help setting up volumes so I can do practice exercises for exam 70-431.
What I have on an XP Home edition personal computer are my C volume which is 300+ GB, a NTFS basic, and my CD/DVD ROM on D.
What is the code I use at command prompt to do this or can I do it from Disk Management?
Is There A Forum For Those Of Us Who Study From SS 2005 Implementation And Maintenance (Exam 70-431)??
Sep 21, 2007
Is there a Forum for those of us who study from SS 2005 Implementation and Maintenance (Exam 70-431), a la Wrox P2P user forum??
Thanks.
EXAM 70-431: Notes And Collaboration
Dec 21, 2006Hello,
Anyone planning to take the exam 70-431?
It would be nice to share experience and motivation ... I am currently using SQL Server 2005 Bible as a reference, any other references you suggest? Any place where I could find exam samples?
LLOYD
SQL 7 Admin Exam
Jan 4, 2000Does anyone know of a good book that will prepare you for this exam. I know that in some early discussions that Mike Hoetch warned against some of the new books on the market.
Thanks
Ricky Kelley
Ms Sql Admin .....exam..help
Mar 1, 2001Hi
Here is a mcdba admin question
Consider the following time line:
8:00 You accomplish the full database backup.
8:10 User1 enters the order 53 for customer 10, whose name in the database is
XXXXX (I
can't remember, but not Bill Smith)
8:12 User2 at remote server changes the name XXXXX to YYYYY
8:13 User3 changes the name YYYYY to ZZZZZ
8:14 User3 commit the transaction.
8:20 Media fails for database.
8:30 You restore the database from 8:00 backup. What is the status of the order
53 in the
database?
a) The order 53 is not in the database.
b) The order 53 is in the database and name is XXXXX.
c) The order 53 is in the database and name is YYYYY.
d) The order 53 is in the database and name is ZZZZZ.
Ans: B The name was already there.
The answer is B but I think th answer is A
becouse He or Her restroe the database from 8:00
I think the 53 order maked after 8:00 so
there is not order 53 in the backup database
How about you think and why !!!
Thanks kjs
SQL 2000 Admin Exam
Aug 2, 2001anyone know of any useful sites, resources free test etc for sql 2000 admin exam
View 1 Replies View RelatedSQL Server Admin 2014 :: Does DBCC LOGINFO Require SysAdmin Rights
Sep 28, 2015DBCC LogInfo command require SysAdmin rights?
View 2 Replies View RelatedChanging Field Property To Not Require From Require?
Nov 6, 1998Hi everyone,
I have a table which have several fields. I have a field that is made required by mistake. I would like to change this field to not require. Can someone help with the syntax?
Any help is greatly appreciate.
I Wnt Study Sql Server Extensively
Jan 18, 2008
i wnt study sql server extensively
suggest some sites.
with regards
jagadeesh
Self Training Software?? Study Material?
Aug 30, 1999Has anyone used any CBT's for SQL7 or could recommend a good company for study materials. I have seen the product from CBT systems and Keystone and was not impressed.
View 2 Replies View RelatedMCDBA - Study Materials Needed
Feb 27, 2002Hi,
Does anyone have a copy of the MS SQL2000 Administrator exam...??
What's The Best Study Guide Outhere To Pass 70-229
Jan 30, 2005hi guys,
what's the best book outthere that can help me to pass microsoft sql exam
70-229?
rgrds
Mosaad
MCP Exam 70-028
May 24, 2001hi all,
Iam planning to write MCP exam for SqlServerAdministrator. what r the best books and sites to refer.
thanks
keerthi
Exam 70-291 && 70-293
Sep 28, 2004Looking for testking 70-291 & 70-293, I have other exams to share.
let me know if intrested?
70-229 Sql Exam
Feb 9, 2004please help me to find a link that i can download the 70-229 sql v3.1 exam with no payment.
View 2 Replies View RelatedExam 70 - 299
Mar 15, 2004Hi,
am planning to appear for the exam 70 -299 Designing and Implementing Databases with Microsoft SQL Server™ 2000 Enterprise Edition.
anyone who has given that exam, please guide me
Thanks in advance
sudsur
SQL Exam 70-228, Need To Re-take
May 12, 2004well i took it and failed,
the test centre i went to in the UK had a pass mark for SQL Administration 70-228 of 70% out of 100%
does anyone know if this is a usual pass barrier or do some other UK testing centre's offer lower pass marks, and where to find them?
Exam / T-SQL Q
Apr 19, 2006Hello, Im new so please be gentle. I'm just in the midst of studying for the SQL2K admin exam, and was going to to the Design exam straight afterwards. Ive heard that a person is much better off learing T-SQL before doing the design exam, is this the case? I will learn T-SQL anyway, but I'm wondering if learning before the design exam will make life easier for me?
Thanks for reading.
D.
Yes, we have no banana's.
A Question In Ms Exam
Oct 31, 1999hi!
i had the implementing database on sql server 7.0 exam this morning. there's a question that confuse me too much, it's fellowed
there are 3 columns on which you wanna create the composite index, A,B and C, A is almost identical, B is almost 50% identical and C is only 10% identical, i had the implementing database on sql server 7.0 exam this morning. there's a question that confuse me too much, it's fellowed
there are 3 columns on which you wanna create the composite index, A,B and C, A is almost identical, B is almost 50% identical and C is only 10% identical, then they asked which index enable the fastest query?
the choices:
A.clustered (A,B,C)
B.nonclustered (A,B,C)
C.clustered (C,B,A)
D.nonclustered (C,B,A)
i think the sequence must be C,B,A, but how about the clustered or nonclustered? i guess it's will be nonclustered.
ok, it's there.
could you help me? i wanna know when should be clustered besides the primary key and when should be the nonclustered.thanx!
MS SQL Server 6.5 Exam
Nov 12, 19981.You use new database dialog to create DB, but there's not available
Device, what is your quickest way to create a new device.
2.-Data and log are on same device, you issue:
DUMP database mydb to dump1
DUMP transaction mydb with truncate_only
What happened to trans log?
3 -Setting up Windows client to access your server, you enter the IP address
of the PDC, would this work?
Passed My 70-228 Exam!
Dec 27, 2005finally on the road to becoming a full blown ass kicking mcdba!
passed it before christmas with the help of my girlfriend.
brilliant or what!
failed it last time back in 2004
all the best and have a cracking 2006 all!
Mcsd Exam
Apr 5, 2007I intend writing MCSD exams and would need some dumps on it.. if anyone happens to have, please kindly send me some @ gomesea@yahoo.com. I would glady appreciate it. Presently, I've written thr 70-305 exam.
View 4 Replies View Related70-228 Exam Questions.
Jan 7, 2004Hello all,
I am preparing for 70-228 (SQL server Administration) exam. I was looking on the internet for some exam oriented questions or question bank kind of thing. I found couple of them but those are not sufficient. I would appreciate if you could let me know if you know any sites where i can get some more questions to solve. I would really appreciate if anybody has a questions bank and would like to share it with me.
Thanking in advance.
Mandar
Exam Problem
Sep 20, 2005What initial values of a and c are required such that the final values of a and b are:
a = 32
b = 4
…
int a,b,c
a = ?
b = 0
c = ?
for( b=0; a<12; b++ )
{
a = (a+a) * c;
}
…
I know its not the area but i'm hoping someone has an idea
Best Guide For Exam 70-229
Oct 25, 2007I've gone through the Microsoft press study material for Exam 70-229. It is okay but not really comprehensive. I'd appreciate any supporting book that deals with the exam topics inside out... And info on any site which offers good practise exams is also appreciated.
Thank you.
SQl 2005 Exam 70-431
Apr 8, 2008hi guys i just wanna know a lil bit about 70-431 exam.
there is 35 question and 12 simulation quiz.
what i wanna know how many points per right answer? and how many points we recieve per right answer for simulations?
Preperation For Exam 70-431
Oct 27, 2006Hi
I'm not sure if this is the right forum to be posting this query as I am a newbie, but here goes. I will be taking the sql server 2005 exam in december and was wondering whether anybody could recommend any good books. The prepertion guide on the ms site has an overload of information which I am just getting lost in! I will also be purchasing these free e-courses on the ms site and wanted to know once I have purchased them how long will I have access to the courses. Also can I access them on the net from any machine.
I have just recently passed exam 70-315 and found that the exam questions were very similar to the TestKing questions which I made use of prior to the exam. So I will definetley be buying TK Q's for this exam also.
Many Thanks
Vik
70-441 Exam Pattern
Jan 30, 2008
hi can any one help me to get the pattern of 70-441 exam.
i need information total number of question in the exam..
and will there be any simulation as 70-431 exam.
Help (require Code)
Mar 13, 2004right im programming a database program and i need some code. (the database is in sql/msde)
This is what i am attempting to do:
I have a page with textboxes on it with buttons at the bottom
i need to program the database with the add function
this is the code that i have already
Imports system.data.sqlclient
'You need two objects
Dim conn as new sqlconnection
dim comm as new sqlcommand
conn.connectionstring = "Your UDL String here"
comm.text = "insert into books (isbn, title, author, publisher, description, price,)
'books is the name of the databse
values ( '1234' , 'Title', 'Author', 'Publisher' )
conn.open
comm.connection = conn
comm.executenonquery
comm.close
conn.close
now i think i need to insert this at the top of the page but im not 100% sure (btw i have the udl string)
so what do i need to add to this code to make the page submit data that has been enterd into textboxes into a database table(sql/msde) on the click of the button?
thanks for any help provided
URGENT REQUIRE HELP
Feb 11, 2002Hi
1) I am facing the problem of database suspect how do I solve the problem.
2) When I tried to cofigure my SQL mail I am not getting the option or Icon of SQL MAIL in the enterprise manager. I think it probably got deleted , how do I retrieve it .
Thanks for the help in advance
Arya Sharma
70-431 SQL Server 2005 Exam
Sep 20, 2006hi there, i am planning to take the exam 70431 for sql server 2005 ...does any one have a good exam and course material either online or it will be great if it could be emailed to me. Thanks in advance
View 3 Replies View RelatedSQL Server Certification Exam
Aug 3, 2004Hello,
My employer has recently offered to pay for my certification exam (70-229) so I am about to start preparing/revising. Having visited numerous sites to get an idea of what is needed, I am now overwhelmed with info.
Has anyone out there successfully completed the exam and if so can you recommend any sites/resources that you found useful (or any to avoid).
Regards
Simon