ISA

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: 19,037
| Attempts: 9,538 | �ntrebri: 162
Please wait...
Isa test
Question 1 / 162
0 %
0/100
Score 0/100
1. Care functie calculeaza madia aritmetica simpla?

Explanation

The correct answer is AVERAGE. The AVERAGE function calculates the simple arithmetic mean of a set of numbers. It adds up all the numbers in the set and then divides the sum by the count of numbers in the set. This function is commonly used to find the average of a range of numbers in Excel or other spreadsheet programs.

Submit
Please wait...
About This Quiz
ISA - Quiz

Personalize your quiz and earn a certificate with your name on it!
2. Excel face parte din:

Explanation

Excel is a spreadsheet program developed by Microsoft, which is a part of the MS Office suite. MS Office is a collection of productivity applications, including Word, PowerPoint, and Outlook, among others. Therefore, Excel is included in MS Office.

Submit
3. Argumentele functiilor excel sunt incluse intre caracterele:

Explanation

The correct answer is "()". The parentheses are used to enclose the arguments of Excel functions. The arguments are the values or references that the function uses to perform calculations or operations. By enclosing the arguments in parentheses, Excel can identify and process them correctly within the function.

Submit
4. Cu referire la Excel,care dintre urmatoarele enunturi sunt adevarate?

Explanation

In Excel, the user can rename worksheets and add or delete worksheets in a workbook. This means that the statement "intr-un registru de lucru, utilizatorul poate adauga sau sterge foi de calcul" (in a workbook, the user can add or delete worksheets) is true. However, the statement "intr-un registru de lucru, numarul foilor de calcul nu poate fi mai mare ca 3" (in a workbook, the number of worksheets cannot be greater than 3) is false, as there is no limitation on the number of worksheets in Excel.

Submit
5. Prin operatiile de copiere sua mutare adresele absolute se modifica?

Explanation

The correct answer is "no." In operations such as copying or moving, absolute addresses do not change. Absolute addresses refer to specific locations in memory or on a storage device, and they remain the same regardless of any copying or moving operations.

Submit
6. Care sunt adevara?

Explanation

The correct answer states that after creating a chart in Excel, it can be modified using the options in the chart menu. Additionally, it states that modifying the data in the spreadsheet will also result in changes to the charts. This explanation highlights the functionality of Excel in allowing users to customize and update their charts based on the data in the spreadsheet.

Submit
7. In excel,specificarea Preturi!B45 indica:

Explanation

The correct answer is "casuta B45 din foaia de calcul Preturi". This means that the specific area "Preturi!B45" refers to cell B45 in the worksheet named "Preturi".

Submit
8. In excel prin operatiile de copiere adresele absolute se modifica?

Explanation

The correct answer is "no." In Excel, absolute references do not change when copied. Absolute references are used to fix a specific cell or range of cells in a formula so that it does not adjust when the formula is copied to other cells. This is useful when you want to maintain a constant reference to a specific cell or range in your calculations.

Submit
9. La modificarea continutului unei casute are loc:

Explanation

When the content of a cell is modified, the graph representing the value in that cell is automatically updated and the formulas and functions referencing that cell are also automatically recalculated.

Submit
10. Reprezentarea structurii profitului anual pe cele patru trimestre se realizeaza intr-un grafic de tip:

Explanation

The correct answer is "pie" because a pie chart is commonly used to represent the distribution or proportion of different categories or parts of a whole. In this case, the annual profit is being represented, and a pie chart would be suitable for showing the percentage or share of profit contributed by each of the four quarters.

Submit
11. Sa presupunem ca s-a realizat o investitie care aduce in urmatorii 3 ani incasarile:in anul 2008,8ROn;in anul 2009,7 Ron,in anul 2010,6,5 ron.Ce funstie financiara se utilizeaza pentru a estima eficienta investitiei realizate,sub aspectul ratei de rentabilitate?

Explanation

The correct answer is IRR (Internal Rate of Return). IRR is a financial function used to estimate the efficiency of an investment by calculating the rate at which the investment's net present value (NPV) equals zero. It takes into account the cash flows generated by the investment over a specific period of time and calculates the rate of return that would make the NPV of those cash flows equal to zero. In this case, by using IRR, we can determine the rate of return that would make the net present value of the cash flows from the investment equal to zero over the next three years.

Submit
12. Programele de calcul tabelar:

Explanation

The given answer states that programul de calcul tabelar integreaza facilitati de lucru cu tabele and permite reprezentarea grafica a datelor. This means that spreadsheet programs have features that allow working with tables and also provide the ability to represent data graphically. This suggests that spreadsheet programs are designed to handle and manipulate data in a tabular format, making it easier to organize and analyze information. Additionally, the ability to create visual representations of data through charts and graphs can aid in understanding and presenting the data effectively.

Submit
13. Care dintre urmatoarele reguli trebuie respecatete in Excel?

Explanation

The rule that needs to be respected in Excel is that no spaces should be left between the function name and arguments.

Submit
14. In casutele foilor de calcul Excel,pot fi introduse:

Explanation

In casutele foilor de calcul Excel, pot fi introduse date numerice, siruri de caractere, formule si functii. Datele numerice pot fi numere sau valori numerice, cum ar fi sume sau procente. Sirurile de caractere sunt textele sau cuvintele introduse în celule. Formulele sunt utilizate pentru a efectua calcule și operații matematice pe datele introduse. Funcțiile sunt predefinite în Excel și pot fi utilizate pentru a efectua operații complexe sau pentru a returna valori specifice în funcție de anumite criterii.

Submit
15. Protejarea unei foi de calcul asigura:

Explanation

The correct answer is the protection of a spreadsheet ensures the avoidance of deliberate deterioration of applications and the avoidance of unintentional deterioration of applications. This means that by protecting a spreadsheet, the risk of intentional and unintentional damage to the applications within it is minimized.

Submit
16. Optiunea de sortare la un moment dat poate fi:

Explanation

The correct answer is "ascending, descending". This is because the option for sorting at any given time can be either ascending or descending. Ascending means arranging the items in increasing order, while descending means arranging them in decreasing order. Therefore, the correct answer includes both options as it is possible to choose either ascending or descending for sorting.

Submit
17. Considerind o zona dintr-o foaie de calcul, B5:B10, denumita Venituri, cum se poate exprima suma valorilor din casutele acestei zone?

Explanation

The correct answer is =SUM(B5:B10) and =SUM(Venituri). Both expressions calculate the sum of the values in the range B5 to B10, which is named Venituri. The SUM function in Excel is used to add up a range of cells, and it can be written either with the actual range (B5:B10) or with the named range (Venituri). Both expressions will yield the same result, which is the sum of the values in the specified range.

Submit
18. Pentru calculul amortizarii se folosesc functiile:

Explanation

These functions are used for calculating depreciation.

- =SLN() is used to calculate straight-line depreciation, which evenly distributes the cost of an asset over its useful life.
- =DDB() is used to calculate the declining balance depreciation, which applies a higher depreciation rate in the early years and decreases it over time.
- =SYD() is used to calculate the sum-of-years' digits depreciation, which allocates more depreciation in the early years and less in the later years.

These functions are commonly used in financial analysis and accounting to determine the value of assets over time.

Submit
19. Ce restrictii trebuie sa respecte zona criteriu creata pentru interogarea unei baze de date?

Explanation

The restriction that needs to be respected in the created criterion zone for querying a database is that the field name to which the condition refers must be identical to the one in the database structure.

Submit
20. In memoria interna,o data calendaristica Excel este reprezentata:

Explanation

In memoria interna, data calendaristica Excel este reprezentata ca un numar. Aceasta se datoreaza faptului ca in Excel, datele calendaristice sunt stocate sub forma de numere seriale, unde fiecare numar reprezinta o anumita data. De exemplu, data 1 ianuarie 2022 poate fi reprezentata prin numarul 44405. Acest format numeric permite utilizatorului sa efectueze operatii matematice si calcule pe datele calendaristice, precum adunari, scaderi sau comparatii.

Submit
21. Simularile in tabelele de simulare pot fi realizate in functie de:

Explanation

The correct answer is "o variabila, doua variabile". This means that similarities in simulation tables can be created based on either one variable or two variables. This suggests that the simulation tables can be used to analyze and compare data based on different variables, providing flexibility in the analysis process.

Submit
22. Care dintre urmatorii operatori se utilizeaza pentru concatenarea sirurilor de caractere?

Explanation

The correct answer is "&". In programming, the "&" operator is used for concatenating strings or joining them together. It allows you to combine two or more strings into a single string. For example, if you have two strings "Hello" and "World", using the "&" operator you can concatenate them as "HelloWorld".

Submit
23. Care dintre umatoarele enunturi sunt corecte?

Explanation

The correct answer is IRR determines the internal rate of return for a series of income generated by an investment and DDB calculates depreciation using the declining balance method.

