Intro to Database

Topics: SQL, Database management system, Database Pages: 20 (2693 words) Published: May 5, 2013
Fundamentals of Database Systems
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.

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 ____. |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...
Continue Reading

Please join StudyMode to read the full document

You May Also Find These Documents Helpful

  • Intro to Database Systems Chapter 1 Essay
  • database Essay
  • Essay about Database
  • Essay about Database Questions
  • Database Essay
  • Database Research Paper
  • Essay on Intro to Database Systems
  • Database Essay

Become a StudyMode Member

Sign Up - It's Free