What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
No Answer is Posted For this Question
Be the First to Post Answer
What is raid and what are different types of raid levels?
Explain “not null constraint” in sql server?
Explain the working of sql privileges?
How to get the definition of a trigger back?
Explain how many types of relationship?
What are the options which must be set to allow the usage of optimistic models?
i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .
What is the difference between a Local temporary table and a Global temporary table? How is each one used?
What are sub-queries? Give example? In which case sub-queries are not feasible?
To find second largest salary in Employee table
Which Model uses the SET concept
What do you understand by the denormalisation?
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)