Copiar e Editar

ГОС по БД #1

Descrição

God Philosophy Quiz sobre ГОС по БД #1, criado por хомяк убийца em 23-03-2019.
хомяк убийца
Quiz por хомяк убийца, atualizado more than 1 year ago
хомяк убийца
Criado por хомяк убийца aproximadamente 5 anos atrás
1578
20
0

Resumo de Recurso

Questão 1

Questão
Define a degree of a relation
Responda
  • 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

Questão 2

Questão
Define a cardinality of a relation
Responda
  • how long each tuple is
  • how many columns the table has
  • how many different tuples there are, how many rows a table has
  • how many different datatypes table has

Questão 3

Questão
Which of the following refers to union-compatibility requirements ?
Responda
  • Same number of columns
  • Same number of rows
  • Same number of tuples
  • Different domains

Questão 4

Questão
Which of the following refers to union-compatibility requirements ?
Responda
  • Corresponding columns have the same domains
  • Same number of rows
  • Same number of tuples
  • Corresponding columns have the same fields

Questão 5

Questão
Define a domain
Responda
  • restrict the possible values a tuple can assign to each attribute
  • relations to each other
  • uniquely identifies each tuple that appears in a relation
  • minimality of the attribute

Questão 6

Questão
Define a foreign key
Responda
  • restrict the possible values a tuple can assign to each attribute
  • relations to each other
  • uniquely identifies each tuple that appears in a relation
  • minimality of the attribute

Questão 7

Questão
Define a primary key
Responda
  • restrict the possible values a tuple can assign to each attribute
  • relations to each other
  • uniquely identifies each tuple that appears in a relation
  • datatypes of attributes

Questão 8

Questão
Define restrict
Responda
  • stop the user from doing it
  • let the changes flow on
  • make referencing values the default for their column
  • make referencing values null

Questão 9

Questão
Define cascade
Responda
  • stop the user from doing it
  • let the changes flow on
  • make referencing values the default for their column
  • make referencing values null

Questão 10

Questão
Define set default
Responda
  • stop the user from doing it
  • let the changes flow on
  • make referencing values the default for their column
  • make referencing values null

Questão 11

Questão
Define set null
Responda
  • stop the user from doing it
  • let the changes flow on
  • make referencing values the default for their column
  • make referencing values null

Questão 12

Questão
Define Data Definition Language
Responda
  • Specify database format
  • Specify access controls (privileges)
  • Specify and retrieve database contents
  • Specify table attribute uniqueness

Questão 13

Questão
Define Data Control Language
Responda
  • Specify access controls (privileges)
  • Specify database format
  • Specify and retrieve database contents
  • Specify table attribute uniqueness

Questão 14

Questão
Define Data Manipulation Language
Responda
  • Specify table attribute uniqueness
  • Specify database format
  • Specify access controls (privileges)
  • Specify and retrieve database contents

Questão 15

Questão
Which of the following does not refer to DBMS tools
Responda
  • Oracle
  • PostgreSQL
  • MySQL
  • Python

Questão 16

Questão
Which of the following is used to provide privilege to only a particular attribute?
Responda
  • Grant select on employee to finance
  • Grant update(salary, rate) on employee to finance
  • Grant update(salary) on employee to finance
  • Grant delete to finance

Questão 17

Questão
Which of the following statement is used to remove the privilege from the user finance?
Responda
  • Remove update on employee from finance
  • Delete select on employee from finance
  • Revoke update on employee from finance
  • Grant update on employee from finance

Questão 18

Questão
Which of the following is true regarding views?
Responda
  • 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.
  • If a user creates a view on which no authorization can be granted, the system will allow the view creation request.
  • A user who creates a view receives all privileges on that view.

Questão 19

Questão
If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.
Responda
  • With grant
  • Grant user
  • With grant option
  • Grant pass privelege

Questão 20

