POST-TEST MODUL 1 APSI

… is commands to delete database object.

• DROP

• DELETE

• CREATE

• UPDATE

There are several types of outer join..

• Left, right, full

• Left, right, half

• Full, right, half

• Left, half, right

JOIN is used to combine rows from two or more tables, based on related column between them.

• FALSE

• TRUE

The following are statements in DML, except...

• INSERT

• UPDATE

• DROP

• SELECT

… is an SQL statement that serves to manipulate data in database.

(a)  

What’s the meaning of commit?

• Commit is command that used to save changes on the workspace that is being operated, because at first the changes are still stored on the workspace temporary.

• Commit is a command that used to undo changes made after the last commit command.

SELECT * FROM table_name. 1 FULL JOIN table_name.2 ON column_name.1 = column_name.2

The syntax above is an example of a syntax…

• Half join

• Right Join

• Left Join

• Full Join

… Is command used to make or to create new database object or the database themselves.

(a)  

DDL stands for?

(a)  

…is used to display the content of the table.

(a)