If we shrink the Databse and Files, how much size is
decreased?
Answer / lmr
The primary data file cannot be made smaller than the size
of the primary file in the model database.
for eg. while creating a db having size 10 MB
N GREW 100MB
then max the can be shrunk to 10MB.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain atomicity?
 Explain what is sql override for a source taLle in a mapping?
IN Vs OR operator which is best to use sql server.
What are logical/boolean operations in ms sql server?
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement
What is difference between TRUNCATE and DELETE statement
What do we have to check in database testing?
How can I create a new template for import ? : sql server management studio
I have to display ten columns values from diffrent ten tables. how many joins are require?
10 Answers CarrizalSoft Technologies, HCL,
What is acid properties?
explain the storage models of olap? : Sql server database administration
How to implement service broker?
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)