Baze Podataka - Uvodni Pojmovi

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Sanja.srdelic
S
Sanja.srdelic
Community Contributor
Quizzes Created: 6 | Total Attempts: 8,895
| Attempts: 2,350
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/30 Pitanja

    Tablice u relacijskoj bazi međusobno povezujemo pomoću primarnih i stranih ključeva koristeći tzv. ...

    • Linkove (hiperveze)
    • Upite (querye)
    • Izvješća (reporte)
    • Relacije (veze)
Please wait...
Baze Podataka - Uvodni Pojmovi - Quiz
About This Quiz

Poznavanje osnovne terminologije

Quiz Preview

  • 2. 

    Nepotrebno ponavljanje istih podataka unutar baze podataka nazivamo 

    • Normalizacija

    • Optimizacija

    • Hiperinflacija

    • Zalihost ili redundancija

    Correct Answer
    A. Zalihost ili redundancija
    Explanation
    The correct answer is "zalihost ili redundancija" which translates to "redundancy or duplication" in English. This refers to the unnecessary repetition of the same data within a database. Redundancy can lead to data inconsistencies and inefficiencies in storage and retrieval. Normalization, optimization, and hyperinflation are not relevant to this concept.

    Rate this question:

  • 3. 

    Skup programa koji omogućuju kreiranje i održavanje baze podataka, te kontrolu pristupa podacima nazivamo 

    • DBBS

    • DBMS

    • DMBS

    • DMMS

    Correct Answer
    A. DBMS
    Explanation
    The correct answer is DBMS. DBMS stands for Database Management System, which is a software program that allows users to create and maintain a database, as well as control access to the data. It provides an interface for users to interact with the database, allowing them to perform tasks such as creating tables, inserting data, querying the database, and managing security and permissions. DBMS is essential for organizing and managing large amounts of data efficiently and securely.

    Rate this question:

  • 4. 

    Kada polje služi za unos podataka do 655 znakova koristiti ćemo vrstu podataka Short text (Kratki tekst)

    • Točno

    • Netočno

    Correct Answer
    A. Netočno
    Explanation
    The correct answer is "Netočno" (False). This is because the statement suggests that we should use the data type "Short text" for entering data up to 655 characters, but the correct data type for this purpose would be "Long text" or "Text". The "Short text" data type typically allows for a shorter character limit, such as 255 characters.

    Rate this question:

  • 5. 

    Tekstualne podatke duljine do 255 znakova unosimo u polje vrste 

    • Kratki tekst (Short text)

    • Dugi tekst (long text)

    • Samonumeriranje (Autonumber)

    • Privitak (Attachment)

    Correct Answer
    A. Kratki tekst (Short text)
    Explanation
    The correct answer is "Kratki tekst (Short text)". This is because the given options are different types of data fields that can be used to input textual data. Among these options, "Kratki tekst (Short text)" is the most suitable for entering textual data of up to 255 characters. The other options, such as "Dugi tekst (long text)" and "Privitak (Attachment)" are not specifically designed for inputting short textual data.

    Rate this question:

  • 6. 

    Skup logički organiziranih i međusobno povezanih podataka koji čine neku cjelinu nazivamo 

    • Informacija

    • Tablica

    • Banka podataka

    • Baza podataka

    Correct Answer
    A. Baza podataka
    Explanation
    A skup logički organiziranih i međusobno povezanih podataka koji čine neku cjelinu nazivamo baza podataka.

    Rate this question:

  • 7. 

    Polje (polja) koje nedvosmisleno identificira svaki zapis pohranjen u tablicu i ima jedinstvenu vrijednost naziva se...

    • Strani ključ

    • Primarni (glavni) ključ

    • Relacijski ključ

    • šifra

    Correct Answer
    A. Primarni (glavni) ključ
    Explanation
    A primarni (glavni) ključ is a field (or fields) that uniquely identifies each record stored in a table and has a unique value. It is used to ensure the integrity and uniqueness of the data in the table.

    Rate this question:

  • 8. 

    _________________ je postupak organiziranja podataka s ciljem kreiranja učinkovite, pouzdane (sačuvan integritet baze podatka) i fleksibilne baze podataka.

    • Redundancija

    • Optimizacija

    • Normalizacija

    • Skodiranje

    Correct Answer
    A. Normalizacija
    Explanation
    Normalizacija je postupak organiziranja podataka u bazi podataka radi eliminacije redundancije i postizanja veće efikasnosti, pouzdanosti i fleksibilnosti. Ovaj postupak pomaže u održavanju integriteta baze podataka i smanjuje potrebu za ponavljanjem istih podataka u različitim tabelama. Normalizacija se koristi kako bi se osiguralo da svaki podatak bude zapisan samo jednom i da se veze između podataka jasno definišu.

    Rate this question:

  • 9. 

    Stupac u tablici baze podataka nazivamo...

    Correct Answer
    polje
    field
    Explanation
    In the context of a database table, a "stupac" refers to a column. A column represents a specific attribute or characteristic of the data being stored in the table. The term "polje" is the Croatian translation for "field," which is commonly used to describe a column in a database table. Therefore, the correct answer is "polje" or "field."

    Rate this question:

  • 10. 

    Polje Prezime u nekoj tablici možemo definirati kao primarni ključ.

    • Točno

    • Netočno

    Correct Answer
    A. Netočno
    Explanation
    The given statement states that the field "Prezime" in a table can be defined as a primary key. However, this statement is incorrect. A primary key is a unique identifier for each record in a table, and it cannot contain duplicate or null values. In most cases, a field like "Prezime" (which translates to "Last Name") would not be suitable as a primary key because multiple people can have the same last name. Therefore, the correct answer is "Netočno" (False).

    Rate this question:

  • 11. 

    Osnovni objekt baze podataka koji sadrži podatke i koji je temelj za izradu svih ostalih objekata je

    • Izvješće

    • Obrazac

    • Upit

    • Tablica

    Correct Answer
    A. Tablica
    Explanation
    The correct answer is "tablica". In a database, a table is the basic object that stores data and serves as the foundation for creating other objects. It organizes data into rows and columns, allowing for efficient storage and retrieval of information. Tables are essential for structuring and managing data in a database system, and they are used to represent entities and their relationships in a relational database model.

    Rate this question:

  • 12. 

    Činjenicu predstavljenu zvukom, tekstom ili brojem koja sama za sebe ne mora imati nikakvo značenje nazivamo

    Correct Answer
    podatak
    podatkom
    Explanation
    The correct answer is "podatak" because it refers to a fact presented in the form of sound, text, or numbers that may not have any meaning on its own.

    Rate this question:

  • 13. 

    Skup podataka kojima smo pridodali značenje i kontekst i kojim doznajemo nešto novo nazivamo

    • Baza podataka

    • Informacija

    • Podatak

    • Tablica

    Correct Answer
    A. Informacija
    Explanation
    The given correct answer is "informacija". In the context of the question, it is stated that we add meaning and context to a set of data in order to learn something new. This aligns with the definition of "informacija", which means information in Croatian. Therefore, it can be concluded that the correct term for the described situation is "informacija".

    Rate this question:

  • 14. 

    Definiranje, dodavanje i brisanje polja, izmjena svojstava polja i sl. postupci su koje obavljamo u _____________ prikazu tablice (view).

    • Prikazu podatkovne tablice (datasheet view)

    • Prikazu dizajna (Design view)

    • Niti jedan odgovor nije točan

    • Oba odgovora su točna

    Correct Answer
    A. Prikazu dizajna (Design view)
    Explanation
    In the Design view, we can define, add, and delete fields, as well as modify field properties and perform other actions related to the design of the table. This view allows us to make structural changes to the table, such as adding or removing fields, and also modify the properties of the fields. Therefore, it is the correct answer for the given question.

    Rate this question:

  • 15. 

    Unos podataka u tablicu obavlja se u Prikazu dizajna tablice.

    • Netočno

    • Točno

    Correct Answer
    A. Netočno
    Explanation
    The given statement is incorrect. The correct answer is "Netočno" which means "False" in English. The statement implies that data entry in a table is done in the Design View of the table, but this is not true. Data entry in a table is typically done in the Datasheet View or Form View of the table.

    Rate this question:

  • 16. 

    Redak u tablici baze podataka nazivamo ...

    Correct Answer
    zapis
    record
    Explanation
    The correct answer for this question is "zapis, record". In a database table, a record refers to a complete set of information about a specific entity or item. It is a collection of related data fields that are grouped together to represent a single entity. In Croatian, the term for record is "zapis". Therefore, both "zapis" and "record" are correct terms to describe a row or entry in a database table.

    Rate this question:

  • 17. 

    Kada želimo da Access sam dodjeljuje jedinstvene numeričke vrijednosti u polje kako bismo ga mogli koristiti za npr. šifru proizvoda tada ćemo za vrstu polja odabrati _________

    Correct Answer
    Autonumber
    Explanation
    When we want Access to automatically assign unique numerical values to a field so that we can use it for purposes like product codes, we would choose the field type as Autonumber.

    Rate this question:

  • 18. 

    Primarni ključ u tablici može biti npr. polje...

    • OIB

    • Prezime

    • Ime

    • JMBG

    • Broj šasije automobila

    • Matični broj učenika u matičnoj knjizi škole

    • Šifra proizvoda u skladištu

    • Broj putovnice

    Correct Answer(s)
    A. OIB
    A. JMBG
    A. Broj šasije automobila
    A. Matični broj učenika u matičnoj knjizi škole
    A. Šifra proizvoda u skladištu
    A. Broj putovnice
    Explanation
    The given answer lists various examples of fields that can be used as the primary key in a table. These fields include OIB (personal identification number), JMBG (unique master citizen number), car chassis number, student ID number, product code in a warehouse, and passport number. A primary key is a unique identifier for each record in a table, and it ensures that there are no duplicate records. In this case, any of the listed fields can serve as a primary key, depending on the specific requirements and characteristics of the table.

    Rate this question:

  • 19. 

    U njima je spremljena lokacija zapisa na nekom polju ili poljima. Koriste se da se ubrzaju pretragu i dohvat podataka. Koriste prema principu kazala pojmova u knjizi. To su....

    • Primarni ključevi

    • Filteri

    • Indeksi

    • Zadane vrijednosti

    Correct Answer
    A. Indeksi
    Explanation
    Indexes are used to speed up the search and retrieval of data by storing the location of records on a field or fields. They work based on the principle of an index in a book. Therefore, the correct answer is "indeksi".

    Rate this question:

  • 20. 

    Prikaz dizajna tablice sadrži sljedeće elemente:

    • Naziv polja

    • Opis

    • Vrsta podataka

    • Svojstva polja

    • Toga uopće nema u prikazu dizajna

    Correct Answer(s)
    A. Naziv polja
    A. Opis
    A. Vrsta podataka
    A. Svojstva polja
    Explanation
    The correct answer includes the elements that are present in the design view of a table, which are the field name, description, data type, and field properties.

    Rate this question:

  • 21. 

    Osobe uključene u sustav baza podataka su 

    • Programeri aplikacija

    • Korisnici

    • Administratori baze

    • Krajnji korisnici

    • Serviseri računala

    • Nitko od navedenih

    Correct Answer(s)
    A. Programeri aplikacija
    A. Korisnici
    A. Administratori baze
    A. Krajnji korisnici
    Explanation
    The individuals involved in a database system are programmers of applications, users, database administrators, and end-users. These individuals play different roles in the database system. Programmers of applications develop the software that interacts with the database. Users are individuals who interact with the database system to perform various tasks. Database administrators are responsible for managing and maintaining the database system. End-users are the ultimate consumers of the data stored in the database. Therefore, the correct answer includes all these individuals.

    Rate this question:

  • 22. 

    MS Access je...

    • Komercijalni software

    • Opensource software

    • Desktop DBMS

    • Podržava SQL

    • Ne podržava SQL

    • Ne podržava SQL

    Correct Answer(s)
    A. Komercijalni software
    A. Desktop DBMS
    A. Podržava SQL
    Explanation
    MS Access is a commercial software that is used as a desktop database management system (DBMS). It supports SQL, which stands for Structured Query Language, allowing users to interact with and manipulate the database.

    Rate this question:

  • 23. 

    DBMS je kratica od engleskog naziva za sustav za upravljanje bazama podataka tj.

    Correct Answer(s)
    database management system
    Database Management System
    Database management System
    Database management system
    Explanation
    The correct answer is "database management system". This is the correct term for the English abbreviation "DBMS" which stands for "database management system". The answer options "Database Management System", "Database management System", and "Database management system" are all variations of the correct term, but they are not written in the correct capitalization format.

    Rate this question:

  • 24. 

    Osnovni objekti u bazi podataka su:

    • Tablica

    • Upit

    • Obrazac

    • Izvješće

    Correct Answer(s)
    A. Tablica
    A. Upit
    A. Obrazac
    A. Izvješće
    Explanation
    The correct answer is tablica, upit, obrazac, izvješće. In a database, the basic objects are tables, queries, forms, and reports. Tables store the actual data in a structured format, queries are used to retrieve specific data from the tables, forms provide a user-friendly interface for entering and viewing data, and reports are used to present data in a formatted and organized manner. These objects are essential components of a database system and are used for various purposes in managing and analyzing data.

    Rate this question:

  • 25. 

    Vrste tj. modeli baza podataka koji su danas najviše u upotrebi su...

    • Plošne

    • Relacijske

    • Mrežne

    • Hijerarhijske

    Correct Answer(s)
    A. Relacijske
    A. Mrežne
    A. Hijerarhijske
    Explanation
    The correct answer includes the terms "relacijske," "mrežne," and "hijerarhijske," which are all types or models of databases that are commonly used today. Relational databases organize data into tables with rows and columns, while network databases organize data using a network structure, and hierarchical databases organize data in a tree-like structure. These three types of databases are widely used in various industries and applications for efficient data management and retrieval.

    Rate this question:

  • 26. 

    Vrste podataka u poljima možemo definirati kao:

    • Kratki tekst (Short text)

    • Dugi tekst (Long tekst)

    • Web lokacija (Web page)

    • Broj (Number)

    • Valuta (Currency)

    • Slika (Picture)

    • Da/Ne (Yes/No)

    • Datum/vrijeme (Date/time)

    • Samonumeriranje (Automumber)

    • Hiperveza (Hyperlink)

    Correct Answer(s)
    A. Kratki tekst (Short text)
    A. Dugi tekst (Long tekst)
    A. Broj (Number)
    A. Valuta (Currency)
    A. Da/Ne (Yes/No)
    A. Datum/vrijeme (Date/time)
    A. Samonumeriranje (Automumber)
    A. Hiperveza (Hyperlink)
    Explanation
    The given answer lists the different types of data that can be defined in fields. These include short text, long text, number, currency, yes/no, date/time, autonumber, hyperlink.

    Rate this question:

  • 27. 

     Treća normalna forma (3NF) zahtijeva da

    • Da bude zadovoljena prva normalna forma (1NF)

    • Da bude zadovoljena druga normalna forma (2NF)

    • Da su sva polja indeksirana

    •  sva polja moraju biti jednoznačna i u potpunosti ovisiti o glavnom ključu (engl. primary key).

    • Sva polja koja nisu dio glavnog ključa ne smiju međusobno ovisiti jedno o drugom

    Correct Answer(s)
    A. Da bude zadovoljena prva normalna forma (1NF)
    A. Da bude zadovoljena druga normalna forma (2NF)
    A.  sva polja moraju biti jednoznačna i u potpunosti ovisiti o glavnom ključu (engl. primary key).
    Explanation
    The correct answer states that the third normal form (3NF) requires the satisfaction of the first normal form (1NF), the second normal form (2NF), and that all fields must be unique and fully dependent on the primary key. This means that the data must be organized into tables with atomic values, there should be no partial dependencies, and all non-key fields should depend on the entire primary key.

    Rate this question:

  • 28. 

     Druga normalna forma (2NF) zahtijeva da

    • Da bude zadovoljena prva normalna forma (1NF)

    • Da bude zadovoljena treća normalna forma (3NF)

    • Da su sva polja indeksirana

    •  sva polja moraju biti jednoznačna i u potpunosti ovisiti o glavnom ključu (engl. primary key).

    • U svakoj tablici moraju se zapisivati podatci o samo jednom subjektOption 5

    Correct Answer(s)
    A. Da bude zadovoljena prva normalna forma (1NF)
    A.  sva polja moraju biti jednoznačna i u potpunosti ovisiti o glavnom ključu (engl. primary key).
    Explanation
    The correct answer is that the second normal form (2NF) requires that the first normal form (1NF) is satisfied, and that all fields must be unique and fully dependent on the primary key. This means that each field in the table must have a unique value and the value of each field should be determined by the primary key. This ensures that the table is properly organized and eliminates any potential data redundancy or anomalies.

    Rate this question:

  • 29. 

    Prva normalna forma (1NF) zahtjeva

    • Atomičnost polja tablice

    • Da svi zapisi moraju imati isti broj polja

    • Ne sadržavati vrijednosti koje se ponavljaju

    • Da bude zadovoljena druga normalna forma

    • Da bude zadovoljena treća normalna form

    • Da su sva polja indeksirana

    Correct Answer(s)
    A. Atomičnost polja tablice
    A. Da svi zapisi moraju imati isti broj polja
    A. Ne sadržavati vrijednosti koje se ponavljaju
    Explanation
    The correct answer is that 1NF requires atomicity of table fields, that all records must have the same number of fields, and that it should not contain repeating values. This means that each field in the table should contain a single value, records should have a consistent structure, and there should be no duplicate values within the table. These requirements help ensure data integrity and eliminate data redundancy in the table.

    Rate this question:

Quiz Review Timeline (Updated): Jul 22, 2024 +

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

  • Current Version
  • Jul 22, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Sep 26, 2016
    Quiz Created by
    Sanja.srdelic
Back to Top Back to top
Advertisement