Quiz about СГИЛ

Question 1

The database has a Courses table with the following columns: course id, course name,

of credits. Select which of the following constraints can be implemented for this table?

numberx

Accepted Answer

the number of credits can be from 1 to 6

Answer

books for each course should be available in the university library

Answer

course grades must range from 0 to 100%

Answer

courses must last 3 months

Question 2

The database has a Schedule table with the following columns: schedule_id, course_id,

teacher id, group id, time, room, day of week. Select which of the following constraints can be

implemented for this table?

Accepted Answer

lesson time can be from 08:00 to 22:00

Answer

lessons should be interesting

Answer

students must attend all lessons

Answer

after each lesson, students must complete

Question 3

The Books table has the followislg columns: ISBN - unique code of the book edition, title

of the book, author of the book, number of pages. Which of these columns can be the Primary key?

Accepted Answer

ISBN

Answer

title

Answer

pages

Answer

pages

Question 4

Choose the right order of the database design phases

Accepted Answer

Subject area analysis, Conceptual Design, Logical Design, Physical Design

Answer

Subject area analysis, Logical Design, Conceptual Design, Physical Design

Answer

Conceptual Design, Logical Design, Physical Design, Queries Implementation

Answer

Conceptual Design, Logical Design, Physical Design, Queries Implementation

Question 5

DBMS stands for...

Accepted Answer

Database

Management

System

Answer

None of the given

Answer

Database Basic Management System

Answer

Database Administrator System

Question 6

A teacher teaches one or more groups, each of which is taught by one or more teachers. The

TEACHERS table has teacher_id, teacher_name columns. The GROUPS table has group_id, name

columns. Identify a type of the relationship between TEACHERS and GROUPS tables.

Accepted Answer

many (teachers)-to-many (groups)

Answer

one (teachers)-to-many (groups)

Answer

one (groups)-to-many (teachers)

Answer

one (teachers)-to-one (groups)

Question 7

A teacher teaches one or more subjects, each of which is taught by one or more

teachers.

Definitions of the entities are: Teachers (teacher_id, name, birthdate), Subjects (subject_id, name,

description). Identify a type of the

relationship between TEACHERS and SUBJECTS tables.

Accepted Answer

many (teachers)-to-many (subjects)

Answer

one (teachers)-to-one (subjects)

Answer

> one (teachers)-to-many (subjects)

Answer

one (subjects)-to-many (teachers)

Question 8

A teacher teaches one or more subjects, each of which is taught by one or more teachers.

Definitions of entities are: Teachers (teacher id, name, birthdate), Subjects (subject id, name,

description). Identify a table with a Foreign Key(s) for the relationship between TEACHERS and

SUBJECTS tables.

Accepted Answer

associative table between Teachers and Subjects tables

Answer

Teachers

Answer

Subjects

Answer

in the Teachers table or in the

Subjects table - both options are

correct

Question 9

Entities Groups and Subjects have a many-to-many relationship type. For this reason a

new associative table between them should be created - Schedule table. Definitions of tables are: Groups

(group_code (PK), group_name), Subjects (subject_code (PK), subject_name, description). Identify

attributes in the Schedule table.

Accepted Answer

schedule_id (PK), group_code (FK), subject_code (FK)

Answer

schedule_id (PK), group_name (FK), subject_name (FK)

Answer

schedule_id (PK), group_code (FK)

Answer

schedule id (PK), subject name (FK)

Question 10

Determine the relationship type between Courses and Teachers entities by the description:

"One course can be taught by many teachers, and one teacher can teach many courses".

Accepted Answer

many-to-many

Answer

one-to-one

Answer

one-to-many

Answer

none of the given

Question 11

Choose the right order of the database design phases

Accepted Answer

Subject area analysis, Conceptual Design, Logical Design, Physical Design

Answer

Subject area analysis, Logical Design, Conceptual Design, Physical Design

Answer

Conceptual Design, Logical Design, Physical Design, Queries Implementation

Answer

Conceptual Design, Logical Design, Physical Design, DBMS Selection

Question 12

A teacher teaches one or more groups, each of which is taught by one or more teachers. The

TEACHERS table has teacher_id, teacher name columns. The GROUPS table has group id, name

columns. Identify a table with a Foreign Key(s) for the relationship between TEACHERS and GROUPS

tables.

Accepted Answer

associative table between TEACHERS and GROUPS tables

Answer

TEACHERS

Answer

GROUPS

Answer

in the TEACHERS table or in the GROUPS table - both options are correct

Question 13

A teaher may be assigned with exactly one position. A position must be assigned to one or

many teachers, The TEACHERS table has teacher id, teacher_name, birthdate columns, The

POSITIONS table has position id, position name columns. Identify a type of the relationship between

TEACHERS and POSITIONS entities.

Accepted Answer

one (positions)-to-many (teachers)

Answer

one (teachers)-to-many (positions)

Answer

one (teachers)-to-one (positions)

Answer

many (teachers)-to-many (positions)

Question 14

Entities Groups and Subjects have a many-to-many relationship type. For this reason a

new associative table between them should be created - Schedule table. Definitions of tables are: Groups

(group_code (PK), group_name), Subjects (subject_code (PK), subject_name, description). Identify

attributes in the Schedule table.

Accepted Answer

schedule_id (PK), group code (FK), subject code

(FK)

Answer

schedule id (PK), group name (FK), subject name (FK)

Answer

schedule_id (PK), group_code (FK)

Answer

schedule_id (PK), subject_name (FK)

Question 15

Determine the relationship type between Courses And Teachers entities by the description:

"One course can be taught by many teachers, and one teacher can

teach many courses"

Accepted Answer

many-to-many

Answer

one-to-one

Answer

one-to-many

