<class 'tuple'>

<class 'function'>

<class 'NoneType'>

class 'type'>

<class 'bool'>

C

c

i

a

An exception is thrown

6

1

2

10

An exception is thrown

1

2

An exception is thrown

Any number

Two;

One;

SELECT teacher.name, dept.name FROM teacher OUTER JOIN dept ON dept.id

SELECT teacher.name, dept.name FROM teacher JOIN dept ON (dept = id)

SELECT teacher.name, dept.name FROM teacher

LEFT OUTER JOIN dept ON (teacher.dept = dept.id)

SELECT teacher.name, dept.name FROM teacher, dept JOIN WHERE(teacher.dept = dept.id)

SELECT teacher.name, dept.name FROM teacher, dept INNER JOIN ON (teacher.dept = dept.id)

4

3

0

1

7

Query will fail;

It is usually slower than DELETE command

It is usually faster than DELETE command

There is no comparison between DELETE &

TRUNCATE

None of these

Truncate command can be rolled back