ГОС по БД #2

Question 1 of 77

1

Retrieve the lowest experience from tutor. 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 one of the following:

select min (experience) from tutor;
select max (experience) from tutor;
select max (t.experience) from tutor t group by t.name;
select min (t.experience) from tutor t group by t.name;

Explanation

Question 2 of 77

1

Retrieve book name, number of books, price and publisher, for those books which have more than 20 copies. Tables : BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

select count (b.bookid),b.title, b.price, b.publisher_name from book b join book_copies bc on b.bookid=bc.bookid where bc.no_of_copies>20 group by b.title, b.price, b.publisher_name;
select count (b.bookid),b.title, b.price, b.publisher_name from book b join book_copies bc on b.bookid=bc.bookid where bc.no_of_copies>20;
select count (b.bookid),b.title, b.price, b.publisher_name from book b join book bc on b.bookid=bc.bookid where bc.no_of_copies>20 group by b.title, b.price, b.publisher_name;
select b.bookid,b.title, b.price, b.publisher_name from book b join book_copies bc on b.bookid=bc.bookid where bc.no_of_copies>20 group by b.title, b.price, b.publisher_name;

Explanation

Question 3 of 77

1

Retrieve card number, book name, borrower name, who have borrowed in 12 July, bookid (references Book (bookid)), libraryid (references Library (libraryid)), cardno 2013. Tables: BOOK {bookid, title, publisher_name, price}. BOOKLOANS {bookloans, cardno(references Borrower (cardno)),bookid (references Book (bookid)) dateout, duedate}. BORROWER {cardno, c_name, b_address, phoneno}

Select one of the following:

select bl.cardno, b.title, br.c_name from book b join bookloans bl on bl.bookid=b.bookid join borrower br on br.cardno=bl.cardno where bl.dateout='12-07-2013'
select bl.cardno, b.title, br.c_name from book b join bookloans bl on bl.bookid=b.bookid join borrower br on br.cardno=bl.cardno where bl.duedate='12-07-2013'
select bl.cardno, b.title, br.c_name from book b join bookloans bl on bl.bookid=b.bookid where bl.dateout='12-07-2013'
select bl.cardno, b.title, br.c_name from book b join borrower br on br.cardno=bl.cardno where bl.dateout='12-07-2013'

Explanation

Question 4 of 77

1

Retrieve max price for Fariza's publication. BOOK {bookid, title, publisher_name, price}.BOOK_AUTHORS {author_name, bookid (references Book (bookid))}

Select one of the following:

select max (b.price)from book b join book_authors ba on b.bookid=ba.bookid where ba.author_name = 'Fariza';
select max (b.price)from book b join book_authors ba on b.bookid=ba.bookid where ba.author_name = Fariza;
select max (b.price)from book b join book_authors ba b.bookid=ba.bookid where ba.author_name = 'Fariza';
select max (b.price)from book b join book_authors ba on b.bookid=ba.bookid; #subToPewDiePie

Explanation

Question 5 of 77

1

Retrieve book name, total number of book copies. BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

select b.title, sum (no_of_copies) from book b join book_copies bc on b.bookid=bc.bookid group by b.title;
select b.title, sum (no_of_copies) from book b join book_copies bc b.bookid=bc.bookid group by b.title;
select b.title, count(no_of_copies) from book b join book_copies bc on b.bookid=bc.bookid group by b.title;
select b.title, count(no_of_copies) from book b join book_copies bc b.bookid=bc.bookid group by b.title;

Explanation

Question 6 of 77

1

Retrieve book title and total number of book copies, which has id 1. BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

select b.title, sum (no_of_copies) from book b join book_copies bc on b.bookid=bc.bookid where b.bookid=1 group by b.title;
select b.title, sum (no_of_copies) from book b join book_copies bc on b.bookid=bc.bookid where b.bookid=1;
select b.title, count (no_of_copies) from book b join book_copies bc on b.bookid=bc.bookid where b.bookid=1 group by b.title;
select b.title, count (no_of_copies) from book b join book_copies bc on b.bookid=bc.bookid where b.bookid=1;

Explanation

Question 7 of 77

1

Retrieve borrower name and number of books that each borrower has. BOOKLOANS {bookloans, bookid (references Book (bookid)), libraryid (references Library (libraryid)), cardno (references Borrower (cardno)), dateout, duedate}. BORROWER {cardno, c_name, b_address, phoneno}

