Data Analytics Internship Quiz 2

Which datatype would get 8000 maximum characters both variable length and non code data

• varchar

• UNIQUE

• int

• varchar(max)

A collected information which is in an organized form for easier access, management, and various updating is known as

• Table

• Database

• Record

• Row

Which of the following constraint ensures that all the values in a column are different

• NOT NULL

• UNIQUE Constraint

• PRIMARY

• DEFAULT

What does a foreign key do?

• Uniquely identifies a row/record in any another database table

• Uniquely identifies a Column

• Uniquely identifies a another database table

• Uniquely identifies a Feild

The data in an RDBMS is stored in database objects which are called as

• Records

• Columns

• Feilds

• Tables

Full form of SQL

• Structured Query Langauge

• Structural Query Langauge

• Structure Query Langauge

• Structured Query Design

Which of the following comes under Data Manipulation Language

• insert, update, delete

• drop,create

• create,delete

• grant,revoke

Which of the following comes under Data Control Language

• insert, update, delete

• drop,create

• create,delete

• grant,revoke

Which category do SQL INSERT statements belong to?

• Data Definition Language (DDL)

• Data Manipulation Language (DML)

• Data Query Language (DQL)

• Data Control Language (DCL)

Which SQL statement is used for retrieving data from a database?

• INSERT

• UPDATE

• DELETE

• SELECT