Computer Questions and Answers

Attempt Mode

Computer » Database Basics and Architecute

The DBMS acts as an interface between what two components of an enterprise-class database system?

A

Database application and the database

B

Data and the database

C

The user and the database application

D

Database application and SQL

Computer » Database Basics and Architecute

Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?

A

IDMS

B

DB2

C

dBase-II

D

R:base

Computer » Database Basics and Architecute

The following are components of a database except ________ .

A

user data

B

metadata

C

reports

D

indexes

Computer » Database Basics and Architecute

An application where only one user accesses the database at a given time is an example of a(n) ________ .

A

single-user database application

B

multiuser database application

C

e-commerce database application

D

data mining database application

Computer » Database Basics and Architecute

An on-line commercial site such as Amazon.com is an example of a(n) ________ .

A

single-user database application

B

multiuser database application

C

e-commerce database application

D

data mining database application

Computer » Database Basics and Architecute

Which of the following products was the first to implement true relational algebra in a PC DBMS?

A

IDMS

B

Oracle

C

dBase-II

D

R:base

Computer » Database Basics and Architecute

SQL stands for ________ .

A

Structured Query Language

B

Sequential Query Language

C

Structured Question Language

D

Sequential Question Language

Computer » Database Basics and Architecute

Because it contains a description of its own structure, a database is considered to be ________ .

A

described

B

metadata compatible

C

self-describing

D

an application program

Computer » Database Basics and Architecute

The following are functions of a DBMS except ________ .

A

creating and processing forms

B

creating databases

C

processing data

D

administrating databases

Computer » Database Basics and Architecute

Helping people keep track of things is the purpose of a(n) ________ .

A

database

B

table

C

instance

D

relationship

Computer » Database Basics and Architecute

Which of the following products implemented the CODASYL DBTG model?

A

IDMS

B

DB2

C

dBase-II

D

R:base

Solution

The data model proposed by the CODASYL DBTG (see CODASYL) in which data is organized into records of different types and records are organized into sets of different types, both record and set types being named. A particular set type is defined as having an owner record type and one or more member record types.

Computer » Database Basics and Architecute

An Enterprise Resource Planning application is an example of a(n) ________ .

A

single-user database application

B

multiuser database application

C

e-commerce database application

D

data mining database application

Computer » Database Basics and Architecute

A DBMS that combines a DBMS and an application generator is ________ .

A

Microsoft's SQL Server

B

Microsoft's Access

C

IBM's DB2

D

Oracle Corporation's Oracle

Computer » Database Basics and Architecute

You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .

A

user data.

B

metadata

C

A report

D

indexes

Computer » Database Basics and Architecute

Which of the following is not considered to be a basic element of an enterprise-class database system?

A

Users

B

Database applications

C

DBMS

D

COBOL programs

Computer » SQL

You can add a row using SQL in a database with which of the following?

A

ADD

B

CREATE

C

INSERT

D

MAKE

Computer » SQL

The command to remove rows from a table 'CUSTOMER' is:

A

REMOVE FROM CUSTOMER ...

B

DROP FROM CUSTOMER ...

C

DELETE FROM CUSTOMER WHERE ...

D

UPDATE FROM CUSTOMER ...

Computer » SQL

The SQL WHERE clause:

A

limits the column data that are returned.

B

limits the row data are returned.

C

Both A and B are correct.

D

Neither A nor B are correct.

Computer » SQL

Which of the following is the original purpose of SQL?

A

To specify the syntax and semantics of SQL data definition language

B

To specify the syntax and semantics of SQL manipulation language

C

To define the data structures

D

All of the above.

Computer » SQL

The wildcard in a WHERE clause is useful when?

A

An exact match is necessary in a SELECT statement.

B

An exact match is not possible in a SELECT statement.

C

An exact match is necessary in a CREATE statement.

D

An exact match is not possible in a CREATE statement.