Explain what is the difference between a local and a global temporary table?
No Answer is Posted For this Question
Be the First to Post Answer
What is RAID and what are different types of RAID configurations?
Tell me the phases a transaction has to undergo?
Is port 1433 secure?
Can a stored procedure call another stored procedure. If yes what level and can it be controlled?
2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID
Explain the concept of view and Types of views in SQL server?
Scalability, Availability, Integration with internet, etc.)?
As a part of your job, what are the DBCC commands that you commonly use for database maintenance?
explain different types of constraints? : Sql server database administration
Normalization and denormalization
i have a table like this Eno ename 1 a 2 b 3 c i want to display ename and bossname from table hint boss is also an employee
How you can move data or databases between servers and databases in sql server?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)