Select one of the following:

select br.c_name, count(bl.bookid) from borrower br join bookloans bl on br.cardno = bl.cardno group by br.c_name;
select br.c_name, count(bl.bookid) from borrower br join bookloans bl on br.cardno = bl.cardno;
select br.c_name, sum(bl.bookid) from borrower br join bookloans bl on br.cardno = bl.cardno group by br.c_name;
select br.c_name, sum(bl.bookid) from borrower br join bookloans bl on br.cardno = bl.cardno;

Explanation

Question 8 of 77

1

Retrieve books name and prices. Increase price twice more for books, which have more than 20 copies;BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

select b.title, b.price, b.price *2 as increasedprice from book b join book_copies bc on bc.bookid=b.bookid where bc.no_of_copies > 20;
select b.title, b.price book b join book_copies bc on bc.bookid=b.bookid where bc.no_of_copies > 20;
impossible to solve
select b.title, b.price, b.price *2 as increasedprice from book b join book_copies bc on bc.bookid=b.bookid;

Explanation

Question 9 of 77

1

Retrieve library name, book name, number of copies, which have more than 25 copies. BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}. LIBRARY (libraryid)), cardno (references Borrower (cardno)), dateout, duedate}.

Select one of the following:

select l.libraryname, b.title, bc.no_of_copies from book b join book_copies bc on b.bookid=bc.bookid join library l on l.libraryid = bc.libraryid where bc.no_of_copies>25;
select l.libraryname, b.title, bc.no_of_copies from book b join book_copies bc on b.bookid=bc.bookid where bc.no_of_copies>25;
select l.libraryname, b.title, bc.no_of_copies from book join library l on l.libraryid = bc.libraryid where bc.no_of_copies>25;
select l.libraryname, b.title, bc.no_of_copies from book b join book_copies bc on b.bookid=bc.bookid join library l l.libraryid = bc.libraryid where bc.no_of_copies>25;

Explanation

Question 10 of 77

1

Retrieve the number of departments in the department table. Tables: DEPARTMENT {id, name}. EMPLOYEE {id, name, salary, dep_id (references Department (id))}

Select one of the following:

select count(id) from department
select sum (id) from department;
select coun(id) from department
select id from department

Explanation

Question 11 of 77

1

Retrieve total salaries payable to employee. Tables: DEPARTMENT {id, name}. EMPLOYEE {id, name, salary, dep_id (references Department (id))}

Select one of the following:

select sum (salary) from employee;
select count (salary) from employee;
select sum (id) from employee;
select max (salary) from employee;

Explanation

Question 12 of 77

1

Retrieve office name and tutor name, who have experience equal or more than five years. 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 one of the following:

select o.name, t.name from office o join tutor t on o.id=t.officeid where t.experience >=5;
select o.name, t.name from office o join tutor t on o.id=t.officeid where t.experience >5;
select o.name, t.name from office o join tutor t o.id=t.officeid where t.experience >=5;
select o.name, t.name from office join tutor on o.id=t.officeid where t.experience >=5;

Explanation

Question 13 of 77

1

Retrieve tutor name and their office locations, who refer to CSSE and Management. 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 one of the following:

select t.name, o.locations from office o join tutor t on o.id=t.officeid where o.name in ('CSSE', 'Management');
select t.name, o.locations from office o join tutor t on o.id=t.officeid where o.name in ('CSSE' or 'Management');
select t.name, o.locations from office o join tutor t o.id=t.officeid where o.name in ('CSSE', 'Management');
select t.name, o.locations from office o join tutor t on o.id=t.officeid where o.name in ('CSSE') or ('Management');

Explanation

Question 14 of 77

1

Retrieve student's name, which starts from A. 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 one of the following:

select name from students where name like 'A_%';
select name from students where name like 'A';
select name from students where name like 'a%';
select name from students where name like '%A%'

Explanation

Question 15 of 77

1

Retrieve all students name with the department name, but excluding department CSSE. 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 one of the following:

select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where o.name <> 'CSSE';
select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid;
select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where o.name = 'CSSE';
select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid group by o.name, s.name;

Explanation

Question 16 of 77

1

Which of the following query is incorrect for retrieving all students name with the department name, but excluding department CSSE. 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 one of the following:

