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

Buckets

Disk pages

Disk pages

Blocks

Blocks

Nodes

Nodes

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

Logical database design

Physical database design

Physical database design

Testing and performance tuning

Testing and performance tuning

Evaluation and selecting

Evaluation and selecting

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

Backing up

Restoring

Restoring

Writing

Writing

Reading

Reading

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

INSTR

SUBSTRING

SUBSTRING

SUBSTR

SUBSTR

POS

POS

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 a global variable

Can be assigned to any field only during design time

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 any variable or field during run time

Can be assigned to a local variable

Can be assigned to a local variable

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

6789

2345

2345

1234

1234

456789

456789

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

View

Commit

Commit

Rollback

Rollback

flash

flash

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

Transaction

Flashback

Flashback

Rollback

Rollback

Abort

Abort

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 serializable schedule

A schedule that does not conflict with serializable

A schedule that does not conflict with serializable

A conflict serializable schedule

A conflict serializable schedule

A schedule for which a precedence graph cannot be drawn

A schedule for which a precedence graph cannot be drawn

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 not display any values

It would display the value TWO once

It would display the value TWO once

It would display the value TWO twice

It would display the value TWO twice

It would display the values ONE, TWO, and TWO

It would display the values ONE, TWO, and TWO

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

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Completed

0/0

Accuracy

0%