Вопросы по базам данных и SQL

Examples of structured data include: (more than one answer)

• Entity relationship 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)

• Information about customer demographics (e.g., name, address, age, gender)

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

Examples of DBMS: (more than one answer)

• Microsoft Access

• MySQL

• Apache Cassandra

• PostgreSQL

• MongoDB

____________________ is software that helps to create and manage databases.

• Spreadsheet

• Relational database

• DBMS

• Database technology

• SQL

Data in a RDBMS is stored in database objects called _____________. _____________ is a collection of related data records, and it consists of columns and rows.

• sql

• database

• table

• data structure

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

• ALL

• *

• EVERY

• AND

• GET

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 false 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

The table can have only one PRIMARY___ key, and this key is used for the unique identification of each row in the table. It must have unique values and cannot contain NULL values.