SQL Server Quiz 1

SQL Server Quiz 1

University

•

41 Qs

quiz-placeholder

Similar activities

Microsoft Excels: Formulas and Functions

Microsoft Excels: Formulas and Functions

12th Grade - University

•

45 Qs

Class Test 1 - CSE 443 (Mobile Telecommunication)

Class Test 1 - CSE 443 (Mobile Telecommunication)

University

•

40 Qs

OS Quiz 2 LH18

OS Quiz 2 LH18

University

•

45 Qs

Recuperatorio Bases y Modelado

Recuperatorio Bases y Modelado

12th Grade - Professional Development

•

37 Qs

Simulasi Digital

Simulasi Digital

12th Grade - Professional Development

•

40 Qs

Post test Keamanan Jaringan

Post test Keamanan Jaringan

University

•

40 Qs

Davinci Resolve 17 Fusion 101

Davinci Resolve 17 Fusion 101

11th Grade - Professional Development

•

45 Qs

Soal WAN Tkj kls 2

Soal WAN Tkj kls 2

University

•

41 Qs

SQL Server Quiz 1

SQL Server Quiz 1

Assessment

Quiz

•

Computers

•

University

•

Practice Problem

•

Hard

Created by

Omphile Mosingathi

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

41 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

.ndf

.mdf

.ldf

sql

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

.mdf

.ldf

.ndf

.log

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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';

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?