Submit
24. In foile da calcul Excel,adresele casutelor pot fi:

Explanation

The addresses of cells in an Excel spreadsheet can be categorized as logical, physical, relative, absolute, or mixed. Logical addresses refer to the column and row headers, such as A1 or B5. Physical addresses, on the other hand, refer to the actual physical location of the cells on the spreadsheet. Relative addresses are cell references that change when copied or moved, while absolute addresses remain constant. Mixed addresses combine elements of both relative and absolute addresses. Therefore, the correct answer is relative, absolute, and mixed.

Submit
25. Tipul datelor din casutele foilor excel este determinat de:

Explanation

The data type in Excel cells is determined by the first character entered. This means that if the first character is a number, Excel will recognize it as a numeric data type. If the first character is a letter or symbol, Excel will recognize it as a text data type. The data type affects how Excel treats the data for calculations and formatting.

Submit
26. O pers fizica vrea sa ia imprumut de la o banca ,cu rambursare 10 ani,in conditiile in care isi permite sa plateasca lunar o rata de 100 RON.In conditiile in care rata dobinzii va fi neschimbata (7%),ce functii folositi pentru  a afla valoarea maxima a creditului de care paote beneficia in prezent persoana in cauza?

Explanation

The correct answer is "pv". In this question, the individual wants to calculate the maximum value of the loan they can benefit from currently. To do this, they need to use the present value (pv) function, which calculates the current value of a future cash flow. By inputting the relevant information such as the monthly payment, interest rate, and loan term, the pv function can determine the maximum loan amount the person can afford to repay over 10 years with a monthly payment of 100 RON.

Submit
27. In proiectarea aplicatiilor folosind progr de calcul tabelar trebuie de parcurs urm etape:

Explanation

The correct answer is the correct sequence of steps in designing applications using spreadsheet software. The steps include analyzing the problem and constructing the problem-solving model, building the model in the spreadsheet, and finally utilizing the model for data analysis and decision-making. The last option, formatting the hard disk for data retrieval, is not a step in the application design process and is therefore not included in the correct answer.

Submit
28. Sa presupunem ca sa realizat o investitie care aduce in urrmatoarii 3 ani incasarile:in 2008,3500RON;in 2009,105000 RON; in 2010,5200 RON.Ce functie financiara sse utilizeaza pentru a determina valoarea neta a investitiei?

Explanation

The Net Present Value (NPV) function is used to determine the net value of an investment by calculating the present value of all cash inflows and outflows associated with the investment. In this case, the cash inflows are the amounts received in 2008, 2009, and 2010, which are 3500 RON, 105000 RON, and 5200 RON respectively. By discounting these cash flows to their present value and subtracting the initial investment, the NPV can be calculated to assess the profitability of the investment.

Submit
29. In bazele de date, lucrul cu fisierele de date (extragerea si modificarea datelor) se realizeaza exclusiv prin intermediul:

Explanation

The correct answer is the dictionary of data, which contains information about the structure of the data and the restrictions they meet. This dictionary is essential for working with data files in databases as it provides important details about the organization and constraints of the data, allowing for proper extraction and modification of the data.

Submit
30. In excel,care dintre urm enunturi sunt adevarate?

Explanation

The correct answer is that =RATE() is the function that calculates the interest rate for an annuity. This is true because the RATE() function in Excel is used to calculate the interest rate for an annuity or a loan. It returns the interest rate per period for a loan or an investment based on periodic, constant payments and a constant interest rate. Therefore, this statement accurately describes the functionality of the RATE() function in Excel.

Submit
31. Dupa inserarea liniei intr-un tabel,formulele se actualizeaza automat?

Explanation

After inserting a row in a table, the formulas do not automatically update.

Submit
32. O pers fizica isi deschidde cont la o banca cu capitalizare.Lunar se depun 80 de ron.Presupunind ca rata dobinzii va fi constatnta,ce functii folositi pentru a afla valoarea capitalizata dupa 5 ani?

Explanation

The correct answer is "fv". In this question, the individual is opening an account with a bank that has compounding interest. The monthly deposit is 80 ron and the interest rate is assumed to be constant. The function "fv" is used to calculate the future value of the account after 5 years.

Submit
33. In excel ,rata de rambursat dintr-un credit se determina cu ajutorul functiei:

Explanation

The correct answer is =PMT(). In Excel, the PMT() function is used to calculate the periodic payment for a loan or an investment based on a constant interest rate and a fixed number of periods. It takes inputs such as the interest rate, the number of periods, and the present value of the loan or investment, and returns the amount that needs to be paid or received at each period. This function is commonly used in financial calculations and planning.

Submit
34. Dezavantajele organizarii datelor supa modelul fisierelor independente sunt;

Explanation

The correct answer is "costul ridicat" (high cost) and "modelarea inadecvata a lumii reale" (inadequate modeling of the real world). This is because organizing data in independent file models can be expensive in terms of storage and maintenance. Additionally, the model may not accurately represent the real-world scenario, leading to potential errors or inefficiencies in data analysis and decision-making processes.

Submit
35. In excel in casutele foilor de calcul se introduc:

Explanation

In Excel, the cells are used to input various types of data such as numeric data, character strings, calendar dates, formulas, and functions. Numeric data refers to any numerical values that can be used for calculations. Character strings are sequences of characters or text. Calendar dates are used to represent specific dates or time periods. Formulas are used to perform calculations and manipulate data in cells. Functions are predefined formulas that perform specific operations and return results.

Submit
36. Intrun grafic de tip column sau bar,seriile de date sunt reprezentate pe :

Explanation

The correct answer is "axa Oy". In a column or bar graph, the data series are represented on the y-axis. The y-axis is the vertical axis of the graph, which typically represents the dependent variable or the variable being measured. The x-axis, on the other hand, represents the independent variable or the variable that is being manipulated or controlled. Therefore, in this case, only the y-axis is used to represent the data series.

Submit
37. Intrun grafic de tip PIE se reprezinta:

Explanation

A pie chart represents a single series of data. It is a circular chart divided into sectors, with each sector representing a proportionate part of the whole. Each sector's size is determined by the value it represents in relation to the total value of the data set. Therefore, a pie chart is used to show the distribution or composition of a single set of data categories or variables. It is not suitable for comparing multiple sets of data or showing trends over time.

Submit
38. Interogarea unei baze de date pentru a obtine rezultatele intr-o zona distincta,presupune existenta/definirea urmatoarelor zone;

Explanation

The correct answer is that querying a database to obtain results in a distinct area requires the existence/definition of the following zones: the input data zone, the output data zone, and the criteria zone. These zones are necessary to specify where the data is coming from, where it is going, and what criteria are being used to filter the results.

Submit
39. In modelul relational de organizare a datelor, care dintre urmatoarele enunturi sunt adevarate?

Explanation

When the primary key of a table is composite, no attribute of the key can be eliminated without destroying the uniqueness of the tuple.

Submit
40. Actualizarea foii de calul prin inserare si sau stergerea de linii /coloana determina:

Explanation

Inserarea și ștergerea de linii/coloane în foaia de calcul determină actualizarea adreselor de casuțe utilizate în formule și funcții, precum și rearanjarea și renumerotarea automată a liniilor și/sau coloanelor. Aceasta înseamnă că, atunci când se adaugă sau se elimină linii sau coloane, adresele casuțelor utilizate în formule și funcții trebuie să fie actualizate pentru a reflecta noile poziții ale casuțelor. De asemenea, rearanjarea și renumerotarea automată a liniilor și/sau coloanelor asigură că acestea sunt ordonate corect și numerotate în mod consecutiv.

Submit
41. Intr-o baza de date realizata intrun program de calcul tabelar,o linie reprezinta:

Explanation

In a database created in a spreadsheet program, a row represents a record. Each row contains a set of related data that represents a single entity or object. This data is organized into columns, with each column representing a different attribute or field. Therefore, a row or line in a database table is commonly referred to as a record, as it contains all the information about a specific entry in the database.

Submit
42. Care dintre urm constructii sunt corecte din punct de vedere sintactic?

Explanation

The correct answer is "=VLOOKUP(A40,A2:D35,3)". This is a valid syntax for the VLOOKUP function in Excel. It searches for a value in the first column of a table array and returns a value in the same row from a specified column. In this case, it is searching for the value in cell A40 in the range A2:D35 and returning the value in the third column of the range.

Submit
43. Cum va interpreta Excel constructia =12/04/07

Explanation

The given Excel construction "=12/04/07" will be interpreted as a mathematical expression because it follows the format of a mathematical calculation with numbers and operators. It does not contain any specific formatting or indicators to suggest that it represents a calendar date. Therefore, Excel will treat it as a mathematical calculation and perform the division operation between 12 and 4, resulting in the value 3.

