Please login

Prime

Prepinsta Prime

Video courses for company/skill based Preparation

(Check all courses)
Get Prime Video
Prime

Prepinsta Prime

Purchase mock tests for company/skill building

(Check all mocks)
Get Prime mock

InfyTQ Normalization Quiz 2

Question 1

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 2

Time: 00:00:00
Which is the subset of SQL commands used to manipulate Oracle Database Structures, including tables?

Data Definition Language

Data Definition Language

 Data Manipulation Language

 Data Manipulation Language

Data Described Language

Data Described Language

Data Retrieval Language

Data Retrieval Language

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 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 4

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

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
A concurrency-control policy such as this one leads to ______ performance since it forces transactions to wait for preceding transactions to finish before they can start.

Good

Good

Average

Average

Poor

Poor

Unstable

Unstable

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
__________ are used to ensure that transactions access each data item in order of the transactions’ ____ if their accesses conflict.

Zone

Zone

Relay

Relay

Line

Line

TimeStamps

TimeStamps

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Which statement is true regarding external tables?

The default REJECT LIMIT for external tables is UNLIMITED

The default REJECT LIMIT for external tables is UNLIMITED

The data and metadata for an external table are stored outside the database

The data and metadata for an external table are stored outside the database

ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table

ORACLE_LOADER and ORACLE_DATAPUMP have exactly the same functionality when used with an external table

 The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table

 The CREATE TABLE AS SELECT statement can be used to unload data into regular table in the database from an external table

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
McFadden has defined normalization in his which book___________

Database modern management

Database modern management

 Management database of modern

 Management database of modern

Modern database management

Modern database management

 Database management

 Database management

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
The database design prevents some data from being represented due to _______

Deletion anomalies

Deletion anomalies

 Insertion anomalies

 Insertion anomalies

Update anomaly

Update anomaly

None of the mentioned

None of the mentioned

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
Who developed the normalization process:

E.F codd

E.F codd

F.F codd

F.F codd

E.E codd

E.E codd

None of the above

None of the above

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!"]

Completed

0/0

Accuracy

0%

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%