Font size
WorksheetsPOST-TEST MODUL 1 APSI
Total questions: 15
Worksheet time: 5mins
… 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)
ROLLBACK is command to modify, add and delete column from table and also can be used to modify the database.
TRUE
FALSE
… is determine a field that is an important key and cannot be empty.
(a)
... is a language that allows database administrators (DBA) or users to describe and give names of entities, attributes and relationships that the application needs along with associated integrity and security restrictions.
DDL (Data Definition Language)
DDL (Definition Data Language)
DML (Data Manipulation Language)
TCL (Transaction Control Language)
… is returns all rows from both the participating tables which satisfy the join condition along with rows which do not satisfy the join condition.
Inner Join
Outer Join
Joining more than two tables
Full Join
Module 1 discusses about Query, DDL, DML, and Join.
TRUE
FALSE