Submit
44. In excel,formulele:

Explanation

The correct answer is "sunt elemente de baza a unei foi de calcul, sunt construite de utilizator." This is because the given statements describe the characteristics of formulas in Excel. Formulas are basic elements of a spreadsheet and they are built by the user. They are not limited to simple arithmetic calculations and they are not always preceded by the % sign.

Submit
45. In excel,care dintre aceste constructii dau acelasi rezultat

Explanation

All of the given constructions yield the same result because they are all calculating the average of the values in cells B3, C3, D3, and E3. The first construction directly adds the values and divides by 4, the second construction uses the SUM function to add the values and then divides by 4, and the third construction uses the AVERAGE function to calculate the average of the values. The fourth construction, =(B3:E3)/4, is incorrect as it divides the range by 4 instead of calculating the average.

Submit
46. Programele de calcul tabelar:

Explanation

Programmele de calcul tabelar sunt produse integrate care permit lucrul cu tabele, baze de date și grafice. Aceste programe preiau din sarcina functionarilor lucrările de rutină, oferindu-le posibilitatea de a automatiza și simplifica procesele repetitive. De asemenea, ele preiau din sarcina utilizatorilor partea creativă a unei aplicații, oferindu-le instrumente și funcționalități avansate pentru a crea și manipula datele într-un mod flexibil și eficient.

Submit
47. Inca de la inceputurile sale informatica s-a confruntat cu urmatoarele probleme:

Explanation

From the beginning, computer science has faced the following problems: performing complex calculations, storing and managing an increasing volume of information. These challenges have been addressed by developing more advanced algorithms and data storage systems to handle the growing complexity and size of data.

Submit
48. Redundanta datelor se manifesta prin

Explanation

Redundanta datelor se manifesta prin faptul că aceeași dată apare în mai multe fișiere. Aceasta înseamnă că există duplicări ale aceleiași informații în mai multe locuri, ceea ce poate duce la confuzie și la dificultăți în gestionarea și actualizarea datelor. Prin eliminarea redundanței, se poate optimiza stocarea și accesul la date, reducându-se riscul de erori și inconsistente în informații.

Submit
49. In excel functiile:

Explanation

The correct answer is that Excel functions are predefined formulas, allow for the quick execution of complex calculations, and are preceded by the equals sign.

Submit
50. In excel,formulele sunt formate din:

Explanation

Formulas in Excel are formed by using reserved words, which are indicated by the equal sign (=) followed by the name of the function or operation. These reserved words are predefined by Excel and have specific meanings. When creating a formula, the equal sign is used to indicate that the following characters are part of a formula and not regular text. Therefore, the correct answer states that formulas in Excel are formed using reserved words indicated by the equal sign (=).

Submit
51. Sortarea bazelor de date in excel se poate realiza dupa:

Explanation

The correct answer is that sorting a database in Excel can be done based on three keys, two keys, or a single key. This means that you can choose to sort the data using multiple columns as keys or just one column as the key. The number of keys used for sorting depends on the specific requirements and criteria of the data analysis or organization process.

Submit
52. Functiile financiare permit:

Explanation

The correct answer is "realizarea unor game variate de calcule, realizarea de analize economico financiare, calculul amortizarii." This is because financial functions allow for a wide range of calculations, such as determining interest rates, performing financial analysis, and calculating depreciation expenses. These functions are essential for managing and analyzing financial data in various contexts, such as budgeting, investment analysis, and financial reporting.

Submit
53. Stergerea unei inregistrati dint-o baza se realizeaza prin:

Explanation

The correct answer is "stergerea liniei corespunzatoare din foaia de calcul" because deleting a record from a database typically involves removing the corresponding row from a spreadsheet or table. This action physically eliminates the data entry from the dataset. The other options mentioned, such as using a specific command from the data menu or pressing the delete or backspace key, may be applicable in certain software or user interfaces, but they are not the general method for deleting a record from a database.

Submit
54. Stabilirea parametrilor de format pentru datele din foaia de calcul se realizeaza in etapa:

Explanation

The correct answer is "construirea modelului in foaia de calcul" (building the model in the spreadsheet). This is the stage where the parameters of the data format are established. The other options, "analiza problemei si proiectarea modelului de rezolvare" (analyzing the problem and designing the solution model) and "utilizarea modelului" (using the model), are not specifically related to setting the format parameters in the spreadsheet.

Submit
55. Care dintre urm formule si functii sunt corecte?

Explanation

The correct answer is "=SUM(cantitatea)". This formula calculates the sum of the values in the range "cantitatea".

Submit
56. Care enunturi sunmt adev?

Explanation

The answer is explaining that in the calculation of annuities, equal deposits and regular intervals of time are used. The number of periods and the interest rate should refer to the same time interval. The function PMT() calculates the future value for a series of cash flows.

Submit
57. Care sunt adev>?

Explanation

The correct answer is "funstia VLOOKUP efectueaza cautarea pe verticala a unui element in coloana cea mai din stinga a unui domeniu intr-o tabela indexata" and "functia LOOKUP este folosita pentru cautarea valorilor dintr-un vector sau matrice". These statements explain the functions of VLOOKUP and LOOKUP in Excel. VLOOKUP is used to search for a value vertically in the leftmost column of a table, while LOOKUP is used to search for values in a vector or matrix.

Submit
58. Care dintre urmatoarele enunturi sunt adevarte

Explanation

The first statement is true because the term "baza de date" (database) was indeed introduced in 1964. The second statement is also true because a data dictionary ensures program independence from data.

Submit
59. Intrun tab de simulare cu 2 variabile:

Explanation

The formula for calculation is written at the intersection of the first row and the first column in the results area.

Submit
60. IN excel protejarea poate fi realizata la nivel de:

Explanation

In Excel, protejarea (protection) can be done at the level of the workbook, worksheet, and cells. This means that you can protect the entire workbook, specific worksheets within the workbook, or individual cells within a worksheet. By protecting these levels, you can restrict certain actions such as editing, formatting, or deleting data, ensuring the integrity and security of your Excel file.

Submit
61. In excel care dintre urm enunturi sunt adevarate?

Explanation

The statement "argumentele functiilor pot fi si alte functii" is true. In Excel, it is possible to use functions as arguments within other functions. This allows for more complex calculations and enables users to create dynamic formulas. By using functions as arguments, users can perform calculations based on the results of other functions, making their formulas more flexible and powerful.

Submit
62. Care dintre utrm instrumeste software sunt instrumente de calcul tabelar?

Explanation

The correct answer is Excel, Lotus 1-2-3, and Quattro Pro. These three software tools are commonly used for spreadsheet calculations and data analysis. They provide features for creating tables, performing mathematical calculations, organizing data, and generating charts and graphs. These tools are widely used in various industries for tasks such as financial analysis, data management, and project planning.

Submit
63. Analiza rezultatelor se realizeaza in etapa:

Explanation

The correct answer is "utilizarea modelului". This is because the question asks about the stage in which the analysis of the results is performed, and "utilizarea modelului" refers to the usage or utilization of the model, which would involve analyzing the results obtained from it. The other options mentioned, such as "analiza prob si proiectarea modelului de rez" (analysis of data and projection of the model) and "construirea modelului in foaia de calcul" (building the model in a spreadsheet), do not specifically refer to the analysis of the results.

Submit
64. Modelul relational de organizare a datelor are urmatorii piloni:

Explanation

The relational data model organizes data into tables, with each table consisting of rows and columns. The structural component refers to the way the tables and their relationships are defined, including the primary and foreign keys that establish connections between tables. The manipulative component involves the operations that can be performed on the data, such as inserting, updating, and deleting records. The integrity component ensures that the data in the tables follows certain rules and constraints, such as unique values, referential integrity, and data types. These three components are essential for the relational data model to function effectively.

Submit
65. In foile de calcul excel,casutele sunt referite prin:

Explanation

In foile de calcul Excel, casutele pot fi referite prin adrese absolute, adrese relative și adrese mixte. Adresele absolute sunt fixe și nu se schimbă atunci când este copiată sau mutată o formulă într-o altă celulă. Adresele relative se ajustează automat în funcție de locația relativă a formulei atunci când este copiată sau mutată într-o altă celulă. Adresele mixte combină atât adrese absolute, cât și adrese relative și permit fixarea unei părți a adresei, în timp ce cealaltă parte rămâne relativă.

Submit
66. Care sunt adevarate?

Explanation

In a cell, you can write on multiple lines. The "wrap text" option prevents writing on multiple lines in the same cell. The "merge cell" option combines multiple cells. Vertical alignment is not possible in cells.

Submit
67. Care dintre urm functii intra in categoria functiilor statistice?

Explanation

