databases Online Quiz - 97
|Description: databases Online Quiz - 97|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Suppose in the declaration section of a PL/SQL block, you create but do not initialize a NUMBER variable. What will be the initial value of the variable when the block is executed?
A user executes a PL/SQL block containing complex data with several update and insert statements using multiple row subqueries and complex inline view. Under which of the following conditions will the database save the change after executing one or more PL/SQL blocks? (Choose two)
For an unconditional approach to a particular part of a complex PL/SQL block, which of the following control structures can be used?
You are declaring a variable of data type NUMBER in a PL/SQL block. During the execution of the PL/SQL block, a query returns seven rows, and the next FETCH statement is issued. If the variable was assigned a value by using %ROWCOUNT attribute, which of the following values will be stored in it?
Which of the following statements about an SQL statement are not correct? (Choose two)
Suppose you have to remove a table. There are several indexes associated with this table. Which among the following would remove all the indexes associated with the table?
Which of the following are not legal?
Which three of the following methods make PL/SQL tables easier to use? (Choose three)
For which of the following tasks would it be most appropriate to use a PL/SQL WHILE loop?
Examine the statement of correlated subquery in the following cursor declaration. DECLARE CURSOR c1 IS SELECT D1.deptno, D1.loc, E1.Totalemp FROM dept D1, (SELECT deptno, COUNT(*) Totalemp FROM emp GROUP BY deptno) E1 WHERE D1.deptno = E1.deptno AND E1.Totalemp > 6; Why does this statement result in an error?
In which section is a user-defined exception trapped?
Which of the following architecture is used to support the agent or the application tier?
What is the purpose of SET DBMSSERVER OUTPUT ON
SQL is a product of ?
How many normalization processes are available in RDBMS
How many constraints are available in SQL
Auto commit occurs on
Which component will never allocate memory from the larger pool
What is the main reason to create a reverse key index on a column
What is the best table to be cached?