select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where o.name <= 'CSSE';
select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where o.name <> 'CSSE';
select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where o.name not like 'CSSE';
select s.name, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where o.name not in ('CSSE');

Explanation

Question 17 of 77

1

Retrieve students name, scholarship and their office name, who have scholarship ranging from 3200 to 4500.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 one of the following:

select s.name, s.scholarship, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where s.scholarship between 3200 and 4500;
select s.name, s.scholarship, o.name from students s join tutor t on t.id=s.tutorid where s.scholarship between 3200 and 4500;
select s.name, s.scholarship, o.name from students join office o on o.id=t.officeid where s.scholarship between 3200 and 4500;
select s.name, s.scholarship, o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid where s.scholarship 3200 and 4500;

Explanation

Question 18 of 77

1

What kind symbol is used to find one character in wildcards?

Select one of the following:

-
?
$
in

Explanation

Question 19 of 77

1

Find an average scholarship of students. Tables: STUDENTS {id (PK), name, scholarship, registereddate, tutorid }

Select one of the following:

select avg (scholarship) from students ;
select averg (scholarship) from students ;
select avrg (scholarship) from students ;
select av (scholarship) from students ;

Explanation

Question 20 of 77

1

Retrieve average scholarship of students for each department. 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 one of the following:

select avg (scholarship), o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid group by o.name;
select avg (scholarship), o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid ;
select avg (scholarship), o.name from students s join tutor t on t.id=s.tutorid group by o.name;
select avg (scholarship), o.name from students s d join office o on o.id=t.officeid group by o.name;

Explanation

Question 21 of 77

1

Retrieve student number in each department. 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 one of the following:

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

Explanation

Question 22 of 77

1

Retrieve student number in each department. 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 one of the following:

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

Explanation

Question 23 of 77

1

Retrieve total amount of scholarship of each department. 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 one of the following:

select sum (scholarship), o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid group by o.name;
select count (scholarship), o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid group by o.name;
select sum (scholarship), o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid;
select count (scholarship), o.name from students s join tutor t on t.id=s.tutorid join office o on o.id=t.officeid;

Explanation

Question 24 of 77

1

SQL stands for

Select one of the following:

Sequence Question Language
Structured Query Language
Structured Querty Language
Selection Query Language

Explanation

Question 25 of 77

1

You can add a row using SQL in a database with which of the following

Select one of the following:

ADD
CREATE
INSERT
UPDATE

Explanation

Question 26 of 77

1

The command to remove rows from a table “Customer”

Select one of the following:

Remove from Customer
Delete from Customer
Drop from Customer
Update row from Customer

Explanation

Question 27 of 77

1

The SQL WHERE clause

Select one of the following:

Condition that limits the column data that are returned
Condition that limits the row data are returned
Clause that returns all rows
Clause that returns nothing

Explanation

Question 28 of 77

1

The command to eliminate a table from a database

Select one of the following:

Drop
Delete
Remove
Update

Explanation

Question 29 of 77

1

Which of the following is correct order of keywords for SQL Select statement?

Select one of the following:

SELECT, FROM, WHERE
WHERE, FROM, SELECT
FROM, WHERE, SELECT
SELECT, WHERE, FROM

Explanation

Question 30 of 77

1

SQL data definition commands make up a(n)

Select one of the following:

DDC
DML
DDL
DDD

Explanation

Question 31 of 77

1

In a relation, the columns are also called attributes

Select one of the following:

True
False

Explanation

Question 32 of 77

1

Find the SQL statement that is equal to: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Select one of the following:

SELECT NAME IN CUSTOMER WHERE STATE IN 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'VA';
SELECT NAME FROM CUSTOMER WHERE STATE IN 'VA';
SELECT NAME IN CUSTOMER WHERE STATE = 'V';

Explanation

Question 33 of 77

1

In E\R diagrams, we will represent Entities as

Select one of the following:

Boxes with rounded corners
Links between two entities
Ovals
Diamond box

Explanation

Question 34 of 77

1

In E\R diagrams, we will represent Relationships as

Select one of the following:

Boxes with rounded corners
Links between two entities
Ovals
Diamond box

Explanation

Question 35 of 77

1

In E\R diagrams, we will represent Attributes as

Select one of the following:

Boxes with rounded corners
Links between two entities
Ovals
Diamond box

Explanation

Question 36 of 77

1

Many to many relationships are difficult to represent in database, so we need to

Select one of the following:

