Prepare
- All Platforms
- Programming
- Aptitude
- Syllabus
- Interview Preparation
- Interview Exp.
- Off Campus
- Prime Video
- Prime Mock
PrepInsta Prime
OffCampus
The Job Company
Placement Stats

Prime Video
Prime Mock

⁰

Notifications Mark All Read

7 Day TCS NQT Crash Course is available at just 1999. Click here to Purchase
Login
Get Prime

InfyTQ Menu

What is InfyTQ ?
Placement Papers
Registration Process
Certification Round
- Certification Round Details
- Certification Round Practice Questions
Java
- Java Round
- Java MCQ Practice Questions
Python
- Python Round
- Python MCQ Practice Questions
DBMS
- DBMS Round
- DBMS MCQ Practice Questions
Coding Questions
Advantage Round
Syllabus
Recruitment Process
How to Prepare
InfyTQ Results
Interview Experiences

Get Hiring Updates
Contact us

PrepInsta MockMock
Prime VideoVideo

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)

DDL(Data Definition Language)

Query

Relational Schema

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

DML(Data Manipulation Language) provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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

Attribute set

Relation set

Entity model

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

An entity is a “thing” or “object” in the real world that is distinguishable from all other objects.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 3

Time: 00:00:00

Entity is a _________

Object of relation

Present working model

The thing in real world

Model of relation

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

For example, each person in a university is an entity.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 4

Time: 00:00:00

The descriptive property possessed by each entity set is _________

Entity

Attribute

Relation

Model

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Explanation: Possible attributes of the instructor entity set are ID, name, dept name, and salary.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 5

Time: 00:00:00

The function that an entity plays in a relationship is called that entity’s _____________

Participation

Position

Role

Instance

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

A relationship is an association among several entities.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

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

Composite attribute

Multivalued attribute

Derived attribute

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Composite attributes can be divided into subparts (that is, other attributes).

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 7

Time: 00:00:00

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is

Single Valued

Multi Valued

Composite

Derived

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

The value for this type of attribute can be derived from the values of other related attributes or entities

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 8

Time: 00:00:00

Not applicable condition can be represented in relation entry as

NULL

BLANK SPACE

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

NULL always represents that the value is not present.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 9

Time: 00:00:00

Which of the following can be a multivalued attribute?

Phone Number

Name

Date of Birth

All of the above

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Name and Date_of_birth cannot hold more than 1 value.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

Question 10

Time: 00:00:00

Which of the following is a single valued attribute?

Register_number

Address

Subject Taken

Refrence

Good Job!

Oops!

Report the answer

How to use PrepInsta Quiz

PrepInsta Explanation
User Explanation

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

Register_number is a single valued attribute.

Please login to submit your explanation

You can check your performance of this question after Login/SignupLogin

Start

["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

Start Preparing

Detailed performance

Completed

0/10

Accuracy

Related Banners

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

Instagram

Get Hiring Updates

Amazon,Google,Delottie & 30+companies are hiring ! Get hiring Updates right in your inbox from PrepInsta

PrepInsta 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

PrepInsta 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