The correct answer is =AVERAGE(), =COUNT(), =MIN(). These functions are considered statistical functions because they are commonly used in statistical analysis. The AVERAGE() function calculates the average of a range of values, the COUNT() function counts the number of cells that contain numbers in a range, and the MIN() function returns the smallest value in a range. These functions are useful for analyzing data and drawing conclusions in statistics.

Submit
68. Extragerea de informatii dintro baza de date ntro alta zona a foii de calcul presupune:

Explanation

The correct answer is defining the criterion zone and the output zone. This means that when extracting information from a database in another area of the spreadsheet, both the criteria zone (which indicates the condition that the records must meet) and the output zone (where the extracted information will be displayed) need to be defined. This ensures that the desired data is correctly filtered and displayed in the desired location.

Submit
69. Modificarea unei inregistrari dintro baza de date se realizeaza :

Explanation

The correct answer is "prin introducerea unei valori noi in casuta corespunzatoare cimpului modificat, prin folosirea comenzii edit(f2)". This means that modifying a record in a database can be done by entering a new value in the corresponding field box or by using the edit command (f2). This suggests that there are multiple ways to modify a record in a database, but the most common methods are through directly inputting a new value or using the edit command.

Submit
70. Care dintre urm adrese de casute sunt incorecte?

Explanation

The correct answer is "DATE?A1" because it contains a special character "?" which is not allowed in a valid address for mailboxes.

Submit
71. Realizarea copiilor de siguranta se efectueazain etapa:

Explanation

The correct answer is "utilizarea modelului". This is because the question is asking about the stage in which the safety children are achieved, and the correct stage is when the model is being used. The other options mentioned, such as analyzing the problem and designing the model, or constructing the model in a spreadsheet, are not directly related to achieving the safety children.

Submit
72. Datele organizate in BD prezinta urmatoarele caracteristici:

Explanation

The given answer lists the characteristics of data organized in a database. These characteristics include partajabilitate (sharability), persistenta (persistence), securitate (security), and validitate (validity). Partajabilitate refers to the ability to share data among multiple users or systems. Persistenta means that the data is stored and maintained over time. Securitate refers to the protection of data from unauthorized access or manipulation. Validitate means that the data is accurate, consistent, and conforms to predefined rules or constraints.

Submit
73. Un program de calcul tabelar performat trebuie sa permita:

Explanation

A performant spreadsheet program should allow for simultaneous work with multiple tables, graphical representation of data, and the use of linking and embedding techniques through DDE and OLE. Additionally, it should not restrict the use of predefined functions for financial calculations.

Submit
74. In excel protejarea componentelor modelului se realizeaza in etapa:

Explanation

The correct answer is "construirea modelului in foaia de calcul". This is because in Excel, the process of protecting the components of a model is done during the construction phase of the model in the spreadsheet. This involves setting up formulas, formatting cells, and defining data validation rules to ensure the integrity and security of the model. Once the model is built, it can then be used for analysis and decision-making purposes.

Submit
75. Care dintre urmatoarele enunturi sunt adevarate?

Explanation

The first statement is false because the hierarchical model does not derive from the relational model. The second statement is true as the network model is indeed a development of the hierarchical model. The third statement is also true as the relational-object model is the most recent model and is supported by major software producers dedicated to database management.

Submit
76. Intr-o relatie

Explanation

In a relationship, there cannot be two identical rows. At most, there can be three identical rows. This is because there is an attribute or group of attributes that differentiate a tuple from all other tuples based on their values.

Submit
77. In excel,formulele:

Explanation

The given answer states that in Excel, formulas can contain values and operators. These values can include numbers, dates, and text. However, the operators % and ^ cannot be included in the formulas.

Submit
78. In functia Vlookup:

Explanation

The third argument in the Vlookup function indicates from which column the desired value is taken, while the "false" argument, placed at the end, indicates the exact search.

Submit
79. Excel este:

Explanation

Excel is a program that is used for creating and manipulating spreadsheets, which are a form of tabular calculations. It allows users to perform various mathematical and statistical calculations, organize data, and create charts and graphs. Additionally, Excel also has some database management capabilities, allowing users to store and manage large amounts of data. Therefore, the correct answer is "un program de calcul tabelar, un sistem de gestiune a bazelor de date" (a spreadsheet program, a database management system).

Submit
80. Intr-o baza de date realiztata intr-n program d ecalcul tabelar o coloana este

Explanation

In a database created in a spreadsheet program, a column represents an attribute. An attribute is a characteristic or property of the data being stored in the database. Each column in the table represents a specific attribute, such as a person's name, age, or address. Therefore, the correct answer is "un atribut."

Submit
81. Care enunturi sunt adevarate:

Explanation

The correct answer is "registrul de lucru este un fisier .xls" because it states that the workbook is a .xls file, which is a common file format for spreadsheets. The other statements are not accurate or relevant to the question.

Submit
82. Organizarea datelor in BD poate fi analizata pe urmmatoarele niveluri:

Explanation

The correct answer is the order in which data is organized in a database can be analyzed at different levels: physical, internal, global, external, and semantic. The physical level refers to how data is stored on the physical devices, such as hard drives. The internal level refers to the representation of data within the database management system. The global level refers to the overall organization of data across multiple databases. The external level refers to the specific views and access to data for individual users or applications. The semantic level refers to the meaning and interpretation of data within the context of the application or system.

Submit
83. Care zone sunt necesare pentru realizarea operatiunii de soratre?

Explanation

The correct answer is "zona de intrare(datele)". In order to perform the sorting operation, it is necessary to have a designated area where the input data can be stored and accessed. This area is referred to as the "zona de intrare(datele)", which translates to "input zone(data)". This is where the data to be sorted is initially placed before the sorting algorithm is applied.

Submit
84. Programele de calcur tabelar:

Explanation

The correct answer is "permit realizarea de simulari in grafice, permit organizarea datelor in baze de date." This means that spreadsheet programs allow for the creation of simulations in graphs and the organization of data in databases.

Submit
85. Formal, o baza de date este:

Explanation

The correct answer is a collection of data that is independent, along with the description of the data and the relationships between them. It is also an automated, shared, formalized, and centrally controlled collection of data. This means that a formal database includes data that is organized and structured, with relationships defined between different data elements. It is also automated, meaning that it is processed and managed by computer systems. Additionally, it is shared among multiple users and centrally controlled, ensuring that access and management of the data are regulated.

Submit
86. Cheile de sortare pot fi:

Explanation

The correct answer is that sorting keys can be a single field or multiple fields from the database structure. This means that when sorting data in a database, you can choose to sort based on a single field or multiple fields simultaneously.

Submit
87. Dezavantajele organizarii datelor dupa modelul fisierelor independente sunt:

Explanation

The given answer states that the disadvantages of organizing data according to the independent file model are the redundancy and inconsistency of data, as well as the isolation of data. This means that in this model, there is a high likelihood of having duplicate or conflicting data, which can lead to inaccuracies and inefficiencies. Additionally, the data is isolated in separate files, making it difficult to access and analyze in a comprehensive manner.

Submit
88. In modelul ierarhic de organizare a datelor

Explanation

The correct answer explains that in a hierarchical data model, the data structure is represented in the form of a tree. Each child node is dependent on its parent node and cannot exist independently of it. This means that the data is organized in a hierarchical manner, with parent nodes at higher levels and child nodes at lower levels. The relationship between parent and child nodes ensures that the data is structured and organized in a specific hierarchy.

Submit
89. Cum se dispun componentele unui model de rezolvare in foaia de calcul>?

Explanation

The components of a solving model are arranged in different spreadsheets and in a cascade within the same spreadsheet. This means that different parts of the model are organized in separate spreadsheets, while within a single spreadsheet, the components are arranged in a cascade, meaning that the output of one component is used as input for the next component in a sequential manner.

Submit
90. Modelarea realitatii in tabele are in vedere ca :

Explanation

The given answer correctly states that a table has a name, a column represents an attribute, and a row represents a tuple. This is a basic concept in database modeling, where tables are used to represent entities, and each column in the table represents a specific attribute of that entity. Each row in the table represents a unique instance of that entity, with the values in each column representing the attributes of that instance. Therefore, the given answer accurately describes the key components of modeling reality in tables.

Submit
91. O baza de date reprezinta

Explanation

A database is a structured collection of files that contains a collection of data that is interdependent. This means that the files within the database are organized in a structured manner and the data within these files are interconnected and rely on each other.

Submit
92. Care dintre urmatoarele constructii sunt adevarate?

Explanation

The correct answer includes "sheet2!C34" and "A:B". "sheet2!C34" refers to a specific cell in the "C" column of the "sheet2" worksheet. "A:B" represents all the cells in columns A and B.

Submit
93. Un tabel de simulare trebuie sa contina obligatoriu:

Explanation

A simulation table is a tool used to model and analyze different scenarios. It is necessary for a simulation table to include a calculation formula, explanatory texts, a group of empty cells to display the results, and a set of values for one or two variables. These components are essential for accurately simulating and interpreting the results of the simulation.

