SQL RDBMS BASIC

What does SQL stand for?

• Standard Query Language

• Sequential Query Language

• Structured Question Language

• Structured Query Language

What is a field?

• A collection of information

• A single item of information

• A list of information

• A group of records

A database management system (DBMS) is a:

• Software system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide controlled access to a database
• Hardware system used to create, maintain, and provide uncontrolled access to a database
• Software system used to create, maintain, and provide uncontrolled access to a database

A database application can perform which of the following activities?

• Add records
• Display / read records
• Update records
• All of the above

Data administrator are responsible for ________

• Overall management of data resources in an organization
• Physical data design
• Managing technical issues in the database environment
• Writing application program

Some advantages of the database approach include all, but:

• Minimal data redundancy
• Program-data dependency
• Improved data consistency
• Improved data sharing

A relational database consists of a collection of

• Field
• Record
• Table
• Keys

The term attribute refers to a ________ of a table

• Record
• Foreign key
• Primary key
• Field

A_______ in a table represents a relationship among a set of values

• Field
• Foreign key
• Record
• Primary key

The term _______ is used to refer a row

• Record
• Foreign key
• Primary key
• Field