Baze Podataka Drugi Kolokvijum

Approved & Edited by ProProfs Editorial Team

The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.

Learn about Our Editorial Process

| By Nemanja

Nemanja

Community Contributor

Quizzes Created: 2 | Total Attempts: 6,948

Questions: 57 | Attempts: 2,395 | Updated: Mar 21, 2023

Questions

Settings

Feedback

During the Quiz End of Quiz

Play as

Quiz Flashcard

Create your own Quiz

Questions and Answers

1.

Digitalna slika realnog dela sveta, koja je od značaja za informacioni sistem je
- A.
  
  Model-objekat
- B.
  
  Podatak
- C.
  
  Atribut
- D.
  
  Zapis
Correct Answer
A. Model-objekat

Explanation
A digital image of a real-world object that is relevant to an information system is referred to as a model-object. This term suggests that the image represents a specific object or entity in the real world and is used as a model or representation within the information system. This could be a visual representation of a physical object or a digital representation of a concept or idea. The term "model-object" implies that the image is more than just a data point or attribute, but rather a comprehensive representation of something meaningful within the information system.

Rate this question:
2.

Za razliku od hijerarhijskog modela informacionog sistema, mrežni model dozvoljava
- A.
  
  Veze tipa M:N
- B.
  
  Veze tipa 1:N
- C.
  
  Polimorfizam
- D.
  
  formalno-matematičku interpretaciju tabela
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Veze tipa M:N

Explanation
The correct answer is "Veze tipa M:N" because the network model allows for many-to-many relationships between entities. In the network model, entities are connected through sets of relationships, and each entity can be connected to multiple entities through multiple relationships. This allows for more flexibility in representing complex data relationships compared to the hierarchical model, which only allows for one-to-many relationships.

Rate this question:
3.

Kardinalnost relacije je
- A.
  
  Broj n-torki jedne tabele koji su u relaciji sa jednom n-torkom druge tabele
- B.
  
  Broj atributa koji čine složen primarni ključ
- C.
  
  Skup dozvoljenih vrednosti primarnog ključa
- D.
  
  Broj dozvoljenih vrednosti primarnog ključa
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Broj n-torki jedne tabele koji su u relaciji sa jednom n-torkom druge tabele

Explanation
The correct answer is "broj n-torki jedne tabele koji su u relaciji sa jednom n-torkom druge tabele" because cardinality refers to the number of tuples in one table that are related to one tuple in another table. It represents the relationship between tables in a relational database. The other options are not related to the concept of cardinality.

Rate this question:
4.

U SQL upitu
- A.
  
  Klauzula SELECT odgovara operatoru projekcije, klauzula WHERE operatoru selekcije, klauzula FROM operatoru spajanja
- B.
  
  Klauzula SELECT odgovara operatoru selekcije, klauzula HAVING operatoru projekcije, a klauzula GROUP BY operatoru spajanja
- C.
  
  Klauzula SELECT odgovara ooeratoru projekcije, klauzula WHERE operatoru selekcije, a klauzula GROUP BY operatoru spajanja
- D.
  
  Klauzula SELECT odgovara operatoru selekcije, klauzula WHERE operatoru projekcije, a klauzula FROM operatoru spajanja
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Klauzula SELECT odgovara operatoru projekcije, klauzula WHERE operatoru selekcije, klauzula FROM operatoru spajanja

Explanation
The correct answer states that the SELECT clause corresponds to the projection operator, the WHERE clause corresponds to the selection operator, and the FROM clause corresponds to the join operator. This means that the SELECT clause is used to specify the columns to be included in the result set, the WHERE clause is used to filter the rows based on certain conditions, and the FROM clause is used to specify the tables to be joined in the query.

Rate this question:
5.

Data je tabela tab1 <ime> sa atributom ime. Koji upit vraća spisak svih imena koja sadrže mala slova "a" i "b" ?
- A.
  
  SELECT ime FROM tab1 WHERE ime LIKE "%a%b%" OR ime LIKE "%b%a%"
- B.
  
  SELECT ime FROM tab WHERE ime LIKE ""a?b?" OR ime LIKE "?b?a?"
- C.
  
  SELECT ime FROM tab WHERE ime LIKE "%a%b%
- D.
  
  SELECT ime FROM tab WHERE ime LIKE '%b%a%"
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. SELECT ime FROM tab1 WHERE ime LIKE "%a%b%" OR ime LIKE "%b%a%"

Explanation
The correct answer is the first option: SELECT ime FROM tab1 WHERE ime LIKE "%a%b%" OR ime LIKE "%b%a%". This query uses the LIKE operator with wildcard characters (%) to search for names that contain both "a" and "b" in any order. The OR operator allows for either "a" followed by "b" or "b" followed by "a".

Rate this question:
6.

Ako svaki atribut koji nije ključni potpuno funkcionalno zavisi od primarnog ključa,relacija se nalazi u
- A.
  
  Prvoj normalnoj formi
- B.
  
  Drugoj normalnoj formi
- C.
  
  Trećoj normalnoj formi
- D.
  
  četvrtoj normalnoj formi
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
B. Drugoj normalnoj formi

Explanation
The given answer suggests that if every non-key attribute in a relation is functionally dependent on the primary key, then the relation is in the second normal form. The second normal form (2NF) requires that the relation is in 1NF and there should be no partial dependencies, meaning that every non-key attribute should depend on the entire primary key. Therefore, the given answer is correct in stating that the relation is in the second normal form.

Rate this question:
7.

Data je tabela radnik <idbr, posao, ime, prezime, brod>. Koji je upit od siedećih ispravan ?
- A.
  
  SELECT brod, posao, count(*) FROM radnik GROUP BY brod, posao HAVING count ( * )>1
- B.
  
  SELECT brod, count(*) FROM radnik GROUP BY posao HAVING count(*)>1
- C.
  
  SELECT brod, count(*) FROM radnik GROUP BY brod, posao HAVING count(*)>1
