In relation to Azure SQL Database, which of the following is true?
Additional database filegroups can be added via Transact-SQL statements.
The maximum size of a database is determined by its database Edition.
Additional database files can be added via Transact-SQL statements.
All databases on a server must be the same database Edition.
Answers
Answer:
ALTER DATABASE database_name
{
<add_or_modify_files>
| <add_or_modify_filegroups>
}
[;
<add_or_modify_files>::=
{
ADD FILE <filespec> [ ,...n ]
[ TO FILEGROUP { filegroup_name } ]
| ADD LOG FILE <filespec> [ ,...n ]
| REMOVE FILE logical_file_name
| MODIFY FILE <filespec>
}
<filespec>::=
(
NAME = logical_file_name
[ , NEWNAME = new_logical_name ]
[ , FILENAME = {'os_file_name' | 'filestream_path' | 'memory_optimized_data_path' } ]
[ , SIZE = size [ KB | MB | GB | TB ] ]
[ , MAXSIZE = { max_size [ KB | MB | GB | TB ] | UNLIMITED } ]
[ , FILEGROWTH = growth_increment [ KB | MB | GB | TB| % ] ]
[ , OFFLINE ]
)
<add_or_modify_filegroups>::=
{
| ADD FILEGROUP filegroup_name
[ CONTAINS FILESTREAM | CONTAINS MEMORY_OPTIMIZED_DATA ]
| REMOVE FILEGROUP filegroup_name
| MODIFY FILEGROUP filegroup_name
{ <filegroup_updatability_option>
| DEFAULT
| NAME = new_filegroup_name
| { AUTOGROW_SINGLE_FILE | AUTOGROW_ALL_FILES }
}
}
<filegroup_updatability_option>::=
{
{ READONLY | READWRITE }
| { READ_ONLY | READ_WRITE }
}
Answer: Answer of this question is C.
Explanation: A database's physical structure can be altered using the ALTER DATABASE statement. You can alter the following database properties using the Transact-SQL language:
- Adding or removing a database file or files
- Add or delete any number of log files
- Delete or add filegroups
- Change the properties of a file or a filegroup.
- Configure database options
- Use the sp rename stored procedure to rename the database (covered in more detail in the section below under "Altering a Table").
Database files may be added or removed using the ALTER DATABASE statement. A new file can be added or an old file can be deleted using the clauses ADD FILE and REMOVE FILE, respectively. (Additionally, the TO FILEGROUP option can be used to add a new file to an already-existing filegroup.)
For more such questions - https://brainly.in/question/11291638
#SPJ3