InfyTQ Transactions Quiz 3

Question 1

Time: 00:00:00

The unit of storage that can store one are more records in a hash file organization are

Buckets

Disk pages

Blocks

Nodes

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 2

Time: 00:00:00

Which of the following are the process of selecting the data storage and data access characteristics of the database?

Logical database design

Physical database design

Testing and performance tuning

Evaluation and selecting

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 3

Time: 00:00:00

The process of saving the information onto secondary storage devices is referred to as

Backing up

Restoring

Writing

Reading

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 4

Time: 00:00:00

Which character function can be used to return a specified portion of a character string?

INSTR

SUBSTRING

SUBSTR

POS

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 5

Time: 00:00:00

Which of the following is TRUE for the System Variable $date$?

Can be assigned to a global variable

Can be assigned to any field only during design time

Can be assigned to any variable or field during run time

Can be assigned to a local variable

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 6

Time: 00:00:00

The SQL statement SELECT SUBSTR(‘123456789’, INSTR(‘abcabcabc’,’b’), 4) FROM EMP; prints

6789

2345

1234

456789

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 7

Time: 00:00:00

In order to undo the work of the transaction after the last commit which one should be used?

View

Commit

Rollback

flash

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 8

Time: 00:00:00

______ will undo all statements up to commit?

Transaction

Flashback

Rollback

Abort

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 9

Time: 00:00:00

Consider the following transactions with data items P and Q initialized to zero:

T1: read (P) ;
read (Q) ;
if P = 0 then Q : = Q + 1 ;
write (Q) ;
T2: read (Q) ;
read (P) ;
if Q = 0 then P : = P + 1 ;
write (P) ;

A serializable schedule

A schedule that does not conflict with serializable

A conflict serializable schedule

A schedule for which a precedence graph cannot be drawn

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

Question 10

Time: 00:00:00

CREATE TABLE digits
(id NUMBER(2),
description VARCHAR2(15));
INSERT INTO digits VALUES (1,'ONE');
UPDATE digits SET description ='TWO' WHERE id=1;
INSERT INTO digits VALUES (2,'TWO');

COMMIT;
DELETE FROM digits;
SELECT description FROM digits
VERSIONS BETWEEN TIMESTAMP MINVALUE AND MAXVALUE;
What would be the outcome of the above query?

It would not display any values

It would display the value TWO once

It would display the value TWO twice

It would display the values ONE, TWO, and TWO

Good Job!

Oops!