- D.
  
  SELECT posao, count(*) FROM radnik GROUP BY brod HAVING count(*)>1
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer(s)
A. SELECT brod, posao, count(*) FROM radnik GROUP BY brod, posao HAVING count ( * )>1
C. SELECT brod, count(*) FROM radnik GROUP BY brod, posao HAVING count(*)>1

Explanation
The correct answer is the first option: SELECT brod, posao, count(*) FROM radnik GROUP BY brod, posao HAVING count(*)>1. This query selects the columns "brod" and "posao" from the "radnik" table and counts the number of occurrences for each combination of "brod" and "posao". The HAVING clause is used to filter out the results and only return the rows where the count is greater than 1, meaning there are multiple occurrences of the same combination.

Rate this question:
8.

Pogled je
- A.
  
  Virtuelna tabela sa imenom
- B.
  
  Neimenovana virtuelna tabela
- C.
  
  Neimenovana fizička tabela
- D.
  
  Fizička tabela sa imenom
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Virtuelna tabela sa imenom

Explanation
The correct answer is "virtuelna tabela sa imenom." This means that the "Pogled" (view) is a virtual table with a name.

Rate this question:
9.

Posmatraju se objekti RAČUN i STAVKA nekog računa. Za te objekte važisledeće
- A.
  
  RAČUN je čvrst objekat a STAVKA slab
- B.
  
  RAČUN je slab objekat a STAVKA čvrst
- C.
  
  i RAČUN i STAVKA su slabi objekti
- D.
  
  I RAČUN i STAVKA su čvrsti oojekti
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. RAČUN je čvrst objekat a STAVKA slab

Explanation
The given answer states that "RAČUN je čvrst objekat a STAVKA slab" which translates to "RAČUN is a strong object and STAVKA is weak". This means that the object "RAČUN" is considered to have a strong importance or significance, while the object "STAVKA" is considered to have a weaker importance or significance.

Rate this question:
10.

Slabi objekti koji identifikacijski zavise od nekog čvrstog objekta
- A.
  
  Imaju složen primarni ključ
- B.
  
  Imaju prost primarni ključ
- C.
  
  Nemaju primami ključ
- D.
  
  Mogu imati, ali ne moraju imati ni prost ni složen primarni ključ
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Imaju složen primarni ključ

Explanation
Objects that depend on another object for identification have a complex primary key. This means that their primary key is composed of multiple attributes or fields, rather than just a single attribute. This allows for a more precise and unique identification of these objects, as the combination of multiple attributes ensures that no two objects will have the same primary key.

Rate this question:
11.

Data je tabela GRAĐANIN <matbr, ime, prezime, matbr2>. Atribut matbr predstavljamatični broj osobe, a matbr2 matični broj bračnog druga osobe koja je opisana ujednom zapisu. Između n-torki tabele GRAĐANIN postoje
- A.
  
  Unarne veze 1:1
- B.
  
  Binarne veze 1:1
- C.
  
  Unarne veze 1:N
- D.
  
  Unarne veze M:N
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Unarne veze 1:1

Explanation
The correct answer is "unarne veze 1:1" because the table GRAĐANIN has two attributes, matbr and matbr2, which represent the identification numbers of a person and their spouse respectively. In a 1:1 unary relationship, each record in the table is uniquely linked to another record in the same table. In this case, each person's identification number (matbr) is linked to the identification number (matbr2) of their spouse, creating a one-to-one relationship between the records in the GRAĐANIN table.

Rate this question:
12.

Date su tabele NASTAVNIK i PREDMET. Pod uslovom da jedan nastavnik može dapredaje više predmeta, između zapisa ovih tabela ostvarene su
- A.
  
  Binarne veze tipa 1:N
- B.
  
  Binarne veze tipa 1:1
- C.
  
  Unarne veze tipa 1:1
- D.
  
  Unarne veze tipa 1:N
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Binarne veze tipa 1:N

Explanation
The given correct answer is "binarne veze tipa 1:N" because it states that there is a one-to-many relationship between the tables NASTAVNIK and PREDMET, indicating that one teacher can teach multiple subjects. This means that each record in the NASTAVNIK table can be associated with multiple records in the PREDMET table, but each record in the PREDMET table can only be associated with one record in the NASTAVNIK table.

Rate this question:
13.

Prilikom prevođenja E-R modela na relaconi oblik
- A.
  
  svi objekti postaju relacije a svaka veza može ali ne mora da postane relacija
- B.
  
  Svi čvrsti objekti postaju relacije a slabi objekti i veze ne
- C.
  
  Svaki objekat i svaka veza postaju relacije
- D.
  
  Svi čvrsti objekti postaju relacije a slabi objekti i veze mogu ali ne moraju ca postanu relacije
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. svi objekti postaju relacije a svaka veza može ali ne mora da postane relacija

Explanation
When translating an E-R model into a relational form, all objects become relations, and each relationship can, but does not have to, become a relation. This means that all entities in the E-R model will be represented as tables in the relational form, while relationships may or may not be represented as separate tables depending on the situation.

Rate this question:
14.

Prilikom prevođenja E-R modela, za binarne veze važi sledeće
- A.
  
  Binarne veze tipa 1:1 i 1:N se iskazuju spoljnim kijučem a veze tipa M:N veznom tabelom
- B.
  
  Binarne veze tipa 1:1 se iskazuju spoljnim ključem a veze tipa L:N i M:N veznom tabelom
- C.
  
  Sve binarne veze se iskazuju spoljnim ključem
- D.
  
  Sve unarne veze se iskazuju veznom tabelom
- E.
  
  Ni jedan od ponuđenih odgovor
Correct Answer
A. Binarne veze tipa 1:1 i 1:N se iskazuju spoljnim kijučem a veze tipa M:N veznom tabelom

Explanation
When translating an E-R model, binary relationships of type 1:1 and 1:N are expressed using foreign keys, while relationships of type M:N are expressed using a junction table. This means that for 1:1 and 1:N relationships, the primary key of one entity is used as a foreign key in the other entity, establishing the relationship between them. On the other hand, for M:N relationships, a separate table is created to represent the relationship, with foreign keys referencing the primary keys of the two entities involved.