Answer

none of the given

Question 16

Determine the relationship type between Students and Readers entities by the description:

"One student has only one reader's card, and one reader's card can belong to only one student".

Accepted Answer

one-to one

Answer

one-to-many

Answer

many-to-many

Answer

none of the given

Question 17

In an ER-diagram an entity is represent by

a

Accepted Answer

Rectangle

Answer

Ellipse

Answer

Rhombus

Answer

Circle

Question 18

What type of relationship is described by the following rule? For one instance of entity A,

there exists one or many instances of entity B; and for one instance of entity B, there exists one or many

instances of entity A.

Accepted Answer

many-to-many

Answer

one-to-one

Answer

one-to-many

Question 19

Which of the following is not a relational algebra operation?

Accepted Answer

Manipulate

Answer

Selection

Answer

Projection

Answer

Union

Question 20

EXCEPT in SQL is analogous to

Accepted Answer

Difference operator of relational algebra

Answer

Intersection operator ofrelational algebra

Answer

Cartesian product operator of relational algebra

Answer

Toin onerator ofrelational sigebra

Question 21

How to select all data from student table starting the name from letter'r"?

Accepted Answer

SELECT * FROM student WHERE name LIKE' r%';

Answer

SELECT * FROM student WHERE name LIKE 'r%,

Answer

SELECT * FROM student WHERE name LIKE %r%';

Answer

SELECT * FROM student WHERE name LIKE %r';

Question 22

What is a result of "CAST (phone_number AS INTEGER)"?

Accepted Answer

phone_number attribute will be converted into integer data type

Answer

phone number attribute will be converted from integer into yarchar

data type

Answer

phone number attribute will be converted to lower case

Answer

phone number attribute

will be converted to upper case

Question 23

Choose the correct option to convert phone number attribute from yarchar to integer data type

Accepted Answer

phone number::int

Answer

phone number::yarchar(3)

Answer

phone_number to int

Question 24

EXCEPT in SQL is analogous to

Accepted Answer

Difference operator of relational algebra

Answer

Intersection operator of relational algebra

Answer

Cartesian product operator of relational algebra

Answer

Join operator of relational algebra

Question 25

Complete the code for the following table Subjects (subj_id

(PK), name, credits):

SET credits=credits+1;

Accepted Answer

UPDATE Subjects

Answer

UPDATE

Answer

Subjects

Answer

ALTER TABLE Subjects

Question 26

Complete the code for the following table: Faculties (facult_id (PK), name): INSERT INTO

(1, "IT");

Accepted Answer

Faculties VALUES

Answer

Faculties

Answer

VALUES

Answer

TABLE Faculties

Question 27

Complete the code for the following table Groups (group_id (PK), group_name):

VALUES (1, 'SIS-01');

Accepted Answer

INSERT INTO Groups

Answer

INSERT Groups

Answer

ADD ROW Groups

Answer

UPDATE Groups

Question 28

Complete the code for the following table Groups (group_id (PK), group_name):

INTO Groups VALUES (1, 'SIS-01');

Accepted Answer

INSERT

Answer

UPDATE

Answer

DELETE

Answer

ADD ROW

Question 29

With SQL, how do you select all the records from a table named "Persons" where the value of

the column "FirstName" is "Peter"?

Accepted Answer

SELECT * FROM Persons WHERE FirstName='Peter';

Answer

SELECT * FROM Persons WHERE FirstName<>'Peter';

Answer

SELECT [all] FROM Persons WHERE FirstName='Peter';

Answer

SELECT [all] FROM Persons WHERE-FirstName LIKE Peter';

Question 30

With SQL, how do you select all the records from a table named "Persons" where the

"FirstName" is "Peter" and the "LastName" is "Jackson"?

Accepted Answer

SELECT * FROM Persons WHERE FirstName 'Peter' AND LastName 'Jackson';

Answer

SELECT FirstName='Peter', LastName='Jackson' FROM Persons;

Answer

SELECT *

FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson':

Answer

SELECT * FROM Persons-WHERE-LastName Jackson;

Question 31

If you want to apply a

second condition to your statement where both statements must be true,

what keyword would you use between the conditions?

Accepted Answer

AND

Answer

BOTH

Answer

TRUE

Answer

TRUE

Question 32

Which of the following is the correct order of keywords for SQL SELECT statements?

Accepted Answer

SELECT, FROM, WHERE

Answer

FROM, WHERE, SELECT

Answer

WHERE, FROM,SELECT

Answer

SELECT,WHERE,FROM

Question 33

LIKE 'SIS-_' can give 'SIZE-2301' as the answer

Accepted Answer

False

Answer

True

Question 34

LIKE 'SIS-%' can give 'SIZE-2301' as the answer

Accepted Answer

True

Answer

False

Question 35

Which SQL keyword is used to return only different (unique) values?

Accepted Answer

DISTINCT

Answer

UNIQUE

Answer

DIFFERENT

Answer

*

Question 36

What type of relationship is described by this rule? For one instance of entity A, there exists

one or many instances of entity B; but for one instance of entity B, there exists one instance of entity A

Accepted Answer

one-to-many

Answer

many-to-many

Answer

one-to-one

Question 37

What type of relationship is described by this rule? One instance of entity A can be associated

with one instance of entity B, and one instance of entity B can be associated with one instance of entity A.

Accepted Answer

one-to-one

Answer

one-to-many

Answer

many-to-many

Question 38

A relation in which the intersection of each row and column contains one and only one value

is said to be in

Accepted Answer

1NF

Answer

0NF

Answer

2NF

Answer

3NF

Question 39

Can a Foreign key be duplicate?

Accepted Answer

YES

Answer

NO

Create a free account and access millions of resources

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Mathematics