¡GoConqr estrena diseño! Cuéntanos qué te parece.

Regístrate gratis

Test

Test 1

Miruna Teodora 8 preguntas

Hacer el test

Preguntas del test (8)

  1. 1Characteristics for the hierarchical structure:
    1. AA subordinate can be reached in many ways
    2. BA subordinate node can have only one superior
    3. CA node can have any number of subordinates and superiors
    4. DA subordinate node must have many superiors
    5. EA superior may have one or many subordinates
  2. 2In a table one can have:
    1. AA simple primary key
    2. BA composed primary key
    3. CA simple foreign key
    4. DA foreign primary key
    5. EA control key
  3. 3The conceptual schema is the result of:
    1. AThe system study
    2. BThe system analysis
    3. CThe application requirements
    4. DThe database structure's design
    5. EThe database functions' design
  4. 4The clusters are useful for:
    1. AOptimizing the database
    2. BRequests
    3. CUpdates
    4. DData inserts
    5. EDocumentary databases
  5. 5A components database system architecture includes:
    1. Adata
    2. Bdatabase management system
    3. Capplication programs
    4. Dlegal and administrative regulations
    5. Ehardware
  6. 6Having the table STUDENT ( name, year, group, no_stud_group, group_secretary, birth_date), what affirmation(s) is(are) not true:
    1. AThe table is in 2NF
    2. BThe table has a fully functionally dependence
    3. CThe table has a non-transitive dependence
    4. DThe table is normalized
    5. EThe table has a composed primary key
  7. 7In the relational model:
    1. AThere is the "record" notion
    2. BThe attributes that have a role in making the links between tables are called composed keys
    3. CThe links between tables are described in DML
    4. DThere is the "table schema" notion
    5. EProjection, negation and existential are relational algebra operators
  8. 8Having 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)
    1. Aselect 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;
    2. Bselect 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';

Información

Descripción
Test sobre Test 1, creado por Miruna Teodora el 07/02/2017.
Idioma
English
Visitas
107
Etiquetas
db
Valoración
Aún sin valoraciones
Valora este test
Valora este test

Escríbenos

¿Sobre qué es tu mensaje?

¿Qué te parece el nuevo diseño?

¿Te gusta?