Tag: technology

JOIN

LEN

LEFT

AVG

update database table.

verify that the inserted data is correct.

select data from 2 or more tables related by common attribute (table column).

delete data from database table.

SELECT * FROM Contest HAVING ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate >= '05/25/2006'

SELECT * FROM Contest WHERE ContestDate < '05/25/2006'

SELECT * FROM Contest IN ContestDate < '05/25/2006'

A static method may override another static method

A static method cannot override a non-static method

A non-static method cannot override a static method

A non-static method may be overloaded by a static method

A synchronized method cannot be overridden

You can if you use nested SQL statements

You can use UPDATE and SELECT clauses together, even if you don’t have nested SQL statements.

You can if you use WITH clause.

You can't

The try-catch block that encloses myref.test(); is mandatory for the code to compile

Prints: In TechnoSample

Prints: In TechnoSampleSub

Method test() in class TechnoSampleSub has no obligation to declare a throws clause

An exception is thrown at runtime

The FROM SQL keyword specifies a column list

The FROM SQL keyword specifies a search condition.

The FROM SQL keyword specifies the tables, views, and joined tables used in SELECT, UPDATE and DELETE SQL statements.

The FROM SQL keyword specifies a find condition.

a single table in the database

to all tables in the database

to all the tables of the user

more than one table in the database

ORDER BY clause.

GROUP BY clause.

JOIN clause.

WHERE clause.

join

len

left

avg