Copy and Edit

DSBA 6160

Description

Midterm study help
Kait Schroeder
Quiz by Kait Schroeder, updated more than 1 year ago
Kait Schroeder
Created by Kait Schroeder about 9 years ago
37
0
0

Resource summary

Question 1

Question
A [blank_start]simple client server[blank_end] system is a system with a Network, Database server, and clients.
Answer
  • simple client server

Question 2

Question
DBMS stands for [blank_start]database management system[blank_end].
Answer
  • database management system

Question 3

Question
Processing done by the DBMS is typically referred to as [blank_start]back end processing[blank_end] and the database server is referred to as the [blank_start]back end[blank_end].
Answer
  • back end processing
  • back end

Question 4

Question
The [blank_start]application software[blank_end] does the work that the users wants to do. This type of software can be purchased or developed.
Answer
  • application software

Question 5

Question
API stands for [blank_start]application programming interface[blank_end].
Answer
  • application programming interface

Question 6

Question
The [blank_start]data access API[blank_end] provides the interface between the application program and the DBMS.
Answer
  • data access API

Question 7

Question
SQL stands for [blank_start]structured query language[blank_end].
Answer
  • structured query language

Question 8

Question
A networked system using an application server goes from [blank_start]client[blank_end] to application server to [blank_start]database server[blank_end] and responds back.
Answer
  • client
  • database server

Question 9

Question
A simple web based system goes from client [blank_start]web browser[blank_end] to web server to [blank_start]database[blank_end] server and responds back.
Answer
  • web browser
  • database

Question 10

Question
Schema is another word for [blank_start]database[blank_end].
Answer
  • database

Question 11

Question
Which error message will be produced from not selecting a database before executing a SQL statement?
Answer
  • Error code: 1146. Table 'ex.vendors' doesn't exist
  • Error code: 1046. No database selected

Question 12

Question
Which error code will generate if you haven't selected the correct database before executing a SQL statement?
Answer
  • Error code: 1146. Table 'ex.vendors' doesn't exist
  • Error code: 1046. No database selected

Question 13

Question
EER model stands for [blank_start]enhanced entity relationship[blank_end] model.
Answer
  • enhanced entity relationship

Question 14

Question
ER model stands for [blank_start]entity relationship[blank_end] model.
Answer
  • entity relationship

Question 15

Question
T or F, an EER diagram can be created before an EER or ER model has been created.
Answer
  • True
  • False

Question 16

Question
An [blank_start]EER[blank_end] model is a representation of the entities, or objects, of the database including the tables, views, and stored programs.
Answer
  • EER

Question 17

Question
The processing that’s done by the DBMS is typically referred to as
Answer
  • Front-end processing
  • Back-end processing
  • The file server
  • The user interface

Question 18

Question
Which column can NOT be primary key?
Image:
b3cc4cd3-9173-4528-a651-e57f0ae6a242 (image/png)
Answer
  • Item_id
  • (order_id , product_id)
  • order_id
  • All above

Question 19

Question
Foreign Key should be unique
Answer
  • True
  • False

Question 20

Question
The most common type of relationship between two tables is a/an .
Answer
  • one-to-one
  • one-to-many
  • many-to-many
  • all above

Question 21

Question
Which of the following types of SQL statements is NOT a DML statement?
Answer
  • INSERT
  • UPDATE
  • SELECT
  • CREATE TABLE

Question 22

Question
Which join type does this graph illustrate?
Image:
21e15739-04bd-4ed2-ad6f-f9cf97d96338 (image/png)
Answer
  • Left Join
  • Left Inner Join
  • Right Join
  • Right Inner Join

Question 23

Question
A person’s name needs to be saved as first name, last name, middle name separately in database.
Answer
  • True
  • False

Question 24

Question
Which of the following diagrams best represents the relationship between a table of customers and a table of orders placed by customers?
Answer

Question 25

Question
Which
Image:
e112468c-23c7-4891-8f6b-20fd756a4cec (image/png)
Answer

