Test 1

Description

Quiz on Test 1, created by Miruna Teodora on 07/02/2017.
Miruna Teodora
Quiz by Miruna Teodora, updated more than 1 year ago
Miruna Teodora
Created by Miruna Teodora about 7 years ago
63
0

Resource summary

Question 1

Question
Characteristics for the hierarchical structure:
Answer
  • 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

Question 2

Question
In a table one can have:
Answer
  • A simple primary key
  • A composed primary key
  • A simple foreign key
  • A foreign primary key
  • A control key

Question 3

Question
The conceptual schema is the result of:
Answer
  • The system study
  • The system analysis
  • The application requirements
  • The database structure's design
  • The database functions' design

Question 4

Question
The clusters are useful for:
Answer
  • Optimizing the database
  • Requests
  • Updates
  • Data inserts
  • Documentary databases

Question 5

Question
A components database system architecture includes:
Answer
  • data
  • database management system
  • application programs
  • legal and administrative regulations
  • hardware

Question 6

Question
Having the table STUDENT ( name, year, group, no_stud_group, group_secretary, birth_date), what affirmation(s) is(are) not true:
Answer
  • 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

Question 7

Question
In the relational model:
Answer
  • 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

Question 8

Question
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)
Answer
  • 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';
Show full summary Hide full summary

Similar

Disaster- Test 1 Disaster Medicine- PMU- 3rd Year
Med Student
SCIA 360 Chapter 3
Tyler Rock
SCIA 360 Chapter 4
Tyler Rock
SCIA 360 Chapter 1
Tyler Rock
SCIA 360 Chapter 2
Tyler Rock
SCIA 360 Chapter 5
Tyler Rock
Health Assessment Exam 1
Harry Westbrooks
Testing Site
CDismang
SCIA 370 Chapter 1
Tyler Rock
I Phone
ucmasaecs
Tipos de bases de datos
Jeffrey Bedoya