14. DROP TABLE SQL statement is used to: * (0.5 puncte) O Delete a database O Delete a table Modify the structure of a table Index a table B. Enter new 15. The forms created in a database allow users to: A. Display and edit data. data. C. Control the entire application using Macros. * (0.5 puncte) Only A and Care true. O Only A and B are true. O A, B and C are true. O Only B and C are true. 230 7. If a record from table A relates to one or more records in table B and a record from table B relates to one record in table A then the relationship type is: * (0.5 puncte) O Many-to-Many One-to-Many One-to-One 8. What does the acronym SQL stand for?* (0.5 puncte) Select Query Language. Standard Query Language. Structured Query Language. Specifying Queries relations. 9. The record source for a form or report can be: A. a table; B. a query; C. a filter; D. a module. * (0.5 puncte) O A, B, C, D Borc A or B 12. Which of the following characters/symbols cannot be used in a field name? (0.5 puncte) O.(dot character) O-(underscore symbol) O x(x character) O 909 digit) 13. Enforce Referential Integrity can be selected only when: A. The selected field from the primary table is the primary key; B. The related fields have the same data type and the same size; C. The related table have the same number of fields; D. The tables are stored in the same database. * (0.5 puncte) O A, B and Care true. O A, B and D are true. O B, C and D are true. 2301 O None of the above. 5. Which of the following types of associations is not possible in Access: (0.5 puncte) O Cross Join O Right Outer Join O Left Outer Join Inner Join 6. A module is: (0.5 puncte) O A set of instructions written in assembly language; O A set of actions stored in Macro; A collection of one or more procedures; All of the above. 3. A primary key is: (0.5 puncte) O A field that has a unique value for each record A code that allows the user to open the database O A field that allows one database to connect to another None of the above 4. The advantages of using a database are: A. Redundancy can be reduced B. Inconsistency can be avoided C. The data can be randomly saved D. The data can be shared (0.5 puncte) O A, C and D are true A, B and Care true O A, B and D are true B, C and D are true 220 1. When you work with tables, in Design View you cannot: * (0.5 puncte) O Add new records O Modify fields data type O Modify fields name O Modify the length of fields O Add new fields 2. AVG function calculates: * (0.5 puncte) The average of values store in a field O The total number of values store in a field The sum of values store in a field O The average difference between values store in a field 7. If a record from table A relates to one or more records in table B and a record from table B relates to one record in table A then the relationship type is: * (0.5 puncte) Many-to-Many One-to-Many O One-to-One 8. What does the acronym SQL stand for? * (0.5 puncte) Select Query Language Standard Query Language. Structured Query Language. Specifying Queries relations. 2301 9. The record source for a form or report can be: A. a table; B. a query; C. a filter; D. a module. (0.5 puncte) O A, B, C, D O Borc A or B 18. A query that asks the user for values first is called: (0.5 puncte) A select query An action query O A crosstab query A parameter query An append query 19. Which type of field is incremented automatically? (0.5 puncte) AutoNumber Primary key O AutoIncrement AutoValue 19. Which type of field is incremented automatically? * (0.5 puncte) * O AutoNumber Primary key AutoIncrement O AutoValue 12. Which of the following characters/symbols cannot be used in a field name? (0.5 puncte) O.(dot character) O _(underscore symbol) O x(x character) O 9( 9 digit) 13. Enforce Referential Integrity can be selected only when: A. The selected field from the primary table is the primary key; B. The related fields have the same data type and the same size; C. The related table have the same number of fields; D. The tables are stored in the same database. (0.5 puncte) O A, B and C are true. A, B and Dare true. O B, C and D are true. 23 None of the above. 6. A module is: (0.5 puncte) A set of instructions written in assembly language: O A set of actions stored in Macro; O A collection of one or more procedures; O All of the above 16. Which of the following software packages is not a Database Management System? * (0.5 puncte) FoxPro dBase Oracle Visual Basic Microsft Access Microsft SQL Server 17. A MACRO is: * (0.5 puncte) An object that contains an action or a set of actions An object that include a HTML file An object designed to be printed on envelopes An object that contains procedures defined by user