Database (Mssql | MySQL)

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Aaron_marcelino
A
Aaron_marcelino
Community Contributor
Quizzes Created: 1 | Total Attempts: 276
| Attempts: 276
SettingsSettings
Please wait...
  • 1/10 Questions

    Database names are on a first come first serve basis.

    • True
    • False
Please wait...
About This Quiz

This quiz focuses on key aspects of database management in MSSQL and MySQL environments. It tests knowledge on database naming, storage options, troubleshooting steps, and configuration limitations, essential for database administrators and developers.

Database Management Quizzes & Trivia

Quiz Preview

  • 2. 

    What is the size limit per MSSQL on a Windows Unlimited package

    • 200MB

    • 300MB

    • 400MB

    Correct Answer
    A. 300MB
    Explanation
    Source: http://www.networksolutions.com/web-hosting/hosting-package-comparison.jsp

    Rate this question:

  • 3. 

    For MYSQL, you can purchase 1GB worth of space as add on but can only use it on an existing database within your hosting package.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Source: http://pasp/netsolcentral/release/October 2008 Release/Oct Release Related Pre-Shifts/Preshift_Add-on-databases_102208.doc

    Rate this question:

  • 4. 

    How many MSSQL databases can be configured on a Small Unix Hosting Package.

    • 25

    • 20

    • 15

    • None of the Above

    Correct Answer
    A. None of the Above
    Explanation
    Source: http://www.networksolutions.com/web-hosting/hosting-package-comparison.jsp

    Rate this question:

  • 5. 

    Customers can restore database files by use of Enterprise Manager.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Source: http://pasp/netsolcentral/teams/tss/KB/Knowledge%20Base/Windows/Databases/Windows%20Hosting%20MS%20SQL%20DB%20Restore.aspx

    Rate this question:

  • 6. 

    What is the maximum size of a MySQL database that you can configure on a Unix hosting package.

    • 250MB

    • 500MB

    • 300MB

    Correct Answer
    A. 300MB
    Explanation
    Source: http://www.networksolutions.com/web-hosting/hosting-package-comparison.jsp

    Rate this question:

  • 7. 

    How many DSN(MSAccess) can be configured on a Windows Unlimited Hosting Package.

    • 10 DSN

    • 7 DSN

    • 5 DSN

    • 20 DSN

    Correct Answer
    A. 10 DSN
    Explanation
    Source: http://www.networksolutions.com/web-hosting/hosting-package-comparison.jsp

    Rate this question:

  • 8. 

    While troubleshooting database issues and if you log into phpMyAdmin, but find no databases what is the first troubleshooting step that you should try.

    • Create an SR to HOSTSUP001 to report the issue

    • Resync the database through PCP

    • Check the back up option of the DB and restore the latest.

    • Check the FTP first if it is working.

    Correct Answer
    A. Resync the database through PCP
    Explanation
    Source: http://pasp/netsolcentral/teams/tss/KB/Knowledge%20Base/UNIX/Database/phpMyAdmin%20Empty.aspx

    Rate this question:

  • 9. 

    How many MSSQL Database can be configured on a Windows Large Hosting Package.

    • 6

    • 3

    • 9

    • None of the Above

    Correct Answer
    A. 3
    Explanation
    Source: http://www.networksolutions.com/web-hosting/hosting-package-comparison.jsp

    Rate this question:

  • 10. 

    For customers who have a database larger than 8MB and wants to import it to his/her Hosting Package, what can we offer?

    • Offer MyTime Support

    • Create an SR and escalate to HostSup001

    • Walk the customer through on how to import it through PhpMyAdmin

    • Let them download SQLyog from http://www.webyog.com.

    Correct Answer(s)
    A. Offer MyTime Support
    A. Let them download SQLyog from http://www.webyog.com.
    Explanation
    http://pasp/netsolcentral/max/Lists/Preshifts/DispForm.aspx?ID=486

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 07, 2011
    Quiz Created by
    Aaron_marcelino
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.