Home > Computer Science> Oracle, SQL & PL/SQL

1 . What type of join is needed when you wish to include rows that do not have matching values?
A. Equi-join
B. Natural join
C. Outer join
D. All of the above.

2 . What is the full form of SQL?
A. Simple Query Language
B. Structured Query Language
C. Structured Query List
D. None of these

3 . What type of join is needed when you wish to return rows that do have matching values?
A. Equi-join
B. Natural join
C. Outer join
D. All of the above.

4 . Which is the subset of SQL commands used to manipulate Oracle Database structures, including tables?
A. Data Definition Language(DDL)
B. Data Manipulation Language(DML)
C. Both of above
D. None

5 . Which of the following is true concerning a procedure?
A. You do not create them with SQL.
B. They do not need to have a unique name.
C. They include procedural and SQL statements.
D. They are the same thing as a function.




Loading...

TET

Education