ашық сабақты бекіту

Multiple Choice

What are the steps to create a query in constructor mode?

• A) Identify the table

• B) Select fields

• C) Create a web page

• D) Add query parameters

Multiple Choice

Which SQL query is correct to select students under 18 years old?

• A) SELECT * FROM Students WHERE Age > 18;

• B) SELECT * FROM Students WHERE Age < 18;

• C) SELECT * FROM Students;

• D) INSERT INTO Students VALUES (18);

Multiple Choice

What is the main advantage of the constructor mode?

• A) It can only work with one type of data

• B) It allows creating code in a visual way

• C) It does not allow data storage

• D) It can only be used with specific tools

Multiple Choice

What is SQL?

• A) A programming language for data manipulation

• B) A language for working with databases

• C) A website creation language

• D) A game development language

Multiple Choice

What is the result of the following query?

SELECT * FROM cars WHERE model = 'Sedan'

• It selects all cars with model 'Sedan'

• It deletes all cars with model 'Sedan'

• It updates all cars with model 'Sedan'

• It creates a new car with model 'Sedan'

Multiple Choice

What is the result of the following SQL query: `SELECT * FROM Employees WHERE Salary > 50000;`?

• It selects all employees with a salary less than £50,000

• It selects all employees with a salary greater than £50,000

• It selects all employees with a salary equal to £50,000

• It selects all employees regardless of salary

Multiple Choice

SQL-де іріктеу шарттарында қолданылатын операторлар:

• A) SELECT, FROM, INSERT

• B) <>, >, <, BETWEEN, LIKE, IN, AND, OR, NOT

• C) HTML, CSS, JS

• D) IF, ELSE, WHILE

Multiple Choice

Веб бет деректер қорымен қалай байланысады?

• A) Веб бетте тек мәтін көрсетіледі, деректер көрі қажет емес

• B) Серверлік тілдер арқылы сұраныс жасап, деректерді алады

• C) SQL коды веб бетке автоматты жазылады

• D) Деректер тек қолданушы компьютерінде сақталады

Multiple Choice

Which logical operator is used to retrieve data from a range of data?

• AND

• OR

• BETWEEN

• WHERE

Multiple Choice

Which is/are example of list operator in SQL?

• Relation

• IN

• NOT IN

• Both IN & NOT IN

Multiple Choice

Which operator test the column for absence of data?

• Not operator

• and operator

• is null operator

• None of these

Multiple Choice

Which operator performs pattern matching?

• Between Operator

• Like Operator

• Exists Operator

• None of these

Poll

Насколько уверенно вы себя чувствуете по этому вопросу сейчас?

• Очень уверенно
• Довольно уверенно
• Не уверен