Tag: technology

True

False

Late in the mapping

Early in the mapping

Before Router Transformation

Before Aggregator Transformation

True

False

A single row subquery can retrieve data from only one table.

A SQL query statement cannot display data from table B that is referred to in its subquery,unless table B is included in the main query's FROM clause.

A SQL query statement can display data from table B that is referred to in its subquery, without including table B in its own FROM clause

A single row subquery can retrieve data from more than one table.

You can join a maximum of two tables through an equijoin.

You can join a maximum of two columns through an equijoin.

You can join n tables (all having single column primary keys) in a SQL statement by specifying a minimum of n-1 join conditions.

To join two tables through an equijoin, the columns in the join condition must be primary key and foreign key columns.

You specify an equijoin condition in the SELECT or FROM clauses of a SELECT statement.

By default it is accessible to all users.

By default they are created in the public schema.

By default tables are created in your schema.

By default they are created in the DBA schema.

You must specify the schema when the table is created.

DELETE, INSERT,SELECT

DELETE, INSERT, SELECT, UPDATE

ALTER, DELETE, INSERT, SELECT

NONE

You have too many tables.

You have too many columns in your tables.

You want to work on your own tables.

You want to use another schema's tables.

Your tables have difficult names.

Your tables are too long.

You want all unmatched data from both tables.

One of the tables has more data than the other.

You want all matched data from both tables.

You want all matched and unmatched data from only one table.

Primary Key

Check

Not Null

Unique