Need Answes for pre- test

 

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 

Get 20% Discount on This Paper
Pages (550 words)
Approximate price: -

Try it now!

Get 20% Discount on This Paper

We'll send you the first draft for approval by at
Total price:
$0.00

How it works?

Follow these simple steps to get your paper done

Place your order

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Receive the final file

Once your paper is ready, we will email it to you.

Our Services

Ace Writing Center has stood as the world’s leading custom essay writing services providers. Once you enter all the details in the order form under the place order button, the rest is up to us.

Essays

Essay Writing Services

At Ace Writing Center, Nowadays, students normally have extremely busy schedules. You will note that some of them have to take on some evening or weekend jobs in order to get some income that can help them to sustain in college or in the university. This can deny them a chance to write all the essays given. Others usually get bombarded with a lot of work by their lecturers. This can still delay such students from working on all their essays. However, some of them usually try to work on all these essays but end up delivering their work late. This can prevent them from graduating since most lecturers are strict on deadlines. If you want to write a business essay, the wise way is to hire an outstanding essay writing service like us, so that you can get the best results. If you are keen, you will note that many companies usually overcharge their customers. Some of them are there only to make money. And in reality, they really don’t care to build a long term commitment with students. You should not choose such companies. You should take your time and choose a reliable company to work with. Ace Writing Center is the ultimate solution for you. We have been offering our writing service for more than 7 years. This is a clear indication that you will get quality essay writing service. We have a wide range of writers who can work on any business essay that you might have. We believe in doing extensive research so that we can provide quality work to all our clients. .

Admissions

Admission and Business Papers

Have you ever had to write an admission essay for college? The majority of students face the same issues when applying to a university or college and many in such situations decide they need professional help to cope with this matter. They get in a situation when the deadline keeps coming closer but lack motivation to start because they are just not sure if their writing skills are strong enough. We have a solution for you! Ace Writing Center is the best admission essay writing service with a large professional team and years of experience in providing high-quality papers to students of all levels and faculties. The mission of our team is to help students make their dreams of entering a good college come true and that’s what we offer!.

Editing

Editing and Proofreading

Sometimes all the words for your paper just flow out of your mind and into your fingers. You type quickly at your keyboard and there they are, your beautiful words right there on the screen. But you have no idea how to polish it up. You may be wishing there was a paper writing service that offered this type of writing service. Look no more! Here at Ace Writing Center, we offer you an editing and proofreading option that you can't find anywhere else..

Coursework

College Essay Writing

In case you are familiar Ace Writing Center, you know the way to distinguish a better company from a cheap one exactly. First of all, poor service website does not have a sufficient support. We think support team is an essential part of success; it has to answer all clients’ questions and be a connecting link between clients and their writers. On our web-service you will get answers about anything you need and your writer will receive all your instructions, assignments and requirements exactly and swiftly. A writing service that we run has got a flexible pricing system that will save you from senseless wastes and many bonus systems that let you sparing money for something important for you.

See all services