SQL Questions and Answers Pdf - 1

Question: 1

Which data manipulation command is used to combines the records from one or more tables?

(A) Join

(B) Project

(C) Products

(D) Select

Question: 2

The logical design, and the snapshot of the data at a given instant in time is known as

(A) Schema and instance

(B) Domain and schema

(C) Relation and schema

(D) Instance and relation

Question: 3

_____ indicates the maximum number of entities that can be involved in a relationship.

(A) ERD

(B) Maximum cardinality

(C) Minimum cardinality

(D) Greater entity count

Question: 4

Which of the following is not constraint in SQL?

(A) Union

(B) Check

(C) Primary key

(D) Not null

Question: 5

Database is used to _____ the data.

(A) Insert

(B) Delete

(C) Retrieve

(D) All of the above