Questão
Which of the following is used to avoid cascading of authorizations from the user?
Responda
  • Granted by current role
  • Revoke grant option for select on department from finance;
  • Revoke select on employee from finance, cashier restrict;
  • Revoke select on department from finance, cashier cascade;

Questão 21

Questão
Privileges are granted over some specified parts of a database, such as a
Responda
  • Schema
  • Environment
  • Relation Or view
  • Query statement

Questão 22

Questão
Prevention of access to the database by unauthorized users is referred to as:
Responda
  • Integrity
  • Productivity
  • Security
  • Reliability

Questão 23

Questão
Database Authentication refers to:
Responda
  • methods of restricting user access to system
  • controlling access to portions of database
  • all of the answers mentioned
  • controlling the operation on the data

Questão 24

Questão
A set of possible data values is called
Responda
  • attribute
  • degree
  • domain
  • tuple

Questão 25

Questão
A functional dependency between two or more non-key attributes is called
Responda
  • Partial transitive dependency
  • Functional dependency
  • Transitive dependency
  • Partial functional dependency

Questão 26

Questão
__ refers to the correctness and completeness of the data in a database.
Responda
  • Database security
  • Data constraint
  • Data integrity
  • Data independence

Questão 27

Questão
Which of the following creates a virtual relation for storing the query?
Responda
  • Function
  • Procedure
  • View
  • None of the mentioned

Questão 28

Questão
Which of the following is the syntax for views where v is view name?
Responda
  • Create view v as “query name”;
  • Create “query expression” as view;
  • Create view v as “query expression”;
  • Create view “query expression”;

Questão 29

Questão
Updating the value of the view
Responda
  • Will not change the view definition
  • Will not affect the relation from which it is defined
  • Will affect the relation from which it is defined
  • Cannot determine

Questão 30

Questão
Create view faculty as: Select ID, name, dept name from instructor; Find the error in this query.
Responda
  • Instructor
  • Select
  • None of the mentioned
  • View …as

Questão 31

Questão
Which of the following is a basic form of grant statement?
Responda
  • Grant ‘privilege list’ on ‘user/role list’ to ‘relation name or view name’;
  • Grant ‘privilege list’ to ‘user/role list’;
  • Grant ‘privilege list’ on ‘relation name or view name’ to ‘user/role list’;
  • Grant ‘privilege list’ on ‘relation name or view name’ on ‘user/role list’;

Questão 32

Questão
Retrieve all data from the table OFFICE { id,room, name}
Responda
  • Select *from office;
  • Select from office;
  • Select name from office;
  • Select *form office;

Questão 33

Questão
Retrieve office name from the table OFFICE {id, room, name}
Responda
  • Select *from office;
  • Select from office;
  • Select name from office;
  • Select *form office;

Questão 34

Questão
Retrieve office id from the table OFFICE {id, room, name}
Responda
  • Select *from office;
  • Select id from office;
  • Select name from office;
  • Select id form office;

Questão 35

Questão
Retrieve office id and room from the table OFFICE {id, room, name}
Responda
  • Select *from office;
  • Select id, room from office;
  • Select room name from office;
  • Select id form office;

Questão 36

Questão
Retrieve quantity of offices in the office table - OFFICE {id, rom, name}
Responda
  • Select avg (id) from office;
  • Select count (id) from office;
  • Select sum (id) from office;
  • Select max (id) from office;

Questão 37

Questão
Retrieve total number scholarship in the students table – STUDENTS {id, name, scholarship, registereddate, tutorid}
Responda
  • Select avg (scholarship) from office;
  • Select count (scholarship) from office;
  • Select sum (scholarship) from office;
  • Select max (scholarship) from office;

Questão 38

Questão
Retrieve quantity of students in the students table – STUDENTS {id, name, scholarship, registereddate, tutorid}
Responda
  • Select avg (id) from office;
  • Select count (id) from office;
  • Select sum (id) from office;
  • Select max (id) from office;

Questão 39

Questão
Sort students name by descending order - STUDENTS {id, name, scholarship, registereddate, tutorid}
Responda
  • 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;

