Quiz
sql True-False
Create a free account to finish this quiz
Save your progress and see your final score.
Already have an account? Sign in
Questions in this quiz (35)
1NoSQL was designed with security in mind, so developers or security teams don't need to worry about implementing a security layer.
- ATrue
- BFalse
2NoSQL databases never follow the relational model
- ATrue
- BFalse
3True or False? NoSQL prohibits structured query language (SQL).
- ATrue
- BFalse
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
- ATrue
- BFalse
5The NOT NULL constraint enforces a column to not accept null values.
- ATrue
- BFalse
6You cannot order the results of a set operation.
- ATrue
- BFalse
7You can update only a single column at time in a table.
- ATrue
- BFalse
8You can update column in a table using ALTER TABLE command
- ATrue
- BFalse
9You can rename a table with the ALTER TABLE command.
- ATrue
- BFalse
10You can not order the results of a set operation
- ATrue
- BFalse
11You can not selectively delete rows a table.
- ATrue
- BFalse
12You can add to and drop columns from a table using the ALTER TABLE command.
- ATrue
- BFalse
13You can add and drop columns from a table using the ALTER COLUMN command.
- ATrue
- BFalse
14When inserting data into a table form another table, the table names and columns must be the same.
- ATrue
- BFalse
15Transaction control determines when data manipulation becomes permanent in a database.
- ATrue
- BFalse
16Transaction control determines when data manipulation becomes permanent in a database.
- ATrue
- BFalse
17The UNION and UNION ALL set operator have the opposite effect other.
- ATrue
- BFalse
18The TRUNCATE command removes all data permanently from a table.
- ATrue
- BFalse
19The TRANCATE command and the TRUNC function can be used interchangeably.
- ATrue
- BFalse
20The NUMBER data types is usually the best choice for a primary key.
- ATrue
- BFalse
21The VARCHAR data types is usually the best choice for a primary key.
- ATrue
- BFalse
22The data of a temporary table is visible to all session.
- ATrue
- BFalse
23Privileges, roles, and synonyms are all used to implement security in a database.
- ATrue
- BFalse
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.
- ATrue
- BFalse
25Constraints always have a name.
- ATrue
- BFalse
26A table can be created with or without data
- ATrue
- BFalse
27Any user can grant or revoke ant type of system privileges to or from another user.
- ATrue
- BFalse
28Constraints always have a name.
- ATrue
- BFalse
29GROUP BY is often used with aggregate functions
- ATrue
- BFalse
30COUNT, SUM, AVG, MAX, MIN are aggregate functions
- ATrue
- BFalse
31COUNT, SUM, TRIM, CONCAT are aggregate functions
- ATrue
- BFalse
32WHERE keyword could not be used with aggregate functions
- ATrue
- BFalse
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
- ATrue
- BFalse
34The NOT NULL constraint enforces a column to not accept null values.
- ATrue
- BFalse
35A table can be created with or without data
- ATrue
- BFalse
Information
- Description
- Quiz on sql True-False, created by Khamit Zhussip on 22/12/2019.
- Author
- Khamit Zhussip
- Language
- English
- Views
- 13
- History
- Created on 22 Dec 2019 · updated on 22 Dec 2019
- Rating
- No ratings yet Rate this quiz