ICT6_FT_W1_SW1

What is the correct syntax if you want to rename the table?

• ALTER TABLE table_name

  RENAME TO new_table_name;

• ALTER TABLE table_name,

  RENAME TO new_table_name;

• ALTER TABLE table_name

  RENAME TABLE old_table_name to new_name;

• ALTER TABLE table_name

  RENAME new_table_name;

Which from the following is the correct syntax to add a column on a table?

• ADD COLUMN  age NUMBER(3);

• ALTER TABLE tbl_customer,

  ADD age NUMBER(3);

• ALTER TABLE tbl_customer

  ADD age NUMBER(3);

• ALTER TABLE tbl_customer

  ADD age;

Which statement is used to make changes on a table in Oracle Database?

• SELECT statement

• UPDATE statement

• ALTER TABLE statement

• INSERT statement

Which from the following is the correct SQL to delete a table?

• DELETE table_name;

• TRUNCATE table_name;

• ERASE table_name;

• DROP table_name;

Which from the following is the correct SQL to delete a column on a table?

• DROP column_name;

• ALTER TABLE table_name

  DROP COLUMN column_name;

• ALTER TABLE table_name

  DELETE COLUMN column_name;

• TRUNCATE column_name;

Which from the following is the correct SQL to rename a column on a table?

• RENAME column_name;

• ALTER TABLE table_name

  CHANGE NAME column_name;

• ALTER TABLE table_name

  RENAME COLUMN new_name;

• ALTER TABLE table_name

  RENAME COLUMN old_name TO new_name;

Which from the following the is the correct SQL keyword if you want to make changes in your column definition?

• ADD

• CHANGE

• RENAME

• MODIFY

Which from the following is the correct SQL to change the column definition? Column age NUMBER(3) to age VARCHAR2(10)

• ALTER TABLE customer

  MODIFY age VARCHAR2(10);

• ALTER TABLE customer

  CHANGE age VARCHAR2(10);

• CHANGE age to age VARCHAR2(10);

• ALTER TABLE customer

  MODIFY age to age VARCHAR2(10);

Which from the following is the correct SQL to display all the information in your table?

• SELECT * FROM table_name;

• SELECT all FROM table_name;

• SELECT ALTER FROM table_name;

• SELECT all_column FROM table_name;

Which from the following the correct SQL if you want to save the changes made in your table?

• SAVE table_name;

• ALTER TABLE table_name SAVE;

• COMMIT table_name;

• COMMIT;