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

Work as primary key

Uniquely identify the records

show a relation between the primary key and unique key

All of the above

None of these

DML Trigger

Instead of Trigger

DDL Trigger

Nested Trigger

Change the primary key index to clustered and create a nonclustered index on the address

Create a nonclustered index on the address.

Create a clustered index on the address.

Change the primary key to the address and make the index clustered.

DOWN

LOW

MIN

LOWER

ON

OFF

NULL

None of the options

BRUTILITY

SAPTOOLS

BRTOOLS

SAPUTILITY

GRQ

GRQUALITY

GRQ12

ALL THE ABOVE

Insert Work Process

Batch Work Process

Dialog Work Process

Update Work Process

/oracle//saptrace

/oracle//dbs

/oracle//sapdata

/oracle//trace

May Cause Oracle Database components to function improperly

May Cause some Management Components of SAP to function improperly

May Cause both Oracle components and SAP components to function improperly

No need to follow any SAP standard

True

False

The AS SQL clause is used change the name of a column in the result set or to assign a name to a derived column.

The AS clause is used with the JOIN clause only.

The AS clause defines a search condition.

The AS clause defines a group