What are the different ways you can create databases in sql server? : sql server DBA



What are the different ways you can create databases in sql server? : sql server DBA..

Answer / Shipra Mehrotra

SQL Server provides multiple methods to create a database: CREATE DATABASE statement, scripting (using SQL scripts or SSMS), and Management Studio's GUI. Additionally, databases can also be created as part of the installation process or by restoring a backup of an existing database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Administration Interview Questions

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,


What command would you use to encrypt a PL/SQL application?

1 Answers  


Describe what redo logs are.

1 Answers  


What is dcl? : sql server DBA

1 Answers  


WHEN DOWN TIME WHAT CAN U DO?

1 Answers   TCS,


What are the commands used in dcl? : sql server DBA

1 Answers  


What view would you use to determine free space in a tablespace?

3 Answers  


What would you do with an "in-doubt" distributed transaction?

1 Answers  


Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

1 Answers   Patni,


what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,


what do you understand by flashback feature of oracle?

1 Answers   Oracle,


how can you record information about current session?

1 Answers   Oracle,


Categories