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!

a special driver for MS Windows operating system

Microsoft framework for data analysis

Application that allows to store, manage and process the information

organized collection of data

A special software type for working with databases

View this question

What are main features of DBMS?

Preserving data integrity

Multi-user access

View this question

Choose client-server RDMS

View this question

Select the commands that belong to the data manipulation language (DML)

View this question

Select the commands for creating a new table or editing table named STUDENT which would contain the following info: ID (key field), student’s first and last names (select all correct answers).

ALTER TABLE STUDENT ADD CONSTRAINT ID PRIMARY KEY(ID)

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

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

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

ALTER TABLE STUDENT ADD CONSTRAINT ID PRIMARY KEY(ID);

ALTER TABLE STUDENT ALTER COLUMN ID INT NOT NULL;

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

ALTER TABLE STUDENT ALTER COLUMN ID INT NOT NULL ADD CONSTRAINT ID PRIMARY KEY(ID)

View this question

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

Previous
1
2
3
4
5
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