All Categories
Computer Science
Explore questions in the Computer Science category that you can ask Spark.E!
- A field identified in a table as holding the unique identifier of the table's records is called theA) primary key.B) key field.C) primary field.D) unique ID.
- The most prominent data manipulation language today isA) Access.B) DB2.C) SQL.D) Crystal Reports.
- The join operationA) combines relational tables to provide the user with more information than is otherwise available.B) identifies the table from which the columns will be selected.C) creates a subset consisting of columns in a table.D) organizes elements into segments.
- 29) The logical viewA) shows how data are organized and structured on the storage media.B) presents an entry screen to the user.C) allows the creation of supplementary reports.D) presents data as they would be perceived by end users.
- 31) The type of logical database model that treats data as if they were stored in two-dimensional tables is theA) OODBMS.B) pre-digital DBMS.C) relational DBMS.D) hierarchical DBMS.
- Oracle Database Lite is a(n)A) DBMS for small handheld computing devices.B) Internet DBMS.C) mainframe relational DBMS.D) DBMS for midrange computers.
- the confusion created by _________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.A) batch processingB) data redundancyC) data independenceD) online processing
- 28) A DBMS makes theA) physical database available for different logical views.B) logical database available for different analytical views.C) physical database available for different analytical views.D) logical database available for different physical views.
- duplicate data in multiple data files is called data ________.A) redundancyB) repetitionC) independenceD) partitions
- A DBMS reduces data redundancy and inconsistency by A) enforcing referential integrity. B) uncoupling program and data.C) utilizing a data dictionary. D) minimizing isolated files with repeated data.
- A characteristic or quality describing an entity is called a(n)A) field.B) tuple.C) key field.D) attribute
- Which of the following non-digital data storage items is most similar to a database?A) library card catalogB) cash register receiptC) doctor's office invoiceD) list of sales totals on a spreadsheet
- Microsoft SQL Server is a(n)A) DBMS for small handheld computing devices.B) Internet DBMS.C) desktop relational DBMS.D) DBMS for midrange computers.
- OPLAP enables users to obtain answers to ad-hoc questions in a fairly rapid amount of time, except when the data are store in a very large database.
- 30) DBMS for midrange computers include all of the following EXCEPTA) DB2.B) Oracle.C) Microsoft SQL Server.D) Microsoft Access.
- common gateway interface is specification for processing data on a web server
- many applications today require database that can store and retrieve multimedia
- a data warehouse is typically comprised of several smaller data marts
- in a web-based database, middleware is used to transfer information from the organization's internal database back to the web server for delivery in the form of a Web page to the user.
- in relational database, complex groupings of data must be streamlined to eliminate awkward many-to-many relationships