Big Data Technologies (BigData) (Answers Synergy)

Answers to the test Big Data Technologies (BigData) - SYNERGY, MOI, MTI.
The result is 100-100 points.
The test was taken recently.
To search for test answers in a WORD file, press the combination "CTRL+F". Then enter a question to quickly find the answer.
Before purchasing, be sure to review the questions already provided in advance, as tests and instructors change!

Questions:
===№ 1

What command is used to select data?

===№ 2

What command removes spaces at the beginning and end of a line?

===№ 3

What will happen after applying the method:

select reverse('arbadakarba')

===№ 4

What is the difference between INNER JOIN, LEFT JOIN and RIGH JOIN?

Answer type: multiple choice

===№ 5

What does backup mean?

===№ 6

Where is it better to use RDBMS?

===№ 7

What is the difference between CHAR and VARCHAR data types?

===№ 8

How to install MySQL on a computer?

===№ 9

What will this code output?

number =0

while number <4:

number +=1

print (number)

===№ 10

What is the TIMESTAMP format?

===№ 11

What is the essence of data normalization in mysql?

===№ 12

What command can be used to calculate the length of a string?

===№ 13

Definition of ACID

===№ 14

What does it mean for a database to be "isolated"?

===№ 15

Which of the following data types are supported in mysql?

===№ 16

What is the difference between FLOAT and DOUBLE data types?

===№ 17

What is the difference between RDBMS and NDBMS

===№ 18

What command is used to add data to mysql?

===№ 19

Name the popular relational and non-relational databases.

===№ 20

Please specify the correct syntax when selecting data: