Deptno column has 5 distinct values, each having 200 rows

Grade column has 2 distinct values having 1 and 999 rows

Location column has 3 distinct values having 300, 400 and 300 rows

All columns have same skewness

32K

64K

100K

None of the Above

32K

64K

100K

No Limit

SQL is executed one statement at a time. PL/SQL is executed as a block of code.

SQL tells the database what to do (declarative), not how to do it. In contrast, PL/SQL tell the database how to do things (procedural).

SQL is used to code queries, DML and DDL statements. PL/SQL is used to code program blocks, triggers, functions, procedures and packages.

You can embed SQL in a PL/SQL program, but you cannot embed PL/SQL within a SQL statement.

True

False

Scenario 1 : Distinct values for TableA.ColumnA = 10 Total no. of rows for TableA = 100

Scenario 2 : Distinct values for TableA.ColumnB = 20 Total no. of rows for TableA = 100

Scenario 3 : Distinct values for TableA.ColumnC = 30 Total no. of rows for TableA = 100

Distinct values have no corelation to cardinality

Yes

No

Can't Say

None of the above

None of the below

Both C & D

ROWID is not a physical column.

ROWID is the logical address of a row.

variables and constants

cursors

exceptions

All of the above

One

Two

Three

Four

24

8

16

32

/

#

@

\

Error

Last Record

First Record

Can't Say

System Variable

System Function

Both A & B

None of the Above

Use FULL hint to optimizer for full table scan

Use INDEX or AND-EQUAL hint to optimizer to use one index or set to indexes instead of another.

Use an expression in the Where Clause of the SQL.

Disable Index on the column

True

False

True

False

No

Yes

Can't Say

None of the above

Record type declaration.

Opening and parsing of SQL statements.

Fetches records from cursor.

Requires exit condition to be defined.

SQL Server uses a random port

1433

1433 and 1434

It depends; the port can be chosen by an administrator