Тест по базам данных и SQL

What types of data are shown here?

• 1 - Structured, 2 - Semi-structured data, 3 - Relational data

• 1 - Unstructured, 2 - Hierarchical data, 3 - Structured data

• 1 - Unstructured, 2 - Semi-structured data, 3 - Structured data

• 1 - Unorganized, 2 - Semi-organized data, 3 - Organized data

Examples of structured data include:

• Entity diagrams (e.g., tables, rows, columns, primary keys, foreign keys)

• Photos and videos, as multimedia files are typically stored as unstructured data and do not have predefined fields.

• Financial transactions (e.g., sales data, purchase orders, accounting records)

• Demographic information about customers (e.g., name, address, age, gender)

• Text documents (e.g., PDFs, Word documents, and open-ended survey responses)

Examples of DBMS:

• MySQL

• Microsoft Access

• Apache Cassandra

• PostgreSQL

• MongoDB

____________________ is software that helps to create and manage databases.

• Spreadsheet

• Relational database

• DBMS

• Database technology

Data in a relational database management system (RDBMS) is stored in database objects called ____________.

• sql

• database

• table

• data structure

What keyword is used to select all columns in a table?

• ALL

• *

• EVERY

• AND

Which SQL query shows students who wrote a comment containing the phrase "I love studying OIS"?

• SELECT * FROM students WHERE comment = "I love studying OIS";

• SELECT * FROM students WHERE comment LIKE 'I love studying OIS';

• SELECT * FROM students WHERE comment LIKE '%I love studying OIS%';

• SELECT * FROM students WHERE comment CONTAINS 'I love studying OIS';

Which SQL operator correctly adds a new customer to the table?

• INSERT INTO customers ('CustomerID', 'CustomerName', 'ContactName') VALUES (92, 'Global Foods', 'Anna Ivanova');

• INSERT customers Values (92, 'Global Foods', 'Anna Ivanova');

• CREATE customers VALUES (92, 'Global Foods', 'Anna Ivanova');

• INSERT INTO customers (CustomerID, CustomerName, ContactName) VALUES (92, 'Global Foods', 'Anna Ivanova');

Which of the following statements is incorrect regarding keys in a relational DBMS?

• Each table can have only one primary key

• A table can contain multiple foreign keys or none at all

• The rules for primary and foreign keys serve the same purpose

• A foreign key links one table to another by referencing the primary key

What document is described in the text above?

• SDLC

• API

• SRS

• SRSP