Quiz- 1

Question 1

Time: 00:00:00
Logical Level of the database is also known as?

Sub Schema

Sub Schema

Schema

Schema

Attribte set

Attribte set

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 2

Time: 00:00:00
What is Physical Data Independency?

Changes at physical level of database does not reflect at logical level

Changes at physical level of database does not reflect at logical level

Changes at physical level of database reflects at logical level

Changes at physical level of database reflects at logical level

To view record using select statement

To view record using select statement

To implement normalization to remove data redundancy

To implement normalization to remove data redundancy

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
What is Logical Data Independency?

Changes at logical level of database does not reflect at view level

Changes at logical level of database does not reflect at view level

Changes at logical level of database reflects at view level

Changes at logical level of database reflects at view level

To handle multiple records

To handle multiple records

To create data dictionary

To create data dictionary

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
A --- key can be the primary key?

Foreign

Foreign

Primary

Primary

Candidate

Candidate

Composite

Composite

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
ER Model is used to represent?

Database structure

Database structure

Flow of a program

Flow of a program

Algorithm

Algorithm

None of these

None of these

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
Double diamond symbol is used for?

Entity relationship type

Entity relationship type

Attribute

Attribute

Week entity relationship type

Week entity relationship type

Tuple

Tuple

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
Is derived attribute physically contained in relation?

Yes

Yes

No

No

Sometimes

Sometimes

None of these

None of these

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
If F is functional dependency then closure of F is represented by?

F+

F+

F*

F*

F-

F-

F#

F#

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
What is non-trivial functional dependency?

If A→B holds where B is not subset of A.

If A→B holds where B is not subset of A.

If A→B holds where B is subset of A.

If A→B holds where B is subset of A.

If A→B holds where B is not intersection of A.

If A→B holds where B is not intersection of A.

If A→B holds where B is intersection of A.

If A→B holds where B is intersection of A.

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 the correct syntax to sort returned record set in Ascending Order by Column1 and Descending Order by Column2?

SELECT * FROM table_name ORDER BY ASC (column1), DESC (column2)

SELECT * FROM table_name ORDER BY ASC (column1), DESC (column2)

SELECT * FROM table_name ORDER BY ASC column1, DESC column2

SELECT * FROM table_name ORDER BY ASC column1, DESC column2

SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC

SELECT * FROM table_name ORDER BY column1 ASC, column2 DESC

SELECT * FROM table_name column1 ASC, column2 DESC ORDER BY

SELECT * FROM table_name column1 ASC, column2 DESC ORDER BY

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

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

Completed

0/10

Accuracy

0%

Related Banners
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