ITF+ Database Import/Export Quiz

1. Which statement best describes the role of character encoding in data export?

It ensures special characters and symbols display correctly in the exported file

It compresses the file to reduce storage space

It encrypts all sensitive data automatically

It determines the export file's maximum size

2. When importing data, null values in source fields should be handled by:

Defining clear rules for how nulls are treated in the target database

Automatically converting all nulls to zeros

Rejecting the entire import if any null exists

Leaving them as undefined entries

3. In export operations, what does 'rollback' capability ensure?

The ability to revert to a previous state if errors occur during export

Faster data transfer speeds

Automatic file compression

Deletion of temporary files

4. What is the primary purpose of creating a test import before running a full data load?

To identify and resolve issues without affecting production data

To determine the final file size

To encrypt sensitive information

To reduce database performance

5. Which tool or method is commonly used to automate routine database exports?

Scheduled tasks or jobs within the database management system

Manual file copying every hour

Sending data via email

Printing reports and scanning them

6. When exporting a database with relationships, what must be preserved to maintain data integrity?

Foreign keys and referential integrity constraints

Only the largest tables

All user passwords

The export date and time

7. What does 'data transformation' mean during import operations?

Converting data from source format to target database format

Deleting all unwanted records

Compressing files for faster transfer

Creating backup copies of original data

8. Which of the following is a best practice when importing sensitive data?

Encrypt the import file and use restricted user accounts

Export to a public server for accessibility

Disable all security features during import

Share credentials with multiple team members

9. In database export operations, what does 'schema' refer to?

The structure and organization of tables, fields, and relationships

A compressed file format

The encryption method used

The maximum file size allowed

10. What is the primary advantage of using a staging table during data import?

To temporarily hold and validate data before loading into production

To permanently store backup copies

To reduce the number of database tables

To eliminate the need for data validation

11. What does CSV stand for in the context of database exports?

Comma-Separated Values

Centralized Storage Variables

Compressed System Volumes

Column-Specific Validation

12. When importing data with duplicate key values, what typically occurs?

The import proceeds and overwrites existing records

The import is rejected or records are skipped

Duplicate records are automatically merged

The database expands to accommodate duplicates

13. What is a common cause of import failures when transferring data between systems?

Mismatched data types or field constraints

The file is too small

The database is running Windows

The export date is too recent

14. Which format is ideal for exchanging data between different database systems due to its platform-independent nature?

XML

Binary

Proprietary database format

Compressed archive

15. What does the term 'data integrity' mean in import/export operations?

The accuracy and consistency of data throughout transfer

The speed of data movement between systems

The encryption level of exported files

The number of backup copies created

16. When exporting large databases, which approach minimizes performance impact?

Export during peak business hours

Use incremental or scheduled exports during off-peak times

Export all data in a single transaction

Disable all database indexes before exporting

17. What is a delimiter in the context of exporting database records?

A character that separates fields or columns in a file

A password-protected section of data

A time limit for data transfer

A backup file format

18. Which of the following best describes data validation during import?

Checking that data conforms to expected formats and constraints

Removing all duplicate records automatically

Converting all data to uppercase

Deleting incomplete records

19. When importing data, what is the primary purpose of field mapping?

To compress file size during transfer

To match source columns with destination database fields