Test
sql True-False
Crea una cuenta gratis para terminar este test
Guarda tu progreso y consulta tu resultado final.
¿Ya tienes cuenta? Inicia sesión
Preguntas del test (35)
1NoSQL was designed with security in mind, so developers or security teams don't need to worry about implementing a security layer.
- AVerdadero
- BFalso
2NoSQL databases never follow the relational model
- AVerdadero
- BFalso
3True or False? NoSQL prohibits structured query language (SQL).
- AVerdadero
- BFalso
4The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
- AVerdadero
- BFalso
5The NOT NULL constraint enforces a column to not accept null values.
- AVerdadero
- BFalso
6You cannot order the results of a set operation.
- AVerdadero
- BFalso
7You can update only a single column at time in a table.
- AVerdadero
- BFalso
8You can update column in a table using ALTER TABLE command
- AVerdadero
- BFalso
9You can rename a table with the ALTER TABLE command.
- AVerdadero
- BFalso
10You can not order the results of a set operation
- AVerdadero
- BFalso
11You can not selectively delete rows a table.
- AVerdadero
- BFalso
12You can add to and drop columns from a table using the ALTER TABLE command.
- AVerdadero
- BFalso
13You can add and drop columns from a table using the ALTER COLUMN command.
- AVerdadero
- BFalso
14When inserting data into a table form another table, the table names and columns must be the same.
- AVerdadero
- BFalso
15Transaction control determines when data manipulation becomes permanent in a database.
- AVerdadero
- BFalso
16Transaction control determines when data manipulation becomes permanent in a database.
- AVerdadero
- BFalso
17The UNION and UNION ALL set operator have the opposite effect other.
- AVerdadero
- BFalso
18The TRUNCATE command removes all data permanently from a table.
- AVerdadero
- BFalso
19The TRANCATE command and the TRUNC function can be used interchangeably.
- AVerdadero
- BFalso
20The NUMBER data types is usually the best choice for a primary key.
- AVerdadero
- BFalso
21The VARCHAR data types is usually the best choice for a primary key.
- AVerdadero
- BFalso
22The data of a temporary table is visible to all session.
- AVerdadero
- BFalso
23Privileges, roles, and synonyms are all used to implement security in a database.
- AVerdadero
- BFalso
24It is possible to combine from two tables that do not have a primary key/foreign key relationship into one result using a set operation.
- AVerdadero
- BFalso
25Constraints always have a name.
- AVerdadero
- BFalso
26A table can be created with or without data
- AVerdadero
- BFalso
27Any user can grant or revoke ant type of system privileges to or from another user.
- AVerdadero
- BFalso
28Constraints always have a name.
- AVerdadero
- BFalso
29GROUP BY is often used with aggregate functions
- AVerdadero
- BFalso
30COUNT, SUM, AVG, MAX, MIN are aggregate functions
- AVerdadero
- BFalso
31COUNT, SUM, TRIM, CONCAT are aggregate functions
- AVerdadero
- BFalso
32WHERE keyword could not be used with aggregate functions
- AVerdadero
- BFalso
33The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true
- AVerdadero
- BFalso
34The NOT NULL constraint enforces a column to not accept null values.
- AVerdadero
- BFalso
35A table can be created with or without data
- AVerdadero
- BFalso
Información
- Descripción
- Test sobre sql True-False, creado por Khamit Zhussip el 22/12/2019.
- Autor
- Khamit Zhussip
- Idioma
- English
- Visitas
- 13
- Historial
- Creado el 22 dic 2019 · actualizado el 22 dic 2019
- Valoración
- Aún sin valoraciones Valora este test