Final Exam Review Questions
Dr. Fahmi Abboushi
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.
___T2.A database language must enable the user to perform complex queries designed to transform the raw data into useful information.
___F3.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 of logical restrictions on its inquiries such as OR, AND, and NOT.
___F_7.You cannot insert a row containing a null attribute value using SQL.
___F8.SQL requires the use of the ADD command to enter data into a table.
___T_9.The conditional LIKE must be used in conjunction with wildcard characters.
__ T__10.Because COUNT is designed to tally the number of non-null "values" of an attribute, it is used in conjunction with the DISTINCT clause.
__T__11.Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.
__F_12.One of the advantages of DDBMS is that the data is located near the “least demand” site.
__T_13.One of the advantages of DDBMS is growth facilitation.
__T__14.One of the advantages of DDBMS is improved communication.
__F15.One of the disadvantages of DDBMS is greater danger of a single-point failure.
__F_16.One of the advantages of DDBMS is processor dependence.
__T_17.Current DDBMSs are subject to some problems, such as the complexity of management and control.
__F_18.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.
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 ____. |a. |INSERT | |b. |SELECT | |c. |COMMIT | |d. |UPDATE |
___C_2.The SQL command that lets you save your work to disk is ____. |a. |INSERT | |b. |SELECT...