SQL and Excel Management Exam
Translated by
ScribdTranslationsSQL and Excel Management Exam
Translated by
ScribdTranslationsEXAM
Surnames and Names: ___________________________________________
Instructions: Select the correct answer
PART 1.- BASIC SQL
Duration: 10 min.
Question 1: A SELECT statement without the WHERE clause returns
a) All existing records in the table that are not related to another table
b) All existing records in the table
c) A SELECT statement cannot be executed without the WHERE clause.
d) The previous answers are not correct.
Question 2: What instruction is used to delete all the content of a table, but
preserving the table?
a) DELETE TABLE
b) DROP TABLE
c) TRUNCATE TABLE
d) The previous answers are not correct
Question 3: In a LIKE clause, how can you obtain all the names of people who have
exactly four characters?
LIKE '????'
LIKE '____'
c) LIKE '....'
d) The previous answers are not correct.
Question 4: Which of the following is not an aggregation function?
a) COUNT()
b) LIMIT()
c) MAX()
d) MIN()
Question 5: In SQL, to modify the structure of a table in a database, the
instruction
a) ALTER TABLE
b) CHANGE TABLE
c) MODIFY TABLE
d) The previous answers are not correct
Question 6: In SQL, to remove duplicate rows from the result of a SELECT statement you
employs
a) NO DUPLICATE
b) UNIQUE
c) DISTINCT
d) The previous answers are not correct
Question 7: In which of the following SQL statements is the SET clause used?
a) DELETE
b) DROP
c) SELECT
d) UPDATE
Question 8: In SQL, to sort the data returned by a SELECT statement, the ...
clause
a) ORDER BY
b) ORDERED BY
c) SORT BY
d) SORTED BY
Question 9: Which of the following is not an aggregation function?
a) AVG()
b) FLOOR()
c) SUM()
d) The previous answers are not correct
Question 10: How do you delete an entire database with SQL?
a) DELETE DATABASE
b) DROP DATABASE
c) ERASE DATABASE
d) The previous answers are not correct
Question 11: In SQL, which of these statements adds a row to a table in a database?
a) ADD
b) INSERT
c) UPDATE
d) INCLUDE
Question 12: In a LIKE clause, how can we obtain all the names of people who
Do they start with 'Juan'?
LIKE 'Juan%'
b) LIKE "Juan*"
c) LIKE "Juan$"
LIKE 'Juan&'
PART 2.- EXCEL MANAGEMENT
Duration: 20 min.
1. Start EXCEL
2. Make a connection to the SAKILA database located locally.
3. Extract the information of all the movies contained in the database including the
actors involved in them, the year of release, and the level of restriction or rating that
own each movie and place it in Excel.
4. With this information, design a pivot table that shows the number of movies in
the films in which each actor has acted, applying a filter by year of release.