Rate this question:
15.

Anomalije pri upisu, brisanju i izmeni podataka javljaju se kao posledica
- A.
  
  Nekontrolisane redundanse
- B.
  
  Horizontalne normalizacije
- C.
  
  Vertikalne normalizacije
- D.
  
  Prisustva veza reda većeg od 3
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Nekontrolisane redundanse

Explanation
Anomalije pri upisu, brisanju i izmeni podataka javljaju se kao posledica nekontrolisane redundanse. This means that the anomalies in data entry, deletion, and modification occur due to uncontrolled redundancies. Redundancy refers to the unnecessary repetition of data in a database, which can lead to inconsistencies and anomalies. If the data is not properly controlled and managed, these redundancies can cause issues in data operations.

Rate this question:
16.

Postupak dekompozicije tabeia s ciljem postizanja dobrih osobina relacionog modela i uklanjanja moguće pojave nekontrolisane redundanse je
- A.
  
  Normalizacija
- B.
  
  Projekcija
- C.
  
  Diskretizacija
- D.
  
  Dekompozicija
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Normalizacija

Explanation
The given correct answer is "normalizacija." Normalizacija is a process of decomposing a table in a relational database to eliminate redundancy and achieve a well-structured relational model. It involves breaking down a table into smaller tables and establishing relationships between them. This helps in improving data integrity, reducing data duplication, and enhancing overall database performance.

Rate this question:
17.

Dovoljni i potrebni uslovi koje atribut mora da ispunjava da bi mogao bitikandidat za primami ključ su
- A.
  
  Jedinstvenost i minimalnost
- B.
  
  Jedinstvenost i raspoloživost
- C.
  
  Jedinstvenost i nepromenljivost
- D.
  
  Nepromenljivost i raspoloživost
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Jedinstvenost i minimalnost

Explanation
The correct answer is "jedinstvenost i minimalnost" because for an attribute to be a candidate for a primary key, it must be unique (jedinstvenost) and it should not contain any unnecessary attributes (minimalnost). This means that the attribute should uniquely identify each record in the table and there should not be any redundant information in the primary key.

Rate this question:
18.

Ime relacije, vrednost primarnog ključa i ime atributa relacije jednoznačnoidentifikuju
- A.
  
  Zapis
- B.
  
  Skupa zapisa
- C.
  
  Atomarni podatak
- D.
  
  Skup atomarnih podataka
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
C. Atomarni podatak

Explanation
The given answer "atomarni podatak" is correct because in a relation, the value of the primary key and the attribute name uniquely identify an atomic data. An atomic data refers to a single, indivisible value that cannot be further divided. Therefore, the combination of the primary key value and the attribute name in a relation ensures the uniqueness and identification of an atomic data.

Rate this question:
19.

Pravilo referencijalnog integriteta glasi
- A.
  
  Skup vrednosti spoljnog ključa relacije R1 mora biti podskup skupa vrednosti primarnog ključa relacije R2, pri čemu relacije R1 i R2 ne moraju biti različite
- B.
  
  Skup vrednosti spoljnog ključa relacije R1 mora biti nadskup skupa vrednosti primarnog ključa relacije R2, pri čamu relacije R1 i R2 moraju biti različite
- C.
  
  Skup vrednosti spoljnog ključa relacije R1 mora biti nadskup skupa vrednosti primarnog ključa relacije R2, pri čemu relacije R1 i R2 ne moraju biti različite
- D.
  
  Skup vrednosti spoljnog ključa relacije R1 mora biti podskup skupa vređnosti primarnog ključa relacije R2, pri čamu relacije R1 i R2 moraju biti različite
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Skup vrednosti spoljnog ključa relacije R1 mora biti podskup skupa vrednosti primarnog ključa relacije R2, pri čemu relacije R1 i R2 ne moraju biti različite

Explanation
The correct answer states that the set of values of the foreign key of relation R1 must be a subset of the set of values of the primary key of relation R2, without requiring that R1 and R2 be different. This means that every value in the foreign key of R1 must exist in the primary key of R2, but R1 and R2 can refer to the same relation. This ensures referential integrity, as it guarantees that every foreign key value in R1 has a corresponding primary key value in R2.

Rate this question:
20.

Prema Codd-u, pravila integriteta baze podataka definišu se na sledećim mestima
- A.
  
  I referencijalni integritet i integritet entiteta u bazi podataka
- B.
  
  Referencijalni integritet u bazi podataka a integritet entiteta u aplikaciji
- C.
  
  Referencijaini integritet u aplikaciji a integritet entiteta u bazi podataka
- D.
  
  I referencijalni integritet i integritet entiteta u aplikaciji
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. I referencijalni integritet i integritet entiteta u bazi podataka

Explanation
The correct answer is "i referencijalni integritet i integritet entiteta u bazi podataka" because according to Codd, the rules of database integrity are defined in both the referential integrity and entity integrity in the database. This means that the database must maintain the consistency and accuracy of the data by enforcing rules such as primary key constraints, foreign key constraints, and domain constraints.

Rate this question:
21.

U operatore pogodne za ažuriranje spadaju
- A.
  
  Unija, presek i razlika
- B.
  
  Selekcija, projekcija i dekartov proizvod
- C.
  
  Unija, presek i spajanje
- D.
  
  Ni jedan od ponuđenih odgovora
- E.
  
  Selekcija, projekcija i spajanje
Correct Answer
A. Unija, presek i razlika

Explanation
The correct answer is "unija, presek i razlika." This answer is correct because "unija" refers to the union operation in set theory, which combines two sets and returns a new set containing all the elements from both sets without repetition. "Presek" refers to the intersection operation, which returns a new set containing only the elements that are common to both sets. "Razlika" refers to the difference operation, which returns a new set containing only the elements that are in the first set but not in the second set. Therefore, all three operations mentioned in the answer are suitable for updating sets.

Rate this question:
22.