Submit
94. IN progr de calcul tabelar,introducerea datelor de intrare se realizeaza in etapa:

Explanation

The correct answer is "untilizarea modelului". This means that in the stage of a spreadsheet calculation program, the input data is used or utilized to perform calculations or analysis. The other options mentioned, "analiza problemei si proiectarea modelului de rezolvare" (analysis of the problem and design of the solution model) and "cosntruirea modelului in foaia de calcul" (construction of the model in the spreadsheet), are not the correct stages for inputting data.

Submit
95. Intr-o baza de date relationala, care dintre urmatoarele enunturi sunt adevarate?

Explanation

In a relational database, the relationships between tables are established through the mechanism of foreign keys. This means that the correct answer is "legaturile dintre tabele se bazeaza pe mecanismul cheii straine." Additionally, the table in which the linking attribute is the primary key is called the parent table, so the answer "tabela in care atributul de legatura este cheie primara se numeste tabele-parinte" is also correct.

Submit
96. Care dintre urm functii sunt financiare?

Explanation

The correct answer is IRR, DDB, and FV. These functions are all related to financial calculations. IRR stands for Internal Rate of Return and is used to calculate the profitability of an investment. DDB stands for Double Declining Balance and is a method of calculating depreciation expenses. FV stands for Future Value and is used to calculate the value of an investment at a future date. These functions are commonly used in financial analysis and planning.

Submit
97. In excel,comezile pot fi apelate din:

Explanation

The correct answer is meniuri si submeniuri, pitograme din linii de instrumente (standard, formatting). This means that in Excel, commands can be accessed from menus and submenus, as well as from icons in the toolbar (standard, formatting).

Submit
98. In fereastra unei functii excel se afiseaza:

Explanation

The correct answer is the format of the function, a brief description of the function, and distinct ranges for the function's arguments. This means that in the Excel function window, you will see the format of the function, a short description of what the function does, and separate boxes or areas where you can input the arguments for the function. It also suggests that the window may display the result obtained from the previous execution of the function.

Submit
99. Care dintre urmatoarele enunturi sunt puncte forte ale programelor de calcul tabelar?

Explanation

The given answer includes the points that highlight the strengths of spreadsheet programs, such as simulations, automatic recalculation of formulas and functions, implementation of financial, statistical, and logical functions, and automation of tasks. It also mentions the ability to display numerical data in two formats, which enhances the security of the computing system. These features contribute to the effectiveness and efficiency of spreadsheet programs in various tasks and calculations.

Submit
100. Macro-urile din programele de calcul tabelor sunt:

Explanation

The correct answer is "secvente de intructiuni ssau comenzi similare elor din limbajele de programare,elemente ce permit descrierea grupurilor de operatiuni repetitive." This is because macros in spreadsheet programs are sequences of instructions or commands similar to those in programming languages, and they also allow for the description of groups of repetitive operations.

Submit
101. Sunt adevarate:

Explanation

The correct answer states that in the calculation of annuities, equal payments are used at regular intervals of time, while in the calculation of amortizations, unequal payments are used. This means that when calculating annuities, the amount paid at each interval is the same, whereas in amortizations, the amount paid at each interval can vary. Additionally, the answer mentions that the Vlookup function allows for vertical searching of a value in the rightmost column of a table.

Submit
102. Modelul de organizarea a datelor asigura:

Explanation

The correct answer is that the model of data organization ensures the description of data and the relationships between them, as well as the representation of the real world and the events associated with it. This means that the model allows for the organization and understanding of data by describing their attributes and how they are related to each other. Additionally, it allows for the representation of real-world entities and the events that occur in relation to them, providing a comprehensive view of the data and its context.

Submit
103. Intr-o baza de date relationala, cheile pot fi:

Explanation

Intr-o baza de date relationala, cheile pot fi primare, candidat sau alternative. Cheia primara este unica si identifica in mod unic fiecare inregistrare dintr-o tabela. Cheia candidat este o cheie unica care poate fi folosita pentru identificarea inregistrarilor, dar nu este neaparat selectata ca cheie primara. Cheia alternativa este o cheie unica care poate fi folosita ca alternativa la cheia primara sau candidat. Cheile principale si auxiliare nu sunt termeni specifici in cadrul bazei de date relationale si nu sunt considerate raspunsuri corecte pentru aceasta intrebare.

Submit
104. In Excel, simularile folosesc urmatoarele instrumente:

Explanation

The correct answer is "formule si functii, tabele de simulare." This is because in Excel, formulas and functions are used to perform calculations and manipulate data. They allow users to automate tasks and perform complex calculations. On the other hand, simulation tables are used to simulate different scenarios and analyze the impact of changing variables on the data. Therefore, both formulas and functions, as well as simulation tables, are essential tools in Excel for data analysis and manipulation.

Submit
105. O casuta din foaia de calcul poate fi identificata prin:

Explanation

A casuta din foaia de calcul poate fi identificata prin adrese absolute, adrese mixte, adresa relativa sau un nume atribuit in prealabil. Adresele absolute sunt fixe si nu se schimba atunci cand sunt copiate sau mutate. Adresele mixte combina referinte absolute si relative si se schimba in functie de cum sunt copiate sau mutate. Adresele relative se schimba in functie de cum sunt copiate sau mutate. Un nume atribuit in prealabil poate fi utilizat pentru a identifica o casuta si este mai usor de recunoscut decat adresele.

Submit
106. Pentru care dintre componentele excel sunt disponibili asistenti wizard?

Explanation

The correct answer is "grafice" and "functii". In Excel, there are wizards available for creating charts and graphs (grafice) to visually represent data, as well as for using functions (functii) to perform calculations and manipulate data. These wizards provide step-by-step guidance and make it easier for users to create charts and use functions effectively in Excel.

Submit
107. Performantele programelor de calcul tabelar sunt date de folosirea:

Explanation

The performance of spreadsheet programs is determined by the use of formulas and functions. Formulas allow users to perform calculations and manipulate data within the spreadsheet. Functions, on the other hand, are predefined formulas that can be used to perform specific calculations or tasks. Both formulas and functions are essential in improving the efficiency and accuracy of calculations in spreadsheet programs.

Submit
108. Incarcarea produsului program(programul de calcul tabelar) este necesar in etapa:

Explanation

The correct answer is "construirea modelului in foaia de calcul, utilizarea modelului". This answer suggests that loading the product program is necessary during the stage of constructing the model in the spreadsheet and using the model. This implies that the product program needs to be loaded in order to create and utilize the model in the spreadsheet.

Submit
109. Ce implicatii are regula"in formule si functuii nu se folosesc constante"?

Explanation

The correct answer suggests that the rule "do not use constants in formulas and functions" has the implications of requiring the rewriting of formulas or functions for each data, and eliminating potential simulation capabilities. This means that using constants in formulas and functions would result in the need to modify them every time there is new data, and it would also limit the ability to simulate different scenarios or conditions.

Submit
110. Datele organizate in BD prezinta urmatoarele caracteristici:

Explanation

The given answer suggests that the characteristics of organized data in a database include consistency and security. Consistency refers to the accuracy and reliability of the data, ensuring that it is valid and conforms to predefined rules. Security, on the other hand, pertains to measures taken to protect the data from unauthorized access, ensuring its confidentiality, integrity, and availability. These two characteristics are crucial for maintaining the quality and reliability of the data stored in a database.

Submit
111. Instrumentul specific de lucru in programele de calcul tabelor se nueste:

Explanation

The correct answer is "foaie de calcul, centralizator electronic, spreadsheet/worksheet." These terms all refer to the specific tool used in computer programs for creating tables and performing calculations. A "foaie de calcul" is the Romanian term for a spreadsheet or worksheet. A "centralizator electronic" is another term used for a spreadsheet or worksheet in some contexts. "Spreadsheet/worksheet" is a general term that encompasses the various names used for this tool in different languages and programs.

Submit
112. Formatarea datelor din foile de calcul excel poate fin realizata:

Explanation

The correct answer is "dupa anumite sabloane oferite de sistem" because formatting data in Excel can be done using predefined templates or patterns provided by the system. These templates allow users to quickly apply consistent formatting to their data without having to manually adjust each cell or range. This saves time and ensures that the data is presented in a visually appealing and organized manner.

Submit
113. In Excel, dimensionarea liniilor si coloanelor se poate realiza prin folosirea:

Explanation

The correct answer options explain different methods to adjust the dimensions of rows and columns in Excel. The first option suggests using the commands "Format/Row/AutoFit" and "Format/Column/AutoFit Selection" to automatically adjust the height of rows and width of columns based on the content. The second option suggests using the commands "Format/Row/Height" and "Format/Column/Width" to manually specify the height of rows and width of columns. The third option suggests using the mouse in the data area to manually adjust the dimensions. The fourth option suggests using the mouse in the headers of rows or columns to manually adjust the dimensions.

