harichandra prasad


{ City } bangalore
< Country > india
* Profession * se
User No # 15667
Total Questions Posted # 20
Total Answers Posted # 19

Total Answers Posted for My Questions # 38
Total Views for My Questions # 131146

Users Marked my Answers as Correct # 294
Users Marked my Answers as Wrong # 119
Questions / { harichandra prasad }
Questions Answers Category Views Company eMail

How the data stores in a page?

1 SQL Server 4474

what are the problems in logshipping?

3 SQL Server 20808

How to tune a stored procedure?

6 SQL Server 15081

what is index seek and index scan?

2 SQL Server 11107

How to create logins using windows Authentication mode?

2 SQL Server 3709

write the query for taking database restore in sql?

2 SQL Server 4589

where do you use Isolations?give me some exmpale?

1 SQL Server 4527

In which year relase the 7.0& 2000 & 2005?

1 SQL Server 3043

can you any body tell me suppose database is suspect mode. how can take to normal?

Teledata,

2 SQL Server 5308

can you any body tell me which service pack is installed in the sql server?

3 SQL Server 3807

How to find the date and time of last updated table?

3 SQL Server 7970

How to find the date and time of last updated table?

3 SQL Server 16221

can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 SQL Server 3807

can you any body tell me why are go for the rebuild the master database.what is the reason?

2 SQL Server 3547

how to take backup bcp out for a column in table in sql server?

SQL Server 1612


 [1]   2    Next



Answers / { harichandra prasad }

Question { ABC, 12604 }

What do you mean by COLLATION?


Answer

collation is a set of rules determine the how data is
sorted and compared.

Case sensitity collation
Accent Sensitity collation
Kane sensitiy collation

Is This Answer Correct ?    5 Yes 1 No

Question { 5434 }

Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take?


Answer

first you rebuild the master db by using REBUIDM.exe. after
u take single user mode Sqlservr.exe -c -m.


Is This Answer Correct ?    6 Yes 0 No


Question { College School Exams Tests, 15495 }

Explain the basic concepts of SQL server architecture?


Answer

Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc

Is This Answer Correct ?    33 Yes 10 No

Question { 11119 }

How do you know which index a table is using?


Answer

sp_helpindex tabelname

Is This Answer Correct ?    14 Yes 1 No

Question { 9476 }

Explain different isolation levels?


Answer

Isolaton is the reduce the concurrency
Default 1)Read Commit
2)Read Uncommit
3)Repatable read
4) Serizable--

Is This Answer Correct ?    2 Yes 3 No

Question { HP, 36021 }

Explain the architecture of SQL Server?


Answer

Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers

Is This Answer Correct ?    46 Yes 26 No

Question { Wipro, 131873 }

What are constraints? Explain different types of
constraints?


Answer

Constraint : To Restrict the voilation of irrelegular data
and maintain data integrity.

Primary key
Unique Key
NotNull
Forigen Key
Check

Is This Answer Correct ?    73 Yes 45 No

Question { Challenger Financial, 6408 }

What is a join and their types?


Answer

Joins are reterving the data from the multiple tables
Inner Join
Outer Join-left outer join
-----------right outer Join
-----------Full outer Join
Cross Join

Is This Answer Correct ?    0 Yes 2 No

Question { TCS, 15556 }

wht is normalization?can u explain me in detail?


Answer

Normalization is the process of designing the datamodel and
effocientely store the data in database.to reduce the
redundancy.
1Normal form: Elimanate the repeating groups for individual
table
-Create sepeare table for each set of related data
-identify the each set of related data with a primary key
2nd normal form : create separate table for set of values
that apply the multipule records.
--Releate these tables with a forgign key
3rd Normal Form : Eliminate fields that do not depend on
the key

Is This Answer Correct ?    0 Yes 5 No

Question { Microsoft, 10465 }

1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication?


Answer

DBMS : Collection of data in Database
RDBMS : Collection of releated data in a database.

In Trancation Replication : Initial snapahot of the data is
applied to at subscribers. and then when data modifications
are made at the publisher , the individual transcation are
captured and propogated to sbuscribers

In Merge replication : is the process of distributing data
from publisher to subscriber, allowing the publisher and
subscribers to make updates while connected or disconnected
and then merging the updates between sites when they are
connencted

Is This Answer Correct ?    6 Yes 2 No

Question { CSC, 10981 }

what is the diffrence between Snap Shot and Transaction
Replication


Answer

Snapshot is the a picture or snapshot of the databse is
taken peridicalloy propgated to the sbuscripber.
it does't invole continuesly.

only read only

transcation replication : This can be used to replication
changes to the database with this any changes made to the
replication data immediately caputred from transcation log
and propogated to the distributor

Is This Answer Correct ?    6 Yes 2 No

Question { Jade Software, 8394 }

wat is the main diff between sql server 2000and sql server 2005


Answer

In 2005 More features is available
Database Mirroiring
CLR Integration(Common language Runtime ) Integration
Management Studio
SIS Package
mirror backup
DAC(Dedicate Administration Connection)

Is This Answer Correct ?    9 Yes 1 No

Question { HCL, 21422 }

What is the difference between windows authentication and
sql server authentication


Answer

SQL Authentication :
SQL Authentication is the typical authentication used for
various database systems, composed of a username and a
password. Obviously, an instance of SQL Server can have
multiple such user accounts (using SQL authentication) with
different usernames and passwords. In shared servers where
different users should have access to different databases,
SQL authentication should be used. Also, when a client
(remote computer) connects to an instance of SQL Server on
other computer than the one on which the client is running,
SQL Server authentication is needed. Even if you don't
define any SQL Server user accounts, at the time of
installation a root account - sa - is added with the
password you provided. Just like any SQL Server account,
this can be used to log-in localy or remotely, however if
an application is the one that does the log in, and it
should have access to only one database, it's strongly
recommended that you don't use the sa account, but create a
new one with limited access. Overall, SQL authentication is
the main authentication method to be used while the one we
review below - Windows Authentication - is more of a
convenience.
Windows Authentication :
When you are accessing SQL Server from the same computer it
is installed on, you shouldn't be prompted to type in an
username and password. And you are not, if you're using
Windows Authentication. With Windows Authentication, the
SQL Server service already knows that someone is logged in
into the operating system with the correct credentials, and
it uses these credentials to allow the user into its
databases. Of course, this works as long as the client
resides on the same computer as the SQL Server, or as long
as the connecting client matches the Windows credentials of
the server. Windows Authentication is often used as a more
convenient way to log-in into a SQL Server instance without
typing a username and a password, however when more users
are envolved, or remote connections are being established
with the SQL Server, SQL authentication should be used.

Is This Answer Correct ?    50 Yes 13 No

Question { Wipro, 6955 }

What is user stored procedure & it purpose?


Answer

Stored procedure is nothing but a Set of T-Sql statements
combined to perform a single task of several tasks. it's
like a macro

Is This Answer Correct ?    3 Yes 1 No

Question { 3807 }

can you any body tell me which service pack is installed in
the sql server?


Answer

Select serverproperty('product level')

Is This Answer Correct ?    0 Yes 2 No

 [1]   2    Next