SQL Programming

Section 1

100

What does ACID stand for?

Atomicity, Consistency, Isolation, and Durability

200

What does Ambiguous mean?

The word ambiguous means “open to more than one interpretation; not having one obvious meaning”.

300

What does BI? What does it do?

BI stands for Business Intelligence. It refers to the area of study and work that uses technology and tools to view a company’s data in more meaningful ways, which allows people at a company to make better decisions.

400

SQL is a programing type that works with data? 

True or False

True

500

What does BLOB stand for? What is it used for?

BLOB stands for Binary Large Object and is a data type. It’s used for storing digital information from other formats (e.g. images and audio) and can store data up to 4GB.

Section 2

100

To shut down and restart a database or server.

Bounce

200

What is a cluster?

A cluster means two or more computers that share resources and work together to form a larger unit.

300

The act of saving a transaction to the database permanently.

commit

400

What is a constant? 

A constant is a variable that does not change value.

500

What are one of the five types of constraints?

Primary Key

Foreign Key

Unique Constraint

Not Null Constraint

Check Constraint

Section 3

100

Write an SQL query to fetch “FIRST_NAME” from Worker table in upper case.

Select upper(FIRST_NAME) from Worker;

200

Write an SQL query to print the FIRST_NAME from Worker table after removing white spaces from the right side.

Select RTRIM(FIRST_NAME) from Worker;

300

Write an SQL query to print details of Workers with DEPARTMENT name as “Admin”.

Select * from Worker where DEPARTMENT like 'Admin%';

400

Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘a’.

Select * from Worker where FIRST_NAME like '%a';

500

Write an SQL query to print details of the Workers whose SALARY lies between 100000 and 500000.

Select * from Worker where SALARY between 100000 and 500000;

Section 4

100

what does SQL stand for?

Struture Query Language

200

What year was "SQL" established?

1940's

300

Who created "SQL" programming?

Raymond Boyce and Donald Chamberlin

400

The first computer to use SQL programming?

IBM

500

where is your quiz located?

Microsoft Team