ГОС по БД #1

Pregunta 1 de 89

1

Define a degree of a relation

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 2 de 89

1

Define a cardinality of a relation

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 3 de 89

1

Which of the following refers to union-compatibility requirements ?

Selecciona una de las siguientes respuestas posibles:

Same number of columns
Same number of rows
Same number of tuples
Different domains

Explicación

Pregunta 4 de 89

1

Which of the following refers to union-compatibility requirements ?

Selecciona una de las siguientes respuestas posibles:

Corresponding columns have the same domains
Same number of rows
Same number of tuples
Corresponding columns have the same fields

Explicación

Pregunta 5 de 89

1

Define a domain

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 6 de 89

1

Define a foreign key

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 7 de 89

1

Define a primary key

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 8 de 89

1

Define restrict

Selecciona una de las siguientes respuestas posibles:

stop the user from doing it
let the changes flow on
make referencing values the default for their column
make referencing values null

Explicación

Pregunta 9 de 89

1

Define cascade

Selecciona una de las siguientes respuestas posibles:

stop the user from doing it
let the changes flow on
make referencing values the default for their column
make referencing values null

Explicación

Pregunta 10 de 89

1

Define set default

Selecciona una de las siguientes respuestas posibles:

stop the user from doing it
let the changes flow on
make referencing values the default for their column
make referencing values null

Explicación

Pregunta 11 de 89

1

Define set null

Selecciona una de las siguientes respuestas posibles:

stop the user from doing it
let the changes flow on
make referencing values the default for their column
make referencing values null

Explicación

Pregunta 12 de 89

1

Define Data Definition Language

Selecciona una de las siguientes respuestas posibles:

Specify database format
Specify access controls (privileges)
Specify and retrieve database contents
Specify table attribute uniqueness

Explicación

Pregunta 13 de 89

1

Define Data Control Language

Selecciona una de las siguientes respuestas posibles:

Specify access controls (privileges)
Specify database format
Specify and retrieve database contents
Specify table attribute uniqueness

Explicación

Pregunta 14 de 89

1

Define Data Manipulation Language

Selecciona una de las siguientes respuestas posibles:

Specify table attribute uniqueness
Specify database format
Specify access controls (privileges)
Specify and retrieve database contents

Explicación

Pregunta 15 de 89

1

Which of the following does not refer to DBMS tools

Selecciona una de las siguientes respuestas posibles:

Oracle
PostgreSQL
MySQL
Python

Explicación

Pregunta 16 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 17 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

Remove update on employee from finance
Delete select on employee from finance
Revoke update on employee from finance
Grant update on employee from finance

Explicación

Pregunta 18 de 89

1

Which of the following is true regarding views?

Selecciona una de las siguientes respuestas posibles:

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.

Explicación

Pregunta 19 de 89

1

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.

Selecciona una de las siguientes respuestas posibles:

With grant
Grant user
With grant option
Grant pass privelege

Explicación

Pregunta 20 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 21 de 89

1

Privileges are granted over some specified parts of a database, such as a

Selecciona una de las siguientes respuestas posibles:

Schema
Environment
Relation Or view
Query statement

Explicación

Pregunta 22 de 89

1

Prevention of access to the database by unauthorized users is referred to as:

Selecciona una de las siguientes respuestas posibles:

Integrity
Productivity
Security
Reliability

Explicación

Pregunta 23 de 89

1

Database Authentication refers to:

Selecciona una de las siguientes respuestas posibles:

methods of restricting user access to system
controlling access to portions of database
all of the answers mentioned
controlling the operation on the data

Explicación

Pregunta 24 de 89

1

A set of possible data values is called

Selecciona una de las siguientes respuestas posibles:

attribute
degree
domain
tuple

Explicación

Pregunta 25 de 89

1

A functional dependency between two or more non-key attributes is called

Selecciona una de las siguientes respuestas posibles:

Partial transitive dependency
Functional dependency
Transitive dependency
Partial functional dependency

Explicación

Pregunta 26 de 89

1

__ refers to the correctness and completeness of the data in a database.

Selecciona una de las siguientes respuestas posibles:

Database security
Data constraint
Data integrity
Data independence

Explicación

Pregunta 27 de 89

1