Question 26

Question
Foreign key is used to maintain _____.
Answer
  • Referential integrity
  • Uniqueness of record
  • Null values in the field
  • None of the above

Question 27

Question
A [blank_start]subquery[blank_end] is a SELECT statement that's coded within another SQL statement,
Answer
  • subquery

Question 28

Question
Subqueries can be [blank_start]nested[blank_end] within other subqueries.
Answer
  • nested

Question 29

Question
[blank_start]Null[blank_end] value indicates that the value of the column is unknown.
Answer
  • Null

Question 30

Question
A [blank_start]default[blank_end] value is a value that is used if another value isn't provided when a row is added to the table.
Answer
  • default

Question 31

Question
A [blank_start]foreign key[blank_end] constraint may prevent you from deleting a row. In that case, you can only delete the row if you delete all child rows for that row first.
Answer
  • foreign key

Question 32

Question
In creating referential integrity, it makes sure that any changes to the data in the database don't create invalid relationships between tables.
Answer
  • True
  • False

Question 33

Question
A [blank_start]CASCADE[blank_end] clause using ON DELETE would cause a deleted row from the Vendors table to delete all related rows in the Invoices table.
Answer
  • CASCADE

Question 34

Question
If you code an aggregate function in the SELECT clause, that clause can't include non aggregate columns from the base table unless those columns are named on a [blank_start]GROUP BY[blank_end] clause.
Answer
  • GROUP BY

Question 35

Question
Which of the following cannot be used in an aggregate function?
Answer
  • MAX
  • MIN
  • AVG
  • COUNT
  • SUM
  • NONE OF THE ABOVE

Question 36

Question
By using a relational database type you CANNOT reduce data redundancy.
Answer
  • True
  • False

Question 37

Question
A row contains a set of values for a single INSTANCE of the entity, such as one invoice or one vendor.
Answer
  • True
  • False

Question 38

Question
A column does NOT represent an attribute of the entity.
Answer
  • True
  • False

Question 39

Question
In designing a data structure, each table represents on object, or [blank_start]entity[blank_end], in the real world system.
Answer
  • entity

Question 40

Question
What is not an option for the CHECK TABLE statement?
Answer
  • extended
  • slow
  • fast
  • medium
  • quick
  • changed
  • for upgrade

Question 41

Question
Like a join, a [blank_start]union[blank_end] combines data from tow or more tables. Instead of combining columns from base tables, however, a union combines rows from tow or more result sets.
Answer
  • union

Question 42

Question
An intersection of a row is sometimes called a cell.
Answer
  • True
  • False

Question 43

Question
SQLEXCEPTION condition can be used to produce a SHOW ERRORS statement to display to handle the error that occurs when a row cannot be inserted.
Answer
  • True
  • False

Question 44

Question
To group data and use aggregate functions to summarize the data in each group you use two new clauses of the SELECT STATEMENT: [blank_start]GROUP[blank_end] BY and [blank_start]HAVING[blank_end].
Answer
  • GROUP
  • HAVING

Question 45

Question
Which are logical operators?
Answer
  • And
  • HAVING
  • OR
  • NOT

Question 46

Question
A TRIGGER executes when which statements are run against a specific table.
Answer
  • INSERT
  • SELECT
  • DELETE
  • UPDATE
Show full summary Hide full summary

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

THEMES IN KING LEAR
Sarah-Elizabeth
Cell Structure
daniel.praecox
Cognitive Psychology - Loftus and Palmer (1974)
Robyn Chamberlain
Data Structures & Algorithms
Reuben Caruana
Economics
Emily Fenton
Random German A-level Vocab
Libby Shaw
AQA Biology B1 Questions
Bella Statham
An Inspector Calls: Sheila Birling
Rattan Bhorjee
Sociology: Crime and Deviance Flash cards
Beth Morley
CHARACTERS IN OF MICE AND MEN
jessicasusanevans
Study Tips to Improve your Learning
miminoma
Browse Library