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: 19,037
| Attempts: 9,499 | klausim: 143
Please wait...
Question 1 / 143
0 %
0/100
Score 0/100
1. In acceess infrmatiile din domeniul economic sunt prezentate in cel mai adesea:

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.

Submit
Please wait...
About This Quiz
Evp 2 :D - Quiz

2. In Access, extensia implicita a unei baze de date este

Explanation

The correct answer is .mdb. In Access, the default file extension for a database is .mdb. This extension is used to identify and open Access database files. The .dbf extension is commonly used for dBASE database files, while the .xls extension is used for Excel spreadsheet files. However, in the context of Access, the .mdb extension is the correct answer for the default file extension.

Submit
3. In Access, atributele care formeaza structura unei tabele:

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.

Submit
4. In Acces, cheia primara poate fi:

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.

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

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.

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

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.

Submit
7. o functie procedurala VBA se refera la instructiuni cuprinse intre:

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.

Submit
8. Comanda DROP TABLE este folosita pt:

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.

Submit
9. Ce se obtine prin urm interogara>? SELECT Data FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=Facturi.CodClient AND Localitatea="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.

Submit
10. Care din clauzele din fraza SELECT nu sunt obligatorii?

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.

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

Explanation

The query will retrieve the name of the client to whom the invoice with the number 12345 was sent.

Submit
12. Intr-un formular Access, este obligatorie sectiunea

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.

Submit
13. Care dintre urmatoarele afirmatii sunt adevarate?

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.

Submit
14. In Access, care dintre urmatoarele enunturi sunt adevarate?

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.

Submit
15. In cadrul unui formular pot sa para maxim:

Explanation

The maximum number of sections that can appear in a form is 5.

Submit
16. Ce determnina executia comezii :DROP TABLE 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.

Submit
17. In Access, sunt acceptate urmatoarele tipri de date:

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.

Submit
18. In Access, cheia primara este naturala atunci cind este declarata:

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.

Submit
19. In Access tipul implicit de interogare este:

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.

Submit
20. Cu referire la Accesss care dintre urm enunturi sunt edevarate?

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.

Submit
21. In ce an a aparut standartul SQL3?

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.

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

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.

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

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.

Submit
24. In Access, formatul pentr date calendaristice:

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.

Submit
25. PEntru  utilizatorul final,obiectivul principal SQL este:

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.

Submit
26. In Access, declararea restrictiilor dupa popularea tabelelor cu inregistrari:

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.

Submit
27. 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:

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.

Submit
28. In Access o tabela poate fi creata folosind:

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.

Submit
29. In Access, declararea restricitiilor trebuie facuta:

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.

Submit
30. In Access, restrictia de integritate referentiala cere ca:

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.

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

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.

Submit
32. In Access:

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.

Submit
33. Un formular Access, are urmatoarele sectiuni

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.

Submit
34. Limbajele de interogare pot fi:

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.

Submit
35. Care dintre urm enunturi reprezinta facilitati majore ale Accsesului:

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.

Submit
36. pentru declararea cheilor straine prin comanda CREATe TABLE,se utilizeaza clauza:

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.

Submit
37. Ce se obtine prin urm interogara>? SELECT Data FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=Facturi.CodClient AND NumeClient="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".

Submit
38. In proiectele Access se pot organiza urmatoarele tipuri de obiecte:

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.

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

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".

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

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.

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

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.

Submit
42. In Access, raportul:

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.

Submit
43. SQL se bazeaza pe

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.

Submit
44. ACCESS este:

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.

Submit
45. limbajul SQL a fost standartizat in :

Explanation

SQL (Structured Query Language) is a programming language designed for managing and manipulating relational databases. It was first standardized in 1986 in the United States. However, in 1989, it was further standardized at a global level by the OSI (Open Systems Interconnection) and internationally by the ISO (International Organization for Standardization). This means that SQL became a standardized language for database management worldwide, ensuring compatibility and consistency across different database systems.

Submit
46. Care dintre urmatoarele comenzii SQL sunt destinate manipularii datelor

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.

Submit
47. In Access, care dintre urmatoarele afirmatii sunt adevarate?

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.

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

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.

Submit
49. 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#)

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.

