View note:MySQL



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
1)Compare MySQL vs SQL Server.

001
2)What is SQL Server?

001
3)How and why use SQL Server?

001
4) What are the features of MySQL?

001
5)What is the Traditional Network Library for a system?

001
6)What is the default port for MySQL Server?

001
7)What do DDL, DML, and DCL stand for?

001
8)What is a join in MySQL?

001
9)What are the common MySQL functions?

001
10)What is the difference between CHAR and VARCHAR?

001
11)What are Heap Tables?

001
12)What is the syntax for concatenating tables in MySQL?

001
13)What is the limit of indexed columns that can be created for a table?

001
14)What are the different types of strings used in database columns in MySQL?

001
15)How can a user get the current SQL version?

001
16)Is there an object-oriented version of MySQL library functions?

001
17)What is the storage engine used for MySQL?

001
18)"What is the difference between the primary key and the candidate key? "

001
19)What are the different types of tables in MySQL?

001
20)Can you use MySQL with Linux operating system?

001
21)What are the TRIGGERS that can be used in MySQL tables?

002
22)What is the use of ENUM in MySQL?

002
23)What is the difference between LIKE and REGEXP operators in MySQL?

001
24)How to use the MySQL slow query log?

002
25)How can one take an incremental backup in MySQL?

001
26) How can you change the root password if it is lost?

001
27)How to resolve the problem of the data disk that is full?

001
28)What is the difference between the DELETE TABLE and TRUNCATE TABLE commands in MySQL?

001
29)What are the types of joins in MySQL?

001
30)What are the storage models of OLAP?

001
31)How to define the testing of network layers in MySQL?

001
32)What is the difference between primary key and unique key?

001
33)What is the difference between primary key and unique key?

001
34)How can one restart SQL Server in the single user or the minimal configuration modes?

001
35)What is the basic MySQL architecture?

001
36)What are the advantages and disadvantages of using MySQL?

001
37)What is the function of myisamchk?

001
38)Differentiate between FLOAT and DOUBLE?

001
39)Differentiate CHAR_LENGTH and LENGTH?

001
40)What is the usage of ENUMs in MySQL?

001
41)Explain Access Control Lists

001
42)What are all the Common SQL Function?

001
43)What are the nonstandard string types?

001
44)How many TRIGGERS are allowed in MySql table?

001
45)What are the objects can be created using CREATE statement?

001
46)What is the different between NOW() and CURRENT_DATE()?

001
47)How many columns can be used for creating Index?

001
48)How to enter Characters as HEX Numbers?

001
49)How MySQL Optimizes DISTINCT?

001
50)What is ISAM?

001
51)What is InnoDB?

001
52) What are the different tables present in MySQL?

001
53)Where MyISAM table will be stored and also give their formats of storage?

001
54) What is the difference between mysql_fetch_array and mysql_fetch_object?

001
55)What is the difference between BLOB AND TEXT?

001
56)What is the difference between the LIKE and REGEXP operators?

001
57) Is Mysql query is case sensitive?

001
58)What are the column comparisons operators?

001
59)What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?

001
60)How can we find out which auto increment was assigned on Last insert?

001
61)How can you see all indexes defined for a table?

001
62)What are federated tables?

101
63)What is the difference between primary key and candidate key?

001
64)What is Database White Box Testing?

001
65)What is Database Black Box Testing?

001
66)What is CTE?

001
67)What is a Cursor?

001
68) How can you test for NULL values in a database?

001
69)Can you tell how can you display the Maximum salary in SQL?

001
70)What is the difference between the NVL function, IFNULL function, and the ISNULL function?

001
71)What is the difference between GUI Testing and Database Testing?

001
72)How To Display Nth Highest Salary From A Table In A Mysql Query?

001
73)What is the command used to create a database using PHP and MySQL

001
74)Can you tell the reasons for selecting Lamp(Linux, Apache, MySQL, PHP) instead of any other combination of software programs, servers, and operating system?

001
75)How can you increase the performance of MySQL SELECT query?

001
76) Write a program using the SELECT statement, While Loop.

001
77)How can you take the backup and restore a MySQL database using PHP?

001
78)What is Normalization and Denormalization?

001
79)When can we use the WHERE clause and the HAVING clause?

001
80)How to select 10 records from a table?

001
81)What is collation?

001