Final Exam Review Questions
Fundamentals of Database Systems
Final Exam Review Questions
Dr. Fahmi Abboushi
True/False
Indicate whether the statement is true or false.
___T__ 1. A database language must enable the user to create database and table structures to perform basic data management chores.
___T 2. A database language must enable the user to perform complex queries designed to transform the raw data into useful information.
___F 3. SQL is considered hard to learn; its command set has a vocabulary of more than 300 words.
___F_ 4. All SQL commands must be issued on a single line.
___T_ 5. To restore the values of a table, provided you have not used the COMMIT command, you must use the ROLLBACK command.
___T_ 6. SQL allows the use …show more content…
Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.
__T_ 19. In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
__T__ 20. A fully distributed DBMS must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.
__F__ 21. Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
__T_ 22. A remote request allows the user to access data to be processed by a single remote database processor. The SQL statement can reference data at one remote site.
__T_ 23. A remote transaction, composed of several requests, may access data at only one single site.
__F__ 24. Greater ease in managing the data environment is one of the advantages of DDBMS.
__T_ 25. The TP is the software component found in each computer that requests data.
Multiple Choice
Identify the choice that best completes the statement or answers the question.
___A_ 1. The SQL command that lets you insert data into a table, one row at a time, is …show more content…
|SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE |
| |FROM PRODUCT |
| |WHERE V_CODE = 21344 |
| |OR V_CODE > 24288 |
|d. |SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE |
| |FROM PRODUCT |
| |WHERE V_CODE = 21344 |
| |OR V_CODE = 24288 |
__A__ 10. SQL allows the use of a special operator in conjunction with the WHERE clause. The special operator used to define a range limit is ____.
|a. |BETWEEN
Final Exam Review Questions
Dr. Fahmi Abboushi
True/False
Indicate whether the statement is true or false.
___T__ 1. A database language must enable the user to create database and table structures to perform basic data management chores.
___T 2. A database language must enable the user to perform complex queries designed to transform the raw data into useful information.
___F 3. SQL is considered hard to learn; its command set has a vocabulary of more than 300 words.
___F_ 4. All SQL commands must be issued on a single line.
___T_ 5. To restore the values of a table, provided you have not used the COMMIT command, you must use the ROLLBACK command.
___T_ 6. SQL allows the use …show more content…
Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.
__T_ 19. In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
__T__ 20. A fully distributed DBMS must perform all the functions of a centralized DBMS, and it must handle all necessary functions imposed by the distribution of data and processing.
__F__ 21. Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
__T_ 22. A remote request allows the user to access data to be processed by a single remote database processor. The SQL statement can reference data at one remote site.
__T_ 23. A remote transaction, composed of several requests, may access data at only one single site.
__F__ 24. Greater ease in managing the data environment is one of the advantages of DDBMS.
__T_ 25. The TP is the software component found in each computer that requests data.
Multiple Choice
Identify the choice that best completes the statement or answers the question.
___A_ 1. The SQL command that lets you insert data into a table, one row at a time, is …show more content…
|SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE |
| |FROM PRODUCT |
| |WHERE V_CODE = 21344 |
| |OR V_CODE > 24288 |
|d. |SELECT P_DESCRIPT, P_INDATE, P_PRICE, V_CODE |
| |FROM PRODUCT |
| |WHERE V_CODE = 21344 |
| |OR V_CODE = 24288 |
__A__ 10. SQL allows the use of a special operator in conjunction with the WHERE clause. The special operator used to define a range limit is ____.
|a. |BETWEEN