myInterview.co

we have good collection of interview questions with answers


What is maximum size of a database in MySQL?


sql database interview questions and answers

common interview question for fresher and experiences.prepare your job interview with us. get your dream job.most frequently asked interview questions.best interview questions. sql database for interview questions and answers for fresher and experience. improve interview skills.improve interview confidence.sql database best interview questions. start your sql database job interview right now and get your dream jobs. preparation job interview any place and any time.also our android application available here. top sql database interview questions. best and top asking questions sql database interview questions with answers.





Note: any question and answer correct or incorrect give you vote. also you know correct answer then you can post your answer or give vote in answer.

my favorites

add to favorite


What is maximum size of a database in MySQL?

If the operating system or filesystem places a limit on the number of files in a directory, MySQL is bound by that constraint.The efficiency of the operating system in handling large numbers of files in a directory can place a practical limit on the number of tables in a database. If the time required to open a file in the directory increases significantly as the number of files increases, database performance can be adversely affected.
The amount of available disk space limits the number of tables. MySQL 3.22 had a 4GB (4 gigabyte) limit on table size. With the MyISAM storage engine in MySQL 3.23, the maximum table size was increased to 65536 terabytes (2567 – 1 bytes). With this larger allowed table size, the maximum effective table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.The InnoDB storage engine maintains InnoDB tables within a tablespace that can be created from several files. This allows a table to exceed the maximum individual file size. The tablespace can include raw disk partitions, which allows extremely large tables. The maximum tablespace size is 64TB.
The following table lists some examples of operating system file-size limits. This is only a rough guide and is not intended to be definitive. For the most up-to-date information, be sure to check the documentation specific to your operating system.Operating System File-size 
LimitLinux 2.2-Intel 32-bit 2GB (LFS: 4GB) 
Linux 2.4+ (using ext3 filesystem) 4TB 
Solaris 9/10 16TB
NetWare w/NSS filesystem 8TB
Win32 w/ FAT/FAT32 2GB/4GB
Win32 w/ NTFS 2TB (possibly larger)
MacOS X w/ HFS+ 2TB

best mysql interview question.
jayvik 0 0


More Answer

Post your Answer



sql database popular interview questions and answers


favorite 0
votes 0
answers 1
views 659

How can we know the number of days between two given dates usingMySQL?

asking question in sql database job interviews.
sql database 2013-07-08 18:04:02 sql database

favorite 0
votes 0
answers 0
views 598

What is the difference between char and varchar data types?

asking question in sql database job interviews.
sql database 2013-07-08 18:00:04 sql database

favorite 0
votes 0
answers 0
views 492

What is the difference between GROUP BY and ORDER BY in Sql?

asking question in sql database job interviews.
sql database 2013-07-08 17:59:11 sql database

favorite 0
votes 0
answers 0
views 475

What are two methods of retrieving SQL?

asking question in sql database job interviews.
sql database 2013-04-30 17:45:23 sql database

favorite 0
votes 0
answers 1
views 451

Which date function is used to find the difference between two dates?

asking question in sql database job interviews.
sql database 2013-05-04 11:19:48 sql database

favorite 0
votes 0
answers 0
views 449

Explain Normalization concept?

asking question in sql database job interviews.
sql database 2013-07-05 07:06:31 sql database

favorite 0
votes 0
answers 0
views 405

What is difference between DBMS and RDBMS?

asking question in sql database job interviews.
sql database 2013-05-04 11:18:22 sql database

favorite 0
votes 0
answers 0
views 400

What is the difference between Primary Key and Unique key?

asking question in sql database job interviews.
sql database 2013-07-08 17:55:28 sql database

favorite 0
votes 0
answers 0
views 388
sql database 2013-05-04 11:18:56 sql database

favorite 0
votes 0
answers 0
views 375

what is garbage collection? default time ? refresh time?

asking question in sql database job interviews.
sql database 2013-07-08 17:57:12 sql database

favorite 0
votes 0
answers 0
views 356

Difference between Store Procedure and Trigger?

asking question in sql database job interviews.
sql database 2013-05-01 18:24:50 sql database

favorite 0
votes 0
answers 0
views 354

What is maximum size of a database in MySQL?

asking question in sql database job interviews.
sql database 2013-07-05 07:02:31 sql database

favorite 0
votes 0
answers 6
views 353

How many ways we can we find the current date using MySQL?

asking question in sql database job interviews.
sql database 2013-07-05 07:10:46 sql database

favorite 0
votes 0
answers 0
views 336

What are the advantages/disadvantages of MySQL and PHP?

asking question in sql database job interviews.
sql database 2013-07-08 17:57:57 sql database

favorite 0
votes 0
answers 0
views 332

Give the syntax of Grant and Revoke commands?

asking question in sql database job interviews.
sql database 2013-07-05 07:05:18 sql database

favorite 0
votes 0
answers 0
views 327

What is cluster.cluster index and non cluster index ?

asking question in sql database job interviews.
sql database 2013-05-04 11:17:46 sql database

favorite 0
votes 0
answers 0
views 317

favorite 0
votes 0
answers 0
views 314

What is the difference between SQL and SQL Server ?

asking question in sql database job interviews.
sql database 2013-05-04 11:13:24 sql database

favorite 0
votes 0
answers 1
views 314

How can we find the number of rows in a table using MySQL?

asking question in sql database job interviews.
sql database 2013-07-05 07:09:21 sql database

favorite 0
votes 0
answers 0
views 309

What is database?

asking question in sql database job interviews.
sql database 2013-05-04 11:17:13 sql database


sql database best Interview Questions have been designed especially to get you acquainted with the nature of questions you may encounter during your interview for the subject of sql database Programming Language. here some questions that helpful for your interview.

Like Our fb page touch with us.