46. Retrieve students’ name, who registered in 10th of Jan 2016. Tables: STUDENTS {id (PK), name, scholarship, registereddate, tutorid }.

select name from students where registereddate = '2016-01-10';

select name from students where registereddate = '2016-10-10';

select name from students where registereddate = 2016-10-10;

select name from students where registereddate = '2016-01-01';

42. Find minimum scholarship of students - STUDENTS {id, name, scholarship, registereddate, tutorid}

Select min (scholarship) from students;

Select avg (scholarship) from students;

Select count (scholarship) from students

Select max (scholarship) from students;

41. Find maximum scholarship of students - STUDENTS {id, name, scholarship, registereddate, tutorid}

Select max (scholarship) from students;

Select avg (scholarship) from students;

Select count (scholarship) from students

Select sum (scholarship) from students;

40. Find an average scholarship of students - STUDENTS {id, name, scholarship, registereddate, tutorid}

Select avg (scholarship) from students;

Select count (scholarship) from students;

Select sum (scholarship) from students;

Select max (scholarship) from students;

39. Sort students name by descending order - STUDENTS {id, name, scholarship, registereddate, tutorid}

Select name from students order by desc;

Select name from students group by desc;

Select *from students order by desc;

Select name form students order by desc;

37. Retrieve total number scholarship in the students table – STUDENTS {id, name, scholarship, registereddate, tutorid}

Select sum (scholarship) from office;

Select avg (scholarship) from office;

Select count (scholarship) from office

Select max (scholarship) from office;

31. Which of the following is a basic form of grant statement?

Grant ‘privilege list’ on ‘relation name or view name’ on ‘user/role list’;

Grant ‘privilege list’ on ‘user/role list’ to ‘relation name or view name’;

Grant ‘privilege list’ to ‘user/role list’;

29.Updating the value of the view

Will affect the relation from which it is defined

Will not change the view definition

Will not affect the relation from which it is defined

28.Which of the following is the syntax for views where v is view name?

Create view v as “query expression”;

Create view v as “query name”;

Create “query expression” as view;

Create view “query expression

23.Database Authentication refers to:

methods of restricting user access to system

controlling access to portions of database

controlling the operation on the data

20.Which of the following is used to avoid cascading of authorizations from the user?

Revoke select on employee from finance, cashier restrict;

Revoke grant option for select on department from finance;

Revoke select on department from finance, cashier cascade

18. Which of the following is true regarding views?

If a user creates a view on which no authorization can be granted, the system will allow the view creation request.

The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view.

The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view

A user who creates a view receives all privileges on that view.

17Which of the following statement is used to remove the privilege from the user finance

Revoke update on employee from finance

Remove update on employee from finance

Grant update on employee from finance

16.Which of the following is used to provide privilege to only a particular attribute?

Grant update(salary) on employee to finance

Grant select on employee to finance

Grant update(salary, rate) on employee to finance

4.Define Data Manipulation Language

Specify and retrieve database contents

Specify access controls (privileges)

Specify table attribute uniquenes

13.Define Data Control Language

Specify access controls (privileges)

Specify and retrieve database contents

Specify table attribute uniqueness

7. Define a primary key

uniquely identifies each tuple that appears in a relation

restrict the possible values a tuple can assign to each attribute

uniquely identifies each tuple that appears in a relation

SQL 1-60

Authored by мадияр алимов

Mathematics

1st Grade

Used 11+ times

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

Content View

Student View

60 questions

Show all answers

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

1. Define a degree of a relation

How many rows a table has

how long each tuple is, or how many columns the table has

how many different tuples there are

how many different datatypes table has

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

60. Which of the following anomaly does not exist?

Creation anomaly

Deletion anomaly

Insertion anomaly

Modification anomaly

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

59. How many types of anomalies exist?

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

58. Retrieve all students’ name and scholarship, tutors name except students who have scholarship 3000$. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))

select s.name, t.name from students s join tutor t on s.tutorid=t.id where s.scholarship <> 3000;

