Tag: databases

Questions Related to databases

How do you put a message in the browser's status bar?
technology databases

  1. window.status("put your message here")

  2. status("put your message here")

  3. window.status = "put your message here"

  4. statusbar = "put your message here"

Show answer
Correct Option: C

Which column is more skewed? Total no. of rows in the table are 1000
technology databases

  1. Deptno column has 5 distinct values, each having 200 rows

  2. Grade column has 2 distinct values having 1 and 999 rows

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

  4. All columns have same skewness

Show answer
Correct Option: B

What is the limit on the size of a PL/SQL block?

technology databases

  1. 32K

  2. 64K

  3. 100K

  4. None of the Above

Show answer
Correct Option: B

What is the maximum PL/SQL code size?

technology databases

  1. 32K

  2. 64K

  3. 100K

  4. No Limit

Show answer
Correct Option: C

Which of the following are the differences between SQL and PL/SQL?
technology databases

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

  2. 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).

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

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

Show answer
Correct Option: A,B,C,D

Can you call a stored function in the constraint of a table ?

technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which scenario below indicates HIGH cardinality column?
technology databases

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

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

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

  4. Distinct values have no corelation to cardinality

Show answer
Correct Option: C

Can you change the inserted value in one of the columns in AFTER insert trigger code?

technology databases

  1. Yes

  2. No

  3. Can't Say

  4. None of the above

Show answer
Correct Option: B

Why does a query in Oracle run faster when ROWID is used as a part of the where clause?
technology databases

  1. None of the below

  2. Both C & D

  3. ROWID is not a physical column.

  4. ROWID is the logical address of a row.

Show answer
Correct Option: B

Which of the below are constructs of a procedure, function or a package ?

technology databases

  1. variables and constants

  2. cursors

  3. exceptions

  4. All of the above

Show answer
Correct Option: D