Tag: databases

window.status("put your message here")

status("put your message here")

window.status = "put your message here"

statusbar = "put your message here"

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