I took one online test on SQL Server Admin, Four qustions i was not sure
answer
can any provide me answer
1. If you want to be able access the customers table directly from a Web
browser,
what database name must you configure in with the IIS Virtual Directory
Management Tool?
2. While backing up a database to a tape drive, the tape runs out of
space. You
replace the tape. Referring to the scenario above, what is the
correct way
to complete the backup?
3. What is different between Cluster and non cluster.
4. When do you need to use the REPLACE switch while restoring databases?
Thanks
kalyanHi
Taking the questions out of context makes them even more vaguer than usual!!
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
>I took one online test on SQL Server Admin, Four qustions i was not sure
> answer
> can any provide me answer
> 1. If you want to be able access the customers table directly from a Web
> browser,
> what database name must you configure in with the IIS Virtual
> Directory
> Management Tool?
The database will be the database where the customers table is located. You
don't have to name your virtual directory with the same name as the database
and the IIS Virtual Directory Management Tool allows you to create that
mapping.
> 2. While backing up a database to a tape drive, the tape runs out of
> space. You
> replace the tape. Referring to the scenario above, what is the
> correct way
> to complete the backup?
You will be prompted for the contiuation tape which once loaded you should
acknowledged Label and keep the tapes and when restoring the database load
the last tape first.
> 3. What is different between Cluster and non cluster.
Clustered tables and indexed views keep their data rows in order based on
the clustered index key
> 4. When do you need to use the REPLACE switch while restoring databases?
>
REPLACE will overwrite a database/datafile with the same name if they
already exist and bypasses checks that are made if you don't specify it.
You may want to check out books online for more detailed explanations.
John
> Thanks
> kalyan
>
>|||John
here is details about those questions
1. If you want to be able access the customers table directly from a Web
browser,
what database name must you configure in with the IIS Virtual Directory
Management Tool?
Choice 1
Dbobject
Choice 2
Xpath
Choice 3
Schema
Choice 4
Direct
Choice 5
Template
2. While backing up a database to a tape drive, the tape runs out of space.
You
replace the tape. Referring to the scenario above, what is the correct
way to
complete thebackup?
Choice 1
Repeat the previous backup command, adding the BEGIN option.
Choice 2
Repeat the previous backup command, adding the INIT option.
Choice 3
Repeat the previous backup command, adding the NOINIT option.
Choice 4
Repeat the previous backup command, adding the RESTART option.
Choice 5
Repeat the previous backup command, adding the BACKUP option.
Following is general question of my own not from any test
What is different between Cluster and non cluster.
When do you need to use the REPLACE switch while restoring databases?
Thanks
Kalyan
"John Bell" wrote:
> Hi
> Taking the questions out of context makes them even more vaguer than usual!!
> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
> news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
> >I took one online test on SQL Server Admin, Four qustions i was not sure
> > answer
> > can any provide me answer
> >
> > 1. If you want to be able access the customers table directly from a Web
> > browser,
> > what database name must you configure in with the IIS Virtual
> > Directory
> > Management Tool?
> The database will be the database where the customers table is located. You
> don't have to name your virtual directory with the same name as the database
> and the IIS Virtual Directory Management Tool allows you to create that
> mapping.
> >
> > 2. While backing up a database to a tape drive, the tape runs out of
> > space. You
> > replace the tape. Referring to the scenario above, what is the
> > correct way
> > to complete the backup?
> You will be prompted for the contiuation tape which once loaded you should
> acknowledged Label and keep the tapes and when restoring the database load
> the last tape first.
> >
> > 3. What is different between Cluster and non cluster.
> Clustered tables and indexed views keep their data rows in order based on
> the clustered index key
> >
> > 4. When do you need to use the REPLACE switch while restoring databases?
> >
> REPLACE will overwrite a database/datafile with the same name if they
> already exist and bypasses checks that are made if you don't specify it.
> You may want to check out books online for more detailed explanations.
> John
>
> > Thanks
> > kalyan
> >
> >
> >
>
>|||Hi
"Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
news:F88206C9-4021-48C7-82D2-35909D3B77DC@.microsoft.com...
> John
> here is details about those questions
> 1. If you want to be able access the customers table directly from a Web
> browser,
> what database name must you configure in with the IIS Virtual
> Directory
> Management Tool?
> Choice 1
> Dbobject
> Choice 2
> Xpath
> Choice 3
> Schema
> Choice 4
> Direct
> Choice 5
> Template
It is DBObject as described in
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsql/ac_xml1_8e7t.asp
> 2. While backing up a database to a tape drive, the tape runs out of
> space.
> You
> replace the tape. Referring to the scenario above, what is the
> correct
> way to
> complete thebackup?
> Choice 1
> Repeat the previous backup command, adding the BEGIN option.
> Choice 2
> Repeat the previous backup command, adding the INIT option.
> Choice 3
> Repeat the previous backup command, adding the NOINIT option.
> Choice 4
> Repeat the previous backup command, adding the RESTART option.
> Choice 5
> Repeat the previous backup command, adding the BACKUP option.
>
I would expect this to be RESTART.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ba-bz_35ww.asp
>
> Following is general question of my own not from any test
> What is different between Cluster and non cluster.
Check out
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_da2_8sit.asp
> When do you need to use the REPLACE switch while restoring databases?
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ra-rz_25rm.asp?frame=true
John
> Thanks
> Kalyan
> "John Bell" wrote:
>> Hi
>> Taking the questions out of context makes them even more vaguer than
>> usual!!
>> "Kalyan" <Kalyan@.discussions.microsoft.com> wrote in message
>> news:02660DB7-2319-4FFD-BF3E-D40EB284CFB8@.microsoft.com...
>> >I took one online test on SQL Server Admin, Four qustions i was not
>> >sure
>> > answer
>> > can any provide me answer
>> >
>> > 1. If you want to be able access the customers table directly from a
>> > Web
>> > browser,
>> > what database name must you configure in with the IIS Virtual
>> > Directory
>> > Management Tool?
>> The database will be the database where the customers table is located.
>> You
>> don't have to name your virtual directory with the same name as the
>> database
>> and the IIS Virtual Directory Management Tool allows you to create that
>> mapping.
>> >
>> > 2. While backing up a database to a tape drive, the tape runs out of
>> > space. You
>> > replace the tape. Referring to the scenario above, what is the
>> > correct way
>> > to complete the backup?
>> You will be prompted for the contiuation tape which once loaded you
>> should
>> acknowledged Label and keep the tapes and when restoring the database
>> load
>> the last tape first.
>> >
>> > 3. What is different between Cluster and non cluster.
>> Clustered tables and indexed views keep their data rows in order based on
>> the clustered index key
>> >
>> > 4. When do you need to use the REPLACE switch while restoring
>> > databases?
>> >
>> REPLACE will overwrite a database/datafile with the same name if they
>> already exist and bypasses checks that are made if you don't specify it.
>> You may want to check out books online for more detailed explanations.
>> John
>>
>> > Thanks
>> > kalyan
>> >
>> >
>> >
>>
