1. When developing a naming convention, what is the most important quality to keep in mind?
A. Logic
B. Consistency
C. Tradition
D. Filename length
2. What Microsoft program is frequently used to develop pictorial representations of a database’s logical relationships?
A. Excel
B. Word
C. Access
D.Visio
3. _refers to a set of tools for analyzing trends and patterns in business data.
A. MIS
B. Transaction
C. Business intelligence
D. Database management
4. What are the two main advantages to a well-designed relational database over other types?
A. Speed and data protection
B. Flexibility and data protection
C. Data integrity and speed
D. Data integrity and flexibility
5. What relationship does a data warehouse have to an organization’s data?
A. A data warehouse holds only the live version of the data.
B. A data warehouse holds all of the data.
C. A data warehouse holds only customer-related data.
D. A data warehouse holds only backup copies of the data.
6. When using a surrogate key, what form does the key most usually take?
A. Database owner name with incrementing numbers
B. Auto-incremented numbers
C. Random string of letters
D. Random characters beginning with
7. Which type of documentation should go inside your data dictionary?
A. List of software applications used
B. List of columns and data types
C. List of personnel working on the project
D. List of budget committee members
8. Which commercial RDBMS product was the first to hit the market and is the biggest?
A. Access
B. SQL Server
C. Oracle
D. MySQL
9. After an informative session, you find yourself with several pages of notes. For maximum retention and unde notes within _ hours.
A. 8
B. 48
C.24
D.12
10. When gathering the information needed to create a database, the attributes organization needs for its activities are _ requirements.
A. data
B. general
C. access and security
D. report
11. In a relational database, entities are defined by
A. rows.
B. columns.
C. values.
D. attributes.
12. You’re mapping out the logical relations of a database, and you notice that one of your tables will have a pair of child records for every record created in the parent entity. What type of relationship do these tables have?
A. One to many
B. One-to-one
C. Many-to-many
D. Pair of one-to-many relationships
13. If a user can make modifications to database objects, what permission has that user been assigned?
A. Select
B. Create
C. Update
D. Alter
14. The basic idea for relational databases was developed by Edgar Codd, who was a researcher for what company?
A.AT&T
B. IBM
C. Bell Labs
D. Siemens
15. During the information-gathering process, you want the system already in place. Which method would be best to us
A. Interviews
B. Review of business documents
C. Work shadowing
D. Questionnaires
16. Keys based on attributes that arise organically from the entity itself are referred to as what type of key?
A. Surrogate
B. Primary
C. Natural
D. Composite
17. Your project specifications call for a business rule that the database design can’t enforce. What tool should you use to enforce this busi
A. Exception
B. Weak entityty
C. Lookup entity
D. Trigger
18. Which type of entity describes a fundamental business aspect of a database?
A. Lookup
B. Domain
C. Weak
D. Linking
19. What visual practice provides more information about logical relations when creating an ERD?
A. Arrow notation
B. Referential actions
C. Crow’s feet notation
D. Color-coded boxes
20. Which type of relationship is logically supported but can’t be represented by Visio or any database modeling process
A. One-to-one
B. Many-to-many
C. Pair of one-to-many relationships
D. One-to-many
1. Which of the following functions is a scalar function?
A. COUNT
B. MAX
C.SUM
D. MONTH
2. What term is used to describe any action a database takes?
A. Function
B. Attribute
C. Transaction
D. Dependency a
3. Why should you perform the denormalization process on a database?
A. Increase data protection
B. Correct incorrect linkages
C. Correct attribute names
D. Improve performance
4. In testing, you find that one of the tables in your database has multiple versions of one of the columns, and updating the information requires the user to go to several different places to make sure the update completes. What process should you use to fix this kind of issue?
A. Denormalization
B. Normalization
C. Compiling
D. Insertion
5. Which operator signifies both the modulus operation and the wildcard in a WHERE clause?
A. %
0 B./
0 C.*
0 D.+
6. You’re looking for a DBMS to purchase and install for use with the database you’re designing. Because of future expansions, yi away from systems that have file size limits. Which of the following DBMSs should you likely avoid?
A. Access
B. Oracle Express
C.MySQL
D. PostGres
7. Which SQL functional area language contains all the commands for selecting and manipulating database data?
A. HTML
B.XML
C.DML
D.DDL
8. Which language is used to manipulate data and data objects in a relational database?
A. SQL
B.C++
C. XML
D.XQuery
9. You’re looking over the tables in the database you’re creating, and you another table. What type of Join are you seeing?
A. Cross join
B. Equi join
C.Outer join
D. Inner join
10. When users enter data into the database, they find they have to enter a value for every column, as the database won’t, otherwise. What type of value has been disallowed for this database?
A.O
B. Duplicate
C. Tab key
D. Null
11. What type of clause must you always use with DELETE or UPDATE to avoid Inadvertently changing data elsewhere in the data!
A. WHERE
B.ORDER
C.SET
D. FROM
12. Which keyword yields the same results as using the >= and <= operators?
A. IS
B. BETWEEN
C. LIKE
D. WHERE
13. _ are rules about how to do things.
A. Logs
B. Policies
C. Procedures
D. Reports
14. When a database system requests a login
A. Mapping
B. Authorization
C. Authentication
D. Permission
15. If you remove all the repeating groups or arrays from a database, which form is the database now in? 0
A. Fourth normal
B. Second normal
C. First normal
D. Third normal
16. Of the seven types of normal forms, how many are considered the most critical for creating a working database?
A. 3
B.5
C.2
D.4
17. A role is a collection of permissions, while a schema is a collection of
A. procedures
B. objects
C. attributes
D. reports
18. Which keyword should you use to Ffrovide a substitute name for a column?
A. AS
B.UPDATE
C. ORDER
D. SELECT
19. When checking the database, you confirm that the "Enforce Foreign Key Constraint" property is set to "Yes," as expected. What property this constraint create for the database?
A. Referential integrity
B. Data redundancy
C. Third normal form
D. Functional dependency
20. If you wanted to assign a user the permission to create set
A. db_backupoperator
B. db_securityadmin
C. db datawriter
D.db accessadmin
1. When developing a naming convention, what is the most important quality to keep in mind?
A. Logic
B. Consistency
C. Tradition
D. Filename length
2. What Microsoft program is frequently used to develop pictorial representations of a
database's logical relationships?
A. Excel
B. Word
C. Access
D.Visio
3. _refers to a set of tools for analyzing trends and patterns in business data.
A. MIS
B. Transaction
C. Business intelligence
D. Database management
4. What are the two main advantages to a well-designed relational database over other types?
A. Speed and data protection
B. Flexibility and data protection
C. Data integrity and speed
D. Data integrity and flexibility
5. What relationship does a data warehouse have to an organization's data?
A. A data warehouse holds only the live version of the data.
B. A data warehouse holds all of the data.
C. A data warehouse holds only customer-related data.
D. A data warehouse holds only backup copies of the data.
6. When using a surrogate key, what form does the key most usually take?
A. Database owner name with incrementing numbers
B. Auto-incremented numbers
C. Random string of letters
D. Random characters beginning with
7. Which type of documentation should go inside your data dictionary?
A. List of software applications used
B. List of columns and data types
C. List of personnel working on the project
D. List of budget committee members
8. Which commercial RDBMS product was the first to hit the market and is the biggest?
A. Access
B. SQL Server
C. Oracle
D. MySQL
9. After an informative session, you find yourself with several pages of notes. For maximum
retention and unde notes within _ hours.
A. 8
B. 48
C.24
D.12
10. When gathering the information needed to create a database, the attributes organization
needs for its activities are _ requirements.
A. data
B. general
C. access and security
D. report
11. In a relational database, entities are defined by
A. rows.
B. columns.
C. values.
D. attributes.
12. You're mapping out the logical relations of a database, and you notice that one of your
tables will have a pair of child records for every record created in the parent entity. What type of
relationship do these tables have?
A. One to many
B. One-to-one
C. Many-to-many
D. Pair of one-to-many relationships
13. If a user can make modifications to database objects, what permission has that user been
assigned?
A. Select
B. Create
C. Update
D. Alter
14. The basic idea for relational databases was developed by Edgar Codd, who was a
researcher for what company?
A.AT&T
B. IBM
C. Bell Labs
D. Siemens
15. During the information-gathering process, you want the system already in place. Which
method would be best to us
A. Interviews
B. Review of business documents
C. Work shadowing
D. Questionnaires
16. Keys based on attributes that arise organically from the entity itself are referred to as what
type of key?
A. Surrogate
B. Primary
C. Natural
D. Composite
17. Your project specifications call for a business rule that the database design can't enforce.
What tool should you use to enforce this busi
A. Exception
B. Weak entityty
C. Lookup entity
D. Trigger
18. Which type of entity describes a fundamental business aspect of a database?
A. Lookup
B. Domain
C. Weak
D. Linking
19. What visual practice provides more information about logical relations when creating an
ERD?
A. Arrow notation
B. Referential actions
C. Crow's feet notation
D. Color-coded boxes
20. Which type of relationship is logically supported but can't be represented by Visio or any
database modeling process
A. One-to-one
B. Many-to-many
C. Pair of one-to-many relationships
D. One-to-many
1. Which of the following functions is a scalar function?
A. COUNT
B. MAX
C.SUM
D. MONTH
2. What term is used to describe any action a database takes?
A. Function
B. Attribute
C. Transaction
D. Dependency a
3. Why should you perform the denormalization process on a database?
A. Increase data protection
B. Correct incorrect linkages
C. Correct attribute names
D. Improve performance
4. In testing, you find that one of the tables in your database has multiple versions of one of the
columns, and updating the information requires the user to go to several different places to
make sure the update completes. What process should you use to fix this kind of issue?
A. Denormalization
B. Normalization
C. Compiling
D. Insertion
5. Which operator signifies both the modulus operation and the wildcard in a WHERE clause?
A. %
0 B./
0 C.*
0 D.+
6. You're looking for a DBMS to purchase and install for use with the database you're designing.
Because of future expansions, yi away from systems that have file size limits. Which of the
following DBMSs should you likely avoid?
A. Access
B. Oracle Express
C.MySQL
D. PostGres
7. Which SQL functional area language contains all the commands for selecting and
manipulating database data?
A. HTML
B.XML
C.DML
D.DDL
8. Which language is used to manipulate data and data objects in a relational database?
A. SQL
B.C++
C. XML
D.XQuery
9. You're looking over the tables in the database you're creating, and you another table. What
type of Join are you seeing?
A. Cross join
B. Equi join
C.Outer join
D. Inner join
10. When users enter data into the database, they find they have to enter a value for every
column, as the database won't, otherwise. What type of value has been disallowed for this
database?
A.O
B. Duplicate
C. Tab key
D. Null
11. What type of clause must you always use with DELETE or UPDATE to avoid Inadvertently
changing data elsewhere in the data!
A. WHERE
B.ORDER
C.SET
D. FROM
12. Which keyword yields the same results as using the >= and <= operators?
A. IS
B. BETWEEN
C. LIKE
D. WHERE
13. _ are rules about how to do things.
A. Logs
B. Policies
C. Procedures
D. Reports
14. When a database system requests a login
A. Mapping
B. Authorization
C. Authentication
D. Permission
15. If you remove all the repeating groups or arrays from a database, which form is the
database now in? 0
A. Fourth normal
B. Second normal
C. First normal
D. Third normal
16. Of the seven types of normal forms, how many are considered the most critical for creating a
working database?
A. 3
B.5
C.2
D.4
17. A role is a collection of permissions, while a schema is a collection of
A. procedures
B. objects
C. attributes
D. reports
18. Which keyword should you use to Ffrovide a substitute name for a column?
A. AS
B.UPDATE
C. ORDER
D. SELECT
19. When checking the database, you confirm that the "Enforce Foreign Key Constraint"
property is set to "Yes," as expected. What property this constraint create for the database?
A. Referential integrity
B. Data redundancy
C. Third normal form
D. Functional dependency
20. If you wanted to assign a user the permission to create set
A. db_backupoperator
B. db_securityadmin
C. db datawriter
D.db accessadmin
Why Choose Us
- 100% non-plagiarized Papers
- 24/7 /365 Service Available
- Affordable Prices
- Any Paper, Urgency, and Subject
- Will complete your papers in 6 hours
- On-time Delivery
- Money-back and Privacy guarantees
- Unlimited Amendments upon request
- Satisfaction guarantee
How it Works
- Click on the “Place Order” tab at the top menu or “Order Now” icon at the bottom and a new page will appear with an order form to be filled.
- Fill in your paper’s requirements in the "PAPER DETAILS" section.
- Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
- Click “CREATE ACCOUNT & SIGN IN” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
- From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.