InfyTQ Transactions Quiz 1

Question 1

Time: 00:00:00
A transaction is delimited by statements (or function calls) of the form __________

Begin transaction and end transaction

Begin transaction and end transaction

Start transaction and stop the transaction

Start transaction and stop the transaction

Get transaction and post-transaction

Get transaction and post-transaction

Read transaction and write transaction

Read transaction and write transaction

Good Job!

Oops!

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

Please login to submit your explanation

Question 2

Time: 00:00:00
Identify the characteristics of transactions

Atomicity

Atomicity

Durability

Durability

Isolation

Isolation

All of the mentioned

All of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Question 3

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

Atomicity

Atomicity

Durability

Durability

Isolation

Isolation

All of the mentioned

All of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Question 4

Time: 00:00:00
Transaction processing is associated with everything below except

Producing detail summary or exception reports

Producing detail summary or exception reports

Recording a business activity

Recording a business activity

Confirming an action or triggering a response

Confirming an action or triggering a response

Maintaining a data

Maintaining a data

Good Job!

Oops!

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

Please login to submit your explanation

Question 5

Time: 00:00:00
The SQL uses the ____ statement to declare the save work permanent to database.

BEGIN

BEGIN

SET TRANSACTION

SET TRANSACTION

BEGIN TRANSACTION

BEGIN TRANSACTION

COMMIT

COMMIT

Good Job!

Oops!

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

Please login to submit your explanation

Question 6

Time: 00:00:00
__________ states that only valid data will be written to the database.

Consistency

Consistency

Atomicity

Atomicity

Durability

Durability

Isolation

Isolation

Good Job!

Oops!

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

Please login to submit your explanation

Question 7

Time: 00:00:00
In SQL, the CREATE TABLESPACE is used

To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

To create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

To create a database trigger

To create a database trigger

To add/rename data files, to change storage

To add/rename data files, to change storage

All of the mentioned

All of the mentioned

Good Job!

Oops!

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

Please login to submit your explanation

Question 8

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

Good Job!

Oops!

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

Please login to submit your explanation

Question 9

Time: 00:00:00
When SQL statements are embedded inside 3GL, we call such a program as

Nested query

Nested query

Nested programming

Nested programming

Distinct query

Distinct query

Embedded SQL

Embedded SQL

Good Job!

Oops!

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

Please login to submit your explanation

Question 10

Time: 00:00:00
_______________ provides option for entering SQL queries as execution time, rather than at the development stage.

PL/SQL

PL/SQL

SQL*Plus

SQL*Plus

SQL

SQL

Dynamic SQL

Dynamic SQL

Good Job!

Oops!

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

Please login to submit your explanation

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

Please login to report

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%

Start Preparing
Detailed performance

Get over 200+ Courses under One Subscription

Get Prime Course List
mute
Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime

Don’t settle Learn from the Best with PrepInsta Prime Subscription

manish-prepinsta

Manish Agarwal

Ex- Accenture

Trained 3.2L+ students

Rushikesh-prepinsta

Rushikesh Konapure

Data Science & Full Stack Mentor

Trained 35k+ students

atulya-prepinsta

Atulya Kaushik

Ex- Google & Instamojo

Trained 3.2L+ students

Aashay-prepinsta

Aashay Mishra

Ex- Sapient

Trained 83k+ students

Janvi-prepinsta

Janvi Jain

Lead Verbal Mentor

Trained 46k+ students

Learn from Top 1%
Get Prime
prepinsta
prepinsta
prepinsta
prepinsta

One Subscription, For Everything

The new cool way of learning and upskilling -

Limitless Learning

One Subscription access everything

Job Assistance

Get Access to PrepInsta Prime

Top Faculty

from FAANG/IITs/TOP MNC's

Get Prime →

Get over 200+ course One Subscription

Courses like AI/ML, Cloud Computing, Ethical Hacking, C, C++, Java, Python, DSA (All Languages), Competitive Coding (All Languages), TCS, Infosys, Wipro, Amazon, DBMS, SQL and others.

Get Prime Course List
Get Prime Course List

March 26, 2021