Fundamentals of Database Systems
Final Exam Review Questions
Dr. Fahmi Abboushi
Indicate whether the statement is true or false.
A database language must enable the user to create database and table structures to perform basic data management chores.
A database language must enable the user to perform complex queries designed to transform the raw data into useful information.
SQL is considered hard to learn; its command set has a vocabulary of more than 300 words.
All SQL commands must be issued on a single line.
To restore the values of a table, provided you have not used the COMMIT command, you must use the ROLLBACK command.
SQL allows the use of logical restrictions on its inquiries such as OR, AND, and NOT.
You cannot insert a row containing a null attribute value using SQL.
SQL requires the use of the ADD command to enter data into a table.
The conditional LIKE must be used in conjunction with wildcard characters.
Because COUNT is designed to tally the number of non-null "values" of an attribute, it is used in conjunction with the DISTINCT clause.
Distributed processing shares the database's logical processing among two or more physically independent sites that are connected through a network.
One of the advantages of DDBMS is that the data is located near the “least demand” site.
One of the advantages of DDBMS is growth facilitation.
One of the advantages of DDBMS is improved communication.
One of the disadvantages of DDBMS is greater danger of a single-point failure.
One of the advantages of DDBMS is processor dependence.
Current DDBMSs are subject to some problems, such as the complexity of management and control.
Distributed processing does not require a distributed database, and a distributed database does not require distributed processing.
In order to manage distributed data, copies or parts of the database processing functions must be distributed to all data storage sites.
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.
Distributed database systems do not require complex mechanisms to manage transactions and ensure the database's consistency and integrity.
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.
A remote transaction, composed of several requests, may access data at only one single site.
Greater ease in managing the data environment is one of the advantages of DDBMS.
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.
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 |
The SQL command that lets you save your work to disk is ____. |a. |INSERT | |b. |SELECT...
Please join StudyMode to read the full document