MySQL questionary

  • « back
  •  ⇨ Compare MySQL vs SQL Server

     ⇨ What is SL Server?

     ⇨ How and why use it?

     ⇨ What are the features of MySL?

     ⇨ What is traditional Network Library for the system?

     ⇨ What is the default port for MySL Server?

     ⇨ What do DDL, DML, and DCL stand for?

     ⇨ What are meant by Joins in MySL?

     ⇨ What are the common MySL functions?

     ⇨ What is the difference between CHAR and VARCHAR?

     ⇨ What are HEAP Tables?

     ⇨ What is the syntax for concatenating tables in MySL?

     ⇨ What are the limits for using columns to create the Index?

     ⇨ What are the different types of strings in Database columns in MySL?

     ⇨ How the user can get the current SL version?

     ⇨ Is there an object oriented version of MySL library functions?

     ⇨ What is the storage engine for MySL?

     ⇨ What is the difference between primary key and candidate key?

     ⇨ What are the different types of tables in MySL?

     ⇨ Can you use MySL with LINUX operating system?

     ⇨ What is the use of ENUM in MySL?

     ⇨ What are the TRIGGERS that can be used in MySL tables?

     ⇨ What is the difference between LIKE and REGEXP operators in MySL?

     ⇨ How to use the MySL slow uery log?

     ⇨ How can one take incremental backup in MySL?

     ⇨ How can you change the root password if the root password is lost?

     ⇨ How to resolve the problem of data disk that is full?

     ⇨ What is the difference between DELETE TABLE and

         TRUNCATE TABLE commands in MySL?

     ⇨ What are types of joins in MySL?

     ⇨ What are the storage models of OLAP?

     ⇨ How to define testing of network layers in MySL?

     ⇨ What is the difference between primary key and uniue key?

     ⇨ What is meant by transaction and ACID properties?

     ⇨ How can one restart SL Server in single user or minimal

         configuration modes?

     ⇨ What is the difference between BLOB and TEXT?

     ⇨ What is the basic MySL architecture?