7573647
Descrição
Quiz por Miruna Teodora, atualizado more than 1 year ago
|
Criado por Miruna Teodora
mais de 7 anos atrás
|
|
Questão 1
Questão
Characteristics for the hierarchical structure:
Responda
-
A subordinate can be reached in many ways
-
A subordinate node can have only one superior
-
A node can have any number of subordinates and superiors
-
A subordinate node must have many superiors
-
A superior may have one or many subordinates
Questão 2
Questão
In a table one can have:
Responda
-
A simple primary key
-
A composed primary key
-
A simple foreign key
-
A foreign primary key
-
A control key
Questão 3
Questão
The conceptual schema is the result of:
Responda
-
The system study
-
The system analysis
-
The application requirements
-
The database structure's design
-
The database functions' design
Questão 4
Questão
The clusters are useful for:
Responda
-
Optimizing the database
-
Requests
-
Updates
-
Data inserts
-
Documentary databases
Questão 5
Questão
A components database system architecture includes:
Responda
-
data
-
database management system
-
application programs
-
legal and administrative regulations
-
hardware
Questão 6
Questão
Having the table STUDENT ( name, year, group, no_stud_group, group_secretary, birth_date), what affirmation(s) is(are) not true:
Responda
-
The table is in 2NF
-
The table has a fully functionally dependence
-
The table has a non-transitive dependence
-
The table is normalized
-
The table has a composed primary key
Questão 7
Questão
In the relational model:
Responda
-
There is the "record" notion
-
The attributes that have a role in making the links between tables are called composed keys
-
The links between tables are described in DML
-
There is the "table schema" notion
-
Projection, negation and existential are relational algebra operators
Questão 8
Questão
Having the tables
PRODUCTS (product_id NUMBER(15) primary key, name VARCHAR2(25), price NUMBER (7, 2), release_date DATE),
ORDERS (order_id NUMBER(10) primary key, product_id NUMBER (15) REFERENCES products(product_id), quantity NUMBER(7,2), order_date DATE).
Select the orders that were made for the products that were released in 2000 (in two ways)
Responda
-
select o.order_id, p.name, p.release_date, o.quantity from products p, orders o where p.product_id = o.product_id and extract (year from p.release_date) = 2000;
-
select o.order_id, p.name, p.release_date, o.quantity from products p join orders o using(product_id) where to_char(p.release_date, 'DD.MM.YYYY') like '%2000';
Quer criar seus próprios Quizzes gratuitos com a GoConqr? Saiba mais.