Questão 40

Questão
Find an average scholarship of students - STUDENTS {id, name, scholarship, registereddate, tutorid}
Responda
  • Select avg (scholarship) from students;
  • Select count (scholarship) from students;
  • Select sum (scholarship) from students;
  • Select max (scholarship) from students;

Questão 41

Questão
Find maximum scholarship of students - STUDENTS {id, name, scholarship, registereddate, tutorid}
Responda
  • Select avg (scholarship) from students;
  • Select count (scholarship) from students;
  • Select sum (scholarship) from students;
  • Select max (scholarship) from students;

Questão 42

Questão
Find minimum scholarship of students - STUDENTS {id, name, scholarship, registereddate, tutorid}
Responda
  • Select avg (scholarship) from students;
  • Select count (scholarship) from students;
  • Select min (scholarship) from students;
  • Select max (scholarship) from students;

Questão 43

Questão
Retrieve offices’ name and tutors’, who work in CSSE 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))}.
Responda
  • Select o.name, t.name from office o join tutor t on o.id=t.officeid where o.name = ‘CSSE’
  • Select o.name, t.name from office o join tutor t on o.id=t.id where o.name = ‘CSSE’
  • Select o.name, t.name from office o join tutor t on o.id=t.officeid where o.name = ‘csse’
  • Select o.name, t.name from office o join tutor t on o.id=t.officeid where o.name ‘CSSE’

Questão 44

Questão
Retrieve all offices’ name and tutors’, who work in departments. 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))}.
Responda
  • Select o.name, t.name from office o left join tutor t on o.id=t.officeid;
  • Select o.name, t.name from office o left join tutor t on o.id=t.id ;
  • Select o.name, t.name from office o right join tutor t on o.id=t.officeid;
  • Select o.name, t.name from office o right join tutor t on o.id=t.id ;

Questão 45

Questão
Retrieve students’ name, who have more than average scholarship. 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))}.
Responda
  • select s.name from students s where s.scholarship > (select avg (scholarship)from students);
  • select s.name from students s where s.scholarship > (select scholarship from students);
  • select s.name from students s where s.scholarship > avg (scholarship);
  • select s.name from students s where s.scholarship < avg (scholarship);

Questão 46

Questão
Retrieve students’ name, who registered in 10th of Jan 2016. Tables: STUDENTS {id (PK), name, scholarship, registereddate, tutorid }.
Responda
  • 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';

Questão 47

Questão
Retrieve tutors’ name, who have more than experience others along with their students name . 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))}.
Responda
  • select t.name, s.name from tutor t join students s on t.id=s.tutorid where experience = (select max (experience) from tutor);
  • select t.name, s.name, max(experience) from tutor t join students s on t.id=s.tutorid;
  • select t.name, s.name from tutor t join students s on t.id=s.id where experience = (select max (experience) from tutor);

Questão 48

Questão
Retrieve tutors’ name, who have less experience than others along with their students name. 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))}.
Responda
  • select t.name, s.name from tutor t join students s on t.id=s.tutorid where experience = (select min (experience) from tutor);
  • select t.name, s.name, min(experience) from tutor t join students s on t.id=s.tutorid;
  • select t.name, s.name from tutor t join students s on t.id=s.id where experience = (select min (experience) from tutor);

Questão 49

Questão
Increase tutors experience and students’ scholarship twice. Retrieve experience and scholarship along with their 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))}.
Responda
  • select t.name,t.experience*2, s.name, s.scholarship*2 from tutor t join students s on t.id=s.tutorid;
  • select t.name,t.experience*2, s.name, s.scholarship*2 from tutor t join students s on t.id=s.id;
  • select t.name,t.experience*2, s.name, s.scholarship*2 from tutor t join tutor s on t.id=s.tutorid;
  • select t.name,t.experience*2, s.name, s.scholarship*2 from tutor t join tutor s on t.id=s.id;

Questão 50

