InfyTQ SQL Basics Quiz 4

Question 1

Time: 00:00:00
Which statement is used to describe the database schema ?

DDL

DDL

DML

DML

DCL

DCL

TCL

TCL

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
Which of the following is not a SQL Command ?

MERGE

MERGE

REVOKE

REVOKE

COMMIT

COMMIT

KATIN

KATIN

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
Which of the following is not supported by SQL?

UNIQUE

UNIQUE

NOT NULL

NOT NULL

PRIMARY KEY

PRIMARY KEY

CHECK

CHECK

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
What does Integrity Constraint stand for ?

An integrity constraint is a rule that restricts the values for more columns in a table or a view.

An integrity constraint is a rule that restricts the values for more columns in a table or a view.

An integrity constraint is a rule that restricts the values for one column in a view.

An integrity constraint is a rule that restricts the values for one column in a view.

An integrity constraint is a rule that restricts the values for one column in a table.

An integrity constraint is a rule that restricts the values for one column in a table.

An integrity constraint is a rule that restricts the values for one or more columns in a table or a view.

An integrity constraint is a rule that restricts the values for one or more columns in a table or a view.

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 use of SQL WHERE clause ?

To limit the column data that are returned.

To limit the column data that are returned.

To limit the row data that are returned

To limit the row data that are returned

Both (a) and (b) are Correct.

Both (a) and (b) are Correct.

None of the above.

None 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 6

Time: 00:00:00
The SQL WHERE clause is useful when ?

An exact match is necessary in a SELECT Statement.

An exact match is necessary in a SELECT Statement.

An exact match is not possible in a SELECT Statement.

An exact match is not possible in a SELECT Statement.

An exact match is not possible in a CREATE Statement.

An exact match is not possible in a CREATE Statement.

An exact match is necessary in a CREATE Statement.

An exact match is necessary in a CREATE Statement.

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
What is the view in DBMS ?

A virtual table that can be accessed via SQL commands.

A virtual table that can be accessed via SQL commands.

A virtual table that cannot be accessed via SQL commands.

A virtual table that cannot be accessed via SQL commands.

A base table that can be accessed via SQL commands.

A base table that can be accessed via SQL commands.

A base table that cannot be accessed via SQL commands.

A base table that cannot be accessed via SQL commands.

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
The command to remove the table from the database is ?

REMOVE TABLE CUSTOMER;

REMOVE TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DROP TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

DELETE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

UPDATE TABLE CUSTOMER;

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
Which of the following SQL Command is valid for Creating an index ?

CREATE INDEX ID;

CREATE INDEX ID;

CHANGE INDEX ID;

CHANGE INDEX ID;

ADD INDEX ID;

ADD INDEX ID;

REMOVE INDEX ID;

REMOVE INDEX ID;

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!","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

Completed

0/0

Accuracy

0%

March 26, 2021