cts 4408 quiz 2

docx

School

Florida International University *

*We aren’t endorsed by this school

Course

4408

Subject

Computer Science

Date

Feb 20, 2024

Type

docx

Pages

Uploaded by MegaTank13330

Choose all of the statements that are true (10 points). Any filegroup referenced in the partition scheme must exist before the partition scheme is created For you to switch data from a partition to a table or from a table into a partition, the source and target of the ALTER TABLE...SWITCH statement must reside in the same filegroup. When switching data from a partition to a table or from a table into a partition, the indexes for both do not need to be identical Using RANGE LEFT partitions for datetime values is usually best because this approach makes it easier to specify the limits of the ranges You use the ALTER PARTITION ...MERGE RANGE T-SQL command in order to drop a partition You use the ALTER PARTITION ...SPLIT RANGE T-SQL command in order to drop a partition Choose the statements below that are true (15 points When the database is in Bulk-logged recovery mode, a point in time recovery is not allowed Point-in-time recovery is not permitted with file or filegroup backups unless all filegroups are restored to the same point-in-time to maintain database consistency Individual file or filegroup backups can be restored from a full database backup A file or filegroup backup is used to backup a portion of the transaction log. Compressing the backups of encrypted databases are generally a best practice because they compress more than unencrypted databases You should always perform a log tail backup prior to beginning the restore process Match the backup option with the function it provides CHECKSUM = used to verify that

MIRROR TO = used to create a second copy NORECOVERY = use to stop updates DIFFERENTIAL = only backup that extents that FORMAT = indicates that all backups COPY_ONLY = indicates that the backup

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

README.md

CYB_200_Module_Four_Activity_Larissa_Rojas.docx

CYB_250_4-3 Stepping Stone_Larissa_Rojas.docx

IT 145 Global Rain Summary Report Template (1).docx

Question paper xii cs python board.pdf

PICO Worksheet and Search Strategy new new.docx

Intro to BA assignment 7.xlsx

Akiba Thomas week4.docx

50.docx

15.6.2 Lab - Configure IPv4 and IPv6 Static and Default Routes.docx

7.4.2 Lab - Implement DHCPv4.docx

13.1.10 Packet Tracer - Configure a Wireless Network.docx

Recommended textbooks for you

Programming Logic & Design Comprehensive

Computer Science

ISBN:9781337669405

Author:FARRELL

Publisher:Cengage

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:9781337508841

Author:Carey

Publisher:Cengage

EBK JAVA PROGRAMMING

Computer Science

ISBN:9781337671385

Author:FARRELL

Publisher:CENGAGE LEARNING - CONSIGNMENT

Systems Architecture

Computer Science

ISBN:9781305080195

Author:Stephen D. Burd

Publisher:Cengage Learning

LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.

Computer Science

ISBN:9781337569798

Author:ECKERT

Publisher:CENGAGE L

Oracle 12c: SQL

Computer Science

ISBN:9781305251038

Author:Joan Casteel

Publisher:Cengage Learning

SEE MORE TEXTBOOKS

Recommended textbooks for you

Programming Logic & Design Comprehensive
Computer Science
ISBN:9781337669405
Author:FARRELL
Publisher:Cengage
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
EBK JAVA PROGRAMMING
Computer Science
ISBN:9781337671385
Author:FARRELL
Publisher:CENGAGE LEARNING - CONSIGNMENT
Systems Architecture
Computer Science
ISBN:9781305080195
Author:Stephen D. Burd
Publisher:Cengage Learning
LINUX+ AND LPIC-1 GDE.TO LINUX CERTIF.
Computer Science
ISBN:9781337569798
Author:ECKERT
Publisher:CENGAGE L
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning