Answer Posted / phani kiran sai

In the previous versions of MS SQL SERVER, if the server
maxed out the resources due to any of the reasons, it was
practically impossible to connect the server thru remote
desktop. As a result of such situations, the developers /
DBA'S were forced to "reboot". Doing this, many a times, the
SQL SERVER would try to properly shutdown properly by
forcing a CHECK POINT so as to minimize inconsistency, but
there would be instances when such CHECK POINT might not
occur thus screwing up data on the server.
Microsoft addressed this problem with DAC [ DEDICATED
ADMINISTRATOR CONNECTION ] which allows the developers /
DBA'S to connect to the server and perform T-SQL commands to
figure out the problem and perform necessary action accordingly.
syntax:
START -> RUN -> CMD
in dos mode.. enter the following

sqlcmd
[{ { -U login_id [ -P password ] } | –E trusted connection }]
[ -z new password ] [ -Z new password and exit]
[ -S server_name [ \ instance_name ] ] [ -H wksta_name ] [
-d db_name ]
[ -l login time_out ] [ -A dedicated admin connection ]
[ -i input_file ] [ -o output_file ]
[ -f < codepage > | i: < codepage > [ < , o: < codepage > ] ]
[ -u unicode output ] [ -r [ 0 | 1 ] msgs to stderr ]
[ -R use client regional settings ]
[ -q "cmdline query" ] [ -Q "cmdline query" and exit ]
[ -e echo input ] [ -t query time_out ]
[ -I enable Quoted Identifiers ]
[ -v var = "value"...] [ -x disable variable substitution ]
[ -h headers ][ -s col_separator ] [ -w column_width ]
[ -W remove trailing spaces ]
[ -k [ 1 | 2 ] remove[replace] control characters ]
[ -y display_width ] [-Y display_width ]
[ -b on error batch abort ] [ -V severitylevel ] [ -m
error_level ]
[ -a packet_size ][ -c cmd_end ]
[ -L [ c ] list servers[clean output] ]
[ -p [ 1 ] print statistics[colon format]]
[ -X [ 1 ] ] disable commands, startup script, enviroment
variables [and exit]
[ -? show syntax summary ]

Is it important for a database administrator to understand the operating system and file access?

931

---

Explain indexed views and partitioned view with their syntax.

1079

---

How is foreign key related to primary key?

916

---

What is row_number () and partition by in sql server?

1007

---

What are the tools available in market as an alternative to sql server reporting services?

119

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

900

---

Can I delete event logs?

877

---

What are drilldown reports?

140

---

How do you delete a trigger?

919

---

how you can list all the tables in a database?

970

---

How many non clustered indexes there can be on table ?

863

---

What do you mean by subquery?

1024

---

How to convert numeric values to integers in ms sql server?

1010

---

What is de-normalization in sql database administration? Give examples?

927

---

Do you know data definition language, data control language and data manipulation language?

987

---