Split many to many relationship into two one to many relationships
Split one to many relationship into two one to many relationships
Split many to many relationship into one to many relationships
Split many to many relationship into three one to many relationships

Explanation

Question 37 of 77

1

The result of a SQL SELECT statement is a(n)

Select one of the following:

Report
Table
Form
File

Explanation

Question 38 of 77

1

Which of the following are the five built-in functions provided by SQL?

Select one of the following:

COUNT, SUM, AVG, MAX, MULT
SUM, AVG, MIN, MAX, NAME
SUM, AVG, MULT, DIV, MIN
COUNT, SUM, AVG, MAX, MIN

Explanation

Question 39 of 77

1

In a relation, the order of the rows matters

Select one of the following:

True
False

Explanation

Question 40 of 77

1

Given the functional dependency R → (S,T) , then it is also true that R → S

Select one of the following:

True
False

Explanation

Question 41 of 77

1

Given the functional dependency R → (S,T) , then it is also true that R → T

Select one of the following:

True
False

Explanation

Question 42 of 77

1

SQL can be used to

Select one of the following:

create database structures only
query database data only
modify database data only
All of the these can be done by SQL

Explanation

Question 43 of 77

1

The SQL statement that queries or reads data from a table is _

Select one of the following:

READ
QUERY
SELECT
NONE

Explanation

Question 44 of 77

1

A subquery in an SQL SELECT statement

Select one of the following:

can only be used with two tables
has a distinct form that cannot be duplicated by a join
can always be duplicated by a join
cannot have its results sorted using ORDER BY

Explanation

Question 45 of 77

1

The SQL keyword BETWEEN is used

Select one of the following:

for ranges
as a wildcard
to limit the columns displayed
None of the above

Explanation

Question 46 of 77

1

Sometimes you want to change the structure of an existing table, what are your options?

Select one of the following:

Change table
Drop Table
Alter Table
Create Table

Explanation

Question 47 of 77

1

how to Add a new column into existing table?

Select one of the following:

ALTER TABLE Student MODIFY COLUMN sDegree CHAR(64) NOT NULL
ALTER TABLE Student ADD COLUMN sDegree VARCHAR(64) NOT NULL
ALTER TABLE S ADD COLUMN s VACHAR(64) NOT NULL
ALTER TABLE Student DROP COLUMN sDegree VARCHAR(64) NOT NULL

Explanation

Question 48 of 77

1

how to rename a column in existing table?

Select one of the following:

ALTER TABLE Student MODIFY COLUMN sDegree CHAR(64) NOT NULL
ALTER TABLE Student ADD COLUMN sDegree VARCHAR(64) NOT NULL
ALTER TABLE Student RENAME COLUMN s to SS VACHAR(64) NOT NULL
ALTER TABLE Student DROP COLUMN sDegree VARCHAR(64) NOT NULL

Explanation

Question 49 of 77

1

how to change the row(s) in a table

Select one of the following:

insert
update
change
delete

Explanation

Question 50 of 77

1

how to remove the row(s) from a table

Select one of the following:

insert
update
change
delete

Explanation

Question 51 of 77

1

A SELECT statement can be nested inside another query to form a

Select one of the following:

Subselect
Subresults
Subquery
Query in query

Explanation

Question 52 of 77

1

SQL uses privileges to control access to tables and other database objects, so which is NOT?

Select one of the following:

Select privilege
Update privilege
Insert privilege
Drop privilege

Explanation

Question 53 of 77

1

To convert any relation into _______, split any nonatomic values

Select one of the following:

First normal form
Second normal form
Third normal form
Fourth normal form

Explanation

Question 54 of 77

1

A functional dependency (FD) is a

Select one of the following:

link between three sets of attributes in a relation
link between all sets of attributes in a relation
link between four sets of attributes in a relation
link between two sets of attributes in a relation

Explanation

Question 55 of 77

1

which if the following does not refer to redundancy problems?

Select one of the following:

INSERT anomalies
CREATE anomalies
UPDATE anomalies
DELETE anomalies

Explanation

Question 56 of 77

1

To convert any relation into _______, remove transitive dependency

Select one of the following:

First normal form
Second normal form
Third normal form
Fourth normal form

Explanation

Question 57 of 77

1

What is it ?

Select one of the following:

Relation
Tuples
Attributes
Relationships

Explanation

Question 58 of 77

1

