GK One-Line Question & Answer

Pipelines can be executed in

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

Which of the following has “all-or-none” property?

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

The property of a transaction that persists all the crashes 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?

                     states that only valid data will be written to the database.

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?

Transaction processing is associated with everything below except

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

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.

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.

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.

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

A line of PL/SQL text contains groups of characters known as

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?

We use                              name PL/SQL program objects and units.

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

A                                        is an explicit numeric, character, string or Boolean value not represented by an identifier.

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

If no header is specified, the block is said to be an                                PL/SQL block.

Which of the following pair of regular

                                   is a sequence of zero or more characters enclosed by single quotes.

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

In                                the management of the password for the account can be handled outside of oracle such as operating system.

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

In                                  of Oracle, the database administrator creates a user account in the database for each user who needs access.

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

Consider money is transferred from (1)account-A to account-B and (2) account-B to account-A. Which of the following form a transaction?

Stored procedures are safe from SQL injection attacks

A transaction is delimited by statements (or function calls) of the form                      

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

Identify the characteristics of transactions