View note:MySQL



Questions of this subject!.

QuestionLikes!Dislikes!Answers!
1)Should I use the datetime or timestamp data type in MySQL?

001
2)Why shouldnt I use mysql_* functions in PHP?-mysql

001
3)Compare MySQL vs SQL Server.

001
4)What is SQL Server?

001
5)How and why use SQL Server?

001
6) What are the features of MySQL?

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

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

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

001
10)What is a join in MySQL?

001
11)What are the common MySQL functions?

001
12)What are Heap Tables?

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

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

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

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

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

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

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

002
20)What are the different types of tables in MySQL?

006
21)Can you use MySQL with Linux operating system?

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

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

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

002
25)How to use the MySQL slow query log?

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

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

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

001
29)What is the difference between the Drop, DELETE TABLE and TRUNCATE TABLEcommands in MySQL?

003
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?

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

001
34)What is the basic MySQL architecture?

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

006
36)What is the function of myisamchk?

001
37)Differentiate between FLOAT and DOUBLE?

001
38)Differentiate CHAR_LENGTH and LENGTH?

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

001
40)What are all the Common SQL Function?

001
41)What are the nonstandard string types?

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

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

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

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

001
46)How to enter Characters as HEX Numbers?

001
47)What is ISAM?

001
48)What is InnoDB?

003
49)Where MyISAM table will be stored and also give their formats of storage?

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

001
51)What are the column comparisons operators?

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

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

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

001
55)What is Database White Box Testing?

001
56)What is Database Black Box Testing?

002
57)What is CTE?

002
58) How can you test for NULL values in a database?

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

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

002
61)What is the difference between GUI Testing and Database Testing?

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

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

001
64)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
65)How can you increase the performance of MySQL SELECT query?

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

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

001
68)What is Normalization and Denormalization?

002
69)When can we use the WHERE clause and the HAVING clause?

002
70)How to select 10 records from a table?

002
71)What is collation?

002
72)What are the different ways to optimize a MySQL query?

004
73)What is the purpose of DDL Language? in Mysql

001
74)What is the purpose of DCL Language? in MySQL

001
75)Which command is used to view the content of the table in MySQL?

002
76) How to change a password for an existing user via mysqladmin? MYSQL

001
77)What are SQL Injections, how do you prevent them and what are the best practices?

002
78)What is a UNIQUE constraint in MySQL?

001
79)How can we delete a column or a row in MySQL?

001
80)Can a primary key be dropped in MySQL? If yes, how?

001
81) What are Procedures in MySQL?

001
82) What is a trigger in MySQL?

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

002
84)SQL query return data from multiple tables. -mysql

001
85)How do I import an SQL file using the command line in MySQL?

001
86)Can I concatenate multiple MySQL rows into one field?

001
87)Which MySQL data type to use for storing boolean values?

001
88)How do I connect to a MySQL Database in Python?

002
89)What is difference between INNER JOIN ON vs WHERE clause in MySQL?

001
90)INSERT INTO a MySQL table or update if exists?

001
91)How can I do insert if not exists in MySQL?

001
92)TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes? -Mysql

001
93)Finding duplicate values in MySQL?

001
94)Duplicating a MySQL table, indices, and data?

001
95)Disable ONLY_FULL_GROUP_BY in MySQL?

001
96)How can I temporarily disable a foreign key constraint in MySQL?

001
97)When to use single quotes, double quotes, and backticks in MySQL?

001
98)How do I change the data type for a column in MySQL?

001
99)How to see indexes for a database or table in MySQL?

001
100)MySQL select 10 random rows from 600K rows fast?

001
101)Maximum length for MySQL type text?

001
102)How do I add indexes to MySQL tables?

001
103)How can I check MySQL engine type for a specific table?

001
104)How can I import a database with MySQL from terminal?

001
105)MYSQL firstly released in which year?

001
106)In MYSQL,Explain unique features ?

001
107)MYSQL in which way connected to RDBMS?

001
108)In MYSQL,Do Semicolon required to seperate the sql statements or at the end of each statement?

001
109)IN MYSQL,explain about the commands? SELECT, UPDATE, DELETE

001
110)IN MYSQL,explain about the commands? CREATE TABLE, ALTER DATABASE

001
111)IN MYSQL,explain about the commands? CREATE INDEX, DROP INDEX?

001
112)IN MYSQL, What is Result-set?

001
113)IN MYSQL, how to Select Columns?

001
114)IN MYSQL, What is meant by Select * ? and what primarily asterick here means?

001
115)IN MYSQL, what is meant by SELECT DISTINCT?

001
116)IN MYSQL, where clause is used for?

001
117)IN MYSQL, explain some common operators used under where clause?

001
118)IN MYSQL, Explain about AND,OR , NOT operators and how they will be combine with where clause?

001
119)IN MYSQL, explain about ORDER BY KEYWORD?

001
120)IN MYSQL, which statement is used to insert new records into table?

001
121)IN MYSQL, what is null value?

001
122)IN MYSQL, Explain about Is Null and Is Not Null opeartors?

002
123)IN MYSQL, what is the usage of UPDATE keyword ?

001
124)IN MYSQL, how to update multiple records?

003
125)IN MYSQL, explain the difference between Delete and Drop?

001
126)IN MYSQL, what is the usage of LIMIT clause?

001
127)IN MYSQL, count() function returns what?

001
128)IN MYSQL, explain the following functions? AVG() AND SUM()

001
129)IN MYSQL, explain about Like Operator and how we use it with where clause?

002
130)IN MYSQL, what is the use of wildcard characters?

001
131)IN MYSQL wildcard characters, what does % and - symbols represents?

001