Exam (elaborations)
DBMS FINAL P2 | Questions and Answers
- Course
- Institution
DBMS FINAL P2 | Questions and Answers
[Show more]
Seller
Follow
smartchoices
Reviews received
Content preview
DBMS FINAL P2 | Questions and Answers1. It is more expensive to make changes in design phase than in implementa- tion phase: False
2. You can design the database in MYSQL and create ERDs: True
3. The conceptual model has more details than the physical model: false
4. The relationship between company and full time employee is...: one to many
5. The relationship between student and identification card is...: one to one
6. A method for searching and extracting a selection of data: query
7. A unique identifier for a record that cannot contain duplicates and is used to reference a
record: primary key
8. What type of software maintains relational databases?: A relational database management
system
9. Data that is structured for optimal storage and use within a program: nor- malized data
10.Established to maintain that records are not orphaned by ensuring the proper table has
the key field: referential integrity
11.A field or fields that are primary in another table: foreign key
12.What are the three types of entity relationship models?: Conceptual data model, logical data
model, and physical data model
13.The pictorial representation of a database model: entity relationship diagram
14.A structure database in which information is stored in tables where columns represent
1/
9
, DBMS FINAL P2 | Questions and Answers
typed data fields and rows represent records.: relational database
15.Which of the following is not an exampled of a database program?: Excel
16.Display all of the tables from within a database: SHOW TABLES
17.Choose one of the databases to start using: USE DATABASE
18.Display a list of all of the databases after logging in: SHOW DATABASES
19.A clause that indicates you want to filter the result set to include only rows where the
following condition is true: WHERE
20.Clause that lets you specify the maximum number of rows the result set will have: LIMIT
21.Special operator used with the WHERE clause to search for a specific pattern in a
column: LIKE
22.Clause that indicates you want to sort the result set by a particular column either
alphabetically or numerically: ORDER BY
23.Operator that filters the result set to only include rows where either condi- tion is true: OR
24.a clause in SQL that is only used with aggregate functions. It is usedin collaboration with the
SELECT statement to arrange identical datain groups-
: GROUP BY
2/
9
The benefits of buying summaries with Stuvia:
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
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
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 smartchoices. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $8.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
78075 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now