sql True-False

Question 1

NoSQL was designed with security in mind, so developers or security teams don't need to worry about implementing a security layer.

Answer

true

Question 2

NoSQL databases never follow the relational model

Answer

true

Question 3

True or False? NoSQL prohibits structured query language (SQL).

Answer

true

Question 4

The 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

Answer

true

Question 5

The NOT NULL constraint enforces a column to not accept null values.

Answer

true

Question 6

You cannot order the results of a set operation.

Answer

true

Question 7

You can update only a single column at time in a table.

Answer

true

Question 8

You can update column in a table using ALTER TABLE command

Answer

true

Question 9

You can rename a table with the ALTER TABLE command.

Answer

true

Question 10

You can not order the results of a set operation

Answer

true

Question 11

You can not selectively delete rows a table.

Answer

true

Question 12

You can add to and drop columns from a table using the ALTER TABLE command.

Answer

true

Question 13

You can add and drop columns from a table using the ALTER COLUMN command.

Answer

true

Question 14

When inserting data into a table form another table, the table names and columns must be the same.

Answer

true

Question 15

Transaction control determines when data manipulation becomes permanent in a database.

Answer

true

Question 16

Transaction control determines when data manipulation becomes permanent in a database.

Answer

true

Question 17

The UNION and UNION ALL set operator have the opposite effect other.

Answer

true

Question 18

The TRUNCATE command removes all data permanently from a table.

Answer

true

Question 19

The TRANCATE command and the TRUNC function can be used interchangeably.

Answer

true

Question 20

The NUMBER data types is usually the best choice for a primary key.

Answer

true

Question 21

The VARCHAR data types is usually the best choice for a primary key.

Answer

true

Question 22

The data of a temporary table is visible to all session.

Answer

true

Question 23

Privileges, roles, and synonyms are all used to implement security in a database.

Answer

true

Question 24

It is possible to combine from two tables that do not have a primary key/foreign key relationship into one result using a set operation.

Answer

true

Question 25

Constraints always have a name.

Answer

true

Question 26

A table can be created with or without data

Answer

true

Question 27

Any user can grant or revoke ant type of system privileges to or from another user.

Answer

true

Question 28

Constraints always have a name.

Answer

true

Question 29

GROUP BY is often used with aggregate functions

Answer

true

Question 30

COUNT, SUM, AVG, MAX, MIN are aggregate functions

Answer

true

Question 31

COUNT, SUM, TRIM, CONCAT are aggregate functions

Answer

true

Question 32

WHERE keyword could not be used with aggregate functions

Answer

true

Question 33

The 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

Answer

true

Question 34

The NOT NULL constraint enforces a column to not accept null values.

Answer

true

Question 35

A table can be created with or without data

Answer

true

sql True-False

Erstelle ein kostenloses Konto, um dieses Quiz zu beenden

Fragen in diesem Quiz (35)

Informationen

Feedback

Wie gefällt dir das neue Design?