Which of the following creates a virtual relation for storing the query?

Selecciona una de las siguientes respuestas posibles:

Function
Procedure
View
None of the mentioned

Explicación

Pregunta 28 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

Create view v as “query name”;
Create “query expression” as view;
Create view v as “query expression”;
Create view “query expression”;

Explicación

Pregunta 29 de 89

1

Updating the value of the view

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 30 de 89

1

Create view faculty as: Select ID, name, dept name from instructor; Find the error in this query.

Selecciona una de las siguientes respuestas posibles:

Instructor
Select
None of the mentioned
View …as

Explicación

Pregunta 31 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

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’;

Explicación

Pregunta 32 de 89

1

Retrieve all data from the table OFFICE { id,room, name}

Selecciona una de las siguientes respuestas posibles:

Select *from office;
Select from office;
Select name from office;
Select *form office;

Explicación

Pregunta 33 de 89

1

Retrieve office name from the table OFFICE {id, room, name}

Selecciona una de las siguientes respuestas posibles:

Select *from office;
Select from office;
Select name from office;
Select *form office;

Explicación

Pregunta 34 de 89

1

Retrieve office id from the table OFFICE {id, room, name}

Selecciona una de las siguientes respuestas posibles:

Select *from office;
Select id from office;
Select name from office;
Select id form office;

Explicación

Pregunta 35 de 89

1

Retrieve office id and room from the table OFFICE {id, room, name}

Selecciona una de las siguientes respuestas posibles:

Select *from office;
Select id, room from office;
Select room name from office;
Select id form office;

Explicación

Pregunta 36 de 89

1

Retrieve quantity of offices in the office table - OFFICE {id, rom, name}

Selecciona una de las siguientes respuestas posibles:

Select avg (id) from office;
Select count (id) from office;
Select sum (id) from office;
Select max (id) from office;

Explicación

Pregunta 37 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

Select avg (scholarship) from office;
Select count (scholarship) from office;
Select sum (scholarship) from office;
Select max (scholarship) from office;

Explicación

Pregunta 38 de 89

1

Retrieve quantity of students in the students table – STUDENTS {id, name, scholarship, registereddate, tutorid}

Selecciona una de las siguientes respuestas posibles:

Select avg (id) from office;
Select count (id) from office;
Select sum (id) from office;
Select max (id) from office;

Explicación

Pregunta 39 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 40 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

Select avg (scholarship) from students;
Select count (scholarship) from students;
Select sum (scholarship) from students;
Select max (scholarship) from students;

Explicación

Pregunta 41 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

Select avg (scholarship) from students;
Select count (scholarship) from students;
Select sum (scholarship) from students;
Select max (scholarship) from students;

Explicación

Pregunta 42 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

Select avg (scholarship) from students;
Select count (scholarship) from students;
Select min (scholarship) from students;
Select max (scholarship) from students;

Explicación

Pregunta 43 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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’

Explicación

Pregunta 44 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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 ;

Explicación

Pregunta 45 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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);

Explicación

Pregunta 46 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

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';

Explicación

Pregunta 47 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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);

Explicación

Pregunta 48 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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);

Explicación

Pregunta 49 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 50 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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%';

Explicación

Pregunta 51 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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%';

Explicación

Pregunta 52 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 53 de 89

1

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

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 54 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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);

Explicación

Pregunta 55 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 56 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 57 de 89

1

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))}.

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 58 de 89

1

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))

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 59 de 89

1

How many types of anomalies exist?

Selecciona una de las siguientes respuestas posibles:

1
2
3
4

Explicación

Pregunta 60 de 89

1

Which of the following anomaly does not exist?

Selecciona una de las siguientes respuestas posibles:

Creation anomaly
Deletion anomaly
Insertion anomaly
Modification anomaly

Explicación

Pregunta 61 de 89

1

When an insertion anomaly occurs?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 62 de 89

1

When a modification anomaly occurs?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 63 de 89

1

When a deletion anomaly occurs?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 64 de 89

1

Define inner join

Selecciona una de las siguientes respuestas posibles:

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)

Explicación

Pregunta 65 de 89

1

Define left join

Selecciona una de las siguientes respuestas posibles:

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)

Explicación

