100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten
logo-home
CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022. $10.49
In winkelwagen

Tentamen (uitwerkingen)

CIST 1220 SQL Final Exam Study Guide/CIST 1220 Final Exam Review Packet Guide fall 2022.

 0 keer verkocht
  • Vak
  • Instelling

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...

[Meer zien]

Voorbeeld 4 van de 34  pagina's

  • 17 januari 2023
  • 34
  • 2022/2023
  • Tentamen (uitwerkingen)
  • Vragen en antwoorden
avatar-seller
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

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper magdamwikash23. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor $10.49. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 63950 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis

Laatst bekeken door jou


$10.49
  • (0)
In winkelwagen
Toegevoegd