Test
SQL Quiz
Este test tiene tiempo límite, así que se abre en el reproductor de siempre.
Preguntas del test (15)
1The SQL select statement is used to select data from tables. Which of the following is the correct syntax of retrieving all records from all columns in a table called employees?
- AA) employees.select(all)
- BB) set select = employees
- CC) SELECT * FROM employees
2If I am concerned about the particular order in which the results from a select statement are returned, which keywords should I use to achieve this?
- AA) ORDER BY
- BB) SORT BY
- CC) ARRANGE BY
3I need to retrieve related data from more than one table. Which of these would be required to link the tables when I perform a select operation?
- AA) JOIN
- BB) CONNECT
- CC) MERGE
4I have the data and now I need to make a table to store my data. What SQL statement would I use for this?
- AA) SELECT statement
- BB) CREATE statement
- CC) MAKE statement
5How can you populate a database table with data using SQL?
- AA) By using an INSERT statement
- BB) By using a SELECT
- CC) By using an ADD statement
6I just discovered my table needs an additional column, what should I do to make this change?
- AA) Delete your table and recreate it
- BB) There is nothing you can do
- CC) Use the ALTER TABLE statement
7Now that my data is corrupted I want to remove it all from the table. What should I do?
- AA) use CLEAN
- BB) use SELECT EMPTY
- CC) use TRUNCATE
8How about if I just want to delete the table, what should I do?
- AA) You cannot delete tables
- BB) Use the DROP TABLE statement
- CC) Use the DELETE statement
9How do I set a certain criteria when selecting data from my table?
- AA) Use FILTER keyword
- BB) Use the CRITERIA keyword
- CC) Use the WHERE clause
10Sometimes it may be difficult to test whether a column is void of data or has some non printable data. Visually they look the same, how can I verify this using SQL?
- AA) Use IS NULL or IS NOT NULL clauses
- BB) Use = ''
- CC) There is no such thing as empty space in a table
11Retrieving data from my table using a SELECT statement is extremely slow, how can I solve this problem?
- AA) Break your table into several smaller ones
- BB) Upgrade you computer hardware
- CC) INDEX your table columns
12I have noticed on occasion that I need to place a selection criteria in one statement based on indefinite information stored in another table. Is there an efficient way to go about it? If yes, what should I do?
- AA) Use a subquery
- BB) Run the SELECT statement in a loop;
- CC) There is no efficient way
13How do I use SQL to perform math calculations?
- AA) Use the CALCULATE clause
- BB) Use the MATH statement
- CC) Use the SELECT statement
14While we are still thinking about calculations, how would I find the average of values in a certain column in SQL?
- AA) Use SELECT AVERAGE
- BB) Use AVG() built in function
- CC) You need a third party application
15What if I need to make changes to the data in a database without affecting the table structure, what would I use?
- AA) Data in a table cannot be edited
- BB) TRUNCATE the table and INSERT the correct data
- CC) Use the UPDATE statement
Información
- Descripción
- This is quick quiz to test the basics of SQL
- Autor
- Chris Cronin
- Idioma
- English
- Visitas
- 226
- Etiquetas
- Valoración
- Aún sin valoraciones Valora este test