U operatore pogodne za izveštavanje spadaju
- A.
  
  selekcija, projekcija i spajanje
- B.
  
  Selekcija, projekcija i dekartov proizvod
- C.
  
  Unija, presek i spajanje
- D.
  
  Ni jedan od ponuđenih odgovora
- E.
  
  Unija, presek, razlika i dekartov proizvod
Correct Answer
A. selekcija, projekcija i spajanje

Explanation
The correct answer is "selekcija, projekcija i spajanje". These are the operators suitable for querying in a database. "Selekcija" refers to selecting specific rows from a table based on certain conditions. "Projekcija" refers to selecting specific columns from a table. "Spajanje" refers to combining data from multiple tables based on a common attribute. These operators are fundamental for retrieving specific information from a database.

Rate this question:
23.

U naredbe za definisanje podataka (Data Definition Staternents) spadaju
- A.
  
  Create view, create index, create table
- B.
  
  Create table, create view, begin transaction
- C.
  
  Create table, drop view, commit work
- D.
  
  Grant, revoke, rollback work
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Create view, create index, create table

Explanation
The correct answer is "create view, create index, create table". These are all examples of data definition statements in SQL. "Create view" is used to create a virtual table based on the result of a query, "create index" is used to create an index on a table to improve query performance, and "create table" is used to create a new table in a database.

Rate this question:
24.

U naredbe za rukovanje podacima (Data Manipulation Statements) spadaju
- A.
  
  Insert, select, delete, update
- B.
  
  Insert, select, grant, revoke
- C.
  
  Insert, select, alter table, drop table
- D.
  
  Ni jedan od ponuđenih odgovora
- E.
  
  Grant, revoke, alter table, drop table
Correct Answer
A. Insert, select, delete, update

Explanation
The correct answer is insert, select, delete, update. These are the basic data manipulation statements in SQL. "Insert" is used to add new records to a table, "select" is used to retrieve data from a table, "delete" is used to remove records from a table, and "update" is used to modify existing records in a table. The other options either include additional statements that are not part of data manipulation (such as "grant" and "revoke") or are incorrect combinations of statements.

Rate this question:
25.

Indeksi omogućavaju
- A.
  
  Direktan pristup podacima u tabeli putem atributa koji su indeksirani
- B.
  
  Ni jedan od ponuđenih odgovora
- C.
  
  Direktan pristup podacima u tabeli isključivo putem primarnog ključa
- D.
  
  Sekvencijalni pristup podacima u tabeli putem atributa koji-su indeksirani
- E.
  
  Sekvencijalni pristup podacima u tabeli isključivo putem primarnog ključa
Correct Answer
A. Direktan pristup podacima u tabeli putem atributa koji su indeksirani

Explanation
Indexes allow for direct access to data in a table through attributes that are indexed. This means that instead of having to search through the entire table sequentially, the index allows for quick and efficient retrieval of specific data based on the indexed attribute. This is different from accessing data solely through the primary key or using sequential access.

Rate this question:
26.

Opšti oblik select upita glasi
- A.
  
  SELECT lista atributa 1 FROM lista relacija WHERE lista uslova 1 GROUP BY lista atributa 2 HAVING lista uslova 2 ORDER BY lista atributa 3
- B.
  
  SELECT lista atributa 1 FROM lista relacija HAVING lista uslova 1 GROUP BY lista atributa 2 WHERE lista uslova 2 ORDER 3Y lista atributa 3
- C.
  
  Ni jedan od ponuđenih odgovora
- D.
  
  SELECT lista atributa i FROM lista relacija HAVING lista uslova 1 ORDER BY lista atributa GROUP BY lista atributa 3 WHERE lista uslova 2
- E.
  
  SELECT lista atributa 1 FROM lista relacija WHERE lista uslova 1 ORDER BY lista atributa 2 GROUP BY lista atributa 3 HAVING lista uslova 2
Correct Answer
A. SELECT lista atributa 1 FROM lista relacija WHERE lista uslova 1 GROUP BY lista atributa 2 HAVING lista uslova 2 ORDER BY lista atributa 3

Explanation
The correct answer is the first option because it follows the correct syntax for a SELECT query. It selects the specified attributes from the specified relations, applies the specified conditions, groups the results by the specified attribute 2, applies additional conditions using the HAVING clause, and finally orders the results by the specified attribute 3.

Rate this question:
27.

Višestruke zapise, u tabeli koju select upit vraća kao odgovor, eliminišemo klauzulom
- A.
  
  ALL
- B.
  
  DISTINCT
- C.
  
  UNION
- D.
  
  Ni jedan od ponuđenih odgovora
- E.
  
  UNLIKE
Correct Answer
B. DISTINCT

Explanation
The correct answer is DISTINCT. When using the SELECT query, the DISTINCT keyword is used to eliminate duplicate records from the result set. It ensures that only unique values are returned in the table. This means that if there are multiple rows with the same values, only one of them will be included in the result set.

Rate this question:
28.

Relacija se nalazi u trećoj normalnoj formi
- A.
  
  Ako neključni atributi u tabeli nisu ni funkcionalno ni tranzitivno zavisni od ključnih atributa
- B.
  
  Ako su svi neključni atributi u tabeli i funkcionalno i tranzitivno zavisni od ključnih atributa
- C.
  
  Ako svi neključni atributi u tabeli nisu međusoono funkcionalno zavisni
- D.
  
  Ako su svi neključni atributi u tabeii međusobno tranzitivno zavisni
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. Ako neključni atributi u tabeli nisu ni funkcionalno ni tranzitivno zavisni od ključnih atributa

Explanation
The given correct answer states that a relation is in the third normal form if the non-key attributes in the table are neither functionally nor transitively dependent on the key attributes. This means that the non-key attributes should not be determined by any combination of key attributes or by any other non-key attributes. In other words, the non-key attributes should only depend on the key attributes directly. This condition ensures that there are no redundant dependencies in the table, leading to a more efficient and organized database design.

Rate this question:
29.