Questão
Retrieve office, tutor and students name, but tutors name should have y value. 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))}.
Responda
  • select o.name, t.name, st.name from tutor t join office o on o.id=t.officeid join students st on t.id=st.tutorid where t.name like '%y%';
  • select o.name, t.name, st.name from tutor t join office o o.id=t.officeid join students st on t.id=st.tutorid where t.name like '%y%';
  • select o.name, t.name, st.name from tutor t join office o on o.id=t.officeid join students st t.id=st.tutorid where t.name like '%y%';
  • select o.name, t.name, st.name from tutor t join office o on o.id=t.officeid join students st on t.id=st.id where t.name like '%y%';

Questão 51

Questão
Retrieve office, tutor and students name, but tutors name should not have y value. Tables: OFFICE {id (PK), locations, name}, TUTOR {id (PK), name, officeid (FK references office (id)), experience}, STUDENTS {id (PK), name, scholarship, registereddate, tutored (FK references tutor (id))}.
Responda
  • select o.name, t.name, st.name from tutor t join office o on o.id=t.officeid join students st on t.id=st.tutorid where t.name not like '%y%';
  • select o.name, t.name, st.name from tutor t join office o o.id=t.officeid join students st on t.id=st.tutorid where t.name not like '%y%';
  • select o.name, t.name, st.name from tutor t join office o on o.id=t.officeid join students st t.id=st.tutorid where t.name not like '%y%';
  • select o.name, t.name, st.name from tutor t join office o on o.id=t.officeid join students st on t.id=st.id where t.name not like '%y%';

Questão 52

Questão
Retrieve students name and scholarship along with their department name, who have scholarship between 4000 and 5000. 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))}.
Responda
  • select s.name, s.scholarship, o.name from office o join tutor t on o.id=t.officeid join students s on t.id=s.tutorid where s.scholarship between 4000 and 5000;
  • select s.name, s.scholarship, o.name from office o join tutor t on o.id=t.officeid join students s on t.id=s.tutorid where s.scholarship 4000 and 5000;
  • select s.name, s.scholarship, o.name from tutor t join students s on t.id=s.tutorid where s.scholarship between 4000 and 5000;
  • select s.name, s.scholarship, o.name from tutor t join students s on t.id=s.tutorid where s.scholarship >=4000

Questão 53

Questão
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
Responda
  • select *from office o join tutor t on o.id=t.officeid;
  • select *from office o join tutor t in o.id=t.officeid;
  • select *form office o join tutor t on o.id=t.officeid;
  • select *from office o join tutor t on o.id=t.id;

Questão 54

Questão
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))}.
Responda
  • select o.name, t.name from office o join tutor t on o.id=t.officeid where t.experience = (select max (experience) from tutor);
  • select o.name, t.name from office o join tutor t on o.id=t.officeid where t.experience = (select min (experience) from tutor);
  • select o.name, t.name from office o join tutor t on o.id=t.officeid where t.experience = (select high (experience) from tutor);
  • select o.name, t.name from office o join tutor t on o.id=t.officeid where t.experience = (select low (experience) from tutor);

Questão 55

Questão
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))}.
Responda
  • 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;

Questão 56

Questão
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))}.
Responda
  • 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;

Questão 57

Questão
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))}.
Responda
  • 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;

Questão 58

Questão
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))
Responda
  • 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;

Questão 59

Questão
How many types of anomalies exist?
Responda
  • 1
  • 2
  • 3
  • 4

Questão 60

Questão
Which of the following anomaly does not exist?
Responda
  • Creation anomaly
  • Deletion anomaly
  • Insertion anomaly
  • Modification anomaly

Questão 61

Questão
When an insertion anomaly occurs?
Responda
  • we are prevented from inserting some data into a relation until other data can be supplied
  • deletion leads to an unintended loss of data
  • it is possible that not all data needs to be changed will always be changed
  • it does not occur

Questão 62

Questão
When a modification anomaly occurs?
Responda
  • it is possible that not all data needs to be changed will always be changed
  • we are prevented from inserting some data into a relation until other data can be supplied
  • deletion leads to an unintended loss of data
  • it does not occur

