With SQL, how would you select all records from a table named "Personas", where "Nombre" is "Pedro" and "Apellido" is "Gil"? SELECT * FROM Personas WHERE Nombre LIKE 'Peter' AND LastName LIKE 'Jackson';. SELECT * FROM Personas WHERE Nombre LIKE 'Pedro' AND LIKE 'Gil';. SELECT * WHERE FirstName = 'Pedro', LastName = 'Gil' FROM Personas;. SELECT * FROM Personas WHERE FirstName = 'Pedro' OR LastName = 'Gil';.
What keyword is used to return only distinct values? ORDER BY. DISTINCT. COUNT. AS.
I want to extract the last character from a string, for this I would use: INSTR('string', length('string')) SUBSTR('string', length('string')) INSTR('string',-1) SUBSTR('string', 1,-1).
Which of these statements is correct about the following query? SELECT DNOMBRE 'DEPARTAMENTOS', DEPT_NO 'NUMERO DEPARTAMENTO' FROM DEPART; Column aliases are specified with double quotes. Aliases in columns are not allowed. Column aliases are specified in front of the column name. It is correct to allow aliases in columns.
When does a SELECT statement alter the content of a table? Only when it affects all the records. Only when calculations are involved (e.g. SUM, AVG). Always. Never, a SELECT statement does not alter the content of a table.
If using string comparison operators, I want to obtain any string whose second character is an A, I would use: _A' '_A%' '_ _ A%' '%A%'.
In the SELECT syntax, the ALL clause: Retrieves all rows even if they are repeated. Retrieves all columns of the specified table. Retrieves all columns even if they are repeated. Retrieves all rows that are not repeated.
I want to obtain the following format for the salary column: 12.012,12€ which of the following functions should I use? TO_CHAR(salary, '99D999G99M') TO_CHAR(salary, '99G999D99N') TO_NUMBER(salary, '999G999D99L') TO_CHAR(salary, '99G999D99L').
What value does this function return : INSTR ('García Pérez, Francisco', 'a',3,2)? 6 2 10 17.
What keyword is used to sort the result? ASC ORDER ORDER BY SORT.
To obtain data from two tables, Comerciales and Anuncios, the query should be: SELECT * FROM COMERCIALES GROUP BY ANUNCIOS;. SELECT COMERCIALES FROM ANUNCIOS;. SELECT * FROM COMERCIALES, ANUNCIOS;. SELECT * FROM COMERCIALES, ANUNCIOS WHERE COMERCIALES.DNI = ANUNCIOS.DNI_COMERCIAL;.
We have the following query SELECT COUNT(*) FROM EMPLEADOS GROUP BY DEPARTAMENTOS; What result would we get? Total number of employees. Number of employees in each department. Total number of rows in the table. Number of columns in the EMPLEADOS table grouped by departments.
What would the following query return: SELECT NEXT_DAY('24/11/11', 'JUEVES') FROM DUAL;? 30/11/11 2/12/11 1/12/11 24/11/11.
The syntax of subqueries is as follows: SELECT listExpr FROM table WHERE expression OPERATOR (SELECT listExpr FROM table); What operators from the following can we use as OPERATOR? > OR = IN.
I want to fill the column Localidad with dots ("…") on the right, and with a total length of 30 characters, for this I would use: RPAD(Localidad, 30, '.'). LPAD(Localidad, 30, '.'). RPAD(Localidad, length(localidad)+12, '.'). RPAD(Localidad, length(localidad)+30, '.').
What is the GROUP BY clause used for? To specify the condition that a group of rows must meet. To classify selected fields in an ordered way. To organize records into groups and obtain a summary of those groups. To group the columns of a table.
Does the MAX function(expression) return the maximum value of the expression, including nulls? True or false? True False.
We have the following query: SELECT DEPT_NO FROM DEPART WHERE LOC=('MADRID', 'BARCELONA'); which of the following answers is true? '. It is correct. It is incorrect because the 'IN' operator must be used instead of ' It is incorrect because MADRID and BARCELONA must be written with double quotes. It is incorrect, a space must be left between LOC and the equal symbol.
What would the following query return: SELECT LAST_DAY('24/11/11') FROM DUAL;? 30/11/11 Wednesday Thursday 27/11/05.
If you examine the rows of the SELECT from table A and table B and get those rows that appear in both tables, eliminating duplicates, you are using: JOIN UNION INTERSECT MINUS.
|
