Random Testing

Question 1

How many TRIGGERS are allowed in MySql table?

Answer 1

BEFORE INSERT AFTER INSERT BEFORE UPDATE AFTER UPDATE BEFORE DELETE and AFTER DELETE

Question 2

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

Answer 2

TIMESTAMP column is updated with Zero when the table is created. UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to the current time whenever there is a change in other fields of the table.

Question 3

What is InnoDB?

Answer 3

lnnoDB is a transaction safe storage engine developed by Innobase Oy which is a Oracle Corporation now.

Question 4

What are federated tables?

Answer 4

Federated tables which allow access to the tables located on other databases on other servers.

Question 5

What are the column comparisons operators?

Answer 5

The = , <>, <=, =, >,<>, <=>, AND, OR, or LIKE operators are used in column comparisons in SELECT statements.

Question 6

How do you control the max size of a HEAP table?

Answer 6

Maximum size of Heal table can be controlled by MySQL config variable called max_heap_table_size.

Question 7

What is the difference between mysql_fetch_array and mysql_fetch_object?

Answer 7

Following are the differences between mysql_fetch_array and mysql_fetch_object: mysql_fetch_array() -Returns a result row as an associated array or a regular array from database. mysql_fetch_object – Returns a result row as object from database.

Question 8

What are all the Common SQL Function?

Answer 8

CONCAT(A, B) – Concatenates two string values to create a single string output. Often used to combine two or more fields into one single field. FORMAT(X, D) – Formats the number X to D significant digits. CURRDATE(), CURRTIME() – Returns the current date or time. NOW() – Returns the current date and time as one value. MONTH(), DAY(), YEAR(), WEEK(), WEEKDAY() – Extracts the given data from a date value. HOUR(), MINUTE(), SECOND() – Extracts the given data from a time value. DATEDIFF(A, B) – Determines the difference between two dates and it is commonly used to calculate age SUBTIMES(A, B) – Determines the difference between two times. FROMDAYS(INT) – Converts an integer number of days into a date value.

Question 9

What storage engines are used in MySQL?

Answer 9

Storage engines are called table types and data is stored in files using various techniques. Technique involves: Storage mechanism Locking levels Indexing Capabilities and functions.

Question 10

What is ISAM?

Answer 10

ISAM is abbreviated as Indexed Sequential Access Method.It was developed by IBM to store and retrieve data on secondary storage systems like tapes.

Question 11

What is the difference between BLOB AND TEXT?

Answer 11

The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive for BLOB values and case-insensitive for TEXT values.

Question 12

How many columns can be used for creating Index?

Answer 12

Maximum of 16 indexed columns can be created for any standard table.

Question 13

What are the different tables present in MySQL?

Answer 13

MyISAM Heap Merge INNO DB ISAM

Question 14

What is the default port for MySQL Server?

Answer 14

The default port for MySQL Server is 3306. Another standard default is port 1433 in TCP/IP for SQL Server.

Question 15

How to display top 50 rows?

Answer 15

SELECT * FROM LIMIT 0,50;

Question 16

What does myisamchk do?

Answer 16

It compresses the MyISAM tables, which reduces their disk or memory usage.

Question 17

What do you mean by % and _ in the LIKE statement?

Answer 17

% corresponds to 0 or more characters, _ is exactly one character in the LIKE statement.

Question 18

What is the difference between primary key and candidate key?

Answer 18

Every row of a table is identified uniquely by primary key. There is only one primary key for a table. Primary Key is also a candidate key. By common convention, candidate key can be designated as primary and which can be used for any foreign key references.

Question 19

What are the drivers in MySQL?

Answer 19

PHP Driver JDBC Driver ODBC Driver C WRAPPER PYTHON Driver PERL Driver RUBY Driver CAP11PHP Driver Ado.net5.mxj

Question 20

Can you tell what are the different set operations available in MySQL?

Answer 20

UNION – This operation returns all the distinct rows selected by a query

UNION ALL – This operation returns all the rows selected by a query and also includes all duplicate rows.

MINUS – This operation returns all the distinct rows selected by the first query but does not select the rows selected by the second query.

INTERSECT – This operation returns all the distinct rows selected by both queries.

Question 21

Can you tell the order of SQL SELECT statement?

Answer 21

The order of SQL SELECT statement is as follows:

SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY.

Question 22

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

Answer 22

To display the maximum salary in SQL, you can use the inbuilt function called MAX().

Question 23

Can you tell how many values can Set the function of MySQL to consider?

Answer 23

MySQL’s Set function can take a maximum of 64 values, but can also consider 0 values.