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!

Which of the following commands will enforce the EMPLOYEE table to not accept negative values in the SALARY field?

ALTER TABLE EMPLOYEE; ALTER COLUMN SALARY CHECK (SALARY>=0)

ALTER TABLE EMPLOYEE; ADD CONSTRAINT SALARY>=0

ALTER TABLE EMPLOYEE; ADD CHECK (SALARY>=0)

ALTER TABLE EMPLOYEE; ADD CONSTRAINT chk_Emp_Salary CHECK (SALARY>=0)

View this question

Which of the following key words is used to define an autoincremental field in a table in MS SQL server?

View this question

Assume that EMPLOYEE table has a foreign key constraint on the DEP_ID field that sets a relationship with the ID field of the DEPARTMENT table. Which of the following actions could be performed when deleting a record with ID=5 in the DEPARTMENT table?

This operation will also delete the EMPLOYEE table

This operation will not be allowed even if there’s no records in the EMPLOYEE table with DEP_ID=5

All records in the EMPLOYEE table for which DEP_ID=5, are also deleted

This operation will not be allowed if there are any records in the EMPLOYEE table with DEP_ID=5

The DEP_ID field for those records of the EMPLOYEE table for which DEP_ID=5, is set to NULL

View this question

Which of the following key words refer to data integrity?

View this question

Which of the following commands will create an index for the LASTNAME field of the EMPLOYEE table?

ALTER TABLE EMPLOYEE; ADD INDEX idx_Emp_Lastname on EMPLOYEES(LASTNAME)

ALTER TABLE EMPLOYEE; ADD INDEX idx_Emp_Lastname on LASTNAME

CREATE INDEX idx_Emp_Lastname on EMPLOYEES(LASTNAME)

ALTER TABLE EMPLOYEE; ALTER COLUMN LASTNAME SET INDEX

View this question

Which commands refer to DDL?

DELETE

UPDATE

SELECT

ALTER

DROP

View this question

How many records may be inserted into the EMPLOYEES table by the following query (Assume that ID field is autoincremental):

INSERT INTO EMPLOYEES (FIRSTNAME, LASTNAME, SALARY) SELECT FIRSTNAME, LASTNAME, SALARY FROM EMPLOYEES WHERE ID BETWEEN 3 AND 5

4

3

1

2

5

View this question

How many records may be deleted from the EMPLOYEES table by the following query (Assume that ID field is a primary key):

DELETE FROM EMPLOYEES WHERE ID IN (1, 3, 5) AND LASTNAME LIKE ’K%’

4

0

1

2

5

View this question

Which commands do not refer to DDL?

INSERT

UPDATE

ALTER

DROP

CREATE

View this question

Which of the following queries are syntactically correct?

UPDATE EMPLOYEES SET FIRSTNAME = 'Petro', SALARY = SALARY*1.1 WHERE ID = 4

UPDATE EMPLOYEES (FIRSTNAME, LASTNAME) VALUES ('Petro', 2100) WHERE ID = 4

UPDATE EMPLOYEES SET FIRSTNAME = 'Petro' WHERE ID = 4

UPDATE EMPLOYEES (FIRSTNAME, LASTNAME) VALUES FIRSTNAME = 'Petro', SALARY = SALARY*1.1 WHERE ID = 4

View this question

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