What purpose does the model database server? : sql server DBA
Answer / Rajveer Singh Mourya
The Model database in SQL Server serves as a template for creating new databases. It contains the default database settings, system tables, and system procedures. When you create a new user database, it is based on this Model database.
| Is This Answer Correct ? | 0 Yes | 0 No |
what do you understand by fine-grained auditing?
what is the difference between db2start command and start database manager command?
how can you enable flashback feature?
what are the performance views in an oracle rac environment?
how can you process messages in order asynchronously?
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Is it possible to update the multiple field values in a single query? If possible then write the actual query.
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?
11 Answers FA, GE, Wipro,
what is logical system in sap basis
which background process invoke at the time of upgradation tell me???
internal architecture
Oracle (3253)
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)