How do you put a message in the browser's status bar?
window.status("put your message here")
status("put your message here")
window.status = "put your message here"
statusbar = "put your message here"
Which column is more skewed? Total no. of rows in the table are 1000
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
What is the limit on the size of a PL/SQL block?
32K
64K
100K
None of the Above
What is the maximum PL/SQL code size?
No Limit
Which of the following are the differences between SQL and PL/SQL?
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.
Can you call a stored function in the constraint of a table ?
True
False
Which scenario below indicates HIGH cardinality column?
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
Can you change the inserted value in one of the columns in AFTER insert trigger code?
Yes
No
Can't Say
None of the above
Why does a query in Oracle run faster when ROWID is used as a part of the where clause?
None of the below
Both C & D
ROWID is not a physical column.
ROWID is the logical address of a row.
Which of the below are constructs of a procedure, function or a package ?
variables and constants
cursors
exceptions
All of the above