GK One-Line Question & Answer

The space factor when determining the efficiency of an algorithm is measured by

The iterator maintains the                      of its execution in between calls so that successive next() requests receive successive result tuples.

The relation EMPDT1 is defined with attributes empcode(unique), name, street, city, state, and pincode. For any pincode, there is only one city and state. Also, for any given street, city and state, there is just one pincode. In normalization terms EMPDT1 is a relation in

Which of the following case does not exist in complexity theory

Tuples are generated                        in producer-driven pipelining, they are generated                  on demand, in demand- driven pipelining.

                               is a procedural extension of Oracle – SQL that offers language constructs similar to those in imperative programming languages.

The Average case occur in linear search algorithm

When two inputs that we desire to pipeline into the join are not already sorted it is the                            technique.

                       combines the data manipulating power of SQL with the data processing power of Procedural languages.

The complexity of the average case of an algorithm is

Which of the following is/are false for RAW mode of FOR XML?

                               has made PL/SQL code run faster without requiring any additional work on the part of the programmer.

The complexity of a linear search algorithm is

                       refers to the ability of the system to recover committed transaction updates if either the system or the storage media fails.

The complexity of Bubble sort algorithm is

You have a column that will only contain values from 0 to 256. What is the most economical data type to use for the column?

A           is a query that retrieves rows from more than one table or view:

Problems occurs if we don’t implement a proper locking strategy

A condition is referred to as                      

Which of the following fixed database roles can add or remove user IDs?

Which oracle is the join condition is specified using the WHERE clause:

Which of the following pair of regular

Which join refers to join records from the write table that have no matching key in the left table are include in the result set:

Which feature converts row data to a column for better analytical view?

Which operation are allowed in a join view:

What is the default “SORT” order for a SQL?

Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

How inserting data through stored procedure do reduces network traffic and increase database performance?

The results of each intermediate operation are created and then are used for evaluation of the next-level operations. This is called

Stored procedures are safe from SQL injection attacks

                             allows the algorithm to execute more quickly by performing CPU activity in parallel with I/O activity.

Which of the following connection type supports application role permissions and password encryption?

Pipelines can be executed in

Cursor that reflects the changes made to the database table even after the result set is returned

In a                    the system makes repeated requests for tuples from the operation at the top of the pipeline.

Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is

In a                            operations do not wait for requests to produce tuples, but instead generate the tuples eagerly.

Which one of the following statements about normal forms is FALSE?

Each operation in a demand-driven pipeline can be implemented as an          that provides the following functions: open(), next(), and close().

Which of the following is TRUE?