My SQL Quiz

Ace your homework & exams now with Quizwiz!

After installation, MySQL must be ____. configured encrypted ported linked

configured

The phase of software where new features are added

Alpha

____ accounts do not require credentials, providing easy access into the database infrastructure. Anonymous Community User Root

Anonymous

The phase of software that has known issues and should not be downloaded for use in a working environment

Beta

____________________ code installations of MySQL are already packaged as binary files and are ready to be installed without the need for compiling the code to enable it to be run as an executable file on a particular machine. Base 10 Binary Accuracy Server

Binary

The ____ Edition of MySQL is the most popular edition available as open source. Enterprise Technical Professional Community

Community

The ____ Edition of MySQL provides additional assistance for monitoring and analyzing the performance of your database server. Community Professional Enterprise Technical

Enterprise

The ____ for installing MySQL on Windows is ideal for almost any environment because it allows for a lighter installation of MySQL. Complete Package Noinstall Archive Patch Archive Essentials Package

Essentials Package

T/F: By default, MySQL is encrypted.

False

T/F: Root access should be given to outside remote machines

False

A great way to connect online with other users and MySQL professionals that have a wealth of knowledge to share

Forum

Used by MySQL to add digital signatures from which authenticity can be determined

GNU Privacy Guard

The phase of software that is ready for production; it is a stable application and there are very few known bugs

General Availability

MySQL provides administrators with the tools to define allowed access based on ____. Web browsers file sizes operating systems IP addresses

IP addresses

Assigned to each package that is downloaded from MySQL

MD5 Checksum

The phase of software that is considered somewhat stable, though it might have serious bugs that still exist, but do not affect everyone

Release Candidate

With MySQL versioning the second digit indicates the release level Entry Level Version Number Release Level Minor Release

Release Level

In MySQL ____________________ access allows administrative access to the database server. super sa server Root

Root

Can be used to encrypt your connection to the server

SSH

T/F: MySQL is an open-source application.

True

Provides a quick and easy way to reach customers by sending quick updates and reminders

Twitter

If you cannot disable remote access, you should secure the MySQL server behind a(n) ____. server IP address cell block firewall

firewall

The ____ model was implemented to improve the efficiency of the version phase and iteration process as well as allow for smaller, more frequent, and controllable releases of the MySQL database software. ladder guidelines spiral milestone

milestone

Opening ____ in your firewall provides all computers access to MySQL through your firewall. ports databases Web pages groups

ports

The ____ user has full privileges on a MySQL server. primary community anonymous root

root


Related study sets

Musculoskeletal LECTURE Midterm FA 2019 Q2

View Set

JS/TS Short/Long Answer Questions

View Set

AT BOC Prep Domain III - Immediate and Emergency Care

View Set

Chapter 13 - Final Exam - MIE 330

View Set

Ch 4 How to Form a Business SmartBook

View Set

Operating and Financial Leverage

View Set

Management & Supervision in LE 7th Edition (Ch 8 Definition & Notes)

View Set