SQL preguntas y respuestas de entrevista
Pregunta 101. What are the wildcards used for pattern matching.?
_ for single character substitution and % for multi-character substitution.
Pregunta 102. What is the parameter substitution symbol used with INSERT INTO command?
&
Pregunta 103. What's an SQL injection?
SQL Injection is when form data contains an SQL escape sequence and injects a new SQL query to be run.
Pregunta 104. What is difference between TRUNCATE & DELETE ?
TRUNCATE commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE
DELETE allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.
Pregunta 105. What is a join? Explain the different types of joins?
Join is a query, which retrieves related columns or rows from multiple tables.
Self Join - Joining the table with itself.
Equi Join - Joining two tables by equating two common columns.
Non-Equi Join - Joining two tables by equating two common columns.
Outer Join - Joining two tables in such a way that query can also retrieve rows that do not have corresponding join value in the other table.
Lo mas util segun los usuarios: