7573647
Beschreibung
Quiz von Miruna Teodora, aktualisiert more than 1 year ago
|
Erstellt von Miruna Teodora
vor mehr als 7 Jahre
|
|
Frage 1
Frage
Characteristics for the hierarchical structure:
Antworten
-
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
Frage 2
Frage
In a table one can have:
Antworten
-
A simple primary key
-
A composed primary key
-
A simple foreign key
-
A foreign primary key
-
A control key
Frage 3
Frage
The conceptual schema is the result of:
Antworten
-
The system study
-
The system analysis
-
The application requirements
-
The database structure's design
-
The database functions' design
Frage 4
Frage
The clusters are useful for:
Antworten
-
Optimizing the database
-
Requests
-
Updates
-
Data inserts
-
Documentary databases
Frage 5
Frage
A components database system architecture includes:
Antworten
-
data
-
database management system
-
application programs
-
legal and administrative regulations
-
hardware
Frage 6
Frage
Having the table STUDENT ( name, year, group, no_stud_group, group_secretary, birth_date), what affirmation(s) is(are) not true:
Antworten
-
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
Frage 7
Frage
In the relational model:
Antworten
-
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
Frage 8
Frage
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)
Antworten
-
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';
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.