Submit
50. ce se obtine prin urm interogare SQL? SELECT NrFactura FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=ABONATI.CodClinet AND ValtTot IN(5000,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".

Submit
51. Ce determina executia comenzii: UPDATE facturi SET TVAColectata = INT(ValoareaTotala *19/1.19)/100

Explanation

The execution of the given command "UPDATE facturi SET TVAColectata = INT(ValoareaTotala *19/1.19)/100" will modify the value of the attribute TVA Colectata. This command updates the TVAColectata attribute by calculating it based on the ValoareaTotala attribute in the facturi table. The formula used in the command calculates the TVA Colectata value by multiplying the ValoareaTotala by 19 and dividing it by 1.19, and then converting it to an integer and dividing it by 100. Therefore, the correct answer is "modificarea valorii atributului TVA Colectata".

Submit
52. Programele VBA sunt numite proceduri si sunt grupate in:

Explanation

VBA programs are divided into two main groups: subroutines and procedural functions. Subroutines are a type of procedure that performs a specific task or set of tasks, but does not return a value. On the other hand, procedural functions are also procedures, but they do return a value after performing a specific task or calculation. Therefore, the correct answer includes both subroutines and procedural functions as the two main groups of VBA procedures.

Submit
53. Se da urm interogare SQL: SELECT NrFactura,ValoareTotala-TVAColect As ValFaraTVA,TotalTVAColect,ValoareaTotala As ValTot FROM FACTURI WHERE Data=Date() In urma executiei rezultatul va avea:  

Explanation

The query selects four columns from the table FACTURI: NrFactura, ValFaraTVA, TotalTVAColect, and ValTot. Therefore, the result of the execution will have four columns.

Submit
54. In expresiile Access, cared intre urmatoarele contructii sunt corecte?

Explanation

The expressions "FEAA" and #12/122005# are correct in Access. "FEAA" is a valid string expression, while #12/122005# is a valid date expression. The other expressions, #31/312006# and "31/12/2005", are not valid because the date format is incorrect.

Submit
55. In Access, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The correct answer is "un formulat este legat de o structura de date de tip tabela" which means "a form is linked to a table data structure". This statement is true because in Access, a form is typically created to display and interact with data from a table or query. The form is linked to the table through its record source property, allowing the user to view, add, edit, and delete records in the table through the form.

Submit
56. Comanda UPDATE poate fi utilizata pentru:

Explanation

The UPDATE command in SQL is used to modify the values of a field in a table. It allows you to change the data in a specific column or columns of a table. This command is commonly used when you need to update existing records in a database, such as changing the values of certain fields based on certain conditions or criteria.

Submit
57. In Access:

Explanation

In Access, indexes are created for each type of primary or alternative key. For the primary key attribute, the Indexed property is set to YES with the option of No Duplicates, ensuring that each value in the primary key is unique. This helps in maintaining data integrity and efficient retrieval of data. Similarly, for foreign key attributes, the Indexed property is also set to YES with the option of No Duplicates to ensure referential integrity.

Submit
58. In Access, tipul de date Memo se foloseste cind datele ce urmeaza a fi introduse:

Explanation

The correct answer is "au mai multe de 255 aractere, nu sunt structurate." In Access, the Memo data type is used when the data to be entered has more than 255 characters and is unstructured. This data type allows for the storage of large amounts of text and is commonly used for notes, descriptions, or comments where the length of the text exceeds the limit of other data types like Text.

Submit
59. Care dintre urmatoarele comenzii SQL sunt destinate manipularii datelor

Explanation

The correct answer is INSERT, SELECT, and UPDATE. These SQL commands are used for manipulating data in a database. INSERT is used to add new records to a table, SELECT is used to retrieve data from a table, and UPDATE is used to modify existing records in a table. CREATE TABLE, on the other hand, is used to create a new table in a database and is not directly related to data manipulation.

Submit
60. Care dintre urmatoarele comenzii SQL sunt destinate manipularii datelor

Explanation

The correct answer is INSERT and SELECT because these two SQL commands are used for data manipulation. INSERT is used to add new rows or records into a database table, allowing the user to insert data into specific columns. SELECT is used to retrieve data from a database table, allowing the user to specify the columns and conditions to filter the data they want to retrieve. The other two options, CREATE TABLE and MODIFY, are not data manipulation commands. CREATE TABLE is used to create a new table in a database, while MODIFY is not a valid SQL command.

Submit
61. In Access, bazele de date organizeaza:

Explanation

The correct answer is that databases in Access organize tables that include primary data and tables that contain lists of values. This means that Access allows users to create tables that store important data and tables that store reference values or options for data entry. These tables can be linked together using relationships to create a comprehensive database system.

Submit
62. In Access, sunt acceptate urmatoarele tipuri de date:

Explanation

The correct answer includes two types of data accepted in Access: "date calendaristice" which refers to calendar dates, and "memo" which allows for storing large amounts of text. The other options mentioned, "numerologice" and "Hlookup", are not valid data types in Access.

Submit
63. Prin interogarile Access pot fi obtinute informatii:

Explanation

The correct answer is "din una sau mai multe tabele, pe baza unor criterii stabilite de utilizator, preluate din cimpurile tabelelor si/sau rezultate din expresii calculate." This means that with Access queries, information can be obtained from one or more tables, based on user-defined criteria, and can include data from the fields of the tables or calculated expressions.

Submit
64. In interogarile Access:

Explanation

In Access queries, calculations can be performed at the group level of records. This means that calculations can be done for each group of records based on a specific criteria or field. To perform these calculations, aggregate functions are used. Aggregate functions in Access, such as SUM, AVG, COUNT, etc., allow you to calculate values based on groups of records rather than individual records. These functions can be used to calculate totals, averages, counts, and other summary statistics for each group of records in a query.

Submit
65. In proiectele Access se pot organiza urmatoarele tipuri de obiecte:

Explanation

In proiectele Access, se pot organiza următoarele tipuri de obiecte: formulare, module și tabele. Formularele sunt utilizate pentru a afișa și manipula datele într-un mod interactiv și personalizat. Modulele sunt utilizate pentru a scrie cod VBA (Visual Basic for Applications) pentru a extinde funcționalitatea aplicației. Tabelele sunt utilizate pentru a stoca datele într-un format structurat și relațional.

Submit
66. In Access, AutoNumber:

Explanation

AutoNumber in Access is a special variant of Numeric data type that is recommended for establishing primary keys. It does not accept NULL values.

Submit
67. Ce descrie urm clasuza a comenzii CREATE TABLE din SQL:CONSTRANT ck_numeclient CHECK (NumeClient = UPPER(NumeClient))

Explanation

The given SQL command describes a CHECK constraint on the attribute NumeClient. This means that whenever a new record is inserted or updated in the table, the value of the NumeClient attribute must satisfy the specified condition, which in this case is that the value of NumeClient must be equal to its uppercase version. Therefore, the correct answer is "A validation rule at the attribute level of NumeClient."

Submit
68. La vizualizarea continutului tabelelor Access:

Explanation

The correct answer is that the "+" sign next to a record signifies that it is linked through foreign keys to records in other tables, while the "-" sign next to a record signifies that the displayed records are related to it.

Submit
69. In procedurile Access, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The given correct answer states that subroutines do not return a value, while procedural functions do return a value. This is accurate because subroutines in Access are used to perform a series of actions or tasks without returning a result, whereas procedural functions are designed to return a value based on the input parameters. Additionally, the other options mentioned in the question, such as subroutines referring to Excel macros and procedural functions not containing VBA instructions, are not relevant to the behavior of subroutines and procedural functions in Access.

Submit
70. Care din urmatoarele enunturi sunt adevarate? 

Explanation

The correct answer is the first statement, "SQL este un sub-limbaj orientat pe lucrul cu baze de date" (SQL is a sub-language oriented towards working with databases). This statement is true because SQL (Structured Query Language) is specifically designed for managing and manipulating data in relational database management systems. It provides a standardized way to create, retrieve, update, and delete data in databases. The other two statements are false. The second statement is incorrect because SQL commands can be embedded in programs written in various programming languages, such as Java or Python. The third statement is also false as SQL does not offer visual object manipulation features.

Submit
71. Se da urm fraza SQL SELECT SUM(valoarea totala) As TotalValTot FROM FACTURI WHERE ValTot IN  (SELECT MAX(ValTot) FROM FACTURI WHERE Data=#30/04/2007) in urma executie rezultatul :

Explanation

The query is selecting the sum of the "valoarea totala" from the table "FACTURI" where the "ValTot" is in the set of values returned by the subquery. The subquery selects the maximum value of "ValTot" from the table "FACTURI" where the "Data" is equal to #30/04/2007. Therefore, the answer is "valoarea totala a fcaturilor care acu aceleasi valori ca si valoarea maxima a unei facturi emise pe 30 aprilie 2007".

Submit
72. In Access, care dintre urmatoarele enunturi  sunt adevarate?

Explanation

The correct answer is that "adaugarea unui nou cimp inseamna modificarea structurii unei tabele" (adding a new field means modifying the structure of a table) and "adaugarea unei noi inregistrari inseamna actualizarea unei tabele" (adding a new record means updating a table) are true statements. In Access, adding a new field to a table does indeed involve modifying the structure of the table, as it changes the columns or attributes that the table contains. Similarly, adding a new record to a table means updating the table with new data.

Submit
73. ce se obtine prin urm interogare SQL? SELECT NrFactura FROM CLIENTI,FACTURI WHERE CLIENTI.CodClient=ABONATI.CodClinet AND Data BETWEEN #07/05/2007/# AND #14/05/2007#

Explanation

The given SQL query will retrieve the "NrFactura" (invoice number) from the tables "CLIENTI" and "FACTURI" where the "CodClient" in the "CLIENTI" table matches the "CodClinet" in the "ABONATI" table, and the "Data" is between 7th May 2007 and 14th May 2007. Therefore, the correct answer is "numai facturile emise intre 7 si 14 mai" which translates to "only the invoices issued between 7th and 14th May".

Submit
74. Care dintre urm fraze SQL sunt corecte?

Explanation

not-available-via-ai

Submit
75. In Access sunt acceptate urmatoarele tipuri de date:

Explanation

The given answer is correct because in Access, these are the accepted types of data. "Date/Time" is used to store dates and times, "Numeric" is used to store numerical values, and "Lookup Wizard" is used to create a field that allows the user to choose a value from a list of predefined values.

Submit
76. SQL este un limaj de consultare a bazei de date care permite:

Explanation

SQL este un limbaj de consultare a bazei de date care permite manipularea datelor din baza de date și partajarea între mai mulți utilizatori ai bazei de date.

Submit
77. In Access, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The statement "la modificare structurii unei tabele, pot fi strese mai multe atribute pentr-o singura comanda" is true. It means that when modifying the structure of a table in Access, multiple attributes can be deleted using a single command. This allows for efficient and convenient management of table structure changes.

Submit
78. Marcati comenzile SQL oentru definirea bazei de date:

Explanation

The correct answer is "CREATE TABLE, ALTER TABLE". These two SQL commands are used for defining and modifying the structure of a database. "CREATE TABLE" is used to create a new table in the database, specifying the table name and the columns it will contain. "ALTER TABLE" is used to modify an existing table, allowing changes such as adding or deleting columns, modifying column data types, or adding constraints. The other two options, "UPDATE" and "INSERT", are used for manipulating data within the tables, not for defining or modifying the structure of the database.

Submit
79. In proiectele Access se pot organiza urmatoarele tipuri de obiecte:

Explanation

In proiectele Access, se pot organiza interogari și rapoarte. Interogările sunt utilizate pentru a căuta și extrage informații din baza de date, în timp ce rapoartele sunt utilizate pentru a formata și afișa aceste informații într-un mod structurat și ușor de înțeles. Centralizatoarele electronice și meniurile nu sunt menționate ca tipuri de obiecte organizabile în proiectele Access în enunțul dat.

Submit
80. Care dinter urm comenzi SQL asigura declararea structurii bazei de date?

Explanation

The correct answer is CREATE TABLE and CREATE VIEW. These two SQL commands are used to declare the structure of a database. CREATE TABLE is used to create a new table in the database, specifying the columns and their data types. CREATE VIEW is used to create a virtual table, which is a result of a query, and it defines the structure of the view. UPDATE, on the other hand, is used to modify the existing data in the table, not to declare the structure.

Submit
81. In Access, tabelele sunt organizate in:

Explanation

The correct answer is baze de date ierarhice, baze de date relationale, fisiere .mdb. This is because in Access, tables are organized in hierarchical database structures, relational databases, and .mdb files. Hierarchical databases organize data in a tree-like structure, where each record has a parent and child relationship. Relational databases organize data into tables with relationships between them. And .mdb files are the file format used by Access to store databases.

Submit
82. Marcati caracteristile SQL din lista de mai jos:

Explanation

The given answer correctly identifies "standardizare" and "portabilitate" as characteristics of SQL. Standardizare refers to the fact that SQL follows a set of standardized rules and syntax, which ensures consistency and compatibility across different database systems. Portabilitate refers to the ability of SQL to be easily transferred or migrated between different database platforms without significant modifications. Both of these characteristics contribute to the versatility and widespread adoption of SQL in the industry.

Submit
83. Ce se obtine prim urm interogare SQL? SELECT NrFactura,ValoareTotala-TVAColect As TotalTVA FROM FACTURI,CLIENTI WHERE FACTURI.CodClient=CLIENTI.CodClient

Explanation

The given SQL query selects the "NrFactura" and the difference between "ValoareTotala" and "TVAColect" as "TotalTVA" from the tables "FACTURI" and "CLIENTI" where the "CodClient" in the "FACTURI" table matches the "CodClient" in the "CLIENTI" table. Therefore, the query obtains the value without VAT for the issued invoices.

Submit
84. In Acces, cheia primara poate fi:

Explanation

The primary key in Access can be declared by the system, declared by the user, artificial, or natural. This means that Access allows for flexibility in defining the primary key for a table. The system can automatically generate a primary key, the user can manually declare a primary key, or the primary key can be a generated value (artificial) or a value that already exists in the data (natural).

Submit
85. In Access, modificarea structurii unei tabele inseamna:

Explanation

The correct answer is the addition of new fields, the deletion of some fields, and the modification of the properties of fields. In Access, modifying the structure of a table refers to making changes to the fields within the table. This can involve adding new fields to store additional information, deleting unnecessary fields, or modifying the properties of existing fields such as changing the data type or field size. These actions help in customizing the table structure to better fit the data needs and improve data management in Access.

Submit
86. Cu referire la SQL car e enunturi sunt edevarate>

Explanation

The function COUNT counts the non-null values of a column in a table.

Submit
87. Se da urm fraza SQL: SELECT Data, SUM(Vaoare Totala) As totalValTotala FROM FACTURI, CLIENTI WHERE CLIENTI.CodClient=FACTURI.CodClient GROUp BY Data HAVING SUM(valoarea totala)>5000 Rezultatul va contine:

Explanation

The correct answer is "totalul facturilor emise pe fiecare zi in care acestea depaseste 5000". The given SQL statement is using the GROUP BY clause to group the data by the "Data" column. The HAVING clause is then used to filter the groups and only include those where the sum of "valoarea totala" (total value) is greater than 5000. Therefore, the result will contain the total of the invoices issued for each day where the total value exceeds 5000.

Submit
88. Se da urmatoarea fraza SQL: SELECT NumeClient, SUM(Vaoare Totala) As totalValTotala FROM FACTURI, CLIENTI WHERE CLIENTI.CodClient=FACTURI.CodClient AND NumeClient ="Alfa SRL" GROUP BY NumeClient Rezultatul aceste fraze va fi:

Explanation

The given SQL query selects the "NumeClient" and the sum of "Vaoare Totala" (total value) from the "FACTURI" and "CLIENTI" tables, where the "CodClient" in the "CLIENTI" table matches the "CodClient" in the "FACTURI" table and the "NumeClient" is "Alfa SRL". The query then groups the results by "NumeClient". Therefore, the result of this query will be the total value of the invoices issued to the client "Alfa SRL".

Submit
89. Analizati linia de comanda SQL si marcati variantele corecte de raspuns: CREATE TABLE codPost_loc( codPostal CHAR(6) CONSTRAINT pk_cp PRIMARY KEY, Localitate CHAR(35) NOT NULL, Judet CHAR(25) NOT NULL);

Explanation

The given SQL command creates a table named "codPost_loc" with three attributes: "codPostal", "Localitate", and "Judet". The attribute "codPostal" is defined as a primary key and does not allow null values. This means that every record in the table must have a unique and non-null value for the "codPostal" attribute. The attribute "Localitate" is defined as not null, which means it cannot have null values. However, the data type of the "codPostal" attribute is not specified in the given SQL command, so it is not possible to determine if it is of text or numeric type.

Submit
90. Comanda DELETE poate fi utilizata pentru 

Explanation

The DELETE command is used to remove data from a table in a database. In this case, the correct answer is "stergerea unei linii dintr-o tabela," which translates to "deleting a row from a table." This means that the DELETE command can be used to remove specific rows or records from a table in a database. It does not delete the entire table or just the values of a field.

Submit
91. SQL este:

Explanation

SQL (Structured Query Language) is a language that is implemented on most current database management systems (SGBD-urilor actuale). It is specifically related to relational database management systems (SGBD-urile relationale), which are a type of SGBD. SQL is used to communicate with and manipulate data in these relational databases.

Submit
92. Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?

Explanation

The correct answer is "standardizarea" and "este un limbaj de nivel inalt, cu structura ce se apropie de limba engleza". These statements explain that one of the advantages of SQL is that it is standardized, meaning it follows a set of rules and conventions that ensure consistency and compatibility across different database systems. Additionally, SQL is a high-level language with a structure that resembles the English language, making it easier for users to understand and write queries.

Submit
93. Cu referire la SQl care dintre urm enunturi sunt adevarate?

Explanation

The correct answer is "Modalitatea de a regulilor de validare este cea procedurala, rezultatul unei consultari poate contine doua sau mai multe tupluri identice". This statement is true because it states that the procedural method is used to enforce validation rules in SQL, and it also states that the result of a query can contain two or more identical tuples.

Submit
94. Care dintre urmatoare comanda SQL sunt folosite pentru actualizarea unei tabele?

Explanation

The correct answer is INSERT, UPDATE, and DELETE. These SQL commands are used for modifying the data in a table. INSERT is used to add new records, UPDATE is used to modify existing records, and DELETE is used to remove records from a table. DROP TABLE and CREATE TABLE are not used for updating data, but rather for creating or deleting tables.

Submit
95. In access, care dintre urmatoarele enunturi sunt adevarate?

Explanation

The explanation for the given correct answer is that in Access, it is true that data can be extracted from a single table in a report. This means that a report can display information from one specific table in the database. Additionally, it is also true that a report is an object that is part of an Access project. This means that a report is a separate entity within an Access project and can be created, modified, and managed independently.

Submit
96. In Access, restrictiile de integritate referentiala:

Explanation

Restrictiile de integritate referentiala in Access se bazeaza pe legaturile permanente dintre tabele. Aceste legaturi sunt stabilite prin definirea cheilor primare si cheilor externe. De asemenea, pentru a implementa restrictiile de integritate referentiala, trebuie sa activam optiunea "Enforce Referential Integrity" in Access. Aceasta optiune asigura ca orice modificare sau operatie efectuata asupra tabelelor parinte si copil respecta regulile de integritate referentiala definite. Astfel, se impiedica efectuarea operatiilor de adaugare, stergere sau modificare care ar incalca aceste reguli.

Submit
97. SQL ofera mijloacele necesare formularii unei consultari 

Explanation

SQL ofera mijloacele necesare formularii unei consultari prin descrierea rezultatului dorit. Acest lucru se referă la faptul că SQL permite utilizatorului să specifice exact ce rezultate dorește să obțină din baza de date, prin intermediul clauzelor SELECT, FROM, WHERE și altele. Utilizatorul poate specifica coloanele dorite, condițiile de filtrare și alte cerințe pentru a obține rezultatele dorite.

Submit
98. Comanda Alter Table poate fi utilizata pentru:

Explanation

The Alter Table command can be used to add a field to a table.

Submit
99. Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?

Explanation

The given answer is correct because it correctly identifies the advantages of the SQL language. SQL provides independence from the producer, meaning it can be used with different database management systems. It also offers portability between different operating systems, allowing the same SQL code to be executed on different platforms. Additionally, SQL allows for multiple views or images of the data within a database, providing flexibility and ease of access to the data.

Submit
100. In Access, care dintre urmatoarele enunturi sunt adevarate:

Explanation

A tabela poate avea doar o singură cheie primară, ceea ce înseamnă că poate fi definită o singură coloană ca fiind cheie primară. În plus, într-o tabelă pot fi declarate mai multe restricții la nivel de atribut, ceea ce înseamnă că pot fi impuse mai multe reguli și restricții asupra valorilor introduse în coloanele respective.

Submit
101. In procedurile Access, se folosesc:

Explanation

The correct answer is "cuvinte rezervate ale mediului VBA, variabile, valori". In Access procedures, users can use reserved keywords specific to the VBA environment, as well as variables and values. These reserved keywords are predefined by the VBA environment and have specific meanings and functions within the programming language. Variables are used to store and manipulate data, while values represent specific data that can be assigned to variables or used in calculations.

Submit
102. Interogarile SQL din acces:

Explanation

The given answer states that SQL queries in Access are similar in syntax and semantics to commands in other database management systems (SGBD-uri). They can be used to describe data selection operations and can also be used to describe data insertion, modification, and deletion operations.

Submit
103. Access creeaza indecsi pentru:

Explanation

Access creează indecși pentru cheia primară, cheia alternativă și cheia naturală. Acestea sunt toate tipuri de chei utilizate în bazele de date pentru a identifica și organiza înregistrările. Indecșii sunt creați pentru a accelera căutarea și filtrarea datelor într-o bază de date, ceea ce face interogările mai eficiente.

Submit
104. In Access pentru inetrogari se pot folosi:

Explanation

In Access, pentru interogari se pot folosi instrumente de tip wizard, care sunt instrumente automate care ghidează utilizatorul în crearea interogărilor. De asemenea, se pot utiliza instrumente de tip RAD (Rapid Application Development), care permit dezvoltarea rapidă a aplicațiilor prin intermediul unor instrumente și funcționalități predefinite. În plus, se pot folosi și comenzi SQL pentru a crea interogări mai complexe și personalizate. Limbajele naturale și limbajele artificiale nu sunt instrumente specifice pentru crearea interogărilor în Access.

Submit
105. Se da urm interogare SQL: SELECT NrFactura,ValoareTotala-TVAColect As ValFaraTVA,TotalTVAColect,ValoareaTotala As ValTot FROM FACTURI WHERE Data=#31/04/2007# AND Data=#05/05/2007#  In urma executiei acestei fraze rezultatul va avea:

Explanation

The query is looking for rows in the FACTURI table where the Data column is both equal to 31/04/2007 and 05/05/2007 at the same time. However, there is no such date that is equal to both 31/04/2007 and 05/05/2007. Therefore, the result of the query will be no rows, or "nici o linie" in Romanian.

Submit
106. Cu referire la interogarile Access, acre dintre urmatoarele enunturi sunt adevarate?

Explanation

The given answer states that the following statements are true: 1) the most interesting part of queries is the processing of numerical data, 2) queries can include attribute expressions from one or more tables, and 3) conditions can be defined for records to be included in the result of a query. The answer does not mention anything about the ability to establish a sorting option in a query.

