Key and constrain

1.Which of the following relational algebra operations do not require the participating tables to be union-compatible?

THE NUMBER datatype is used to store

• Negative Integer

• Positive Integer

• Floating point

• Fixed decimal

type of tables

• Permanent Table

• Trmporary Table

• Index Organized Table

• Internal Table

The SQL keyword BETWEEN is used:

• For ranges

• To limit the columns displayed.

• As a wildcard

• None of these

The SQL statement that queries or reads data from a table is ________ .

• SELECT

• READ

• QUERY

• None of these

Which Constraints ensures that the coloumn has a value is not a null value ?

• NOT NULL

• UNIQUE

 

The SQL keyword(s) ________ is used with wildcards.

• LIKE only

• IN only

• NOT IN only

• IN and NOT IN

Which of the following do you need to consider when you make a table in SQL?

• Data Types

• Primary Key

• Default Values

• All of these

Which of the following is the correct order of a SQL statement?

• SELECT, GROUP BY, WHERE, HAVING

• SELECT, WHERE, GROUP BY, HAVING

• SELECT, HAVING, WHERE, GROUP BY

• SELECT, WHERE, HAVING, GROUP BY

Which tables are used for tables with primarykey values that are looked up frequently ?

• Temporary table

• Index Organized table

• External Table

• Internal Tble