Relacija sa dekomponuje bez opasnosti gubitka funkcionalnih zavisnosti samo ako
- A.
  
  se dekompozicija vrši prema funkcionalnoj zavisnosti koja ne potiče od kandidata ključa
- B.
  
  Ni jedan od ponuđenih odgovora
- C.
  
  Se dekompozicija vrsi prema funkcionalnoj zavisnosti koja potiče od kandidata ključa
- D.
  
  Sa dekompozicija vrši prema tranzitivnoj zavisnosti koja ne potiče od kandidata ključa
- E.
  
  Se dekompozicija vrši prema tranzitivnoj zavisnosti koja potiče od kandidata ključa
Correct Answer
A. se dekompozicija vrši prema funkcionalnoj zavisnosti koja ne potiče od kandidata ključa

Explanation
The correct answer is that the decomposition is done according to a functional dependency that does not originate from the candidate key. This means that the decomposition is done based on a dependency that is not necessary for preserving the functional dependencies of the original relation.

Rate this question:
30.

Date su tabele :radnik <me, brod> sa 1000 zapisa iodeljenje <drod, imeod> sa 100 zapisa. SOL upit:SELECT ime, imeod FROM radnik, odeljenjeWHERE radnik.brod = odeljenje.brod AND radnik.ime LIKE "A%"vrši operaciju selekcije nad
- A.
  
  100000 zapisa
- B.
  
  100 zapisa
- C.
  
  1000 zapisa
- D.
  
  1100 zapisa
- E.
  
  Ni jedan od ponuđenih odgovora
Correct Answer
A. 100000 zapisa

Explanation
The given SQL query is selecting the columns "ime" and "imeod" from the tables "radnik" and "odeljenje" respectively. It is using a join condition where the "brod" column of the "radnik" table is equal to the "brod" column of the "odeljenje" table, and the "ime" column of the "radnik" table starts with the letter "A". The query is performing a selection operation on the entire dataset, which contains 100,000 records. Therefore, the answer is "100000 zapisa".

Rate this question:
31.

Svakom elementarnom obeležju pripisuje se
- A.
  
  Tačno jedan zapis
- B.
  
  Tačno jedan atribut
- C.
  
  Najmanje jedan elementarni podatak
- D.
  
  Tačno jedan elementarni podatak
Correct Answer
B. Tačno jedan atribut

Explanation
Each elementary characteristic is associated with exactly one attribute. This means that for every elementary characteristic, there is a corresponding attribute that describes or represents that characteristic. An attribute provides additional information or properties about the elementary characteristic. Therefore, the given answer "Tačno jedan atribut" is correct as it accurately describes the relationship between elementary characteristics and attributes.

Rate this question:
32.

Ukoliko je skup vrednosti spoljnjeg ključa relacije R1 nadskup skupa vrednosti primarnog ključa R2 (pri čemu relacije R1 i R2 ne moraju biti različite)
- A.
  
  Prekršeno je pravilo referencijalnog integriteta,a ne može se odrediti da li je prekršeno pravilo integriteta entiteta
- B.
  
  Prekršeno je pravilo integriteta entiteta,a ne može se odrediti da li je prekršeno pravilo referencijalnog integriteta
- C.
  
  Prekršeno je pravilo integriteta domena,a ne može se odrediti da li je prekršeno pravilo referencijalnog integriteta
- D.
  
  Prekršena su pravila referencijalnog integriteta i integriteta entiteta
Correct Answer
A. Prekršeno je pravilo referencijalnog integriteta,a ne može se odrediti da li je prekršeno pravilo integriteta entiteta

Explanation
The given correct answer states that if the set of values of the foreign key in relation R1 is a superset of the set of values of the primary key in relation R2 (where R1 and R2 can be the same relation), the referential integrity rule is violated, but it cannot be determined if the entity integrity rule is violated. In other words, the foreign key constraint is not satisfied, but it is uncertain if the primary key constraint is also violated.

Rate this question:
33.

Koju kardinalnost treba da ima atribut da bi bio jednoznačni atribut entiteta
- A.
  
  (1,1)
- B.
  
  (1,N)
- C.
  
  (M,1)
- D.
  
  (M,N)
Correct Answer
A. (1,1)

Explanation
The answer (1,1) indicates that the attribute should have a cardinality of one-to-one in order to be a unique attribute of an entity. This means that each entity instance can have only one value for this attribute and each value can be associated with only one entity instance.

Rate this question:
34.

Prostor objekta je
- A.
  
  Konačan skup tebela, kojima su opisani objekti
- B.
  
  Konačan skup objekta, koji su od interesa za problem koji se rešava
- C.
  
  Konačan skup atributa, koji su od interesa za objekte kojim se opisuju
- D.
  
  Konačne normalne forme kojima su predstavljeni objekti
Correct Answer
B. Konačan skup objekta, koji su od interesa za problem koji se rešava

Explanation
The correct answer suggests that the space of the object is a finite set of objects that are relevant to the problem being solved. It implies that the objects being considered are limited and specifically chosen based on their relevance to the problem at hand.

Rate this question:
35.

Za atomarne vrednosti i logičke slogove važi sledeće:
- A.
  
  Atomarna vrednost podataka je dostupna na osnovu imena relacije, imena elementarnog obeležja i kvantitativne vrednosti indetifikatora zapisa, a logički slog je dostupan na osnovu imena relacije i kvantitativne vrednosti indetifikatora zapisa
- B.
  
  Logički slog je dostupan na osnovu imena relacije, imena elementarnog obeležja i kvantitativne vrednosti indetifikatora zapisa, a atomarna vrednost podataka je dostupana na osnovu imena relacije i kvantitativne vrednosti indetifikatora zapisa
- C.
  
  Logički slog je dostupan na osnovu imena relacije, imena elementarnog obeležja i kvantitativne vrednosti indetifikatora zapisa, a atomarna vrednost podataka je dostupana na osnovu imena relacije i imena elementarnog obeležja
- D.
  
  Atomarna vrednost podataka je dostupna na osnovu imena relacije, imena elementarnog obeležja i kvantitativne vrednosti indetifikatora zapisa, a logički slog je dostupan na osnovu imena relacije i imena elementarnog obeležja
Correct Answer
A. Atomarna vrednost podataka je dostupna na osnovu imena relacije, imena elementarnog obeležja i kvantitativne vrednosti indetifikatora zapisa, a logički slog je dostupan na osnovu imena relacije i kvantitativne vrednosti indetifikatora zapisa

Explanation
The given answer states that atomic data values are accessible based on the name of the relation, the name of the elementary attribute, and the quantitative value of the record identifier, while logical records are accessible based on the name of the relation and the quantitative value of the record identifier. This implies that atomic data values require additional information (the name of the elementary attribute) compared to logical records, which only require the name of the relation and the quantitative value of the record identifier.

Rate this question:
36.

Model objekti-veze (MOV) se koristi kod
- A.
  
  Projektovanja baza podataka
- B.
  
  Inplementacija baza podataka
- C.
  
  Projektovanja aplikacije za rad sa bazama podataka
- D.
  
  Održavanje baze podataka
Correct Answer
A. Projektovanja baza podataka

Explanation
The Model-View-Controller (MVC) design pattern is commonly used in software development, particularly in the design of databases. The Model objekti-veze (MOV) is specifically used in the design of databases. It helps in organizing the data and defining the relationships between different entities in the database. By using the MOV model, developers can create a clear and structured database design that can efficiently store and retrieve data. Therefore, the correct answer is "projektovanja baza podataka" (designing databases).

Rate this question:
37.

Zapis ili logički slog je
- A.
  
  Skup svih vrednosti elementarnih obeležja koje se odnose na jedan objekat
- B.
  
  Skup zapisa koji odgovaraju jednom prostoru objekta
- C.
  
  Biblioteka datoteka
- D.
  
  Nešto što postoji i što se može jednoznačno identifikovati
Correct Answer
A. Skup svih vrednosti elementarnih obeležja koje se odnose na jedan objekat

Explanation
The correct answer is "skup svih vrednosti elementarnih obeležja koje se odnose na jedan objekat" because it accurately defines the term "zapis ili logički slog" as a set of all values of elementary characteristics related to an object. This definition implies that a "zapis ili logički slog" represents the data or information associated with an object. The other options, such as "skup zapisa koji odgovaraju jednom prostoru objekta" (set of records corresponding to a space of an object) or "biblioteka datoteka" (file library), do not accurately describe the concept of "zapis ili logički slog."

Rate this question:
38.

Klauzula kojom se proverava postojanje najmanje jedne n-torke u rezultatu pretraživanja je
- A.
  
  EXISTS
- B.
  
  MATCH
- C.
  
  LIKE
- D.
  
  NVL
Correct Answer
A. EXISTS

Explanation
The correct answer is EXISTS. This is because the EXISTS clause is used to check for the existence of at least one tuple in the result of a query. It is commonly used in conjunction with a subquery to determine if a certain condition is met. If the subquery returns any rows, the EXISTS clause evaluates to true, otherwise it evaluates to false.

Rate this question:
39.

Koja naredba pripada grupi naredbi za definisanje podataka
- A.
  
  ALTER TABLE
- B.
  
  DELETE
- C.
  
  GRANT
Correct Answer
A. ALTER TABLE

Explanation
The correct answer is ALTER TABLE. This command is used to modify the structure of an existing table in a database, such as adding or deleting columns, modifying data types, or changing constraints. It is a data definition language (DDL) statement that allows users to define and alter the structure of tables to store and manipulate data. DELETE is used to remove rows from a table, while GRANT is used to grant privileges to users in a database.

Rate this question:
40.

Sql kod za kreiranje tabele je:
- A.
  
  MAKE TABLE ODELJENJE (BROD integer, IMEOD Text(20), MESTO Text(20));
- B.
  
  CREATE TABLE ODELJENJE (BROD integer, IMEOD Text(20), MESTO Text(20));
- C.
  
  ALTER TABLE ODELJENJE (BROD integer, IMEOD Text(20), MESTO Text(20));
- D.
  
  ADD TABLE ODELJENJE (BROD integer, IMEOD Text(20), MESTO Text(20));
Correct Answer
B. CREATE TABLE ODELJENJE (BROD integer, IMEOD Text(20), MESTO Text(20));

Explanation
The correct answer is "CREATE TABLE ODELJENJE (BROD integer, IMEOD Text(20), MESTO Text(20));". This is the correct SQL code for creating a table named "ODELJENJE" with three columns: "BROD" of type integer, "IMEOD" of type Text with a maximum length of 20 characters, and "MESTO" of type Text with a maximum length of 20 characters. The other options provided are not valid SQL syntax for creating a table.

Rate this question:
41.

Entitet koji se može potpuno definisati jednim primarnim ključem i nizom atributa je
- A.
  
  čvrst objekat
- B.
  
  Vezni bojekat, koji ima sva svojstva objekta
- C.
  
  Slab objekat, identifikaciono zavistan od čvrstog objekta
- D.
  
  Slab objekat, egzistencijalno zavistan od čvrstog objekta
Correct Answer
A. čvrst objekat

Explanation
A čvrst objekat is an entity that can be fully defined by a primary key and a set of attributes. This means that the primary key uniquely identifies the entity, and the attributes provide additional information about the entity. In contrast, a vezni objekat is an object that has all the properties of an object but is not fully defined by a primary key and attributes. A slab objekat can either be identifikaciono zavistan (identification-dependent) or egzistencijalno zavistan (existentially-dependent) on a čvrst objekat, meaning its existence or identity is dependent on the čvrst objekat.

Rate this question:
42.

Domen atributa je
- A.
  
  Skup dozvoljenih vrednosti koje neki atribut može da uzeti
- B.
  
  Nešto što postoji i što se može jednoznačno indetifikovati
- C.
  
  Iskaz definisan jednom prostom rečenicom