Submit
107. In Access, restrictia de integritate referentiala are urmatoarele consecinte:

Explanation

The correct answer states that in Access, the referential integrity constraint has the following consequences:
1. The primary key in the parent table cannot be modified if there is at least one record in the child table that is linked to it.
2. A foreign key value cannot be inserted if the corresponding value is not present as a primary key in the parent table.

These consequences ensure that the relationships between tables are maintained and that data integrity is preserved.

Submit
108. In Access, care dintre urmatoarele enunturi nu sunt adevarate?

Explanation

The correct answer is "pentru modificarea structurii, o tabela trebuie deschisa in modul Open, pentru actualizare, o tabela trebuie deschisa in modul Design". This means that in Access, to modify the structure of a table, it needs to be opened in Design mode, not in Open mode. Similarly, to update the data in a table, it needs to be opened in Open mode, not in Design mode.

Submit
109. Intro fraza SQL care dintre enunturi sunt adevarata?

Explanation

The given correct answer states that the option "optiune DISTINCT elimina din rezultatul interogari tuplurile identice" is true, which means that the DISTINCT option removes identical tuples from the query result. It also states that the option "literalul este o constanta de tip sir de caractere" is true, indicating that a literal is a constant of type string.

Submit
110. Se da urm fraza SQL: FROM FACTURI,ABONATI WHERE CLIENTI.CodClient=FACTURI.CodClient GROUp BY Data HAVING SUM(valoarea totala)>5000 rezultatul acestei fraze va contine:

Explanation

The correct answer is "fraza select este gresita" because the given SQL statement is not correctly formed. There are several errors in the syntax, such as using the wrong table name "CLIENTI" instead of "ABONATI" and missing the SELECT keyword before the column names. Additionally, the GROUP BY clause should include all non-aggregated columns mentioned in the SELECT statement. Therefore, the SQL statement is incorrect and will not produce the desired result.

Submit
111. Limbajul SQL permite:

Explanation

The correct answer is that SQL allows for the declaration of primary key constraints, the creation of tables, and the declaration of foreign key constraints. SQL is a programming language specifically designed for managing and manipulating relational databases. With SQL, users can create tables to store data, declare primary key constraints to ensure unique identification of records, and establish foreign key constraints to enforce referential integrity between tables. These features are essential for designing and maintaining a well-structured and interconnected database system.

Submit
112. In Access, modificare structurii unei tabele inseamna:

Explanation

The correct answer is "adaugarea unor noi atribute, modificarea numelui, tipului si/sau lungimii atributelor." In Access, modifying the structure of a table refers to adding new attributes (columns), as well as changing the name, data type, or length of existing attributes. This allows for flexibility in organizing and managing data within the table.

Submit
113. Fraza SQL SELECT poate fi utilizata pentru:

Explanation

