GoConqr has a new look! Let us know what you think.

Sign up free

Quiz

Test 1

Miruna Teodora 8 questions

Take the quiz

Questions in this 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';

Information

Description
Quiz on Test 1, created by Miruna Teodora on 07/02/2017.
Language
English
Views
107
Tags
db
Rating
No ratings yet
Rate this quiz
Rate this quiz

Feedback

What is it about?

What do you think of the new look?

How do you like it?