Tag: databases

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

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

we are using left and right join together

we are joining more than 2 tables

we are joining table to itself

when joining a table and its view

The DELETE clause deletes all rows in a database table, while the TRUNCATE clause can have a WHERE condition and might or might not delete all rows in a table.

The TRUNCATE clause is identical to the DELETE clause

The TRUNCATE clause deletes all rows in a database table, while the DELETE clause can have a WHERE condition and might or might not delete all rows in a table.

None fo the above

Creates a database view

Creates a new database table

Creates a stored procedure

Creates a trigger

A trigger is part of data extraction process.

A trigger is a special kind of stored procedures executed when certain event occurs.

A trigger defines relations between tables.

A trigger is a part of error handling

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

The JOIN SQL clause.

The name of the table we are selecting from.

Selects a database

Having Clause

Where clause

Distinct

Exists