Analyze the following SQL statement which has been used to create the TRANSACTION table. 

> CREATE TABLE transaction (trn_id char(2) primary key, Start_date date DEFAULT SYSDATE, End_date date NOT NULL); 

In this table does not exist the value 'A1' for trn_id. 

Which from the following SQL statements would successfully insert a row into the table with the default value for START_DATE?

Which from the following SQL statements will display the value 1890.55 as $1,890.55? (Select three.)

You have to issue a query which asks users for column names and conditions every time it is executed. 

The user should be asked only once for the table name. Which from the following statements will satisfy those objectives?

Which from the following statements are true about the WHERE and HAVING clauses in a SELECT statement? (Select two.)

You have to create a table EMPLOYEES in which the columns EMPLOYEES_ID and LOGIN_ID contain only unique and not null values. Which from the following SQL statements will create a table which satisfy that requirement? (Select two.)

Analyze the following types and examples of relationship: 1 One-to-one 

a) teacher to Student 2 One-to-many 

b) Employees to Manager 3 Many-to-one 

c) Person to SSN 4 Many-to-many 

d) Customers to Products 

Which of the following options indicates relationships which have been correctly matched?

Which from the following statements are true about subqueries? (Select three.)

Which from the following statements are true about multiple-row subqueries? (Select two.)