Repaso 3r parcial BD

1.What are the advantages of using indexes?. a)Simplify the query’s and enhances security. b)Search information faster. c)All of the above.

2.Wich are the ACID properties of transactions?. a)Atomicity,consistency preservation,isolation,durability. b)Atomicity, consistency preservation, independency, definition. c)Aislation, consistency , isolation, definition.

3. Wich isolation level allow dirty read. a) Read uncommited. b) Read commited. c) Serializable.

4.Which MySQL function is used to convert a string to uppercase?. a)Propper(). b)Lower(). c)upper().

5.How to replace a character into a string in Mysql?. a)Select replace(‘cadena original’,’à’,’a’);. b)Select replace(’à’,’a’);. c)Select replace(‘cadena original’,’cadena destino’,2);.

6. Which MySQL function is used to return a string with the characters in reverse order?. a)Inverse(). b)Reverse(). c)Flip().