Questão 63

Questão
When a deletion anomaly occurs?
Responda
  • deletion leads to an unintended loss of data
  • it is possible that not all data needs to be changed will always be changed
  • we are prevented from inserting some data into a relation until other data can be supplied
  • it does not occur

Questão 64

Questão
Define inner join
Responda
  • selects all rows from both tables as long as there is a match between the columns in both tables
  • returns all rows from the left table (1), with the matching rows in the right table (2)
  • returns all rows from the right table (2), with the matching rows in the right table (1)
  • returns all rows from the left table (1) and from the right table (2)

Questão 65

Questão
Define left join
Responda
  • returns all rows from the left table (1), with the matching rows in the right table (2)
  • selects all rows from both tables as long as there is a match between the columns in both tables
  • returns all rows from the right table (2), with the matching rows in the right table (1)
  • returns all rows from the left table (1) and from the right table (2)

Questão 66

Questão
Define right join
Responda
  • returns all rows from the right table (2), with the matching rows in the left table (1)
  • returns all rows from the left table (1), with the matching rows in the right table (2)
  • selects all rows from both tables as long as there is a match between the columns in both tables
  • returns all rows from the left table (1) and from the right table (2)

Questão 67

Questão
Define full join
Responda
  • returns all rows from the left table (1) and from the right table (2)
  • returns all rows from the right table (2), with the matching rows in the right table (1)
  • returns all rows from the left table (1), with the matching rows in the right table (2)
  • selects all rows from both tables as long as there is a match between the columns in both tables

Questão 68

Questão
Define an union
Responda
  • сombines the result set of two or more select statements
  • returns all rows from the left table (1) and from the right table (2)
  • returns all rows from the right table (2), with the matching rows in the right table (1)
  • returns all rows from the left table (1), with the matching rows in the right table (2)

Questão 69

Questão
INNER JOIN and JOIN are the same
Responda
  • True
  • False

Questão 70

Questão
Define self join
Responda
  • returns all rows from the table that references to yourself
  • returns all rows from the right table (2), with the matching rows in the right table (1)
  • selects all rows from both tables as long as there is a match between the columns in both tables
  • returns all rows from the left table (1) and from the right table (2)

Questão 71

Questão
How many types of functional dependencies exist
Responda
  • 1
  • 2
  • 3
  • 0

Questão 72

Questão
Which of the following does not to the functional dependency
Responda
  • equational
  • full
  • transitive
  • partial

Questão 73

Questão
Which of the following represent a full dependency?
Responda
  • it exists in relation if there is no attribute A that can be removed from X and the dependency still holds
  • if there exists an attribute A that is part of X that can be removed from X and the dependency still holds
  • x->y dependency in relation R and x, y , z are columns in R. X->Y and Y>Z in R. Final: X->Y
  • all above mentioned

Questão 74

Questão
Which of the following represent a partial dependency?
Responda
  • if there exists an attribute A that is part of X that can be removed from X and the dependency still holds
  • it exists in relation if there is no attribute A that can be removed from X and the dependency still holds
  • x->y dependency in relation R and x, y , z are columns in R. X->Y and Y>Z in R. Final: X->Y
  • all above mentioned

Questão 75

Questão
Which of the following represent a transitive dependency?
Responda
  • x->y dependency in relation R and x, y , z are columns in R. X->Y and Y->Z in R. Final: X->Y
  • if there exists an attribute A that is part of X that can be removed from X and the dependency still holds
  • it exists in relation if there is no attribute A that can be removed from X and the dependency still holds
  • all above mentioned

Questão 76

Questão
When was first normalization developed?
Responda
  • 1970
  • 1972
  • 1973
  • 1974

Questão 77

Questão
When was second normalization developed?
Responda
  • 1971
  • 1972
  • 1973
  • 1974

Questão 78