- D.
  
  Novi podatak koji poseduje relavantnu novinu, neko novo saznanje, a rezultat je obrada poznatih podataka
Correct Answer
A. Skup dozvoljenih vrednosti koje neki atribut može da uzeti

Explanation
The correct answer is "skup dozvoljenih vrednosti koje neki atribut može da uzeti" which translates to "a set of allowed values that an attribute can take." This explanation aligns with the concept of a domain of an attribute, which refers to the range of valid values that can be assigned to that attribute.

Rate this question:
43.

Koji od iskaza je tačan
- A.
  
  Svaki atribut mora imati ime a jedan objekat karakteristiše jedan atribut
- B.
  
  Atribut ne mora imati ime ali mora imati vrednost
- C.
  
  Jedan objekat može da karakteristiše više atributa a atributi ne moraju imati imena
- D.
  
  Jedan objekat može da karakteristiše više atributa
Correct Answer
D. Jedan objekat može da karakteristiše više atributa

Explanation
The correct answer is that one object can have multiple attributes. This means that an object can possess or be associated with multiple characteristics or properties. It is not necessary for attributes to have names, but they must have values. This statement is true because in object-oriented programming, an object is typically defined by its attributes, which describe the object's state or characteristics. Multiple attributes can be used to fully describe an object and differentiate it from other objects.

Rate this question:
44.

Osobine primarnog ključa su
- A.
  
  Jedinstvenost, nepromenljivost i raspoloživost
- B.
  
  Nepromenljivost i raspoloživost
- C.
  
  Jedinstvenost i raspoloživost
- D.
  
  Jedinstvenost i nepromenljivost
Correct Answer
A. Jedinstvenost, nepromenljivost i raspoloživost

Explanation
The primary key is a unique identifier for each record in a database table. It ensures that each record has a unique value and cannot be duplicated. The primary key is also immutable, meaning it cannot be changed once it is assigned to a record. Lastly, the primary key must be available for retrieval and reference in order to uniquely identify each record. Therefore, the correct answer is "jedinstvenost, nepromenljivost i raspoloživost" which translates to "uniqueness, immutability, and availability" in English.

Rate this question:
45.

Ako kažemo da jedan radnik radi u jednom odeljenju a u jednom odeljenju radi više radnika tada je kardinalnost veze
- A.
  
  1:M
- B.
  
  0:M
- C.
  
  M:M
- D.
  
  2:M
Correct Answer
A. 1:M

Explanation
The answer 1:M means that one worker works in one department, and one department can have multiple workers. This indicates a one-to-many relationship between the workers and the departments. Each worker is assigned to only one department, but a department can have multiple workers.

Rate this question:
46.

Minimalni uslovi koje tabela mora da ispuni da bi bila u relaciji su
- A.
  
  Svi redovi moraju biti jedinstveni, sve kolone moraju imati različita imena, a redosled kolona i redosled redova nije bitan. Primarni ključ mora da postoji. U svakom polju se sme nalaziti samo jedan podatak.
- B.
  
  Svi redovi moraju biti jedinstveni, sve kolone moraju imati različita imena, a redosled kolona i redosled redova nije bitan. Primarni ključ mora da postoji, kao i indeks po jednom ne-ključnom atributu. U svakom polju se sme nalaziti samo jedan podatak.
- C.
  
  Svi redovi moraju biti jedinstveni, sve kolone moraju imati različita imena, a redosled kolona i redosled redova nije bitan. Primarni ključ mora da postoji. Tabela mora biti indeksirana po najmanje jednom ne-ključnom atributu.
- D.
  
  Svi redovi moraju biti jedinstveni, sve kolone moraju imati različita imena, a redosled kolona i redosled redova nije bitan. Primarni ključ mora da postoji. U svakom polju se sme nalaziti samo jedan podatak. Vrednost svih podataka u jednoj koloni su istog tipa.
Correct Answer
A. Svi redovi moraju biti jedinstveni, sve kolone moraju imati različita imena, a redosled kolona i redosled redova nije bitan. Primarni ključ mora da postoji. U svakom polju se sme nalaziti samo jedan podatak.

Explanation
The correct answer states that for a table to be in a relation, all rows must be unique, all columns must have different names, and the order of columns and rows is not important. Additionally, a primary key must exist, and only one data entry is allowed in each field. This answer covers all the necessary conditions for a table to be in a relation.

Rate this question:
47.

Koja osobina veze je kardionalnost
- A.
  
  Tip veze
- B.
  
  Red veze
- C.
  
  Stepen veze
- D.
  
  Način uspostavljanja veze
Correct Answer
A. Tip veze

Explanation
The correct answer is "tip veze" (type of relationship). This is because the question is asking about the characteristic that defines a relationship, and the type of relationship refers to the specific category or classification of the relationship. The other options (red veze, stepen veze, način uspostavljanja veze) do not directly correspond to the characteristic of a relationship.

Rate this question:
48.

U naredbe jezika za kontrolu podata (Data Control Lenguage) spadaju
- A.
  
  Grant, revoke
- B.
  
  Create table, create view, begin transaction
- C.
  
  Create index, create view, alter table
- D.
  
  Insert, update, delete
Correct Answer
A. Grant, revoke

Explanation
The correct answer is "grant, revoke". Grant and revoke are commands in the Data Control Language (DCL) that are used to manage permissions and privileges in a database. These commands allow users to grant or revoke specific privileges on database objects to other users or roles. They are essential for controlling access and ensuring data security in a database system. The other options mentioned in the question are not part of the DCL, but rather belong to other categories such as Data Definition Language (DDL) or Data Manipulation Language (DML).

Rate this question:
49.

Vrste entiteta su
- A.
  
  Realni bojekat, apstraktni pojam, događaj, asocijacija
- B.
  
  Redovi u tabeli
- C.
  
  Primarni, sekundarni, vezni(slabi)
- D.
  
  Realni entiteti, apstraktni entiteti, pogledi, tabele
Correct Answer
A. Realni bojekat, apstraktni pojam, događaj, asocijacija

