InfyTQ DML Statements Quiz 1

Question 1

Time: 00:00:00
Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?

DML(Data Manipulation Language)

DML(Data Manipulation Language)

DDL(Data Definition Language)

DDL(Data Definition Language)

Query

Query

Relational Schema

Relational Schema

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
An ________ is a set of entities of the same type that share the same properties, or attributes.

Entity set

Entity set

Attribute set

Attribute set

Relation set

Relation set

Entity model

Entity model

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
Entity is a _________

Object of relation

Object of relation

Present working model

Present working model

The thing in real world

The thing in real world

Model of relation

Model of relation

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
The descriptive property possessed by each entity set is _________

Entity

Entity

Attribute

Attribute

Relation

Relation

Model

Model

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 function that an entity plays in a relationship is called that entity’s _____________

Participation

Participation

Position

Position

Role

Role

Instance

Instance

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
The attribute name could be structured as an attribute consisting of first name, middle initial, and last name. This type of attribute is called

Simple attribute

Simple attribute

Composite attribute

Composite attribute

Multivalued attribute

Multivalued attribute

Derived attribute

Derived attribute

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
The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

Single Valued

Single Valued

Multi Valued

Multi Valued

Composite

Composite

Derived

Derived

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
Not applicable condition can be represented in relation entry as

NA

NA

NULL

NULL

BLANK SPACE

BLANK SPACE

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
Which of the following can be a multivalued attribute?

Phone Number

Phone Number

Name

Name

Date of Birth

Date of Birth

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 of the following is a single valued attribute?

Register_number

Register_number

Address

Address

Subject Taken

Subject Taken

Refrence

Refrence

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

January 22, 2022