O GoConqr está de visual novo! Conte para nós o que você achou.

Registre-se grátis

Quiz

Test 1

Miruna Teodora 8 perguntas

Fazer o quiz

Perguntas do quiz (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';

Informações

Descrição
Quiz sobre Test 1, criado por Miruna Teodora em 07-02-2017.
Idioma
English
Visualizações
107
Etiquetas
db
Avaliação
Ainda sem avaliações
Avalie este quiz
Avalie este quiz

Fale Conosco

Sobre o que é sua mensagem?

O que você acha do novo visual?

Você gostou?