SQL 1

अब Quizwiz के साथ अपने होमवर्क और परीक्षाओं को एस करें!

Which of the following is used to create and maintain the physical database?​

Database Management System (DBMS)

If entity A in Figure 2 represents customers and entity B represents automobiles, which of the following statements is correct?​

Each customer can own many cars, but each car can be owned by only one customer.

Which of the following is an example of an attribute?​

a person's hair color

Data mining refers to ____.​

analyzing data already stored in a database

Which of the following terms refers to a group of related records?​

file

What name is used to denote a common field that exists between two tables, but is also the primary key for one of the tables?​

foreign key

Which of the following is used to uniquely identify each record?​

primary key

Data in first normal form (1NF) does not contain which of the following?​

repeating groups

In which step of the Systems Development Life Cycle (SDLC) is the solution to the identified problem determined and understood?​

systems analysis

In which step of the Systems Development Life Cycle (SDLC) are the logical and physical components defined?

systems design

The multi-step process used when creating a new system is referred to as ____.​

the Systems Development Life Cycle

Two tables can be linked or joined together through a common field.​

true

Which statement best describes the relationship shown in Figure 1?

​For every occurrence of A, there can only be one occurrence of B.

What is added to a relational database to eliminate many-to-many relationships?​

​bridging table

A DBMS includes which of the following capabilities?​

​data dictionary, multiuser access, ​security

A ____ is a group of interrelated files.​

​database

A ____ is a storage structure designed to hold a collection of data.​

​database

What represents a characteristic or attribute that is being collected about an entity?​

​field

Data in second normal form (2NF) may contain which of the following?​

​transitive dependencies

Which of the following committees are responsible for establishing SQL guidelines?​

ANSI and ISO


संबंधित स्टडी सेट्स

Chapter 2: Trends in HRM, HRIR 3021 (UMN-Peter Ronza)

View Set

The Legislative Branch: The Senate (Article 1,Section 3)

View Set

CH.7- Structuring System Process Requirements

View Set

Week 2- The Immune System Pharmacology ATI Questions (Exam 1)

View Set

Videbeck Psychiatric Mental Health Nursing Chapter 5 Therapeutic Relationships NCLEX

View Set

Science Chapter 7.3 What are Viruses?

View Set