| Question | Likes! | Dislikes! | Answers! |
|---|
Questions of this subject!.
| 1)Should I use the datetime or timestamp data type in MySQL? | 0 | 0 | 1 |
| 2)Why shouldnt I use mysql_* functions in PHP?-mysql | 0 | 0 | 1 |
| 3)Compare MySQL vs SQL Server. | 0 | 0 | 1 |
| 4)What is SQL Server? | 0 | 0 | 1 |
| 5)How and why use SQL Server? | 0 | 0 | 1 |
| 6) What are the features of MySQL? | 0 | 0 | 1 |
| 7)What is the Traditional Network Library for a system? | 0 | 0 | 1 |
| 8)What is the default port for MySQL Server? | 0 | 0 | 1 |
| 9)What do DDL, DML, and DCL stand for? | 0 | 0 | 1 |
| 10)What is a join in MySQL? | 0 | 0 | 1 |
| 11)What are the common MySQL functions? | 0 | 0 | 1 |
| 12)What are Heap Tables? | 0 | 0 | 1 |
| 13)What is the syntax for concatenating tables in MySQL? | 0 | 0 | 1 |
| 14)What is the limit of indexed columns that can be created for a table? | 0 | 0 | 1 |
| 15)What are the different types of strings used in database columns in MySQL? | 0 | 0 | 1 |
| 16)How can a user get the current SQL version? | 0 | 0 | 1 |
| 17)Is there an object-oriented version of MySQL library functions? | 0 | 0 | 1 |
| 18)What is the storage engine used for MySQL? | 0 | 0 | 1 |
| 19)"What is the difference between the primary key and the candidate key? " | 0 | 0 | 2 |
| 20)What are the different types of tables in MySQL? | 0 | 0 | 6 |
| 21)Can you use MySQL with Linux operating system? | 0 | 0 | 1 |
| 22)What are the TRIGGERS that can be used in MySQL tables? | 0 | 0 | 2 |
| 23)What is the use of ENUM in MySQL? | 0 | 0 | 2 |
| 24)What is the difference between LIKE and REGEXP operators in MySQL? | 0 | 0 | 2 |
| 25)How to use the MySQL slow query log? | 0 | 0 | 2 |
| 26)How can one take an incremental backup in MySQL? | 0 | 0 | 1 |
| 27) How can you change the root password if it is lost? | 0 | 0 | 1 |
| 28)How to resolve the problem of the data disk that is full? | 0 | 0 | 1 |
| 29)What is the difference between the Drop, DELETE TABLE and TRUNCATE TABLEcommands in MySQL? | 0 | 0 | 3 |
| 30)What are the storage models of OLAP? | 0 | 0 | 1 |
| 31)How to define the testing of network layers in MySQL? | 0 | 0 | 1 |
| 32)What is the difference between primary key and unique key? | 0 | 0 | 2 |
| 33)How can one restart SQL Server in the single user or the minimal configuration modes? | 0 | 0 | 1 |
| 34)What is the basic MySQL architecture? | 0 | 0 | 1 |
| 35)What are the advantages and disadvantages of using MySQL? | 0 | 0 | 6 |
| 36)What is the function of myisamchk? | 0 | 0 | 1 |
| 37)Differentiate between FLOAT and DOUBLE? | 0 | 0 | 1 |
| 38)Differentiate CHAR_LENGTH and LENGTH? | 0 | 0 | 1 |
| 39)What is the usage of ENUMs in MySQL? | 0 | 0 | 1 |
| 40)What are all the Common SQL Function? | 0 | 0 | 1 |
| 41)What are the nonstandard string types? | 0 | 0 | 1 |
| 42)How many TRIGGERS are allowed in MySql table? | 0 | 0 | 1 |
| 43)What are the objects can be created using CREATE statement? | 0 | 0 | 1 |
| 44)What is the different between NOW() and CURRENT_DATE()? | 0 | 0 | 1 |
| 45)How many columns can be used for creating Index? | 0 | 0 | 1 |
| 46)How to enter Characters as HEX Numbers? | 0 | 0 | 1 |
| 47)What is ISAM? | 0 | 0 | 1 |
| 48)What is InnoDB? | 0 | 0 | 3 |
| 49)Where MyISAM table will be stored and also give their formats of storage? | 0 | 0 | 1 |
| 50) What is the difference between mysql_fetch_array and mysql_fetch_object? | 0 | 0 | 1 |
| 51)What are the column comparisons operators? | 0 | 0 | 1 |
| 52)What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table? | 0 | 0 | 1 |
| 53)How can we find out which auto increment was assigned on Last insert? | 0 | 0 | 1 |
| 54)How can you see all indexes defined for a table? | 0 | 0 | 1 |
| 55)What is Database White Box Testing? | 0 | 0 | 1 |
| 56)What is Database Black Box Testing? | 0 | 0 | 2 |
| 57)What is CTE? | 0 | 0 | 2 |
| 58) How can you test for NULL values in a database? | 0 | 0 | 1 |
| 59)Can you tell how can you display the Maximum salary in SQL? | 0 | 0 | 1 |
| 60)What is the difference between the NVL function, IFNULL function, and the ISNULL function? | 0 | 0 | 2 |
| 61)What is the difference between GUI Testing and Database Testing? | 0 | 0 | 1 |
| 62)How To Display Nth Highest Salary From A Table In A Mysql Query? | 0 | 0 | 1 |
| 63)What is the command used to create a database using PHP and MySQL | 0 | 0 | 1 |
| 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? | 0 | 0 | 1 |
| 65)How can you increase the performance of MySQL SELECT query? | 0 | 0 | 1 |
| 66) Write a program using the SELECT statement, While Loop. | 0 | 0 | 1 |
| 67)How can you take the backup and restore a MySQL database using PHP? | 0 | 0 | 1 |
| 68)What is Normalization and Denormalization? | 0 | 0 | 2 |
| 69)When can we use the WHERE clause and the HAVING clause? | 0 | 0 | 2 |
| 70)How to select 10 records from a table? | 0 | 0 | 2 |
| 71)What is collation? | 0 | 0 | 2 |
| 72)What are the different ways to optimize a MySQL query? | 0 | 0 | 4 |
| 73)What is the purpose of DDL Language? in Mysql | 0 | 0 | 1 |
| 74)What is the purpose of DCL Language? in MySQL | 0 | 0 | 1 |
| 75)Which command is used to view the content of the table in MySQL? | 0 | 0 | 2 |
| 76) How to change a password for an existing user via mysqladmin? MYSQL | 0 | 0 | 1 |
| 77)What are SQL Injections, how do you prevent them and what are the best practices? | 0 | 0 | 2 |
| 78)What is a UNIQUE constraint in MySQL? | 0 | 0 | 1 |
| 79)How can we delete a column or a row in MySQL? | 0 | 0 | 1 |
| 80)Can a primary key be dropped in MySQL? If yes, how? | 0 | 0 | 1 |
| 81) What are Procedures in MySQL? | 0 | 0 | 1 |
| 82) What is a trigger in MySQL? | 0 | 0 | 1 |
| 83)What is the command used to create a database using PHP and MySQL? | 0 | 0 | 2 |
| 84)SQL query return data from multiple tables. -mysql | 0 | 0 | 1 |
| 85)How do I import an SQL file using the command line in MySQL? | 0 | 0 | 1 |
| 86)Can I concatenate multiple MySQL rows into one field? | 0 | 0 | 1 |
| 87)Which MySQL data type to use for storing boolean values? | 0 | 0 | 1 |
| 88)How do I connect to a MySQL Database in Python? | 0 | 0 | 2 |
| 89)What is difference between INNER JOIN ON vs WHERE clause in MySQL? | 0 | 0 | 1 |
| 90)INSERT INTO a MySQL table or update if exists? | 0 | 0 | 1 |
| 91)How can I do insert if not exists in MySQL? | 0 | 0 | 1 |
| 92)TINYTEXT, TEXT, MEDIUMTEXT, and LONGTEXT maximum storage sizes? -Mysql | 0 | 0 | 1 |
| 93)Finding duplicate values in MySQL? | 0 | 0 | 1 |
| 94)Duplicating a MySQL table, indices, and data? | 0 | 0 | 1 |
| 95)Disable ONLY_FULL_GROUP_BY in MySQL? | 0 | 0 | 1 |
| 96)How can I temporarily disable a foreign key constraint in MySQL? | 0 | 0 | 1 |
| 97)When to use single quotes, double quotes, and backticks in MySQL? | 0 | 0 | 1 |
| 98)How do I change the data type for a column in MySQL? | 0 | 0 | 1 |
| 99)How to see indexes for a database or table in MySQL? | 0 | 0 | 1 |
| 100)MySQL select 10 random rows from 600K rows fast? | 0 | 0 | 1 |
| 101)Maximum length for MySQL type text? | 0 | 0 | 1 |
| 102)How do I add indexes to MySQL tables? | 0 | 0 | 1 |
| 103)How can I check MySQL engine type for a specific table? | 0 | 0 | 1 |
| 104)How can I import a database with MySQL from terminal? | 0 | 0 | 1 |
| 105)MYSQL firstly released in which year? | 0 | 0 | 1 |
| 106)In MYSQL,Explain unique features ? | 0 | 0 | 1 |
| 107)MYSQL in which way connected to RDBMS? | 0 | 0 | 1 |
| 108)In MYSQL,Do Semicolon required to seperate the sql statements or at the end of each statement? | 0 | 0 | 1 |
| 109)IN MYSQL,explain about the commands? SELECT, UPDATE, DELETE | 0 | 0 | 1 |
| 110)IN MYSQL,explain about the commands? CREATE TABLE, ALTER DATABASE | 0 | 0 | 1 |
| 111)IN MYSQL,explain about the commands? CREATE INDEX, DROP INDEX? | 0 | 0 | 1 |
| 112)IN MYSQL, What is Result-set? | 0 | 0 | 1 |
| 113)IN MYSQL, how to Select Columns? | 0 | 0 | 1 |
| 114)IN MYSQL, What is meant by Select * ? and what primarily asterick here means? | 0 | 0 | 1 |
| 115)IN MYSQL, what is meant by SELECT DISTINCT? | 0 | 0 | 1 |
| 116)IN MYSQL, where clause is used for? | 0 | 0 | 1 |
| 117)IN MYSQL, explain some common operators used under where clause? | 0 | 0 | 1 |
| 118)IN MYSQL, Explain about AND,OR , NOT operators and how they will be combine with where clause? | 0 | 0 | 1 |
| 119)IN MYSQL, explain about ORDER BY KEYWORD? | 0 | 0 | 1 |
| 120)IN MYSQL, which statement is used to insert new records into table? | 0 | 0 | 1 |
| 121)IN MYSQL, what is null value? | 0 | 0 | 1 |
| 122)IN MYSQL, Explain about Is Null and Is Not Null opeartors? | 0 | 0 | 2 |
| 123)IN MYSQL, what is the usage of UPDATE keyword ? | 0 | 0 | 1 |
| 124)IN MYSQL, how to update multiple records? | 0 | 0 | 3 |
| 125)IN MYSQL, explain the difference between Delete and Drop? | 0 | 0 | 1 |
| 126)IN MYSQL, what is the usage of LIMIT clause? | 0 | 0 | 1 |
| 127)IN MYSQL, count() function returns what? | 0 | 0 | 1 |
| 128)IN MYSQL, explain the following functions? AVG() AND SUM() | 0 | 0 | 1 |
| 129)IN MYSQL, explain about Like Operator and how we use it with where clause? | 0 | 0 | 2 |
| 130)IN MYSQL, what is the use of wildcard characters? | 0 | 0 | 1 |
| 131)IN MYSQL wildcard characters, what does % and - symbols represents? | 0 | 0 | 1 |