The SQL SELECT statement is used to retrieve data from a database. It is not used for adding or modifying fields or deleting rows or fields from a table. Therefore, the correct answer is "modificarea valorilor unui cimp" which translates to "modifying the values of a field".

Submit
114. Interogarile din MIcrosoft access pot fi folosite:

Explanation

Interogarile din Microsoft Access pot fi utilizate în mai multe moduri. Pot fi folosite de alte interogari Access în cazul interogarilor de selectie. De asemenea, pot fi utilizate direct în mod vizual, cu ajutorul gestionarului bazei de date. Interogarile pot fi utilizate și din ferestrele, rapoartele și modulele de cod VBA ale bazei de date. Aceste opțiuni permit utilizatorilor să acceseze și să utilizeze interogările în diferite contexte și în diferite moduri, în funcție de nevoile lor specifice.

Submit
115. SQL este cel mai important limbaj in domeniul bazei de date deoarece:

Explanation

SQL este considerat cel mai important limbaj în domeniul bazelor de date deoarece este standardizat, ceea ce înseamnă că este recunoscut și utilizat în mod universal în industrie. De asemenea, este portabil pe cele mai semnificative SGBD-uri (Sisteme de Gestiune a Bazelor de Date), ceea ce înseamnă că poate fi folosit în diferite medii și platforme. SQL poate fi deprins relativ ușor de către persoanele care nu au cunoștințe avansate în informatică, făcându-l accesibil și utilizatorilor neinformaticieni. De asemenea, SQL oferă răspunsuri la o gamă omogenă de întrebări legate de manipularea și interogarea bazelor de date.

