(Solved) : Write Sql Statement Create Database Named Project Yourusername Db1 Example Mine Would Nam Q37174670 . . .
Write a SQL statement to
CREATE
a database named
project
_
<
your__user_name
>
_db1
. For
example, mine would be named project_myproject_db1 .
This database needs to have the following
specifications:
a.
full recovery model
b.
A primary data file with an initial size of
15
MB, that is unlimited in how large it can be, and that grows
in 1 MB increments.
c.
A log file with an initial size of 5 MB, that is
unlimited in how large it can be, that grows in 1 MB
increments, and is on a separate drive from the data file.
2.
After creating this database, execute the stored procedure
sp_helpdb
project
_
<
your_UWF_user_name
>
_db1
3.
Capture the results of the above
sp_helpd
b
stored procedure and
paste into the
document
4.
Write
1
SQL statement to
ALTER
the database created in
Step
1 named
project
_
<
your_user_name
>
_db1
to
s
et the database to single user mode
5.
Write
1
SQL statement to
ALTER
the database created in
Step
1 named
project
_
<
your_user_name
>
_db1
to
a
dd a filegroup named
fg_
secondary
6.
Write
1
SQL statement to
ALTER
the database created in
Step
1 named
project
_
<
your__user_name
>
_db1
to
a
dd a secondary data file to the filegroup named
fg_
secondary
with an initial size of 10 MB, that is unlimited in how large itcan be, and that grows in 1 MB
increments.
Expert Answer
Answer to Write a SQL statement to CREATE a database named project _ _db1 . For example, mine would be named project_myproject_db1…
OR