Submit
114. Datele pot fi organizate dupa modelele:

Explanation

The correct answer is a list of different ways in which data can be organized, namely hierarchically, in a network, relationally, and object-oriented. These are different models or approaches to organizing and structuring data, each with its own advantages and use cases. The hierarchical model organizes data in a tree-like structure, where each record has a parent and multiple children. The network model allows for more complex relationships between records through the use of pointers. The relational model organizes data into tables with rows and columns, and the object-oriented model represents data as objects with properties and methods.

Submit
115. Urmatoarele elemente pot constitui argumente pentru functia SUM?

Explanation

The given answer is correct because both "un nume atribuit unei zone din foaia de calcul" (a name assigned to a range in the spreadsheet) and "o adresa absoluta" (an absolute address) can be used as arguments for the SUM function in a spreadsheet. These arguments can be used to specify the range of cells or individual cells that need to be summed. However, "un sir de caractere" (a string of characters) cannot be used as an argument for the SUM function as it is designed to work with numerical values.

Submit
116. Modelul realtional are urmatoarele avantaje:

Explanation

The relational model improves data integrity and confidentiality. This is because it enforces constraints and rules on the data, ensuring that it is accurate and consistent. Additionally, the relational model provides access control mechanisms that allow for the protection of sensitive data, ensuring that only authorized users can access it. By enforcing integrity and confidentiality, the relational model helps to maintain the quality and security of the data.

Submit
117. Urmatoarele calcule sunt realizate de functii financiare:

Explanation

The correct answer is "amortizarea imobilizarilor dupa mnet liniara" and "vaoarea viitoare a unei investitii curente". These calculations are related to financial functions. "Amortizarea imobilizarilor dupa mnet liniara" refers to the linear depreciation of assets, which is a common method used to allocate the cost of an asset over its useful life. "Vaoarea viitoare a unei investitii curente" refers to the future value of a current investment, which is a calculation used to determine the potential return on an investment over a specific period of time.

Submit
118. Argumentele functiilor excel pot fi:

Explanation

The correct answer is a list of possible arguments for Excel functions. These arguments can include cell references, logical expressions, graphical elements, numerical or string variables, and formulas.

Submit
119. Cu referire la organizarea datelor in BD, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The given answer correctly states that the way data is "written" on storage media represents the physical level of data organization. It also correctly states that the way the observed real world is modeled corresponds to the conceptual level of data organization. Additionally, it correctly states that the external level of data organization aims to simplify user-DB interaction and increase security in the database.

Submit
120. In Excel, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The correct answer states that the components of a model can be arranged in different worksheets or in a cascade within the same worksheet. This is true in Excel as it allows users to organize their data and calculations across multiple worksheets or within the same worksheet using grouping and linking functions. Additionally, it is also true that for complex tasks, it is recommended to use macro commands in Excel to automate repetitive tasks and increase efficiency.

Submit
121. Urm elemente pot constitui argumente pentru functia PV:

Explanation

The correct answer is "un nume atribuit unei casute din foaia de calcul" and "o adresa absoluta." These are valid arguments for the PV function in Excel. The PV function is used to calculate the present value of an investment, and it requires the input of a cell reference or a specific value for the rate, number of periods, and payment. In this case, using a cell reference (a name assigned to a cell in the spreadsheet) or an absolute address (a specific cell reference) would be appropriate inputs for the PV function.

Submit
122. Care dintre urma functii sunt corecte?

Explanation

not-available-via-ai

Submit
123. Modelul relational poate fi definit prin 

Explanation

The correct answer includes three components that define the relational model: structures of data, operations applied to the data structures, and integrity rules that ensure data consistency. These components are essential in organizing and manipulating data in a relational database system. Structures of data refer to the tables and relationships between them, operations applied to the data structures include querying and modifying the data, and integrity rules ensure that data remains accurate and valid throughout the database.

Submit
124. Intr-o baza de date, dictionarul de date:

Explanation

The correct answer is "este un fisier de descriere globala a bazei de date, asigura independenta programelor fata de date." This is because a data dictionary is a file that provides a global description of the database, including information about the structure, organization, and relationships of the data. It also ensures that programs can access and manipulate the data in a consistent and independent manner, without needing to know the specific details of the data implementation.

Submit
125. Pentru realizarea de simulari intrun tabel cu o variabila:

Explanation

The correct answer states that for conducting simulations in a table with a variable, values need to be entered for the variable in the first column/row and there must be an initial starting situation. This implies that in order to perform simulations accurately, it is necessary to input the variable values and establish a starting point for the simulation. Additionally, it suggests that the first column/row is used to represent the variable values for the simulation.

Submit
126. Conform modelului relational de organizare a datelor, cu referire la valoarea NULL, care dintre urmatoarele enunturi sunt adevarate?

Explanation

According to the relational model of data organization, the following statements are true: some attributes do not allow NULL values, attributes involved in the calculation of important information do not allow NULL values, and attributes without significant importance can have NULL values.

Submit
127. In excel,argumentele functiilor pot fi

Explanation

The correct answer is that in Excel, the arguments of functions can be assigned names to ranges in the worksheet, logical expressions, other functions, and constants.

Submit
128. In aplicatiile cu fisiere independente:

Explanation

In applications with independent files, each data is described autonomously in each file in which it appears. Additionally, the description of each data file is mandatory in all programs that read or modify it. This means that each file contains its own description of the data it holds, and this description must be included in all programs that interact with the file.

Submit
129. Care enunturi sunt false?

Explanation

The correct answer is "linia de tendinta(trendline) se poate defini in grafice 3d, simularile se pot realiza doar folosind grafice 3d, intr-un grafic de tip pie se pot reprezenta doua sau mai multe serii de date." This answer states that trendlines can be defined in 3D graphs, simulations can only be done using 3D graphs, and a pie chart can represent two or more series of data.

Submit
130. Dupa modelul relational, fiecare tabela:

Explanation

According to the given information, each table in the relational model has a unique name, is stored on an external storage device (usually a magnetic disk), and an atomic value is entered at the intersection of a row and a column.

Submit
131. Care dintre urmaoarele enunturi sunt restrictii ale modelului referential a datelor

Explanation

The correct answer is: regula la nivel de atribut, regula la nivel de tabela, regula la nivel de linie, regula la nivel de inregistrare.

These are all restrictions of the data referential model. The rule at the attribute level refers to constraints placed on individual attributes within a table. The rule at the table level refers to constraints placed on the entire table. The rule at the row level refers to constraints placed on individual rows within a table. The rule at the record level refers to constraints placed on the entire record or entry in a table.

Submit
132. In cazul bazelor de date relationale, care dintre enunturile de mai jos sunt adevarate?

Explanation

The content of a relation in a relational database is represented by the set of tuples that make it up at a given moment. The restriction of domain refers to the set of authorized values for an attribute.

Submit
133. In Excel care dintre urmatoarele enunturi sunt adevarate?

Explanation

The given answer states that the following statements are true:
1. In formulas and functions, constants are not used.
2. The dimensions of rows and columns are determined based on the data in the headers.
3. Worksheets are renamed with meaningful names.
4. Functions provide solutions for many complex problems from different domains.

Submit
134. Intr-o baza de date relationala, restrictiile:

Explanation

Restrictions in a relational database indicate the existence of established and somewhat obligatory constraints. They ensure the increase of accuracy and trustworthiness of the data in the database. These restrictions are declared by the user and must be respected by the database management system (SGBD).

Submit
135. Intr-o tabela, care dintre urmatoarele enunturi sunt adevarate?

Explanation

An attribute is defined by its name and domain, and any value of an attribute must fall within a domain defined by values. Attributes that ensure the identification or characterization of an entity can have a NULL value. However, attributes without importance cannot be declared as NOT NULL.

Submit
136. Un tabel de simulare este:

Explanation

A simulation table is an instrument that tracks the impact of changing the value of a variable on a calculation formula. It is also a way to concretize "What If" questions.

Submit
137. Cu referire la modelul relational, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The given answer states that foreign keys are attributes or combinations of attributes that link rows from different relations, referential restriction occurs when a relation refers to another relation, and most DBMSs have mechanisms for declaring and managing referential constraints automatically.

Submit
138. Costul ridicat al aplicatiilor bazate pe fisiere independente deriva din:

Explanation

The high cost of applications based on independent files is derived from the high degree of data redundancy, the significant efforts required to interconnect different types of data files, and the efforts to ensure optimal system functioning with minimum integrity and information security.

Submit
139. ZONA ocupata de un tabel de simulare trebuie sa contina :

Explanation

The correct answer is that the occupied area of a simulation table should contain the formula for calculation, the input values for variables, the area for results, and the output area.