Submit
116. Care dintre urm enunturi NU sunt adevarate?

Explanation

The statement "interogarile sunt colectii de date aflate in interdependenta" is not true because queries are not collections of data, but rather requests for specific data from a database. Queries are used to retrieve, manipulate, and analyze data, but they are not collections of data themselves.

Submit
117. Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?

Explanation

The correct answer is "se bazeaza pe modelul relational de organziare a datelor,constituie suportul pragmatic pentru accesul la baza de date,furnizeaza raspunsuri la interogari simple,neprevazute initial". This answer explains that SQL is based on the relational model of data organization, it provides practical support for accessing databases, and it allows for providing answers to initially unforeseen simple queries.

Submit
118. SQl prezinta comenzi specifice pentru:

Explanation

SQL (Structured Query Language) is a programming language specifically designed for managing and manipulating relational databases. It provides specific commands for various tasks, including obtaining reports, modifying the content of a table, adding new rows to existing tables, and modifying the value of an attribute. Therefore, the given answer correctly identifies the specific commands in SQL for modifying the content of a table, adding new rows to existing tables, and modifying the value of an attribute.

Submit
119. Limbajul SQL permite:

Explanation

The correct answer is that SQL allows for creating tables, defining constraints, updating data in tables, and extracting and processing data in a database. SQL is a programming language used for managing and manipulating relational databases. It provides various commands and statements that enable users to perform tasks such as creating tables to store data, defining constraints to enforce data integrity, updating existing data, and retrieving and processing data based on specific criteria. Additionally, SQL can also be used for generating reports and working with forms in some database management systems.

Submit
120. Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?

Explanation

The given answer is correct because it lists the advantages of the SQL language. It states that SQL provides excellent support for implementing client-server architectures, offers multiple views of data in a database, is a complete relational language, and allows for dynamic data definition.

Submit
121. In Accesss care dintre urm afirmatii sunt adevarate?

Explanation

The given answer is correct because it states that reports can be printed and displayed on the printer. In Microsoft Access, reports can be printed directly from the application, allowing users to have physical copies of their reports. Additionally, reports can also be displayed on the screen, providing a visual representation of the data. Therefore, both statements are true.

Submit
122. SQL este un limaj universal care permite:

Explanation

SQL este un limbaj universal care permite crearea utilizatorilor și grupurilor de utilizatori, definirea drepturilor fiecărui utilizator/grup de utilizatori, definirea datelor și menținerea integrității bazei de date.

Submit
123. In Access, formularul este un instrument ce permite:

Explanation

The correct answer is accessing and updating data stored in tables and entering data into tables. In Access, a form is a tool that allows users to interact with the data in tables. Users can access and update the data stored in tables through the form, as well as enter new data into the tables. Forms provide a user-friendly interface for managing and manipulating data in Access databases.

Submit
124. Care dintre urm enunturi reprezinta facilitati majore ale Accessului?

Explanation

The correct answer includes multiple major features of Access. It states that Access can quickly identify data relationships, display data in the form of graphs or web pages, export data to Excel or Word, and automate common operations. These features highlight the capabilities of Access in efficiently managing and analyzing data, presenting it visually, and streamlining tasks for users.

Submit
125. Cu referire la SQL care dintre urm enunturi sunt adevarate?

Explanation

The given answer correctly states that SQL is categorized as a fourth-generation language and is not a programming language in the strict sense. Additionally, it mentions that until the SQL3 standard, SQL did not provide facilities for working with visual objects.

Submit
126. SQL dispune de optiuni pentru :

Explanation

SQL dispune de opțiuni pentru specificarea unor restricții legate de cheile primare și specificarea unor restricții legate de cheile străine. Aceste restricții sunt importante pentru a asigura integritatea datelor în baza de date. Prin specificarea restricțiilor legate de cheile primare, se garantează că fiecare înregistrare dintr-o tabelă are o valoare unică pentru cheia primară. Prin specificarea restricțiilor legate de cheile străine, se asigură că valorile dintr-o coloană dintr-o tabelă sunt legate de valorile dintr-o altă coloană dintr-o altă tabelă.

Submit
127. Din punctul de vedere al utilizatorului final,obiectivul principal al SQL consta in oferirea mijloacelor pentru:

Explanation

SQL (Structured Query Language) is a programming language used for managing and manipulating relational databases. From the perspective of the end user, the main objective of SQL is to provide the means for formulating queries in a way that allows them to describe the desired result without explicitly specifying the actual search method used in the database. This means that users can formulate queries by describing the desired result, using logical expressions, without needing to know the specifics of how the search is performed in the database.

Submit
128. In rapoartele Access:

Explanation

The answer states that in Access reports, records can be broken and ordered, the header and footer sections are not mandatory, the detail section contains the values of the fields from the database and calculated expressions that will form a line with data, and the page footer section can contain expressions that will be calculated during the execution of the report.

Submit
129. Comanda Alter Table poate fi utilizata pentru:

Explanation

The correct answer is "stergerea unui cimp dintr-o tabela". The Alter Table command can be used to delete a field from a table. It allows for modifying the structure of a table by adding or removing columns, changing data types, or altering constraints. In this case, the command is specifically used for deleting a field (cimp) from a table.

Submit
130. In Access care dinntre urm enunturi sunt adevarate>

Explanation

The given answer states that the following statements are true:
1. Selection queries are objects of the database.
2. Selection queries are used to extract or display data from a database.
3. Deletion queries require completing the necessary information to identify the record to be deleted.
4. Modification queries require completing the necessary information to create an UPDATE command (like the one in SQL standard).

Submit
131. Ce determina executia linie de comanda:ALTER TABLE CLIENTI ADD CodFiscal CHAR(10)?

Explanation

The execution of the command "ALTER TABLE CLIENTI ADD CodFiscal CHAR(10)" determines the addition of a new attribute in the table "Clienti" and the modification of the structure of the table "Clienti".

