Evp 2 :D

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 Isatest
I
Isatest
Community Contributor
Quizzes Created: 2 | Total Attempts: 18,950
| Attempts: 9,497
Quiz Flashcard
SettingsSettings
Please wait...
  • 1/143 klausimų

    In Access, extensia implicita a unei baze de date este

    • .mdb
    • .dbf
    • .xls
Please wait...
Evp 2 :D - Quiz

Quiz Preview

  • 2. 

    In acceess infrmatiile din domeniul economic sunt prezentate in cel mai adesea:

    • Prin intermediul rapoartelor

    • In fisierele mp3

    • Ca vectori

    Correct Answer
    A. Prin intermediul rapoartelor
    Explanation
    Economic information is most commonly presented through reports, which provide detailed analysis and data on various aspects of the economy. Reports are a widely used medium for presenting economic information as they allow for organized and structured presentation of data, making it easier for readers to understand and interpret the information.

    Rate this question:

  • 3. 

    In Acces, cheia primara poate fi:

    • Simpla

    • Compusa

    • Formata din cel mult 3 atribute

    Correct Answer(s)
    A. Simpla
    A. Compusa
    Explanation
    The primary key in Access can be either simple or composite. A simple primary key consists of a single attribute, while a composite primary key is formed by combining multiple attributes. Therefore, the correct answer is that the primary key in Access can be both simple and composite.

    Rate this question:

  • 4. 

    In Access, atributele care formeaza structura unei tabele:

    • Nu pot fi modificate

    • Nu pot fi sterse

    • Sunt supuse restrictiilor definite de utilizator

    Correct Answer
    A. Sunt supuse restrictiilor definite de utilizator
    Explanation
    The attributes that form the structure of a table in Access are subject to the restrictions defined by the user. This means that the user can define specific rules and limitations for each attribute, such as data type, length, format, or any other constraints that need to be enforced. These restrictions ensure data integrity and consistency within the table. The attributes cannot be modified or deleted because they are essential for the structure and functionality of the table.

    Rate this question:

  • 5. 

    Formularea "orice procedura cuprinde un set de instructiuni care indeplinesc o anumita sarcina este":

    • Incorecta

    • Corecta

    • Partial corecta

    • Partial incorecta

    Correct Answer
    A. Corecta
    Explanation
    The statement "orice procedura cuprinde un set de instructiuni care indeplinesc o anumita sarcina" is correct. It means that every procedure includes a set of instructions that fulfill a specific task. This statement accurately describes the nature of procedures, as they are designed to carry out specific actions or tasks by following a predefined set of instructions. Therefore, the answer "corecta" is the correct choice.

    Rate this question:

  • 6. 

    In Access pentru interogarea "Lista studentilor care sau prezentat numai la examenele din data de 10 februarie 2007" conditia se stabileste in zona:

    • Criteria

    • Show

    • Sort

    • Field

    Correct Answer
    A. Criteria
    Explanation
    The correct answer is "Criteria." In Access, the criteria is the part of a query where you specify the conditions that the data must meet to be included in the results. In this case, the criteria would be set to filter the list of students who have only attended exams on February 10, 2007.

    Rate this question:

  • 7. 

    O functie procedurala VBA se refera la instructiuni cuprinse intre:

    • Inceput.... Sfirsit

    • Sub.... End sub

    • Function..... End function

    Correct Answer
    A. Function..... End function
    Explanation
    A procedural VBA function refers to instructions enclosed between "Function" and "End function". This is the correct answer because in VBA, a function is a block of code that performs a specific task and returns a value. The "Function" keyword is used to define the start of a function, and the "End function" keyword is used to mark the end of the function.

    Rate this question:

  • 8. 

    Ce se obtine prin urm interogara>? SELECT Data FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=Facturi.CodClient AND Localitatea="Iasi"

    • Codurile clientilor din localitatea iasi

    • Facturile emise tuturor clientilor

    • Zilele in care au fost emise facturi clientilor din iasi

    • Zilele in care au fost emise facturi

    Correct Answer
    A. Zilele in care au fost emise facturi clientilor din iasi
    Explanation
    The given SQL query is selecting the "Data" column from the tables "CLIENTI" and "FACTURI" where the "CodClient" column in both tables match and the "Localitatea" column is equal to "Iasi". Therefore, the query will return the dates on which invoices were issued to clients in Iasi.

    Rate this question:

  • 9. 

    Care din clauzele din fraza SELECT nu sunt obligatorii?

    • FROM

    • WHERE

    • SELECT

    Correct Answer
    A. WHERE
    Explanation
    The WHERE clause in a SELECT statement is not mandatory. It is used to specify conditions that must be met for the rows to be included in the result set. If no WHERE clause is specified, all rows from the selected table(s) will be returned. Therefore, the WHERE clause is not obligatory in a SELECT statement.

    Rate this question:

  • 10. 

    Comanda DROP TABLE este folosita pt:

    • Stergerea unei tabele din baza de date

    • Modificarea structurii unei tabele

    • Modificarea valorii unor atribute

    Correct Answer
    A. Stergerea unei tabele din baza de date
    Explanation
    The correct answer is "stergerea unei tabele din baza de date" which translates to "deleting a table from the database" in English. The DROP TABLE command is used to remove an entire table and all its data from the database. It is a way to permanently delete a table and its contents, rather than just modifying the structure or values of the attributes.

    Rate this question:

  • 11. 

    Ce se obtine prin urm interogara>? SELECT NumeClient FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=Facturi.CodFacturi AND NrFactura=12345

    • Numele tuturor clientilor

    • Clientii din iasi

    • Clientii care au intocmit factura 12345

    • Clientul caruia ia fost trimisa factura 12345

    Correct Answer
    A. Clientul caruia ia fost trimisa factura 12345
    Explanation
    The query will retrieve the name of the client to whom the invoice with the number 12345 was sent.

    Rate this question:

  • 12. 

    Care dintre urmatoarele afirmatii sunt adevarate?

    • Access dispune de mecanisme pentru exportul datelor in Excel si/sau Word

    • Acces permite gasirea rapida a datelor legate intre ele

    • Acces nu permite afisarea datelor sub forma de pagini Web

    Correct Answer(s)
    A. Access dispune de mecanisme pentru exportul datelor in Excel si/sau Word
    A. Acces permite gasirea rapida a datelor legate intre ele
    Explanation
    Access dispune de mecanisme pentru exportul datelor în Excel și/sau Word - Această afirmație este adevărată deoarece Access oferă opțiuni pentru exportul datelor în formatele Excel și Word, permițând utilizatorilor să transfere informațiile din baza de date în aceste aplicații.

    Acces permite găsirea rapidă a datelor legate între ele - Această afirmație este adevărată deoarece Access are funcții de căutare și interogare care facilitează identificarea și accesarea rapidă a datelor legate între ele în baza de date.

    Acces nu permite afișarea datelor sub formă de pagini web - Această afirmație este falsă deoarece Access oferă opțiuni pentru publicarea bazelor de date pe web, permițând afișarea datelor sub formă de pagini web.

    Rate this question:

  • 13. 

    Intr-un formular Access, este obligatorie sectiunea

    • Detalii

    • Antetul si subsolul de pagina (Page Header si Page Footer)

    • Antetul si subsolul de formular (Form Header si Form Footer)

    Correct Answer
    A. Detalii
    Explanation
    In a Microsoft Access form, the "detalii" section is mandatory. This section includes the page header and page footer, as well as the form header and form footer. These sections provide important information and formatting for the form, such as the title, page numbers, and any additional details or instructions.

    Rate this question:

  • 14. 

    In Access, care dintre urmatoarele enunturi sunt adevarate?

    • Intr-o baza de date, poate fi creat un singur formular, pentru tabela parinte

    • Poate fi creat cite un formular pentru fiecare tabela componenta a unei baze de date

    • Intr-o baza de date poate fi creat cite un formular numai pentru tabelele copil

    Correct Answer
    A. Poate fi creat cite un formular pentru fiecare tabela componenta a unei baze de date
    Explanation
    In Access, it is true that a form can be created for each component table in a database. This means that for every table in a database, a separate form can be created to interact with the data in that table. This allows for more flexibility and customization in the user interface of the database.

    Rate this question:

  • 15. 

    In cadrul unui formular pot sa para maxim:

    • 5 sectiuni de lucru

    • 3 sectiuni de lucru

    • 6 sectiuni de lucru

    Correct Answer
    A. 5 sectiuni de lucru
    Explanation
    The maximum number of sections that can appear in a form is 5.

    Rate this question:

  • 16. 

    Ce determnina executia comezii :DROP TABLE CLIENTI?

    • Adaugarea unui nou tabel in baza de date

    • Stergerea tabelului clienti

    • Modificarea tabelului clienti

    • Crearea tabelului clienti

    Correct Answer
    A. Stergerea tabelului clienti
    Explanation
    The execution of the command "DROP TABLE CLIENTI" determines the deletion of the table named "CLIENTI". This command is used to remove a table from the database. So, the correct answer is "stergerea tabelului clienti" which means "deletion of the CLIENTI table" in English.

    Rate this question:

  • 17. 

    In Access, sunt acceptate urmatoarele tipri de date:

    • Text

    • Memo

    • Numeric

    • Vlookup

    Correct Answer(s)
    A. Text
    A. Memo
    A. Numeric
    Explanation
    The given answer lists the accepted data types in Access, which are text, memo, and numeric. These data types are commonly used to store different types of information in a database. "Text" is used for alphanumeric characters, "memo" is used for longer text or notes, and "numeric" is used for numerical values. "Vlookup" is not a valid data type in Access and therefore is not included in the answer.

    Rate this question:

  • 18. 

    In Access, cheia primara este naturala atunci cind este declarata:

    • Prin AutoNumber

    • De utilizator prin AutoNumber

    • De utilizator prin alegerea unui atribut/grup de atribute din structura tabelei

    Correct Answer
    A. De utilizator prin alegerea unui atribut/grup de atribute din structura tabelei
    Explanation
    The correct answer is "de utilizator prin alegerea unui atribut/grup de atribute din structura tabelei". This means that the primary key in Access is chosen by the user by selecting an attribute or a group of attributes from the table's structure. This allows the user to define a unique identifier for each record in the table, which is essential for maintaining data integrity and facilitating efficient data retrieval. The other options, "prin AutoNumber" and "de utilizator prin AutoNumber", refer to using an automatically generated number as the primary key, which is also a valid option in Access but not the correct answer in this case.

    Rate this question:

  • 19. 

    In Access tipul implicit de interogare este:

    • Selectie

    • Stergere

    • Modificare

    • Actualizare

    Correct Answer
    A. Selectie
    Explanation
    The correct answer is "Selectie" because in Access, the default type of query is a "Select" query. This type of query is used to retrieve specific data from one or more tables based on specified criteria. It allows the user to select and display specific fields from the tables and apply filters to narrow down the results. The other options (stergere, modificare, actualizare) refer to different types of queries that involve deleting, modifying, or updating data in the tables, which are not the default types of queries in Access.

    Rate this question:

  • 20. 

    Cu referire la Accesss care dintre urm enunturi sunt edevarate?

    • Este conceput pentru scenarii multiutilizator

    • Nu pot accesa datele in acelasi timp mai mul de 10 utilizatori

    • Interfata este construia in principal din linia de meniuri,linia de intrumente database si panoul de activitati Task Pane

    Correct Answer(s)
    A. Este conceput pentru scenarii multiutilizator
    A. Interfata este construia in principal din linia de meniuri,linia de intrumente database si panoul de activitati Task Pane
    Explanation
    Access este conceput pentru scenarii multiutilizator, ceea ce înseamnă că mai mulți utilizatori pot accesa și lucra în același timp cu baza de date. Interfața este construită în principal din linia de meniuri, linia de instrumente database și panoul de activități Task Pane. Nu există informații în textul dat referitoare la limita de 10 utilizatori care pot accesa datele în același timp.

    Rate this question:

  • 21. 

    In ce an a aparut standartul SQL3?

    • 1989

    • 1999

    • 1992

    Correct Answer
    A. 1999
    Explanation
    The correct answer is 1999. This is the year when the SQL3 standard was introduced. SQL3, also known as SQL-99, is the third major revision of the SQL database query language. It introduced several new features and enhancements, including support for object-oriented programming, user-defined types, and improved support for complex queries. The introduction of SQL3 in 1999 marked a significant milestone in the evolution of the SQL language.

    Rate this question:

  • 22. 

    In Acces declararea restrictiilor unei tabele presupune ca aceasta sa fie deschisa in modul:

    • Design

    • Open

    • View

    Correct Answer
    A. Design
    Explanation
    The correct answer is "Design" because when declaring restrictions for a table in Access, it is necessary for the table to be open in Design mode. This mode allows users to make changes to the structure and properties of the table, including adding constraints and defining restrictions. "Open" mode simply allows users to view and edit the data in the table, while "View" mode only allows users to view the data without making any changes to the table's structure or properties.

    Rate this question:

  • 23. 

    In Access, optiunea Cascade Update Related Fields activata determina ca:

    • La modificarea unei valori a cheii primare din tabela parinte sa se modifice in cascada toate cheile straine din inregistrarile copil corespondente

    • La stergerea unei valori a cheii primare din tabela parinte sa se stearga in cascada toate cheile straine din inregistrarile copil corespondente

    • La modificarea unei valori a cheii straine din tabela parinte sa se modifice in cascada toate cheile primare din tabela copil corespondenta

    Correct Answer
    A. La modificarea unei valori a cheii primare din tabela parinte sa se modifice in cascada toate cheile straine din inregistrarile copil corespondente
    Explanation
    When the "Cascade Update Related Fields" option is enabled in Access, it means that when a value of the primary key in the parent table is modified, all corresponding foreign keys in the child records will be updated in cascade. This ensures that any changes made to the primary key are reflected in the related records in the child table.

    Rate this question:

  • 24. 

    In Access, formatul pentr date calendaristice:

    • Este ales de utilizator dintr-o lista prestabilita

    • Este stabilit de utilizator, dar cu lungimea maxima de 40 de carcatere

    • Nu are importanta, deoarece intern, aceste date sunt reprezentate ca numere

    Correct Answer
    A. Este ales de utilizator dintr-o lista prestabilita
    Explanation
    The correct answer is "este ales de utilizator dintr-o lista prestabilita". In Access, the format for calendar dates is chosen by the user from a predefined list of formats. This means that the user can select the format that best suits their needs from a range of options provided by Access.

    Rate this question:

  • 25. 

    In Access, declararea restrictiilor dupa popularea tabelelor cu inregistrari:

    • Asigura prelucrarea corecta a tuturor informatiilor in tabele

    • Poate determina prelucrarea incorecta a informatiilor in tabele

    • Asigura alegerea corecta a cheilor primare

    Correct Answer
    A. Poate determina prelucrarea incorecta a informatiilor in tabele
    Explanation
    Declararea restrictiilor dupa popularea tabelelor cu inregistrari poate determina prelucrarea incorecta a informatiilor in tabele. This is because if constraints are not defined before inserting data into the tables, there is a possibility of inserting incorrect or inconsistent data that does not adhere to the defined constraints. This can lead to data integrity issues and incorrect processing of information in the tables. It is important to define constraints before populating tables to ensure the correct processing of all information.

    Rate this question:

  • 26. 

    PEntru  utilizatorul final,obiectivul principal SQL este:

    • Explicitarea modului in care se face cautarea

    • Formularea unei consultari numai prin decsrierea rezultatului dorit

    • Decsrierea pas cu pas a operatiunilor de realizat

    Correct Answer
    A. Formularea unei consultari numai prin decsrierea rezultatului dorit
    Explanation
    The main objective of SQL for the end user is to formulate a query solely by describing the desired result. This means that the user should be able to specify what they want to retrieve from the database without having to specify how to retrieve it or the step-by-step operations to be performed. The focus is on the outcome rather than the process.

    Rate this question:

  • 27. 

    In Access o tabela poate fi creata folosind:

    • Modul de proiectare Design View

    • Introducind datele in campurile create de Exel

    • Asistentul Table Wizard

    Correct Answer(s)
    A. Modul de proiectare Design View
    A. Asistentul Table Wizard
    Explanation
    The correct answer is "modul de proiectare Design View, asistentul Table Wizard". In Access, a table can be created using the Design View mode or the Table Wizard assistant. In the Design View mode, users can define the structure of the table by specifying the field names, data types, and other properties. The Table Wizard, on the other hand, provides a step-by-step guide for creating a table by selecting pre-defined templates or importing data from external sources. Both methods offer different approaches to creating tables in Access.

    Rate this question:

  • 28. 

    Se da urn fraza SQL: SELECT NumeClient, SUM(Vaoare Totala) As totalValTotala FROM FACTURI, CLIENTI WHERE CLIENTI.CodClient=FACTURI.CodClient GROUp BY Nume client HAVING COUNT(Nr factura)>5 Rezultatul aceste fraze va contine:

    • Valoarea facturilor emise pnetru fiecare client care are codul mai mare ca 5

    • Valoare facturilor emise

    • Valoarea facturilor emise pentru clientii carora li sau trimis mai mult de 5 facturi

    Correct Answer
    A. Valoarea facturilor emise pentru clientii carora li sau trimis mai mult de 5 facturi
    Explanation
    The correct answer is "valoarea facturilor emise pentru clientii carora li sau trimis mai mult de 5 facturi". This is because the query includes the HAVING clause with the condition COUNT(Nr factura)>5, which filters the result to only include clients who have been sent more than 5 invoices. Therefore, the result will show the total value of invoices issued for those clients.

    Rate this question:

  • 29. 

    In Access, declararea restricitiilor trebuie facuta:

    • Odata cu crearea tabelei

    • Inaintea incarcarii tabelei cu rticole

    • Dupa popularea tabelei cu articole

    Correct Answer(s)
    A. Odata cu crearea tabelei
    A. Inaintea incarcarii tabelei cu rticole
    Explanation
    The correct answer is "odata cu crearea tabelei". In Access, when declaring restrictions, it is necessary to do it at the same time as creating the table. This means that the restrictions should be specified during the table creation process. It is important to define the restrictions before loading the table with articles, as it ensures that the data being loaded meets the specified restrictions.

    Rate this question:

  • 30. 

    In Access, restrictia de integritate referentiala cere ca:

    • Valorile cheii straine din tabela parinte sa se regaseasa printre valorile cheii primare din tabela copil

    • Valorile cheii straine din tabela copil sa se regaseasa printre valorile cheii primare din tabela parinte

    • Valorile cheii alternative din tabela parinte sa se regaseasa printre valorile cheii primare din tabela copil

    Correct Answer
    A. Valorile cheii straine din tabela copil sa se regaseasa printre valorile cheii primare din tabela parinte
    Explanation
    The correct answer is that the foreign key values in the child table should be found among the primary key values in the parent table. This is because referential integrity ensures that any value in the foreign key field of the child table must correspond to a value in the primary key field of the parent table. This ensures that the relationship between the two tables is maintained and prevents orphaned records in the child table.

    Rate this question:

  • 31. 

    In Access, optiunea Cascade Update Related Fields activata determina ca:

    • La modificarea unei valori a cheii primare din tabela parinte sa se modifice in cascada toate cheile straine din inregistrarile copil corespondente

    • La stergerea unei valori a cheii primare din tabela parinte sa se stearga in cascada toate cheile straine din inregistrarile copil corespondente

    • La modificarea unei valori a cheii straine din tabela parinte sa se modifice in cascada toate cheile primare din tabela copil corespondenta

    Correct Answer
    A. La modificarea unei valori a cheii primare din tabela parinte sa se modifice in cascada toate cheile straine din inregistrarile copil corespondente
    Explanation
    When the "Cascade Update Related Fields" option is enabled in Access, it means that when a value of the primary key in the parent table is modified, all corresponding foreign keys in the child records will be updated in cascade. This ensures that any changes made to the primary key value in the parent table are reflected in the related child records.

    Rate this question:

  • 32. 

    In Access:

    • Pentru scrierea de proceduri, se folosesc limbajele C, Cobol sau Fortran

    • Pentru scrierea de proceduri, se foloseste VBA

    • O procedura contine un set de instructiuni care realizeaza o anumita sarcina

    Correct Answer(s)
    A. Pentru scrierea de proceduri, se foloseste VBA
    A. O procedura contine un set de instructiuni care realizeaza o anumita sarcina
    Explanation
    The correct answer is "pentru scrierea de proceduri, se foloseste VBA" because in Access, VBA (Visual Basic for Applications) is the programming language used for writing procedures. A procedure is a set of instructions that performs a specific task.

    Rate this question:

  • 33. 

    Un formular Access, are urmatoarele sectiuni

    • Zona Detalii

    • Antetul de raport

    • Subsolul de raport

    • Antetul de pagina

    • Subsolul de pagina

    Correct Answer(s)
    A. Zona Detalii
    A. Antetul de pagina
    A. Subsolul de pagina
    Explanation
    The given answer is suggesting that in an Access form, there are four sections: "zona Detalii" (Details area), "antetul de pagina" (page header), and "subsolul de pagina" (page footer). This implies that the form consists of a section for displaying detailed information, as well as sections for displaying the header and footer information on each page.

    Rate this question:

  • 34. 

    In proiectele Access se pot organiza urmatoarele tipuri de obiecte:

    • Pagini

    • Macrouri

    • Agende de lucru

    Correct Answer(s)
    A. Pagini
    A. Macrouri
    Explanation
    In proiectele Access, se pot organiza pagini și macrouri ca obiecte. Paginile sunt utilizate pentru a crea interfețe de utilizator pentru bazele de date, unde utilizatorii pot introduce și vizualiza datele. Macrourile sunt utilizate pentru a automatiza acțiuni și operații în baza de date, cum ar fi deschiderea unui formular sau efectuarea unei interogări. Prin organizarea acestor obiecte în proiect, utilizatorii pot gestiona și accesa mai ușor diferitele funcționalități ale bazei de date.

    Rate this question:

  • 35. 

    Limbajele de interogare pot fi:

    • Teoretice

    • Practice

    • Sintetice

    Correct Answer(s)
    A. Teoretice
    A. Practice
    Explanation
    The correct answer is "teoretice, practice" because the question asks for the types of query languages, and the options provided are "teoretice" (theoretical) and "practice" (practical). This suggests that query languages can be classified into these two categories.

    Rate this question:

  • 36. 

    Care dintre urm enunturi reprezinta facilitati majore ale Accsesului:

    • Afiseaza datele pe ecran sau la imprimanta,intrun format usor de inteles

    • Blocheaza exportul datelor in Excel si /sau in Word

    • Asigura protectia datelor de erori

    • Dispune de o inerfata usor de folosit pentru introducerea datelor

    Correct Answer(s)
    A. Afiseaza datele pe ecran sau la imprimanta,intrun format usor de inteles
    A. Asigura protectia datelor de erori
    A. Dispune de o inerfata usor de folosit pentru introducerea datelor
    Explanation
    The correct answer is "afiseaza datele pe ecran sau la imprimanta, intr-un format usor de inteles, asigura protectia datelor de erori, dispune de o interfata usor de folosit pentru introducerea datelor". This answer is correct because it highlights the major features of Access, which include displaying data on screen or printer in an easily understandable format, ensuring data protection from errors, and having a user-friendly interface for data input.

    Rate this question:

  • 37. 

    Ce se obtine prin urm interogara>? SELECT Data FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=Facturi.CodClient AND NumeClient="Gama SA"

    • Facturile emise clientului GAma SA

    • Facturi emise tuturor clientilor

    • Zilele in care au fost trimirse facurile clientului Gama SA

    • Zilele in care au fost emise facturile

    Correct Answer
    A. Zilele in care au fost trimirse facurile clientului Gama SA
    Explanation
    The given SQL query is selecting the "Data" column from the tables "CLIENTI" and "FACTURI" where the "CodClient" column in both tables match and the "NumeClient" is equal to "Gama SA". Therefore, the query will retrieve the dates on which the invoices were sent to the client "Gama SA".

    Rate this question:

  • 38. 

    Pentru declararea cheilor straine prin comanda CREATe TABLE,se utilizeaza clauza:

    • PRIMARY KEY

    • UNIQUE

    • REFERENCES

    • NOT NULL

    Correct Answer
    A. REFERENCES
    Explanation
    The correct answer is REFERENCES. When declaring foreign keys using the CREATE TABLE command, the REFERENCES clause is used. This clause specifies the table and column that the foreign key references, establishing a relationship between the two tables.

    Rate this question:

  • 39. 

    In Access, la crearea tabelelor, pentru fiecare atribut trebuie precizat:

    • Numele

    • Tipul

    • Lungimea

    • Locatia in care se va salva

    Correct Answer(s)
    A. Numele
    A. Tipul
    A. Lungimea
    Explanation
    When creating tables in Access, it is necessary to specify the name, type, and length for each attribute. Additionally, the location where the table will be saved may also need to be specified, depending on the specific requirements of the database management system.

    Rate this question:

  • 40. 

    CE se va obtine prin urma interogare? SELECT NumeStudent FROM STUDNETI WHERE Grupa IN(SELECT Grupa FROM STUDENTI WHERE NrMatricol="31040701SL050198")

    • Numele studentului ce are nr matricol 310.....

    • Numele studnetilor care sunt in grupa cu studentu;l ce are nr matricol 310...

    • Grupa din care face parte studnetul ce are nr matricol 310...

    Correct Answer
    A. Numele studnetilor care sunt in grupa cu studentu;l ce are nr matricol 310...
    Explanation
    The given SQL query is selecting the "NumeStudent" (name of the student) from the table "STUDENTI" where the "Grupa" (group) is in the result of another query that selects the "Grupa" from the same table "STUDENTI" where the "NrMatricol" (student ID) is equal to "31040701SL050198". Therefore, the correct answer is "numele studnetilor care sunt in grupa cu studentu;l ce are nr matricol 310..." which means "the names of the students who are in the same group as the student with student ID 31040701SL050198".

    Rate this question:

  • 41. 

    Prin ce clauza din comanda CREATE TABLE din SQL se introduc regulile de validare?

    • Validation rule

    • Check

    • Validation text

    Correct Answer
    A. Check
    Explanation
    The correct answer is "check." In SQL, the "check" clause is used in the CREATE TABLE command to introduce validation rules. This clause allows the user to define conditions that must be met for data to be considered valid and inserted into the table. The "check" clause ensures that only data that satisfies the specified conditions is added to the table, providing a way to enforce data integrity and consistency.

    Rate this question:

  • 42. 

    ACCESS este:

    • Un sistem de gestiune a bazelor de date relationale

    • Un program de calcul tabelar care admite organizarea in baze de date

    • Un SGBD

    Correct Answer(s)
    A. Un sistem de gestiune a bazelor de date relationale
    A. Un SGBD
    Explanation
    The correct answer is "un sistem de gestiune a bazelor de date relationale, un SGBD". This is because ACCESS is a software program that is used as a relational database management system (SGBD) for organizing and managing databases. It allows users to create and manipulate tables, forms, queries, and reports in a relational database environment.

    Rate this question:

  • 43. 

    In Access, raportul:

    • Este construit pe baza datelor din tabele

    • Reprezinta ansamblu de informatii obtinute, conform cerintelor utilizatorului

    • Poate fi obtinut doar la imprimanta

    • Poate fi obtinut si la imprimanta

    Correct Answer(s)
    A. Este construit pe baza datelor din tabele
    A. Reprezinta ansamblu de informatii obtinute, conform cerintelor utilizatorului
    A. Poate fi obtinut si la imprimanta
    Explanation
    The correct answer is that a report in Access is built based on data from tables, represents a collection of information obtained according to the user's requirements, and can be obtained both on the printer and in other formats.

    Rate this question:

  • 44. 

    SQL se bazeaza pe

    • Calculul relational

    • Algebra relationala

    • Modelul obiectula

    Correct Answer(s)
    A. Calculul relational
    A. Algebra relationala
    Explanation
    SQL se bazează pe calculul relational și algebra relatională. Acestea sunt două teorii matematice care stau la baza limbajului SQL și a sistemelor de baze de date relationale. Calculul relational se referă la operațiile de interogare și manipulare a datelor într-o bază de date, în timp ce algebra relatională se referă la operațiile și regulile pentru combinarea și filtrarea datelor într-o bază de date. Aceste două concepte sunt fundamentale pentru înțelegerea și utilizarea SQL-ului în mod eficient.

    Rate this question:

  • 45. 

    In Access, care dintre urmatoarele afirmatii sunt adevarate?

    • Lookup Wizard este un cimp special cu acre se construiesc expresii pentru calcule precise

    • Ole Object este un tip de date care permite stocarea documentelor Word, a foilor de calcul Exccel et.

    • Currency este un tip de date conceput pentru a obtine rezultate precise in calculele cu banii

    Correct Answer(s)
    A. Ole Object este un tip de date care permite stocarea documentelor Word, a foilor de calcul Exccel et.
    A. Currency este un tip de date conceput pentru a obtine rezultate precise in calculele cu banii
    Explanation
    The statement "Ole Object este un tip de date care permite stocarea documentelor Word, a foilor de calcul Exccel et." is true because an Ole Object data type in Access allows for the storage of documents from other applications, such as Word or Excel.

    The statement "Currency este un tip de date conceput pentru a obtine rezultate precise in calculele cu banii" is also true because the Currency data type in Access is specifically designed for accurate calculations involving money.

    Rate this question:

  • 46. 

    Care dintre urmatoarele comenzii SQL sunt destinate manipularii datelor

    • DELETE

    • ALTER TABLE

    • SELECT

    • DROP TABLE

    Correct Answer(s)
    A. DELETE
    A. SELECT
    Explanation
    The correct answer is DELETE and SELECT because these two SQL commands are specifically designed for manipulating data. The DELETE command is used to remove rows from a table, while the SELECT command is used to retrieve data from one or more tables. The ALTER TABLE command is used to modify the structure of a table, and the DROP TABLE command is used to delete an entire table from the database. However, these two commands do not directly manipulate data like the DELETE and SELECT commands do.

    Rate this question:

  • 47. 

    Se da urm interogare SQL: SELECT Data FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=ABONATI.CodClinet AND CodClient=1120 IN URMA Executiei rez va fi:

    • Nicio linie pntru ca fraza sql este gresita

    • Doua linii

    • O singura linie

    • Patru linii

    Correct Answer
    A. Nicio linie pntru ca fraza sql este gresita
    Explanation
    The SQL query is incorrect because there is a typo in the table name "ABONATI" which should be "CLIENTI". Therefore, the query will not return any rows.

    Rate this question:

  • 48. 

    Ce se obtine prin urm interogare SQL? SELECT NrFactura FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=ABONATI.CodClinet AND Data IN (#07/05/2007#,#14/05/2007#)

    • Numai facturile emise in saptamina 7-14 mai 2007

    • Numai facturile emise intre 7 si 14 mai 2007

    • Numai facurile emise pe 7 sau 14 mai 2007

    • Numai facturile emise clientilor din iasi

    Correct Answer
    A. Numai facurile emise pe 7 sau 14 mai 2007
    Explanation
    The given SQL query will retrieve the invoice numbers (NrFactura) from the tables CLIENTI and FACTURI. The WHERE clause specifies the condition for the query, which is that the CodClient in CLIENTI table should match the CodClient in ABONATI table and the Data should be either on 07/05/2007 or 14/05/2007. Therefore, the query will only return the invoices that were issued on either 7th or 14th May 2007.

    Rate this question:

  • 49. 

    Ce se obtine prin urm interogare SQL? SELECT NrFactura FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=ABONATI.CodClinet AND ValtTot IN(5000,10000)

    • Numai facturile emise cu valoarea intre 5000 si 10000

    • Numai facturile emise cu valoarea de 5000 si 10000

    • Numai facturile emise cu valoarea fie intre 5000 si 10000 fie intre 10000 si 5000

    Correct Answer
    A. Numai facturile emise cu valoarea de 5000 si 10000
    Explanation
    The given SQL query will retrieve only the invoices that have a value of either 5000 or 10000. It uses the "IN" operator to specify the values and the "WHERE" clause to filter the results based on the condition. Therefore, the correct answer is "numai facturile emise cu valoarea de 5000 si 10000" which translates to "only the invoices issued with a value of 5000 and 10000".

    Rate this question:

Quiz Review Timeline (Updated): Mar 21, 2023 +

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
  • Apr 07, 2013
    Quiz Created by
    Isatest
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.