select s.name, t.name from students s join tutor t on s.tutorid=t.id where s.scholarship = 3000;

select s.name, t.name from students s join tutor t on s.tutorid=t.id where s.scholarship < 3000;

select s.name, t.name from students s join tutor t on s.tutorid=t.id where s.scholarship is 3000;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

57. Retrieve office name and the number of students for each of them. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

select count (s.name) as numberofstudents, o.name from tutor t join students s on t.id=s.tutoridjoin office o on o.id=t.officeid group by o.name;

select count (s.name) as numberofstudents, o.name from students s on join office o on o.id=s.id group by o.name;

select count (s.name) as numberofstudents, o.name from tutor t join students s on t.id=s.tutoridjoin office o o.id=t.officeid group by o.name;

select count (s.name) as numberofstudents, o.name from tutor t join students s on t.id=s.idjoin office o on o.id=t.id group by o.name;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

56. Retrieve tutors’ name and the number of students for each of them. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

select count (s.name) as numberofstudents, t.name from tutor t join students s on t.id=s.tutoridgroup by t.name;

select count (s.name) as numberofstudents, t.name from tutor t join students s on t.id=s.tutorid;

select count (s.name) as numberofstudents, t.name from tutor t join students s on t.id=s.idgroup by t.name;

select count (s.name) as numberofstudents, t.name from tutor t join students s on t.id=s.id;

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

55. Retrieve all tutors and students names. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

select t.name, s.name from tutor t full join students s on t.id=s.tutorid;

select t.name, s.name from tutor t full join students s t.id=s.tutorid;

select t.name, s.name from tutor t full join students s t.id=s.id;

select t.name, s.name from tutor t full join students s on t.id=s.id;

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever

or continue with

Microsoft

Apple

Others

Already have an account?

Similar Resources on Wayground

60 questions

Name 3D shapes

Quiz

•

1st - 5th Grade

60 questions

Азамат

Quiz

•

1st - 5th Grade

55 questions

Geometry

Quiz

•

1st - 5th Grade

55 questions

Đề Cương Ôn Tập Giữa Kỳ I - Hóa 11

Quiz

•

1st Grade

Popular Resources on Wayground

10 questions

5.P.1.3 Distance/Time Graphs

Quiz

•

5th Grade

10 questions

Fire Drill

Quiz

•

2nd - 5th Grade

20 questions

Equivalent Fractions

Quiz

•

3rd Grade

15 questions

Hargrett House Quiz: Community & Service

Quiz

•

5th Grade

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

20 questions

Inferences

Quiz

•

4th Grade

15 questions

Equivalent Fractions

Quiz

•

4th Grade

Discover more resources for Mathematics

20 questions

Telling Time to the Hour and Half hour

Quiz

•

1st Grade

16 questions

Counting Coins counting money

Quiz

•

1st - 2nd Grade

20 questions

Halves and Fourths

Quiz

•

1st Grade

10 questions

Telling time to the hour and half hour

Quiz

•

1st - 2nd Grade

15 questions

Clocks to the hour and half hour

Quiz

•

1st Grade

20 questions

Graph Review (Bar and Pictograph)

Quiz

•

1st - 2nd Grade

25 questions

Adding by 7 & 8

Quiz

•

KG - 2nd Grade

20 questions

place value

Quiz

•

1st Grade

SQL 1-60

1. Define a degree of a relation

60. Which of the following anomaly does not exist?

59. How many types of anomalies exist?

57. Retrieve office name and the number of students for each of them. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

56. Retrieve tutors’ name and the number of students for each of them. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

55. Retrieve all tutors and students names. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

54. Retrieve office name and tutor name, which have maximum experienced tutors. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.

53. Retrieve information about office and their tutors as well. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutorid (FK references tutor (id))}.d

Access all questions and much more by creating a free account

Similar Resources on Wayground

Popular Resources on Wayground

Discover more resources for Mathematics