SQL Server Quiz 1

What is the file type associated with a primary data file in SQL Server?

• .ndf

• .mdf

• .ldf

• sql

Which file extension is used for a transaction log file in SQL Server?

• .mdf

• .ldf

• .ndf

• .log

In a database, which file contains the bulk of the data and is typically the first file created when the database is set up?

• Primary data file

• Transaction log file

• Secondary data file

• Configuration file

What is the primary purpose of the .ldf file in SQL Server?

• To store primary data

• To log transactions and ensure recoverability

• To store backup data

• To configure database settings

In the SQL Server file structure, what is the role of a secondary data file with an .ndf extension?

• To store transaction logs

• To provide additional storage space for data beyond the primary file

• To manage database backups

• To serve as a temporary storage file

What is the main function of the ALTER DATABASE command in SQL Server?

• To create a new database

• To modify the properties of an existing database

• To delete an existing database

• To restore a database from a backup

Which of the following is a correct example of how to change the name of an existing database using the ALTER DATABASE command?

• ALTER DATABASE MODIFY Name = 'NewDatabaseName';

• ALTER DATABASE NewDatabaseName RENAME TO 'OldDatabaseName';

• ALTER DATABASE OldDatabaseName MODIFY NAME = 'NewDatabaseName';

• ALTER DATABASE CHANGE NAME TO 'NewDatabaseName';

When adding a new file group to an existing database using the ALTER DATABASE command, which keyword is used to specify that a file group should be added?

• ADD

• MODIFY

• CHANGE

• REMOVE

What is the correct syntax for adding a file to a file group in an existing database using the ALTER DATABASE command?

• ALTER DATABASE ADD FILEGROUP (NAME, FILENAME);

• ALTER DATABASE [DatabaseName] ADD FILE (NAME = 'file_name', FILENAME = 'path') TO FILEGROUP [FileGroupName];

• ALTER DATABASE [DatabaseName] ADD FILE TO [FileGroupName];

• ALTER DATABASE ADD FILE [FileGroupName];

What is the primary purpose of the GO statement in SQL Server?

• To execute multiple commands at once

• To separate sections of code and help identify errors

• To create a transaction block

• o add comments to the SQL code