Questão
When was Boyce–Codd normalization developed?
Responda
  • 1974
  • 1972
  • 1973
  • 1971

Questão 79

Questão
Who is an inventor of relational model?
Responda
  • Edgar F.Codd
  • Raymond Boyce
  • Marine Jone
  • John Salamondor

Questão 80

Questão
Which of the following refers to the requirement of 1NF
Responda
  • Each cell should be single valued
  • Entries in a column are same type
  • Rows uniquely identified
  • All above mentioned

Questão 81

Questão
Which of the following refers to the requirement of 2NF
Responda
  • All attributes (non-key columns) dependent on the key
  • Each cell should be single valued
  • All fields (columns) can be determined only by the key in the table and no other column
  • All above mentioned

Questão 82

Questão
Which of the following refers to the requirement of 3NF
Responda
  • All fields (columns) can be determined only by the key in the table and no other column
  • All attributes (non-key columns) dependent on the key
  • Each cell should be single valued
  • All above mentioned

Questão 83

Questão
Define avg function
Responda
  • Returns average value
  • Returns total value
  • Returns the first value
  • Converts to lowercase

Questão 84

Questão
Which function is used to retrieve quantity of rows
Responda
  • count
  • sum
  • max
  • avg

Questão 85

Questão
Retrieve avg scholarship of students. 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))
Responda
  • select avg (scholarship) from students;
  • select aveg (scholarship) from students;
  • select avr (scholarship) from students;
  • select avgr (scholarship) from students;

Questão 86

Questão
Retrieve students’, scholarship and teacher's’ name, who have more than average scholarship. 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))
Responda
  • select s.name, s.scholarship, t.name from students s, tutor t where t.id=s.tutorid and s.scholarship> (select avg(scholarship) from students)
  • select s.name, s.scholarship, t.name from students s, tutor t where t.id=s.tutorid and s.scholarship> avg(scholarship)
  • select s.name, s.scholarship, t.name from students s, tutor t where s.scholarship> (select avg(scholarship) from students)
  • select s.name, avg(s.scholarship), t.name from students s, tutor t

Questão 87

Questão
Retrieve students’, scholarship and teacher's’ name, who have more than average scholarship AND increase those students twice. 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))
Responda
  • select s.name, s.scholarship*2, t.name from students s, tutor t where t.id=s.tutorid and s.scholarship> (select avg(scholarship) from students)
  • select s.name, s.scholarship*2, t.name from students s, tutor t where t.id=s.tutorid and s.scholarship> avg(scholarship)
  • select s.name, s.scholarship*2, t.name from students s, tutor t where s.scholarship> (select avg(scholarship) from students)
  • select s.name, avg(s.scholarship)*2, t.name from students s, tutor t

Questão 88

Questão
Retrieve students and mentors name, but mentors registration date should be before students registration date. 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))
Responda
  • select s.name, m.name from students s join students m on s.tutorid=m.tutorid where s.registereddate<m.registereddate;
  • select s.name, m.name from students s join students m on s.tutorid=m.tutorid where s.registereddate>m.registereddate;
  • select s.name, m.name from students s join students m on s.tutorid=m.tutorid;
  • select s.name, m.name from students s join students m on s.registereddate=m.registereddate;

Questão 89

Questão
Retrieve the highest 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))
Responda
  • select max (experience) from tutor;
  • select min (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;

Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.

Semelhante

Breakdown of Philosophy
rlshindmarsh
Who did what now?...Ancient Greek edition
Chris Clark
Reason and Experience Plans
rlshindmarsh
The Cosmological Argument
Summer Pearce
AS Philosophy Exam Questions
Summer Pearce
Philosophy of Art
mccurryby
"The knower's perspective is essential in the pursuit of knowledge." To what extent do you agree?
nataliaapedraza
The Ontological Argument
daniella0128
Religious Experience
alexandramchugh9
Chapter 6: Freedom vs. Determinism Practice Quiz
Kristen Gardner
Environmental Ethics
Jason Edwards-Suarez
Explore a Biblioteca