Database (Mssql | MySQL)

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Aaron_marcelino
A
Aaron_marcelino
Community Contributor
Quizzes Created: 1 | Total Attempts: 265
Questions: 10 | Attempts: 265

SettingsSettingsSettings
MySQL Quizzes & Trivia

Hostgen / VPS


Questions and Answers
  • 1. 

    Database names are on a first come first serve basis.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    This statement is true because in most cases, when creating a database, the name chosen for the database must be unique within the database management system. This means that the first person or entity to create a database with a specific name will have ownership of that name, and subsequent attempts to create a database with the same name will be rejected. Therefore, the availability of database names is determined by the order in which they are created.

    Rate this question:

  • 2. 

    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.

    • A.

      True

    • B.

      False

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

    Rate this question:

  • 3. 

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

    • A.

      Create an SR to HOSTSUP001 to report the issue

    • B.

      Resync the database through PCP

    • C.

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

    • D.

      Check the FTP first if it is working.

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

    Rate this question:

  • 4. 

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

    • A.

      Offer MyTime Support

    • B.

      Create an SR and escalate to HostSup001

    • C.

      Walk the customer through on how to import it through PhpMyAdmin

    • D.

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

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

    Rate this question:

  • 5. 

    Customers can restore database files by use of Enterprise Manager.

    • A.

      True

    • B.

      False

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

    Rate this question:

  • 6. 

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

    • A.

      25

    • B.

      20

    • C.

      15

    • D.

      None of the Above

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

    Rate this question:

  • 7. 

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

    • A.

      250MB

    • B.

      500MB

    • C.

      300MB

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

    Rate this question:

  • 8. 

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

    • A.

      10 DSN

    • B.

      7 DSN

    • C.

      5 DSN

    • D.

      20 DSN

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

    Rate this question:

  • 9. 

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

    • A.

      6

    • B.

      3

    • C.

      9

    • D.

      None of the Above

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

    Rate this question:

  • 10. 

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

    • A.

      200MB

    • B.

      300MB

    • C.

      400MB

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

    Rate this question:

Related Topics

Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.