Submit
140. Modelul relational are urmatoarele avantaje:

Explanation

The relational model is advantageous because it proposes data structures that are easy to use. This means that the model provides a straightforward and intuitive way to organize and manipulate data, making it more user-friendly for developers and users. By offering structures that are easy to understand and work with, the relational model simplifies the process of data management and allows for efficient and effective data manipulation.

Submit
141. In modelul relational, care dintre urmatoarele afirmatii sunt adevarate?

Explanation

The given answer is correct. In a relational model, a tuple is a sequence of values of different types. This means that each tuple can contain values of different data types. Additionally, the tuples in a relation must have the same structure, meaning they have the same number of attributes or columns. Lastly, the order of the tuples does not matter in terms of the informational content of the table.

Submit
142. Cu referire la bazele de date, care dintre urmatoarele afirmatii sunt adevarate?

Explanation

The correct answer states that physical autonomy refers to the ability to modify the internal architecture of the database without changing the conceptual schema and rewriting the programs. Logical autonomy refers to the ability to modify the conceptual schema of the database without rewriting the exploitation programs. Physical autonomy also ensures the portability of the database from one computing system to another without modifying the conceptual schema and programs.

Submit
143. Intr-o tabela:

Explanation

In a table, each tuple represents a record and has a name. Each attribute represents a column in the table and has a domain of values, which defines the range of valid values for that attribute. Additionally, each attribute also has a name to identify it. Each row in the table represents a specific instance and can take values within the domain defined for each attribute. Therefore, the statement "fiecare atribut are un domeniu de valori" (each attribute has a domain of values) and "fiecare atribut are un nume" (each attribute has a name) accurately describe the characteristics of a table.

Submit
144. Cu referire la bazele de date, care dintre enunturile de mai jos sunt adevarate?

Explanation

The given answer is correct. In database terms, the core or nucleus of a database is represented by the data dictionary, which contains metadata about the database structure and organization. The analysis, design, and implementation of the database structure are done using a data model, which provides a conceptual representation of the database. Similarly, the analysis, design, and implementation of the database schema are also done using a data model, which defines the structure and organization of the database at a more detailed level.

Submit
145. Cu referire la o baza de date , care dintre urmatoarele enunturi nu sunt adevarate?

Explanation

The correct answer is "schema reprezinta ansamblul informatiilor stocate la un moment dat in BD". This statement is not true because a schema in a database represents the overall structure, organization, and design of the database, including the relationships between data elements, their semantics, and any constraints or restrictions. It does not refer to the specific data stored at a particular moment in time. Additionally, the statement "schema unei BD evolueaza pe parcursul utilizarii acesteia" is true because the schema of a database can change and evolve as the database is used and new data is added or modified.

Submit
146. Pentru o tabela integrata intr-o baza de date relationala, care dintre urmatoarele enunturi sunt adevarate?

Explanation

In a relational database, it is possible to declare multiple primary keys for a table. This allows for more than one attribute to uniquely identify each row in the table. On the other hand, there can only be one foreign key in a table, which establishes a relationship with another table. It is not necessary for a child table to have a primary key, but it must have a foreign key to establish the relationship with the parent table.

Submit
147. Care dintre urmatoarele elemente sunt incluse in schema unei baze de date?

Explanation

The correct answer is "denumirile tabelelor" (table names) and "restrictiile de unicitate" (uniqueness constraints). In a database schema, table names are included as they represent the different entities or categories of data stored in the database. Uniqueness constraints ensure that each value in a certain column or combination of columns is unique, preventing duplicate entries and maintaining data integrity. The other options, "numele, tipul si lungimea tuplurilor" (names, types, and lengths of tuples) and "restrictiile la nivel de sistem de calcul" (system-level computational constraints), are not explicitly mentioned in the question and therefore not included in the schema of a database.

Submit
148. Conform modelului relational, intr-o tabela:

Explanation

In the relational model, the primary key uniquely identifies each tuple in a table. The order represents the number of attributes that form the structure of the table. Cardinality represents the number of records loaded in the table.

Submit
149. Dupa Codd, pentru cheia primara exista urmatoarele restrictii:

Explanation

According to Codd, the primary key must have the following restrictions: uniqueness, minimal composition, non-null values, and entity constraint.

Submit
150. In modelul relational de organizarea a datelor, restrictia referentiala:

Explanation

The correct answer states that referential constraint is established between two tables through a common attribute. It also states that it prohibits the occurrence of foreign key values that do not exist in the parent table. Additionally, it mentions that referential constraint occurs when one relationship refers to another relationship.

Submit
151. Intr-o baza de date relationala, pot fi definite urmatoarele restrictii:

Explanation

In a relational database, the following constraints can be defined: domain constraint, atomicity constraint, complexity constraint, uniqueness constraint, and user constraint.

Submit
152. In modelul relational de organizare a datelor, care dintre urmatoarele enunturi sunt adevarate?

Explanation

In the relational model of data organization, it is true that every attribute of a table must be atomic, meaning it cannot be further divided into smaller components. This ensures that each attribute represents a single value and avoids data redundancy. It is also true that all domains of a database must contain elementary data, meaning they should contain basic data types like numbers or strings. This ensures consistency and compatibility within the database. Additionally, the declaration of constraints aims to increase the accuracy and reliability of the data in the database. These constraints are declared by the user and it is the responsibility of the user to adhere to them.

Submit
153. Care dintre urmatoarele elemente sunt incluse in schema unei baze de date?

Explanation

The elements included in a database schema are the name, type, and length of attributes, as well as referential constraints. These elements define the structure and relationships between the tables in the database.

Submit
154. In bazele de date relationale, o restrictie la nivel de atribut:

Explanation

A restriction at the attribute level in relational databases prevents the insertion of values that do not comply with the established intervals or accepted formats. It is an expression that includes the attribute, constants, and system functions. It is also evaluated when modifying the structure of the table.

Submit
155. In tabelele integrate in baze de date relationale:

Explanation

The correct answer states that a restriction at the record level must contain at least 2 attributes and that the expression defining a restriction at the record level is evaluated when inserting or modifying any row. This means that in a relational database, when applying a restriction at the record level, it is necessary to specify at least 2 attributes and the restriction will be checked whenever a new row is inserted or an existing row is modified.

Submit
156. Interogarea bazei de date prin Autofilter:

Explanation

The correct answer states that the Autofilter does not allow extracting results to another zone, ensures the visualization of records that meet the filtering conditions, and does not allow the formulation of complex conditions that refer to 2 fields of the database.

Submit
157. CE realizeaza functia if?

Explanation

not-available-via-ai

Submit
158. Cu referire la modelul relational de organizarea a datelor, care dintre urmatoarele efirmatii sunt adevarate?

Explanation

In modelul relational de organizare a datelor, toate atributele din structura unei tabele trebuie supuse unor reguli de validare. Aceasta este adevarata deoarece regulile de validare asigura integritatea datelor si impun constrangeri asupra valorilor pe care le pot lua atributele. Astfel, se poate asigura coerenta si consistenta datelor stocate in tabela.

Submit
159. Ce realizeaza functia logica if?

Explanation

The correct answer is: indica tipul datei continute de-o casuta a foii de calcul.

The function "if" in programming is used to make decisions based on a condition. It allows the program to execute different sets of instructions depending on whether the condition is true or false. In the context of a spreadsheet or a worksheet, the "if" function can be used to determine the type of data contained in a cell. It can be used to check if a cell contains a number, text, date, or any other data type, and perform different calculations or actions based on the result.

Submit
160. Care dintre urm functii determina primele 3 valori dinto zona a foii de calcul

Explanation

The correct answer is min. The min function determines the smallest value from a range of cells in a spreadsheet. In this case, it would return the first three smallest values from the specified range.

Submit
161. In Excel un registru de lucru:

Explanation

A workbook in Excel is a file that can contain at least 3 worksheets. It is not limited to only text-based worksheets and can also include worksheets with charts or graphs. A workbook is similar to a worksheet, but it refers to the entire file rather than just one sheet within the file.

Submit
162. In reprezentarea interna a datelor calendaristice, ce indica un numar intreg?

Explanation

Numarul de zile care au trecut de la 1 ianuarie 2000.

Submit
View My Results

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
  • Mar 27, 2013
    Quiz Created by
    Isatest
Cancel
  • All
    All (162)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Care functie calculeaza madia aritmetica simpla?
