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

Start

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

Start

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

Start

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

Start

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

Start

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

Start

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

Start

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

Start

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

Start

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

Start

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

Please login to report

Completed

0/0

Accuracy

0%

Related Banners
prepinsta
prepinsta
prepinsta
prepinsta
Prepinsta Prime
Get Prepinsta Prime

Get all 200+ courses offered by Prepinsta

Explore Prime or check Course List
Check out our instagram

Never Miss an OffCampus Update

Get OffCampus Updates on Social Media from PrepInsta

Follow us on our Media Handles, we post out OffCampus drives on our Instagram, Telegram, Discord, Whatsdapp etc.

Instagram Whatsapp Telegram Linkedin
Get Hiring Updates
Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta
prepinsta
prepinsta
prepinsta
prepinsta

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 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 PrepInsta Prime Subscription

Get access to all the courses that PrepInsta offers, check the out below -

Companies

TCS, Cognizant, Delloite, Infosys, Wipro, CoCubes, KPMG, Amazone, ZS Associates, Accenture, Congnizant & other 50+ companies

See Full list here
Get Prime

Programming

Data Structures, Top 500 Codes, C, C++, Java Python & other 10+ subjects

See Full list here
Get Prime

Skills

Full Stack Web Development, Data Science, Machine Learning, AWS Cloud, & other 10+ skills and 20+ projects

See Full list here
Get Prime

Related Pages

June 24, 2019

Comments