What is it ?

Select one of the following:

Relation
Tuples
Attributes
Relationships

Explanation

Question 59 of 77

1

What is it ?

Select one of the following:

Relation
Tuples
Attributes
Relationships

Explanation

Question 60 of 77

1

Choose the correct relational algebra operation

Select one of the following:

Union
Difference
Itersection
Product

Explanation

Question 61 of 77

1

Choose the correct relational algebra operation

Select one of the following:

Union
Difference
Intersection
Product

Explanation

Question 62 of 77

1

Choose the correct relational algebra operation

Select one of the following:

Difference
Union
Intersection
Product

Explanation

Question 63 of 77

1

Choose the correct relational algebra operation

Select one of the following:

Union
Difference
Intersection
Product

Explanation

Question 64 of 77

1

Are given table union compatible ?

Select one of the following:

yes
no

Explanation

Question 65 of 77

1

Which of the following is not correct?
INSERT INTO Employee(ID, Name, Salary) VALUES

Select one of the following:

INSERT INTO Employee(ID, Name, Salary) VALUES(2,‘Mary’,26);
INSERT INTO Employee (Name,ID) VALUES (‘Mary’,2);
INSERT INTO Employee VALUES (2, ‘Mary’,26000);
INSERT INTO Employe VALUES(26, ‘Mary’,26);

Explanation

Question 66 of 77

1

Please increase salary for 10%?

Select one of the following:

UPDATE Employee SET Salary = Salary*0.5
UPDATE Employee SET Salary = Salary * 0.1
UPDATE Employee SET Salary = Salary * 1.1
UPDATE Employee Update Salary = Salary*0.1

Explanation

Question 67 of 77

1

Please remove staff, who earns more than 22000?

Select one of the following:

DELETE FROM Employee WHERE Salary >=22000
DELETE FROM Employe WHERE Salary => 22000;
REMOVE FROM Employee WHERE Salary >22000;
DELETE FROM Employee WHERE Salary = 22000;

Explanation

Question 68 of 77

1

πsName,sAddress(Student) is equal to?

Select one of the following:

SELECT Sname FROM Students
SELECT Sname, SAddress FORM Students
SELECT Sname and SAddress FROM Students
SELECT Sname, SAddress FROM Student

Explanation

Question 69 of 77

1

SQL query to find a list of the ID numbers and Marks for students who have passed IAI

Select one of the following:

Select ID, Mark from Grade Where code = 'IAI' and Mark > 50;
Select ID, Mark from Grade Where code = 'AIA' and Mark > 50;
Select ID, Mark, Code from Grade Where code = 'IAI';
Select ID, Mark from Grade Where code = 'IAI' and Mark >=50;

Explanation

Question 70 of 77

1

Find students who studying any Programming module

Select one of the following:

Select First,Last from Student,Grade Where Code='PR1'OR'PR2'
Select First,Last from Student Natural Join Grade Where Code like'PR%'
Select First Last from Student Natural Join Grade Where Code like'PR%'
Select First from Student Natural Join Grade Where Code = 'PR%'

Explanation

Question 71 of 77

1

How to use privileges in SQL?

Select one of the following:

ON<objects> TO<users> GRANT<privileges>
GRANT<privileges> ON<objects> TO<users>
GRANT<privileges> TO<users> ON<objects>
GRANT<tables> ON<objects> TO<users>

Explanation

Question 72 of 77

1

If Admin’ grants ALL privileges to ‘Manager’, and SELECT to ‘Finance’ with grant option, So..

Select one of the following:

‘Manager’ grants ALL to ‘Personnel’
‘Manager’ grants SELECT to ‘Personnel’
‘Finance’ grants SELECT to ‘Manager’
‘Finance’ grants ALL to ‘Manager’

Explanation

Question 73 of 77

1

If Admin’ grants ALL privileges to ‘Manager’, and SELECT to ‘Finance’ with grant option, So..

Select one of the following:

‘Finance’ grants SELECT to ‘Personnel’
‘Manager’ grants SELECT to ‘Personnel’
‘Finance’ grants SELECT to ‘Manager’
‘Finance’ grants ALL to ‘Manager’

Explanation

Question 74 of 77

1

If ‘Manager’ revokes ALL from ‘Personnel’

Select one of the following:

