I decided to become MCDBA certified and bought a book (70-228) that
will help me study for the first test. I pop in one of the CD's it
came with and install the test questions. When I launch the program I
get this: http://img154.imageshack.us/img154/7...pterror2zm.jpg
Okay, I click yes, and it loads the program. I then click start test
and I get another one of those messages. I click ok and then I get a
blank screen. I figure maybe it has something to do with the fact that
I have Firefox as my default browser, so I set IE as my default browser
and have the same problem. I tried lowering the security settings all
the way with no luck as well as making sure anything related to scripts
under the advanced tab in IE settings is checked or allowed to run. I
reboot, still nothing. I install it on my laptop with XP SP2 as well,
same thing.
Has anyone run across this problem before? Are these tests not
compatible with XP SP2? I've already emailed Microsoft about it, but
I'm pretty sure I'll be certified before I get a response. Being able
to use these tests is what lead me to purchase the book in the first
place.
Edit-My friend bought the same book earlier in the year and I had him
try to install it on his XP laptop and he has the same problem.
*Bump
|||Turns out there is a patch for the program. Apparently a security fix
in SP2 breaks the program. http://support.microsoft.com/kb/885674/en-us
Showing posts with label mcp. Show all posts
Showing posts with label mcp. Show all posts
Monday, March 26, 2012
MCP Tests Off MCDBA CD Have Script Errors!
I decided to become MCDBA certified and bought a book (70-228) that
will help me study for the first test. I pop in one of the CD's it
came with and install the test questions. When I launch the program I
get this: http://img154.imageshack.us/img154/...ipterror2zm.jpg
Okay, I click yes, and it loads the program. I then click start test
and I get another one of those messages. I click ok and then I get a
blank screen. I figure maybe it has something to do with the fact that
I have Firefox as my default browser, so I set IE as my default browser
and have the same problem. I tried lowering the security settings all
the way with no luck as well as making sure anything related to scripts
under the advanced tab in IE settings is checked or allowed to run. I
reboot, still nothing. I install it on my laptop with XP SP2 as well,
same thing.
Has anyone run across this problem before? Are these tests not
compatible with XP SP2? I've already emailed Microsoft about it, but
I'm pretty sure I'll be certified before I get a response. Being able
to use these tests is what lead me to purchase the book in the first
place.
Edit-My friend bought the same book earlier in the year and I had him
try to install it on his XP laptop and he has the same problem.*Bump|||Turns out there is a patch for the program. Apparently a security fix
in SP2 breaks the program. http://support.microsoft.com/kb/885674/en-us
will help me study for the first test. I pop in one of the CD's it
came with and install the test questions. When I launch the program I
get this: http://img154.imageshack.us/img154/...ipterror2zm.jpg
Okay, I click yes, and it loads the program. I then click start test
and I get another one of those messages. I click ok and then I get a
blank screen. I figure maybe it has something to do with the fact that
I have Firefox as my default browser, so I set IE as my default browser
and have the same problem. I tried lowering the security settings all
the way with no luck as well as making sure anything related to scripts
under the advanced tab in IE settings is checked or allowed to run. I
reboot, still nothing. I install it on my laptop with XP SP2 as well,
same thing.
Has anyone run across this problem before? Are these tests not
compatible with XP SP2? I've already emailed Microsoft about it, but
I'm pretty sure I'll be certified before I get a response. Being able
to use these tests is what lead me to purchase the book in the first
place.
Edit-My friend bought the same book earlier in the year and I had him
try to install it on his XP laptop and he has the same problem.*Bump|||Turns out there is a patch for the program. Apparently a security fix
in SP2 breaks the program. http://support.microsoft.com/kb/885674/en-us
MCP Tests Off MCDBA CD Have Script Errors!
I decided to become MCDBA certified and bought a book (70-228) that
will help me study for the first test. I pop in one of the CD's it
came with and install the test questions. When I launch the program I
get this: http://img154.imageshack.us/img154/7994/scripterror2zm.jpg
Okay, I click yes, and it loads the program. I then click start test
and I get another one of those messages. I click ok and then I get a
blank screen. I figure maybe it has something to do with the fact that
I have Firefox as my default browser, so I set IE as my default browser
and have the same problem. I tried lowering the security settings all
the way with no luck as well as making sure anything related to scripts
under the advanced tab in IE settings is checked or allowed to run. I
reboot, still nothing. I install it on my laptop with XP SP2 as well,
same thing.
Has anyone run across this problem before? Are these tests not
compatible with XP SP2? I've already emailed Microsoft about it, but
I'm pretty sure I'll be certified before I get a response. Being able
to use these tests is what lead me to purchase the book in the first
place.
Edit-My friend bought the same book earlier in the year and I had him
try to install it on his XP laptop and he has the same problem.*Bump|||Turns out there is a patch for the program. Apparently a security fix
in SP2 breaks the program. http://support.microsoft.com/kb/885674/en-us
will help me study for the first test. I pop in one of the CD's it
came with and install the test questions. When I launch the program I
get this: http://img154.imageshack.us/img154/7994/scripterror2zm.jpg
Okay, I click yes, and it loads the program. I then click start test
and I get another one of those messages. I click ok and then I get a
blank screen. I figure maybe it has something to do with the fact that
I have Firefox as my default browser, so I set IE as my default browser
and have the same problem. I tried lowering the security settings all
the way with no luck as well as making sure anything related to scripts
under the advanced tab in IE settings is checked or allowed to run. I
reboot, still nothing. I install it on my laptop with XP SP2 as well,
same thing.
Has anyone run across this problem before? Are these tests not
compatible with XP SP2? I've already emailed Microsoft about it, but
I'm pretty sure I'll be certified before I get a response. Being able
to use these tests is what lead me to purchase the book in the first
place.
Edit-My friend bought the same book earlier in the year and I had him
try to install it on his XP laptop and he has the same problem.*Bump|||Turns out there is a patch for the program. Apparently a security fix
in SP2 breaks the program. http://support.microsoft.com/kb/885674/en-us
Friday, March 23, 2012
MCP Exam Study Query
Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself!
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>|||Hi All,
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.|||Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself!
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself!
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>|||Hi All,
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.|||Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself!
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>
MCP Exam Study Query
Hi All,
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself! :)
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I'm currently studying for MCP exam 70-229. I'm on the database logical
>> modeling section, and have come up with this question:
>> In a non-identifying relationship, how would a join work, or is the
>> term used to describe a situation where a relationship is at fault?
>> Many Thanks,
>> Simon.
>>
>sql
I'm currently studying for MCP exam 70-229. I'm on the database logical
modeling section, and have come up with this question:
In a non-identifying relationship, how would a join work, or is the term
used to describe a situation where a relationship is at fault?
Many Thanks,
Simon.Your question is not very clear.
You can join on any two columns with similar datatypes.
There does not have to be an explicit Parent-Child (PK-FK) relationship.
However, without a relationship, the question is: would the data provide any
useful information? And the answer is: it depends.
If that helps, then I was lucky. If not, please ask again, offering some
information about what you are seeking.
Regards,
--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."
*Yet Another Certification Exam
"Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> I'm currently studying for MCP exam 70-229. I'm on the database logical
> modeling section, and have come up with this question:
> In a non-identifying relationship, how would a join work, or is the
> term used to describe a situation where a relationship is at fault?
> Many Thanks,
> Simon.
>|||Hi Arnie,
Thanks for the post, I do understand that a relatioship can be either
explicit or implicit, but I'm not sure this is what the question refers to,
to bo honest, I'm not 100% sure what the question means myself! :)
Heres an excerpt from the book I'm working from:
"A relationship is said to be identifying if the primary key of a child
entity contains all the attributes of a foreign key. If the primary key of
the child entity does not contain all the attributes of a foreign key, the
the relationship is non-identifying"
The more I read that statement, the more confused I get! 8o)
Any ideas?
Simon.
"Arnie Rowland" <arnie@.1568.com> wrote in message
news:uTMqldWlGHA.884@.TK2MSFTNGP05.phx.gbl...
> Your question is not very clear.
> You can join on any two columns with similar datatypes.
> There does not have to be an explicit Parent-Child (PK-FK) relationship.
> However, without a relationship, the question is: would the data provide
> any useful information? And the answer is: it depends.
> If that helps, then I was lucky. If not, please ask again, offering some
> information about what you are seeking.
> Regards,
> --
> Arnie Rowland, YACE*
> "To be successful, your heart must accompany your knowledge."
> *Yet Another Certification Exam
>
> "Simon Harris" <too-much-spam@.makes-you-fat.com> wrote in message
> news:%23t9mnTWlGHA.4268@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> I'm currently studying for MCP exam 70-229. I'm on the database logical
>> modeling section, and have come up with this question:
>> In a non-identifying relationship, how would a join work, or is the
>> term used to describe a situation where a relationship is at fault?
>> Many Thanks,
>> Simon.
>>
>sql
MCP Exam - 70-229
Dear All,
I am considering taking the above exam in the next few w
s.
I have attended the course that accompanies the Exam and have read the
course material.
I have also recently started reading Inside SQL Server 2000 by Kalen
Delaney.
I have been using SQL 2000 for the past 18-24 Months.
Can anyone give me any information regarding the above exam? Typically
how long is the exam and any guidance re: revision would be most
helpful.
Many thanks
BarryTypically
> how long is the exam
Its about 180 minutes (plus additional time for non native english
speakers)
For content look here (but experience is the best for preparing)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Barry" <barry.oconnor@.singers.co.im> schrieb im Newsbeitrag
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few ws.
> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||I took the exam and it was 3 hours I believe.
Your best source of all information are the BOL, IMO.
I would read Microsoft's site about the contents of the exam
and then brush up on them using the BOL.
"Barry" <barry.oconnor@.singers.co.im> wrote in message
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few ws.
> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||Armando, Jens
Thank you both for your replies - I'm off for some light reading(!) :-D
Barry
I am considering taking the above exam in the next few w
s.I have attended the course that accompanies the Exam and have read the
course material.
I have also recently started reading Inside SQL Server 2000 by Kalen
Delaney.
I have been using SQL 2000 for the past 18-24 Months.
Can anyone give me any information regarding the above exam? Typically
how long is the exam and any guidance re: revision would be most
helpful.
Many thanks
BarryTypically
> how long is the exam
Its about 180 minutes (plus additional time for non native english
speakers)
For content look here (but experience is the best for preparing)
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
--
"Barry" <barry.oconnor@.singers.co.im> schrieb im Newsbeitrag
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few w
s.> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||I took the exam and it was 3 hours I believe.
Your best source of all information are the BOL, IMO.
I would read Microsoft's site about the contents of the exam
and then brush up on them using the BOL.
"Barry" <barry.oconnor@.singers.co.im> wrote in message
news:1116000519.113047.167620@.g14g2000cwa.googlegroups.com...
> Dear All,
> I am considering taking the above exam in the next few w
s.> I have attended the course that accompanies the Exam and have read the
> course material.
> I have also recently started reading Inside SQL Server 2000 by Kalen
> Delaney.
> I have been using SQL 2000 for the past 18-24 Months.
> Can anyone give me any information regarding the above exam? Typically
> how long is the exam and any guidance re: revision would be most
> helpful.
> Many thanks
> Barry
>|||Armando, Jens
Thank you both for your replies - I'm off for some light reading(!) :-D
Barry
Subscribe to:
Posts (Atom)