Excel face parte din:
Argumentele functiilor excel sunt incluse intre caracterele:
Cu referire la Excel,care dintre urmatoarele enunturi sunt adevarate?
Prin operatiile de copiere sua mutare adresele absolute se modifica?
Care sunt adevara?
In excel,specificarea Preturi!B45 indica:
In excel prin operatiile de copiere adresele absolute se modifica?
La modificarea continutului unei casute are loc:
Reprezentarea structurii profitului anual pe cele patru trimestre se...
Sa presupunem ca s-a realizat o investitie care aduce in urmatorii 3...
Programele de calcul tabelar:
Care dintre urmatoarele reguli trebuie respecatete in Excel?
In casutele foilor de calcul Excel,pot fi introduse:
Protejarea unei foi de calcul asigura:
Optiunea de sortare la un moment dat poate fi:
Considerind o zona dintr-o foaie de calcul, B5:B10, denumita Venituri,...
Pentru calculul amortizarii se folosesc functiile:
Ce restrictii trebuie sa respecte zona criteriu creata pentru...
In memoria interna,o data calendaristica Excel este reprezentata:
Simularile in tabelele de simulare pot fi realizate in functie de:
Care dintre urmatorii operatori se utilizeaza pentru concatenarea...
Care dintre umatoarele enunturi sunt corecte?
In foile da calcul Excel,adresele casutelor pot fi:
Tipul datelor din casutele foilor excel este determinat de:
O pers fizica vrea sa ia imprumut de la o banca ,cu rambursare 10...
In proiectarea aplicatiilor folosind progr de calcul tabelar trebuie...
Sa presupunem ca sa realizat o investitie care aduce in urrmatoarii 3...
In bazele de date, lucrul cu fisierele de date (extragerea si...
In excel,care dintre urm enunturi sunt adevarate?
Dupa inserarea liniei intr-un tabel,formulele se actualizeaza automat?
O pers fizica isi deschidde cont la o banca cu capitalizare.Lunar se...
In excel ,rata de rambursat dintr-un credit se determina cu ajutorul...
Dezavantajele organizarii datelor supa modelul fisierelor independente...
In excel in casutele foilor de calcul se introduc:
Intrun grafic de tip column sau bar,seriile de date sunt reprezentate...
Intrun grafic de tip PIE se reprezinta:
Interogarea unei baze de date pentru a obtine rezultatele intr-o zona...
In modelul relational de organizare a datelor, care dintre urmatoarele...
Actualizarea foii de calul prin inserare si sau stergerea de linii...
Intr-o baza de date realizata intrun program de calcul tabelar,o linie...
Care dintre urm constructii sunt corecte din punct de vedere...
Cum va interpreta Excel constructia =12/04/07
In excel,formulele:
In excel,care dintre aceste constructii dau acelasi rezultat
Programele de calcul tabelar:
Inca de la inceputurile sale informatica s-a confruntat cu urmatoarele...
Redundanta datelor se manifesta prin
In excel functiile:
In excel,formulele sunt formate din:
Sortarea bazelor de date in excel se poate realiza dupa:
Functiile financiare permit:
Stergerea unei inregistrati dint-o baza se realizeaza prin:
Stabilirea parametrilor de format pentru datele din foaia de calcul se...
Care dintre urm formule si functii sunt corecte?
Care enunturi sunmt adev?
Care sunt adev>?
Care dintre urmatoarele enunturi sunt adevarte
Intrun tab de simulare cu 2 variabile:
IN excel protejarea poate fi realizata la nivel de:
In excel care dintre urm enunturi sunt adevarate?
Care dintre utrm instrumeste software sunt instrumente de calcul...
Analiza rezultatelor se realizeaza in etapa:
Modelul relational de organizare a datelor are urmatorii piloni:
In foile de calcul excel,casutele sunt referite prin:
Care sunt adevarate?
Care dintre urm functii intra in categoria functiilor statistice?
Extragerea de informatii dintro baza de date ntro alta zona a foii de...
Modificarea unei inregistrari dintro baza de date se realizeaza :
Care dintre urm adrese de casute sunt incorecte?
Realizarea copiilor de siguranta se efectueazain etapa:
Datele organizate in BD prezinta urmatoarele caracteristici:
Un program de calcul tabelar performat trebuie sa permita:
In excel protejarea componentelor modelului se realizeaza in etapa:
Care dintre urmatoarele enunturi sunt adevarate?
Intr-o relatie
In excel,formulele:
In functia Vlookup:
Excel este:
Intr-o baza de date realiztata intr-n program d ecalcul tabelar o...
Care enunturi sunt adevarate:
Organizarea datelor in BD poate fi analizata pe urmmatoarele niveluri:
Care zone sunt necesare pentru realizarea operatiunii de soratre?
Programele de calcur tabelar:
Formal, o baza de date este:
Cheile de sortare pot fi:
Dezavantajele organizarii datelor dupa modelul fisierelor independente...
In modelul ierarhic de organizare a datelor
Cum se dispun componentele unui model de rezolvare in foaia de...
Modelarea realitatii in tabele are in vedere ca :
O baza de date reprezinta
Care dintre urmatoarele constructii sunt adevarate?
Un tabel de simulare trebuie sa contina obligatoriu:
IN progr de calcul tabelar,introducerea datelor de intrare se...
Intr-o baza de date relationala, care dintre urmatoarele enunturi sunt...
Care dintre urm functii sunt financiare?
In excel,comezile pot fi apelate din:
In fereastra unei functii excel se afiseaza:
Care dintre urmatoarele enunturi sunt puncte forte ale programelor de...
Macro-urile din programele de calcul tabelor sunt:
Sunt adevarate:
Modelul de organizarea a datelor asigura:
Intr-o baza de date relationala, cheile pot fi:
In Excel, simularile folosesc urmatoarele instrumente:
O casuta din foaia de calcul poate fi identificata prin:
Pentru care dintre componentele excel sunt disponibili asistenti...
Performantele programelor de calcul tabelar sunt date de folosirea:
Incarcarea produsului program(programul de calcul tabelar) este...
Ce implicatii are regula"in formule si functuii nu se folosesc...
Datele organizate in BD prezinta urmatoarele caracteristici:
Instrumentul specific de lucru in programele de calcul tabelor se...
Formatarea datelor din foile de calcul excel poate fin realizata:
In Excel, dimensionarea liniilor si coloanelor se poate realiza prin...
Datele pot fi organizate dupa modelele:
Urmatoarele elemente pot constitui argumente pentru functia SUM?
Modelul realtional are urmatoarele avantaje:
Urmatoarele calcule sunt realizate de functii financiare:
Argumentele functiilor excel pot fi:
Cu referire la organizarea datelor in BD, care dintre urmatoarele...
In Excel, care dintre urmatoarele enunturi sunt adevarate?
Urm elemente pot constitui argumente pentru functia PV:
Care dintre urma functii sunt corecte?
Modelul relational poate fi definit prin 
Intr-o baza de date, dictionarul de date:
Pentru realizarea de simulari intrun tabel cu o variabila:
Conform modelului relational de organizare a datelor, cu referire la...
In excel,argumentele functiilor pot fi
In aplicatiile cu fisiere independente:
Care enunturi sunt false?
Dupa modelul relational, fiecare tabela:
Care dintre urmaoarele enunturi sunt restrictii ale modelului...
In cazul bazelor de date relationale, care dintre enunturile de mai...
In Excel care dintre urmatoarele enunturi sunt adevarate?
Intr-o baza de date relationala, restrictiile:
Intr-o tabela, care dintre urmatoarele enunturi sunt adevarate?
Un tabel de simulare este:
Cu referire la modelul relational, care dintre urmatoarele enunturi...
Costul ridicat al aplicatiilor bazate pe fisiere independente deriva...
ZONA ocupata de un tabel de simulare trebuie sa contina :
Modelul relational are urmatoarele avantaje:
In modelul relational, care dintre urmatoarele afirmatii sunt...
Cu referire la bazele de date, care dintre urmatoarele afirmatii sunt...
Intr-o tabela:
Cu referire la bazele de date, care dintre enunturile de mai jos sunt...
Cu referire la o baza de date , care dintre urmatoarele enunturi nu...
Pentru o tabela integrata intr-o baza de date relationala, care dintre...
Care dintre urmatoarele elemente sunt incluse in schema unei baze de...
Conform modelului relational, intr-o tabela:
Dupa Codd, pentru cheia primara exista urmatoarele restrictii:
In modelul relational de organizarea a datelor, restrictia...
Intr-o baza de date relationala, pot fi definite urmatoarele...
In modelul relational de organizare a datelor, care dintre urmatoarele...
Care dintre urmatoarele elemente sunt incluse in schema unei baze de...
In bazele de date relationale, o restrictie la nivel de atribut:
In tabelele integrate in baze de date relationale:
Interogarea bazei de date prin Autofilter:
CE realizeaza functia if?
Cu referire la modelul relational de organizarea a datelor, care...
Ce realizeaza functia logica if?
Care dintre urm functii determina primele 3 valori dinto zona a foii...
In Excel un registru de lucru:
In reprezentarea interna a datelor calendaristice, ce indica un numar...
Alert!

Advertisement