Explanation
The correct answer is a list of different types of entities. It includes real objects, abstract concepts, events, and associations. These are all categories or classifications of entities that can exist in various contexts or domains.

Rate this question:
50.

Imamo sledeće modele:1. relacioni model2. hijerajhiski i mrežni model3. objektno orjentisani model4. model zasnovan na programskim jezicimaNavesti redosled kojim su se pojavljivali od prve generacije do četvrte
- A.
  
  4,2,1,3
- B.
  
  4,2,3,1
- C.
  
  1,3,2,4
- D.
  
  2,4,3,1
Correct Answer
A. 4,2,1,3

Explanation
The correct answer is 4,2,1,3. The question asks for the order in which the models appeared from the first generation to the fourth. The relational model (1) was the first to appear, followed by the hierarchical and network models (2), then the object-oriented model (3), and finally the model based on programming languages (4).

Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

Current Version
Mar 21, 2023

Quiz Edited by
ProProfs Editorial Team
Dec 18, 2014

Quiz Created by
Nemanja

Featured Quizzes

Do I Have a Crush on Him? Quiz Do I Have a Crush on Him? Quiz

7th Grade Science Quiz Questions and Answers 7th Grade Science Quiz Questions and Answers

Which BTS Member Are You? Quiz Which BTS Member Are You? Quiz

Take the Does He Like Me Quiz to Decode His True Feelings Take the Does He Like Me Quiz to Decode His True Feelings

Game Recommendations Quiz: What Game Should I Play? Game Recommendations Quiz: What Game Should I Play?

Which FNAF Character Are You? Which FNAF Character Are You?

Back to top

Baze Podataka Drugi Kolokvijum

Digitalna slika realnog dela sveta, koja je od značaja za informacioni sistem je

Za razliku od hijerarhijskog modela informacionog sistema, mrežni model dozvoljava

Kardinalnost relacije je

U SQL upitu

Data je tabela tab1 <ime> sa atributom ime. Koji upit vraća spisak svih imena koja sadrže mala slova "a" i "b" ?

Ako svaki atribut koji nije ključni potpuno funkcionalno zavisi od primarnog ključa,relacija se nalazi u

Data je tabela radnik <idbr, posao, ime, prezime, brod>. Koji je upit od siedećih ispravan ?

Pogled je

Posmatraju se objekti RAČUN i STAVKA nekog računa. Za te objekte važisledeće

Slabi objekti koji identifikacijski zavise od nekog čvrstog objekta

Data je tabela GRAĐANIN <matbr, ime, prezime, matbr2>. Atribut matbr predstavljamatični broj osobe, a matbr2 matični broj bračnog druga osobe koja je opisana ujednom zapisu. Između n-torki tabele GRAĐANIN postoje

Date su tabele NASTAVNIK i PREDMET. Pod uslovom da jedan nastavnik može dapredaje više predmeta, između zapisa ovih tabela ostvarene su

Prilikom prevođenja E-R modela na relaconi oblik

Prilikom prevođenja E-R modela, za binarne veze važi sledeće

Anomalije pri upisu, brisanju i izmeni podataka javljaju se kao posledica

Postupak dekompozicije tabeia s ciljem postizanja dobrih osobina relacionog modela i uklanjanja moguće pojave nekontrolisane redundanse je

Dovoljni i potrebni uslovi koje atribut mora da ispunjava da bi mogao bitikandidat za primami ključ su

Ime relacije, vrednost primarnog ključa i ime atributa relacije jednoznačnoidentifikuju

Pravilo referencijalnog integriteta glasi

Prema Codd-u, pravila integriteta baze podataka definišu se na sledećim mestima

U operatore pogodne za ažuriranje spadaju

U operatore pogodne za izveštavanje spadaju

U naredbe za definisanje podataka (Data Definition Staternents) spadaju

U naredbe za rukovanje podacima (Data Manipulation Statements) spadaju

Indeksi omogućavaju

Opšti oblik select upita glasi

Višestruke zapise, u tabeli koju select upit vraća kao odgovor, eliminišemo klauzulom

Relacija se nalazi u trećoj normalnoj formi

Relacija sa dekomponuje bez opasnosti gubitka funkcionalnih zavisnosti samo ako

Date su tabele :radnik <me, brod> sa 1000 zapisa iodeljenje <drod, imeod> sa 100 zapisa. SOL upit:SELECT ime, imeod FROM radnik, odeljenjeWHERE radnik.brod = odeljenje.brod AND radnik.ime LIKE "A%"vrši operaciju selekcije nad

Svakom elementarnom obeležju pripisuje se

Ukoliko je skup vrednosti spoljnjeg ključa relacije R1 nadskup skupa vrednosti primarnog ključa R2 (pri čemu relacije R1 i R2 ne moraju biti različite)

Koju kardinalnost treba da ima atribut da bi bio jednoznačni atribut entiteta

Prostor objekta je

Za atomarne vrednosti i logičke slogove važi sledeće:

Model objekti-veze (MOV) se koristi kod

Zapis ili logički slog je

Klauzula kojom se proverava postojanje najmanje jedne n-torke u rezultatu pretraživanja je

Koja naredba pripada grupi naredbi za definisanje podataka

Sql kod za kreiranje tabele je:

Entitet koji se može potpuno definisati jednim primarnim ključem i nizom atributa je

Domen atributa je

Koji od iskaza je tačan

Osobine primarnog ključa su

Ako kažemo da jedan radnik radi u jednom odeljenju a u jednom odeljenju radi više radnika tada je kardinalnost veze

Minimalni uslovi koje tabela mora da ispuni da bi bila u relaciji su

Koja osobina veze je kardionalnost

U naredbe jezika za kontrolu podata (Data Control Lenguage) spadaju

Vrste entiteta su

Imamo sledeće modele:1. relacioni model2. hijerajhiski i mrežni model3. objektno orjentisani model4. model zasnovan na programskim jezicimaNavesti redosled kojim su se pojavljivali od prve generacije do četvrte