Submit
132. IN SQL functiile de agregare:

Explanation

The correct answer states that SQL aggregate functions allow calculations to be performed on values taken from an attribute or expression. In the absence of grouping, these functions result in a table with only one row. These functions are also the first step in data analysis in a database.

Submit
133. Adaugarea de noi inregistrari intr-o tabela Access presupune deschiderea acesteia:

Explanation

When adding new records to an Access table, there are multiple ways to do so. One way is to open the table directly in "Open" mode and manually enter the new record. Another way is to use a previously created form specifically designed for that table, which provides a user-friendly interface for entering the new record. Additionally, it is also possible to add new records through an "insert" type of record, where the new record is inserted programmatically or through a query.

Submit
134. In Access interogarile pot fi d etip :

Explanation

The correct answer is selectie, inserare, modificare inregisrari. In Access, queries can be used to perform various operations on a database. "Selectie" refers to selecting specific data from the database based on certain criteria. "Inserare" is used to insert new records into the database. "Modificare inregisrari" means modifying existing records in the database. These are all common operations that can be performed using queries in Access.

Submit
135. Comanda UPDATE poate fi utilizata pentru:

Explanation

The UPDATE command is used for modifying data in a database table. It can be used to add a new record to a table, change the name of a table, add a field to a record, or delete a field from a database.

Submit
136. Comanda UPDATE poate fi utilizata pentru:

Explanation

The UPDATE command can be used to modify the values of existing fields in a table. It cannot be used to add a new field, change primary keys, delete a row, or delete a field from a table.

Submit
137. Se da urm interogare SQL: SELECT NrFactura,ValoareTotala-TVAColect As ValFaraTVA,TotalTVAColect,ValoareaTotala As ValTot FROM FACTURI WHERE Data=#31/04/2006# In urma executiei ecestei fraze rezultatul va avea:

Explanation

In urma executiei acestei fraze, rezultatul va avea o singura linie.

Submit
138. Se da urm fraza SQL: SELECT NumeClient, SUM(Vaoare Totala) As totalValTotala FROM ABONATI, CLIENTI WHERE CLIENTI.CodClient=FACTURI.CodClient GROUp BY Nume client HAVING COUNT(Nr factura)<=5 Rezulatul aceste fraza va contine:

Explanation

The result of this SQL query will contain the value of the total invoices issued for each client whose code is less than or equal to 5.

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

Explanation

The query will retrieve the data from the table "Facturi" for the client with the name "Gama SA". Therefore, the correct answer is "facturile emise clientului Gama SA".

Submit
140. Se da urmatoarea fraza SQL: SELECT NumeClient, SUM(Vaoare Totala) As totalValTotala FROM FACTURI, ABONATI WHERE CLIENTI.CodClient=FACTURI.CodClient AND NumeClient ="Alfa SRL" GROUP BY NumeClient Rezultatul aceste fraze va fi:

Explanation

The correct answer is "Valoarea totala a facturilor emise clientului Alfa SRL". This is because the query selects the column "NumeClient" and calculates the sum of the column "Vaoare Totala" from the tables "FACTURI" and "ABONATI" where the "CodClient" in the table "CLIENTI" matches the "CodClient" in the table "FACTURI" and the "NumeClient" is equal to "Alfa SRL". The result is then grouped by the column "NumeClient", giving the total value of invoices issued to the client "Alfa SRL".

Submit
141. Ce se obtine prim urm interogare SQL? SELECT NrFactura,ValoareTotala-TVAColect As TotalTVA FROM FACTURI,CLIENTI WHERE FACTURI.CodClient=CLIENTI.CodClient

Explanation

The given SQL query will obtain the value with VAT for the issued invoices.

Submit
142. Ce se obtine prim urm interogare SQL? SELECT NrFactura,ValoareTotala-TVAColect As TotalTVA FROM FACTURI,CLIENTI WHERE FACTURI.CodClient=CLIENTI.CodClient AND Localitate="Iasi"

Explanation

The given SQL query will retrieve the value of the total TVA (Taxa pe Valoare Adaugata) for the invoices issued to clients in Iasi. The query selects the NrFactura (invoice number) and calculates the TotalTVA by subtracting the TVAColect (collected TVA) from the ValoareTotala (total value). The query also includes a join with the CLIENTI table to match the CodClient (client code) between the FACTURI and CLIENTI tables. The WHERE clause filters the results to only include clients from Iasi. Therefore, the correct answer is "TVa colectata aferenta facturilor emise clinetilor sin JUdetul IAsi" which translates to "the TVA collected for the invoices issued to clients in Iasi".

Submit
143. Ce se obtine prin urm interogare SQL> SELECT SUM(NrFactura) FROM FACTURI WHERE CodClienti IN (SELECT CodClient FROM CLIENTI WHERE NumeClient="Alfa SRL")

Explanation

The given SQL query will return the sum of the NrFactura column from the FACTURI table for the client "Alfa SRL". In other words, it will give the total number of invoices issued for the client "Alfa SRL".

Submit
View My Results

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
Cancel
  • All
    All (143)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