Pregunta 66 de 89

1

Define right join

Selecciona una de las siguientes respuestas posibles:

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)

Explicación

Pregunta 67 de 89

1

Define full join

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 68 de 89

1

Define an union

Selecciona una de las siguientes respuestas posibles:

с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)

Explicación

Pregunta 69 de 89

1

INNER JOIN and JOIN are the same

Selecciona uno de los siguientes:

VERDADERO
FALSO

Explicación

Pregunta 70 de 89

1

Define self join

Selecciona una de las siguientes respuestas posibles:

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)

Explicación

Pregunta 71 de 89

1

How many types of functional dependencies exist

Selecciona una de las siguientes respuestas posibles:

1
2
3
0

Explicación

Pregunta 72 de 89

1

Which of the following does not to the functional dependency

Selecciona una de las siguientes respuestas posibles:

equational
full
transitive
partial

Explicación

Pregunta 73 de 89

1

Which of the following represent a full dependency?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 74 de 89

1

Which of the following represent a partial dependency?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 75 de 89

1

Which of the following represent a transitive dependency?

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 76 de 89

1

When was first normalization developed?

Selecciona una de las siguientes respuestas posibles:

1970
1972
1973
1974

Explicación

Pregunta 77 de 89

1

When was second normalization developed?

Selecciona una de las siguientes respuestas posibles:

1971
1972
1973
1974

Explicación

Pregunta 78 de 89

1

When was Boyce–Codd normalization developed?

Selecciona una de las siguientes respuestas posibles:

1974
1972
1973
1971

Explicación

Pregunta 79 de 89

1

Who is an inventor of relational model?

Selecciona una de las siguientes respuestas posibles:

Edgar F.Codd
Raymond Boyce
Marine Jone
John Salamondor

Explicación

Pregunta 80 de 89

1

Which of the following refers to the requirement of 1NF

Selecciona una de las siguientes respuestas posibles:

Each cell should be single valued
Entries in a column are same type
Rows uniquely identified
All above mentioned

Explicación

Pregunta 81 de 89

1

Which of the following refers to the requirement of 2NF

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 82 de 89

1

Which of the following refers to the requirement of 3NF

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 83 de 89

1

Define avg function

Selecciona una de las siguientes respuestas posibles:

Returns average value
Returns total value
Returns the first value
Converts to lowercase

Explicación

Pregunta 84 de 89

1

Which function is used to retrieve quantity of rows

Selecciona una de las siguientes respuestas posibles:

count
sum
max
avg

Explicación

Pregunta 85 de 89

1

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))

Selecciona una de las siguientes respuestas posibles:

select avg (scholarship) from students;
select aveg (scholarship) from students;
select avr (scholarship) from students;
select avgr (scholarship) from students;

Explicación

Pregunta 86 de 89

1

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))

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 87 de 89

1

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))

Selecciona una de las siguientes respuestas posibles:

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

Explicación

Pregunta 88 de 89

1

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))

Selecciona una de las siguientes respuestas posibles:

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;

Explicación

Pregunta 89 de 89

1

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))

Selecciona una de las siguientes respuestas posibles:

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;

	Creado por хомяк убийца hace más de 5 años

God Philosophy Test sobre ГОС по БД #1, creado por хомяк убийца el 23/03/2019.

ГОС по БД #1

Pregunta 1 de 89

Define a degree of a relation

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 2 de 89

Define a cardinality of a relation

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 3 de 89

Which of the following refers to union-compatibility requirements ?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 4 de 89

Which of the following refers to union-compatibility requirements ?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 5 de 89

Define a domain

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 6 de 89

Define a foreign key

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 7 de 89

Define a primary key

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 8 de 89

Define restrict

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 9 de 89

Define cascade

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 10 de 89

Define set default

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 11 de 89

Define set null

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 12 de 89

Define Data Definition Language

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 13 de 89

Define Data Control Language

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 14 de 89

Define Data Manipulation Language

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 15 de 89

Which of the following does not refer to DBMS tools

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 16 de 89

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

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 17 de 89

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

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 18 de 89

Which of the following is true regarding views?

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 19 de 89

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.

Selecciona una de las siguientes respuestas posibles:

Explicación

Pregunta 20 de 89

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