we are joining more than 2 tables

we are joining table to itself

we are using left and right join together

none of the above

>=

Neither of the other two.

=>

!>=

The HAVING keyword specifies a search condition for an aggregate or a group

The HAVING keyword is used to select distinct values

The HAVING keyword is used to join 2 or more tables.

None of the above

The JOIN SQL clause.

List of columns that will be selected or the * symbol.

The name of the table we are selecting from.

None of the above

An index is the same as alias.

An index is a special way to join 2 or more tables.

An index is a database table attribute, which speeds-up data search within a table.

None of the above

A view is a special stored procedure executed when certain event occurs.

A view is a database diagram.

A view is a virtual table which results of executing a pre-compiled query. A view is not part of the physical database schema, while the regular tables are

None of the above

UPDATE Persons SET LastName='Hansen' WHERE LastName='Nilsen'

MODIFY Persons SET LastName='Hansen' WHERE LastName='Nilsen'

UPDATE Persons SET LastName='Nilsen' WHERE LastName='Hansen'

MODIFY Persons SET LastName='Nilsen' WHERE LastName='Hansen'

SELECT * FROM Persons WHERE FirstName='%a%'

SELECT * FROM Persons WHERE FirstName='a'

SELECT * FROM Persons WHERE FirstName LIKE '%a'

SELECT * FROM Persons WHERE FirstName LIKE 'a%'

SELECT * FROM Persons WHERE FirstName='Peter',LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson'

SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons SORT BY 'FirstName' DESC

SELECT * FROM Persons SORT 'FirstName' DESC

SELECT * FROM Persons ORDER FirstName DESC

SELECT DIFFERENT

SELECT DISTINCT

SELECT COUNT

SELECT UNIQUE

you save and close the file

you save excel in XML format

you create an excel template

you save it in Excel 2007 version

An entire column gets selected in MS Excel

The entire worksheet gets selected in MS Excel

An entire row gets selected in MS Excel

Nothing happens

Column

123_Invoices

Catch_#22

#Invoices

None of the above

2%

20%

25%

200%

Shift + F1

Ctrl + 1

F11 or ALT+F1

Ctrl + Shift + F1

The cell gets formatted to Number category with 2 decimal places

The cell gets formatted to Number category with 4 decimal places

The cell gets formatted into different font

Nothing happens

True

False

4

3

N - 1

N + 1

System tablespace

Users tablespace

Default tablespace for the user

Oracle will give an error