In acceess infrmatiile din domeniul economic sunt prezentate in cel...
In Access, extensia implicita a unei baze de date este
In Access, atributele care formeaza structura unei tabele:
In Acces, cheia primara poate fi:
In Access pentru interogarea "Lista studentilor care sau...
Formularea "orice procedura cuprinde un set de instructiuni care...
O functie procedurala VBA se refera la instructiuni cuprinse intre:
Comanda DROP TABLE este folosita pt:
Ce se obtine prin urm interogara>?...
Care din clauzele din fraza SELECT nu sunt obligatorii?
Ce se obtine prin urm interogara>?...
Intr-un formular Access, este obligatorie sectiunea
Care dintre urmatoarele afirmatii sunt adevarate?
In Access, care dintre urmatoarele enunturi sunt adevarate?
In cadrul unui formular pot sa para maxim:
Ce determnina executia comezii :DROP TABLE CLIENTI?
In Access, sunt acceptate urmatoarele tipri de date:
In Access, cheia primara este naturala atunci cind este declarata:
In Access tipul implicit de interogare este:
Cu referire la Accesss care dintre urm enunturi sunt edevarate?
In ce an a aparut standartul SQL3?
In Acces declararea restrictiilor unei tabele presupune ca aceasta sa...
In Access, optiunea Cascade Update Related Fields activata determina...
In Access, formatul pentr date calendaristice:
PEntru  utilizatorul final,obiectivul principal SQL este:
In Access, declararea restrictiilor dupa popularea tabelelor cu...
Se da urn fraza SQL:...
In Access o tabela poate fi creata folosind:
In Access, declararea restricitiilor trebuie facuta:
In Access, restrictia de integritate referentiala cere ca:
In Access, optiunea Cascade Update Related Fields activata determina...
In Access:
Un formular Access, are urmatoarele sectiuni
Limbajele de interogare pot fi:
Care dintre urm enunturi reprezinta facilitati majore ale Accsesului:
Pentru declararea cheilor straine prin comanda CREATe TABLE,se...
Ce se obtine prin urm interogara>?...
In proiectele Access se pot organiza urmatoarele tipuri de obiecte:
CE se va obtine prin urma interogare?...
In Access, la crearea tabelelor, pentru fiecare atribut trebuie...
Prin ce clauza din comanda CREATE TABLE din SQL se introduc regulile...
In Access, raportul:
SQL se bazeaza pe
ACCESS este:
Limbajul SQL a fost standartizat in :
Care dintre urmatoarele comenzii SQL sunt destinate manipularii...
In Access, care dintre urmatoarele afirmatii sunt adevarate?
Se da urm interogare SQL:...
Ce se obtine prin urm interogare SQL?...
Ce se obtine prin urm interogare SQL?...
Ce determina executia comenzii: UPDATE facturi SET TVAColectata =...
Programele VBA sunt numite proceduri si sunt grupate in:
Se da urm interogare SQL: ...
In expresiile Access, cared intre urmatoarele contructii sunt corecte?
In Access, care dintre urmatoarele enunturi sunt adevarate?
Comanda UPDATE poate fi utilizata pentru:
In Access:
In Access, tipul de date Memo se foloseste cind datele ce urmeaza a fi...
Care dintre urmatoarele comenzii SQL sunt destinate manipularii...
Care dintre urmatoarele comenzii SQL sunt destinate manipularii...
In Access, bazele de date organizeaza:
In Access, sunt acceptate urmatoarele tipuri de date:
Prin interogarile Access pot fi obtinute informatii:
In interogarile Access:
In proiectele Access se pot organiza urmatoarele tipuri de obiecte:
In Access, AutoNumber:
Ce descrie urm clasuza a comenzii CREATE TABLE din SQL:CONSTRANT...
La vizualizarea continutului tabelelor Access:
In procedurile Access, care dintre urmatoarele enunturi sunt...
Care din urmatoarele enunturi sunt adevarate? 
Se da urm fraza SQL...
In Access, care dintre urmatoarele enunturi  sunt adevarate?
Ce se obtine prin urm interogare SQL?...
Care dintre urm fraze SQL sunt corecte?
In Access sunt acceptate urmatoarele tipuri de date:
SQL este un limaj de consultare a bazei de date care permite:
In Access, care dintre urmatoarele enunturi sunt adevarate?
Marcati comenzile SQL oentru definirea bazei de date:
In proiectele Access se pot organiza urmatoarele tipuri de obiecte:
Care dinter urm comenzi SQL asigura declararea structurii bazei de...
In Access, tabelele sunt organizate in:
Marcati caracteristile SQL din lista de mai jos:
Ce se obtine prim urm interogare SQL?...
In Acces, cheia primara poate fi:
In Access, modificarea structurii unei tabele inseamna:
Cu referire la SQL car e enunturi sunt edevarate>
Se da urm fraza SQL:...
Se da urmatoarea fraza SQL:...
Analizati linia de comanda SQL si marcati variantele corecte de...
Comanda DELETE poate fi utilizata pentru 
SQL este:
Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?
Cu referire la SQl care dintre urm enunturi sunt adevarate?
Care dintre urmatoare comanda SQL sunt folosite pentru actualizarea...
In access, care dintre urmatoarele enunturi sunt adevarate?
In Access, restrictiile de integritate referentiala:
SQL ofera mijloacele necesare formularii unei consultari 
Comanda Alter Table poate fi utilizata pentru:
Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?
In Access, care dintre urmatoarele enunturi sunt adevarate:
In procedurile Access, se folosesc:
Interogarile SQL din acces:
Access creeaza indecsi pentru:
In Access pentru inetrogari se pot folosi:
Se da urm interogare SQL: ...
Cu referire la interogarile Access, acre dintre urmatoarele enunturi...
In Access, restrictia de integritate referentiala are urmatoarele...
In Access, care dintre urmatoarele enunturi nu sunt adevarate?
Intro fraza SQL care dintre enunturi sunt adevarata?
Se da urm fraza SQL: ...
Limbajul SQL permite:
In Access, modificare structurii unei tabele inseamna:
Fraza SQL SELECT poate fi utilizata pentru:
Interogarile din MIcrosoft access pot fi folosite:
SQL este cel mai important limbaj in domeniul bazei de date deoarece:
Care dintre urm enunturi NU sunt adevarate?
Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?
SQl prezinta comenzi specifice pentru:
Limbajul SQL permite:
Care dintre urmatoarele enunturi reprezinta atuuri ale limbajului SQL?
In Accesss care dintre urm afirmatii sunt adevarate?
SQL este un limaj universal care permite:
In Access, formularul este un instrument ce permite:
Care dintre urm enunturi reprezinta facilitati majore ale Accessului?
Cu referire la SQL care dintre urm enunturi sunt adevarate?
SQL dispune de optiuni pentru :
Din punctul de vedere al utilizatorului final,obiectivul principal al...
In rapoartele Access:
Comanda Alter Table poate fi utilizata pentru:
In Access care dinntre urm enunturi sunt adevarate>
Ce determina executia linie de comanda:ALTER TABLE CLIENTI ADD...
IN SQL functiile de agregare:
Adaugarea de noi inregistrari intr-o tabela Access presupune...
In Access interogarile pot fi d etip :
Comanda UPDATE poate fi utilizata pentru:
Comanda UPDATE poate fi utilizata pentru:
Se da urm interogare SQL: ...
Se da urm fraza SQL:...
Ce se obtine prin urm interogara>?...
Se da urmatoarea fraza SQL:...
Ce se obtine prim urm interogare SQL?...
Ce se obtine prim urm interogare SQL?...
Ce se obtine prin urm interogare SQL> ...
Alert!

Advertisement