Crowdly
Додати до Chrome
INF 202 Database Management Systems 1 (Meruyert Raiymbekova)
Шукаєте відповіді та рішення тестів для INF 202 Database Management Systems 1 (Meruyert Raiymbekova)? Перегляньте нашу велику колекцію перевірених відповідей для INF 202 Database Management Systems 1 (Meruyert Raiymbekova) в moodle.sdu.edu.kz.
Отримайте миттєвий доступ до точних відповідей та детальних пояснень для питань вашого курсу. Наша платформа, створена спільнотою, допомагає студентам досягати успіху!
Using the schema:
STUDENT(Sid, Sname, Gender, Age, EntranceYear, GPA)
DEPT(Did, Dname)
PROF(Pid, Pname, Did, Birth_Date)
COURSE(Cno, Did, Cname)
SECTION(Sectno, Did, Cno, Pid)
ENROLL(Eid, Sid, Cno, Sectno, Grade)
Which of the following SQL queries correctly show department IDs and course names?(Select all that apply)
What does the following query do?
Select name, ID, branch
from student, department
where student. branch = department.branch;
____________ is the preferred method for enforcing data integrity
Which of the following syntax of the basic query is correct?
Find students whose name starts with ‘S’ and last name ends with ‘s’?
Which of the following clauses is used to group a set of rows based on a column or set of columns?
If a table’s attributes depend on the whole primary key (not just part), it is in:
Which is the correct sql statement (Choose all that apply)
______ returns all the columns from the table on the right even if no matching rows have been found in the table on the left.
Which of the following functions can be used without GROUP BY clause in SELECT query? (Choose all that apply)