GoConqr hat ein neues Design! Sag uns, wie es dir gefällt.

Kostenlos registrieren

Quiz

Test 1

Miruna Teodora 8 Fragen

Quiz starten

Fragen in diesem 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';

Informationen

Beschreibung
Quiz am Test 1, erstellt von Miruna Teodora am 07/02/2017.
Sprache
English
Aufrufe
107
Schlagwörter
db
Bewertung
Noch keine Bewertungen
Bewerte dieses Quiz
Bewerte dieses Quiz

Feedback

Worum geht es?

Wie gefällt dir das neue Design?

Dein Eindruck