Database (Mssql | MySQL) - Quiz, Trivia & Questions

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

Aaron_marcelino

Community Contributor

Quizzes Created: 1 | Total Attempts: 265

Questions: 10 | Attempts: 265 | Updated: Mar 21, 2023

Questions

Settings

Create your own Quiz

Share on Facebook Share on Twitter Share on Whatsapp Share on Pinterest Share on Email Copy to Clipboard Embed on your website

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:

Quiz Review Timeline +

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

Database (Mssql | MySQL)

Database names are on a first come first serve basis.

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.

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

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

Customers can restore database files by use of Enterprise Manager.

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

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

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

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

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