Complete the gaps in the following questions:
Question 1: Fill in the blanks correctly: A) WHERE / SELECT / NOT IN B) IN / WHERE / INTERSECT C) FR...
Complete the gaps in the following questions:
Question 1: Fill in the blanks correctly: A) WHERE / SELECT / NOT IN B) IN / WHERE / INTERSECT C) FROM / WHERE / NOT IN D) NOT IN / SELECT / INTERSECT E) IN / SELECT / NOT IN Question 2: What is the correct SQL statement to delete all products from a MySQL database? A) DROP TABLE. B) DELETE. C) TRUNCATE. D) SELECT. E) ALTER TABLE. Question 3: Consider the following tables of a database from a store. What is the SQL command necessary to generate a report with all product names that have less than 100 units in stock? A) SELECT Nome, qtdEstoque FROM Produto WHERE qtdEstoque < 100; B) SELECT TABLE Produto WHERE Nome AND qtdEstoque LESS THAN 100; C) SELECT Nome AND qtdEstoque FROM Produto IF qtdEstoque < 100; D) SELECT TABLE Nome, qtdEstoque WHERE qtdEstoque LESS THAN 100; E) SELECT FROM Produto COLUMNS Nome, qtdEstoque WHERE qtdEstoque < 100; Question 4: Given the table and insertions, what are the correct outputs for the following SQL syntaxes? I. SELECT MAX(b) FROM exemplo WHERE b < 9; II. SELECT SUM(c) FROM exemplo WHERE a > 4; III. SELECT COUNT(DISTINCT d) FROM exemplo; IV. SELECT AVG(a) FROM exemplo; A) 8 – 45 – 9 – 4.6. B) 8 – 38 – 10 – 4. C) 9 – 60 – 9 – ~5.5. D) 8 – 55 – 10 – 6. E) 9 – 55 – 0 – ~5.1. Question 5: In a SELECT statement using FULLTEXT, what are the two commands that must be used to inform the DBMS of the column to be used in the FULLTEXT query and the keyword to be searched? A) MATCH(coluna) / AGAINST(‘palavra_desejada’). B) MATCH(coluna) / INDEX(‘palavra_desejada’). C) FULLTEXT (‘palavra_desejada’) / MATCH (coluna). D) FULLTEXT(coluna) / MATCH(‘palavra_desejada’). E) MATCH(‘palavra_desejada’) / AGAINST(coluna). Question 6: What is the SQL resource that encapsulates a SELECT statement, creating a virtual table in the cache of the DBMS, and is faster than a non-encapsulated SELECT statement? A) VIEW / temporary table. B) temporary table / VIEW. C) INDEX / VIEW. D) VIEW / INDEX. E) temporary table / INDEX.
Question 1: A) WHERE / SELECT / NOT IN
Question 2: C) TRUNCATE.
Question 3: A) SELECT Nome, qtdEstoque FROM Produto WHERE qtdEstoque < 100;
Question 4: E) 9 – 55 – 0 – ~5.1.
Question 5: A) MATCH(coluna) / AGAINST(‘palavra_desejada’).
Question 6: A) VIEW / temporary table.
0
0
Faça como milhares de estudantes: teste grátis o Passei Direto
Compartilhar