100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
Previously searched by you
Previously searched by you
logo
CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022. $10.49
Add to cart
Quickly navigate to
Preview
  2.  
  3. CIST 1220
  4.  
  5. CIST 1220

Exam (elaborations)

CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022.
 0 purchase
  • Module
  • CIST 1220
  • Institution
  • CIST 1220

CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022. Which of the following terms refers to a group of related records?a. character b. database c. file d. field c. File Which of the following is used to uniquely identify each record? a. primary key b. r...

[Show more]

Preview 4 out of 34  pages

Document information

  • January 17, 2023
  • 34
  • 2022/2023
  • Exam (elaborations)
  • Questions & answers

Subjects

  • cist 1220 sql final exam study guidecist 1220 final exam review packet guide fall 2022 which of the following terms refers to a group of related recordsa character b database c file d field c

Written for

  • CIST 1220
All documents for this subject (11)

Seller

avatar-seller
magdamwikash23

Reviews received

Content preview

CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final
Exam Review Packet Guide fall 2022.
Which of the following terms refers to a group of related records?a. character
b. database
c. file
d. field
c. File
Which of the following is used to uniquely identify each record?
a. primary key
b. row
c. partial dependency
d. account number
a. Primary Key
Which of the following is used to create and maintain the physical database?
a. Database Management System (DBMS)
b. Data mining
c. Systems Development Life Cycle (SDLC)
d. E-R Model
a.
Database Management System (DBMS)
Which of the following committees are responsible for establishing SQL
guidelines?
a. ANSI and ASCII
b. OSI and ASCII
c. IEEE and OSI
d. ANSI and ISO
d. ANSI and ISO
Which of the following is an example of an attribute?
a. a person's hair color
b. the people who live in a particular town
c. the patients in a doctor's office
d. vendors
a. a person's hair color
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?
a. composite primary key
b. foreign key
c. duplicate key
d. distinct key
b. Foreign Key
What represents a characteristic or attribute that is being collected about an
entity?
a. record
b. row

,c. field
d. both a and b
c. Field
The multi-step process used when creating a new system is referred to as
a. E-R Modeling
b. the Systems Development Life Cycle
c. data mining
d. SQL
b. the Systems Development Life Cycle
In which step of the Systems Development Life Cycle (SDLC) are the logical and
physical components defined?
a. systems implementation and review
b. systems design
c. systems analysis
d. systems recovery
b. systems design
In which step of the Systems Development Life Cycle (SDLC) is the solution to
the identified problem determined and understood?
a. systems design
b. systems analysis
c. systems investigation
d. systems implementation and review
b. Systems analysis
Data in first normal form (1NF) does not contain which of the following?
a. repeating groups
b. both a and b
c. partial dependencies
d. primary key
a. Repeating Groups
Data in second normal form (2NF) may contain which of the following?
a. both a and b
b. repeating groups
c. partial dependencies
d. transitive dependencies
d. Transitive Dependencies
What is added to a relational database to eliminate many-to-many relationships?
a. secondary entity
b. primary entity
c. bridging table
d. transitive dependency
c. Bridging Table
Two tables can be linked or joined together through a common field.
True
False
True

,Data mining refers to
a. selling data to other organizations
b. analyzing data already stored in a database
c. discovering new data to include in the database
d. all of the above
b. Analyzing data the already stored in the database
If entity A in Figure 2 represents customers and entity B represents automobiles,
which of the following statements is correct?
a. Each customer can own many cars and each car can be owned by many
customers.
b. Each customer can only own one car, but each car can be owned by many
customers.
c. Each customer can own many cars, but each car can be owned by only one
customer.
d. Each customer can only own one car and each car can only be owned by one
customer.
c. Each customer can own many cars, but each car can be owned by only one
customer.
A ____ is a storage structure designed to hold a collection of data.
a. database
b. column
c. table
d. row
a. database
A ____ is a group of interrelated files.
a. field
b. database
c. record
d. character
b. database
A DBMS includes which of the following capabilities?
a. multiuser access
b. data dictionary
c. security
d. all of the above
d. all of the above
What is used to indicate the end of an SQL statement?
a. *
b. :
c. /
d. ;
d. ;
Which of the following commands is used to issue a query?
a. SELECT
b. QUER

, c. QUESTION
d. FROM
a. SELECT
To indicate which database table contains the data to be selected by a query, the
table name should be listed in the ____ clause.
a. SELECT
b. HAVING
c. WHERE
d. FROM
c. FROM
Which of the following is a mandatory clause in a SELECT statement?
a. both a and b are mandatory
b. HAVING
c. FROM
d. WHERE
c. FROM
Which of the following symbols represents all the columns contained in a table?
a. ^
b. /
c. *
d. ;
c. *
Which of the following commands can be used to view the structure of a table?
a. DESCRIBE
b. SELECT
c. CONCATENATION
d. none of the above
a. DESCRIBE
Which of the following statements is correct?
a. Character columns are listed first in the output, followed by numeric columns.
b. The columns will be listed in the results in the same order they are listed in the
SELECT clause of the SELECT statement.
c. The columns will be listed in the results in the same order they are stored in
the database table.
d. Numeric columns are listed first in the output, followed by character columns.
b. The columns will be listed in the results in the same order they are listed in the
SELECT clause of the SELECT statement.
If a column alias contains a blank space, it must be enclosed in ____.
a. percent signs (% %)
b. double quotation marks (" ")
c. asterisks ( )
d. single quotation marks (' ')
b. Double Quotation Marks (" ")
A column alias must be contained within double quotation marks (" ") if it
contains which of the following?
a. blank spaces

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

Guaranteed quality through customer reviews

Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.

Quick and easy check-out

Quick and easy check-out

You can quickly pay through credit card for the summaries. There is no membership needed.

Focus on what matters

Focus on what matters

Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!

Frequently asked questions

What do I get when I buy this document?

You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.

Satisfaction guarantee: how does it work?

Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.

Who am I buying these notes from?

Stuvia is a marketplace, so you are not buying this document from us, but from seller magdamwikash23. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $10.49. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

63950 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy revision notes and other study material for 15 years now

Start selling

Recently viewed by you

Exam (elaborations) ·

(0)

(Top 2024/2025 EXAM REVIEW PAPER ) WGU C170 Chapter 5. Exam Review, Rated A+. VERIFIED.

Summary ·

(0)

samenvatting earth portrait of a planet en aantekeningen hoorcollege systeem aarde twee

Exam (elaborations) ·

(0)

Mendelian Genetics Exam 1 Questions And Answers Rated A+ New Update Assured Satisfaction

Exam (elaborations) ·

(0)

G•E•A•R Indoor Cycling (AFAA) Exam latest exam update 2024/2025 with correct answers

Exam (elaborations) ·

(1)

NCLEX RN EXAM 2024 (V2) | ACTUAL EXAM WITH NGN QUESTIONS AND CORRECT ANSWERS GRADED A+

Exam (elaborations) ·

(0)

TEST BABK FOR PHARM NUR 205/NUR 123/PTCB EXAM/ QUESTIONS AND ANSWERS LATEST WITH RATIONALE/

Exam (elaborations) ·

(0)

BTEC First Health and Social care- Unit 1 Exam Questions With Correct Answers 2023

Exam (elaborations) ·

(1)

Solutions Manual For Business Statistics 4th Canadian Edition by Norean R. Sharpe

Package deal ·

(0)

supervision in the Hospitality industry final exam review Questions and Answers

$10.49
  • (0)
Add to cart
Added