Question on CODD Fundamentals Quiz-1

Question 1

Time: 00:00:00
Write SQL query to change the string "axe" to "Ace" in column "file_details" and table "records" using REPLACE function?

UPDATE records SET file_details = REPLACE (\'file_details\',\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (\'file_details\',\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (file_details,\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (file_details,\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (\'file_details\',\'axe\',\'Ace\')

UPDATE records SET file_details = REPLACE (\'file_details\',\'axe\',\'Ace\')

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
What is the SQL query to list all the indexes associated to table name 'Master_Price'?

SHOW INDEX _DATA FROM MASTER_PRICE

SHOW INDEX _DATA FROM MASTER_PRICE

SELECT INDEX FROM MASTER_PRICE

SELECT INDEX FROM MASTER_PRICE

SHOW INDEX FROM MASTER_PRICE

SHOW INDEX FROM MASTER_PRICE

SELECT INDEX _DATA FROM MASTER_PRICE

SELECT INDEX _DATA FROM MASTER_PRICE

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
Select the option that does NOT narrate a normalization principle.

Decomposition should not preserve dependencies.

Decomposition should not preserve dependencies.

Decomposition should stop immediately when all related variables are in SNF

Decomposition should stop immediately when all related variables are in SNF

A non-SNF relation variable should be split into a set of SNF Projections.

A non-SNF relation variable should be split into a set of SNF Projections.

Every projection should be involved in the reconstruction process.

Every projection should be involved in the reconstruction process.

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
Which of the following CODD's rule does MYSQL indicate?

i. All stored values shall be atomic.

ii. Distribution independence.

iii. Logical Data dependence.

i and ii

i and ii

i only

i only

ii and iii

ii and iii

iii only

iii only

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
What is the SQL operator that selects the range of data between two values?

Like

Like

Union

Union

Between

Between

Where

Where

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
What will be the output of following SQL query?

SELECT DATE_ADQ('2012-01-31', INTERVAL 5 DAY);

2012-07-31

2012-07-31

2012-02-05

2012-02-05

2012-02-26

2012-02-26

2012-02-06

2012-02-06

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
Suppose the user stores his database data physically in Type 2 hard disks, which are not performance efficient.To enhance the performance, he upgrades the disk to Type 1, which guarantees twice the performance of the old disk. As per the CODD rule of physical data independence, what is the change that has to be done to the application to ensure data availability?

The application code has to be recompiled

The application code has to be recompiled

No change is required on the application

No change is required on the application

The application must be changed to physically re-point to the new physical hard disk addresses

The application must be changed to physically re-point to the new physical hard disk addresses

As per CODD rule, the hard disk cannot be changed once used in an application

As per CODD rule, the hard disk cannot be changed once used in an application

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
What is true regarding NULL value requirements confirming to Codd rule?

Null value should be zero.

Null value should be zero.

Null value should be space.

Null value should be space.

Null value should represent missing information.

Null value should represent missing information.

Either a or b.

Either a or b.

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
According to Codd rule, how one should be able to access information about data structures like databases, tables etc.

Should be directly accessible via all programming languages.

Should be directly accessible via all programming languages.

Should be directly accessible via same query language used for data manipulation (e.g select, update statements etc)

Should be directly accessible via same query language used for data manipulation (e.g select, update statements etc)

Should be directly accessible via XML

Should be directly accessible via XML

All of the above

All of the above

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
Which is most appropriate regarding information on constraints like primary key, foreign key etc?

They should be stored in the same tables.

They should be stored in the same tables.

They should be stored and handled by business layer programming languages rather than databases.

They should be stored and handled by business layer programming languages rather than databases.

They should be stored as meta data separately

They should be stored as meta data separately

They should be stored in text files.

They should be stored in text files.

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! \n","Keep trying! \n","Not bad! \n","Good work! \n","Perfect! \n"]
×

Please login to report

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

Comments

June 24, 2019