KUNGFU TECH vietnam
6315 câu hỏi phỏng vấn Full-Stack, Coding & System Design Interview
Bộ lọc:
How are VARCHAR and CHAR different. Talk about cases where you will use one over other.
What is a VIEW in MySQL. How can you create and query a view?
Explain foreign key constraint in MySQL
Describe BLOB in MySQL. What is it used for?
What is self referencing foreign key? Give an example.
What is an AGGREGATE function. Name few aggregate functions used in MySQL.
Explain DEFAULT constraint in MySQL
What is the difference between Data Definition Language (DDL) and Data Manipulation Language (DML)?
What is Primary Key Constraint and Unique Key Constraints?
What is the difference between TRUNCATE and DELETE ?
What are different integer data types in MySQL? How can you use unsigned integer in MySQL?
What are key constraints. What different types of constraints are there in MySQL?
What are Derived Columns. What possible problems can a derived column pose?
What are REPEAT , LOOP and WHILE statements used for?
Both TIMESTAMP and DATETIME are used to store data and time. Explain difference between them and when should one be used?
What is the difference between commands create database and create schema in MySQL?
What is Stored Function in MySQL. How are they different from Stored Procedure?
What is the use of IN and BETWEEN in MySQL queries?
What is the use of DELIMETER command in MySQL?
Explain GRANT command in MySQL
What is MySQL Workbench?
What is difference between BLOB and TEXT in MySQL?
What is a trigger. What are different type of triggers in MySQL?
How can VIEW be used to provide security layer for your app?
Explain the use of FEDERATED tables in MySQL
What different stored objects are supported in MySQL?
What happens if a parent row which is referenced by child row is being deleted in case of foreign key constraint?
What is mysqldump ?
What is index in MySQL? What is advantage of index?
What are different TEXT data types in MySQL. What is difference between TEXT and VARCHAR ?
What is advantage of FULLTEXT over LIK...
What are differences between MyISAM and Inn...
What is faster, one big qu...
What are some major differences b...
What is database engine or storage engine? Mention f...
What is autocommit in MySQL? Can you run a...
Compare MySQL ...
What does OPTIMIZE TAB...
What is master-slave replication ...
What are some advantages and disadva...
Which partitioning typ...
What is cursor used in MySQL? Wha...
What is Memory Storage Engine ...
Why you should never use GUID...
What happens to a trigger in MySQL if an operation which t...
Which is better for JOIN & I...
What is the use of ...
How do you make schema changes to...
What are the differences b...
How many tables can a trigger associate to in...
What is difference between horizontal and vertical partitioning...