Analyze the data in the following PRODUCTS table. 

Which from the following statements would add a column called PRICE, knowing that it cannot contain NULL?

Which from the following statements is true regarding the Oracle SQL, DELETE and TRUNCATE statements?

Analyze the structure of the following ORDERS table. 

The default values for the columns ORDER_MODE and ORDER_TOTAL are ‘direct’ and 0, respectively. 

Which from the following are valid INSERT statements? (Select two.)

Which from the following statements are true? (Select two.)

At comparing the relational database (RDB) and object-oriented database (OODB) models, what is the main difference?

Evaluate the following command that was used to create this BOOKS table. 

Knowing that value 101 of the BOOK_ID does not exist in the table, evaluate this SQL statement: 

Which from the following statements is true?

You must list employees in DEPARTMENT_ID 20 days in a single row, sorted by HIRE_DATE. Analyze the output in the Example: 

Which from the following queries will produce the required output?

Analyze the structure of the DEPARTMENTS table below. 

You issued the command:

 Which from the following statements are true? (Select two.)