‘Personnel’ still has ALL privileges from ‘Finance’
‘Finance’ still has SELECT privileges from ‘Personnel’
‘Personnel’ still has SELECT privileges from ‘Finance’
‘Admin’ still has ALL privileges from ‘Finance’

Explanation

Question 75 of 77

1

If ‘Finance revokes SELECT from ‘Personnel’

Select one of the following:

‘Personnel’ still has ALL privileges from ‘Finance’
‘Finance’ still has SELECT privileges from ‘Personnel’
‘Personnel’ still has ALL privileges from ‘Manager’
‘Admin’ still has ALL privileges from ‘Finance’

Explanation

Question 76 of 77

1

If ‘Admin’ revokes Select from ‘Finance’

Select one of the following:

‘Personnel’ still has ALL privileges from ‘Finance’
‘Finance’ still has SELECT privileges from ‘Personnel’
‘Personnel’ still has ALL privileges from ‘Manager’
‘Admin’ still has ALL privileges from ‘Finance’

Explanation

Question 77 of 77

1

If ‘Admin’ revokes ALL from ‘Manager’

Select one of the following:

‘Personnel’ still has ALL privileges from ‘Finance’
‘Finance’ still has SELECT privileges from ‘Personnel’
‘Finance still has SELECT privileges from ‘Admin’
‘Admin’ still has ALL privileges from ‘Finance’

	Created by хомяк убийца over 5 years ago

God Philosophy Quiz on ГОС по БД #2, created by хомяк убийца on 23/03/2019.

ГОС по БД #2

Question 1 of 77

Retrieve the lowest experience from tutor. 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 one of the following:

Explanation

Question 2 of 77

Retrieve book name, number of books, price and publisher, for those books which have more than 20 copies. Tables : BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

Explanation

Question 3 of 77

Select one of the following:

Explanation

Question 4 of 77

Retrieve max price for Fariza's publication. BOOK {bookid, title, publisher_name, price}.BOOK_AUTHORS {author_name, bookid (references Book (bookid))}

Select one of the following:

Explanation

Question 5 of 77

Retrieve book name, total number of book copies. BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

Explanation

Question 6 of 77

Retrieve book title and total number of book copies, which has id 1. BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

Explanation

Question 7 of 77

Retrieve borrower name and number of books that each borrower has. BOOKLOANS {bookloans, bookid (references Book (bookid)), libraryid (references Library (libraryid)), cardno (references Borrower (cardno)), dateout, duedate}. BORROWER {cardno, c_name, b_address, phoneno}

Select one of the following:

Explanation

Question 8 of 77

Retrieve books name and prices. Increase price twice more for books, which have more than 20 copies;BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}

Select one of the following:

Explanation

Question 9 of 77

Retrieve library name, book name, number of copies, which have more than 25 copies. BOOK {bookid, title, publisher_name, price}. BOOKCOPIES {bookid, libraryid,noOfCopies [references Book (bookid)]}. LIBRARY (libraryid)), cardno (references Borrower (cardno)), dateout, duedate}.

Select one of the following:

Explanation

Question 10 of 77

Retrieve the number of departments in the department table. Tables: DEPARTMENT {id, name}. EMPLOYEE {id, name, salary, dep_id (references Department (id))}

Select one of the following:

Explanation

Question 11 of 77

Retrieve total salaries payable to employee. Tables: DEPARTMENT {id, name}. EMPLOYEE {id, name, salary, dep_id (references Department (id))}

Select one of the following:

Explanation

Question 12 of 77

Retrieve office name and tutor name, who have experience equal or more than five years. 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 one of the following:

Explanation

Question 13 of 77

Retrieve tutor name and their office locations, who refer to CSSE and Management. 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 one of the following:

Explanation

Question 14 of 77

Retrieve student's name, which starts from A. 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 one of the following:

Explanation

Question 15 of 77

Retrieve all students name with the department name, but excluding department CSSE. 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 one of the following:

Explanation

Question 16 of 77

Select one of the following:

Explanation

Question 17 of 77

Select one of the following:

Explanation

Question 18 of 77

What kind symbol is used to find one character in wildcards?

Select one of the following:

Explanation

Question 19 of 77

Find an average scholarship of students. Tables: STUDENTS {id (PK), name, scholarship, registereddate, tutorid }

Select one of the following:

Explanation

Question 20 of 77

Retrieve average scholarship of students for each department. 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 one of the following:

Explanation

Question 21 of 77