InfyTQ DML Statements Quiz 3

Question 1

Time: 00:00:00
The language used application programs to request data from the DBMS is referred to as __________

DML

DML

DDL

DDL

Query

Query

ALL

ALL

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

Please login to submit your explanation

Start

Question 2

Time: 00:00:00
In SQL, which of the following is not a data Manipulation Language Commands?

Delete

Delete

Truncate

Truncate

Update

Update

Create

Create

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

Please login to submit your explanation

Start

Question 3

Time: 00:00:00
Which of the following is not a type of SQL statement?

DML

DML

DCL(Data communication Language)

DCL(Data communication Language)

DDL

DDL

DCL(Data Control Language)

DCL(Data Control Language)

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 is not included in DML (Data Manipulation Language)?

INSERT

INSERT

DELETE

DELETE

UPDATE

UPDATE

CREATE

CREATE

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

Please login to submit your explanation

Start

Question 5

Time: 00:00:00
TRUNCATE statement in SQL is a –

DDL

DDL

DML

DML

DCL

DCL

TCL

TCL

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

Please login to submit your explanation

Start

Question 6

Time: 00:00:00
In SQL, which command is used to add new rows to a table?

Alter Table

Alter Table

Add Row

Add Row

Insert

Insert

Append

Append

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

Please login to submit your explanation

Start

Question 7

Time: 00:00:00
Stack is also called __________

First In First Out (LIFO)

First In First Out (LIFO)

Last In First Out (FIFO)

Last In First Out (FIFO)

First In Last Out (FILO

First In Last Out (FILO

First Come First Served

First Come First Served

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

Please login to submit your explanation

Start

Question 8

Time: 00:00:00
A table that displays data redundancies yields ____________ anomalies.

Update

Update

Insertion

Insertion

Deletion

Deletion

All of the above

All of the above

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

Please login to submit your explanation

Start

Question 9

Time: 00:00:00
A type of query that is placed within a WHERE or HAVING clause of another query is called

Master Query

Master Query

Sub Query

Sub Query

Super Query

Super Query

Multi Query

Multi Query

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

Please login to submit your explanation

Start

Question 10

Time: 00:00:00
The three language components of a database management system (DBMS) like DDL, DCL, DML.
Two different types of people (users and practitioners) are concerned with them. Which of them do users of a DBMS usually deal with?

DDL

DDL

DML

DML

DDL and DCL

DDL and DCL

DCL and DML

DCL and DML

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

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%

Completed

0/0

Accuracy

0%