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 |