2620915
Descripción
Test por Chris Cronin, actualizado hace más de 1 año
|
Creado por Chris Cronin
hace más de 9 años
|
|
Pregunta 1
Pregunta
The 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?
Respuesta
-
A) employees.select(all)
-
B) set select = employees
-
C) SELECT * FROM employees
Pregunta 2
Pregunta
If 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?
Respuesta
-
A) ORDER BY
-
B) SORT BY
-
C) ARRANGE BY
Pregunta 3
Pregunta
I 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?
Respuesta
-
A) JOIN
-
B) CONNECT
-
C) MERGE
Pregunta 4
Pregunta
I have the data and now I need to make a table to store my data. What SQL statement would I use for this?
Respuesta
-
A) SELECT statement
-
B) CREATE statement
-
C) MAKE statement
Pregunta 5
Pregunta
How can you populate a database table with data using SQL?
Respuesta
-
A) By using an INSERT statement
-
B) By using a SELECT
-
C) By using an ADD statement
Pregunta 6
Pregunta
I just discovered my table needs an additional column, what should I do to make this change?
Respuesta
-
A) Delete your table and recreate it
-
B) There is nothing you can do
-
C) Use the ALTER TABLE statement
Pregunta 7
Pregunta
Now that my data is corrupted I want to remove it all from the table. What should I do?
Respuesta
-
A) use CLEAN
-
B) use SELECT EMPTY
-
C) use TRUNCATE
Pregunta 8
Pregunta
How about if I just want to delete the table, what should I do?
Respuesta
-
A) You cannot delete tables
-
B) Use the DROP TABLE statement
-
C) Use the DELETE statement
Pregunta 9
Pregunta
How do I set a certain criteria when selecting data from my table?
Respuesta
-
A) Use FILTER keyword
-
B) Use the CRITERIA keyword
-
C) Use the WHERE clause
Pregunta 10
Pregunta
Sometimes 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?
Respuesta
-
A) Use IS NULL or IS NOT NULL clauses
-
B) Use = ''
-
C) There is no such thing as empty space in a table
Pregunta 11
Pregunta
Retrieving data from my table using a SELECT statement is extremely slow, how can I solve this problem?
Respuesta
-
A) Break your table into several smaller ones
-
B) Upgrade you computer hardware
-
C) INDEX your table columns
Pregunta 12
Pregunta
I 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?
Respuesta
-
A) Use a subquery
-
B) Run the SELECT statement in a loop;
-
C) There is no efficient way
Pregunta 13
Pregunta
How do I use SQL to perform math calculations?
Respuesta
-
A) Use the CALCULATE clause
-
B) Use the MATH statement
-
C) Use the SELECT statement
Pregunta 14
Pregunta
While we are still thinking about calculations, how would I find the average of values in a certain column in SQL?
Respuesta
-
A) Use SELECT AVERAGE
-
B) Use AVG() built in function
-
C) You need a third party application
Pregunta 15
Pregunta
What if I need to make changes to the data in a database without affecting the table structure, what would I use?
Respuesta
-
A) Data in a table cannot be edited
-
B) TRUNCATE the table and INSERT the correct data
-
C) Use the UPDATE statement
¿Quieres crear tus propios Tests gratis con GoConqr? Más información.