Crowdly

Add to Chrome

Universities
softserve.academy
Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]

Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016]

Looking for Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] test answers and solutions? Browse our comprehensive collection of verified answers for Database & SQL Basics Lite Edition [Ukr+Eng sub, 2016] at softserve.academy.

Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!

Select the commands for adding a new field named RATING to the STUDENT table created by the following command (select one correct answers).

CREATE TABLE STUDENT(ID INT PRIMARY KEY, FIRSTNAME VARCHAR(30), LASTNAME VARCHAR(30))

ALTER TABLE STUDENT ADD RATING INT

ALTER STUDENT ADD COLUMN RATING INT

CREATE STUDENT(RATING INT)

ALTER TABLE STUDENT ALTER COLUMN RATING INT

UPDATE TABLE STUDENT ADD COLUMN RATING INT

View this question

Select the commands that belong to the data definition language (DDL)

View this question

The data types for storing numbers in SQL could be defined by the following keywords (select all correct answers)

View this question

The data types for storing a text in SQL could be defined by the following keywords (select all correct answers)

View this question

What is the query for creating the PRODUCT table which contains the following fields: ID (primary key), NAME (product name) and PRICE (the product’s unit price)

CREATE TABLE PRODUCT (ID INT PRIMARY KEY, NAME VARCHAR(50), PRICE NUMERIC(6,2))

CREATE TABLE PRODUCT (ID INT, NAME VARCHAR(50), PRICE INT)

CREATE TABLE PRODUCT (ID INT PRIMARY KEY, NAME VARCHAR(50), PRICE)

CREATE TABLE PRODUCT (ID INT NOT NULL, NAME TEXT, PRICE NUMERIC(6,2))

CREATE TABLE PRODUCT (ID PRIMARY KEY, NAME VARCHAR(50), PRICE NUMERIC(6,2))

View this question

Choose statements that relate to desktop (file-server) RDMS

Data is processed on a local PC

Data is stored on a local PC or on a file server

Data is stored on a server

Data is processed on a server

Rapid development

View this question

Which adjectives refer to data models

View this question

Choose statements that relate to client-server RDMS

Data is processed on a local PC

Data is stored on a local PC or on a file server

Data is stored on a server

Data is processed on a server

Rapid development

View this question

What is database?

any set of information stored in a computer memory

a mathematical notion referring to relation theory

collection of information that is organized so that it can easily be accessed, managed, and updated

a graphical representation of tables

organized collection of data

View this question

PRIMARY KEY is one or several fields of a table that contain a reference to the foreign key field in another table.

View this question

1
2
Next

Want instant access to all verified answers on softserve.academy?

Get Unlimited Answers To Exam Questions - Install Crowdly Extension Now!

Add to Chrome

Telegram Instagram TikTok Question Bank

Terms of Use Contact Us

Add to Chrome

Add to Chrome