DBMS FINAL P2 | Questions and Answers
1. 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
1. 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
