Отв: to store and organize data

What is data mining?

отв:

Why would you create a primary key?

отв:

What is the difference between verification and validation?

отв:

What is the difference between an entity and an attribute?

отв:? An attribute is a field in a database and entity is a table

What tool allows a user to search a database for specific information?

отв: A query

Which query would you use to present results for 'purple trousers'?

Отв: Purple AND trousers

In SQL, what does the code 'Title varchar (20)' mean?

Отв: Create a field called 'Title' with a string data type and a length of 20 characters

Which SQL statement allows a user to find records with similar attributes?

Отв: Where

Which of the following are NOT objects of an Access database? Check all that apply.

отв:. chart

51. In Access, the rows and columns of a table are referred to as __________________.

отв: Records and fields

52. Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called…

Отв: Primary key

53. Database Management Systems are featured with:

отв: The ability to store large amount of data to facilitate easy update, sort and retrieval

54. Collection of related records in a database is known as…

Отв: table

55. A part of database that stores only one type of data is…

Отв: Field

Which of the following IS personnel is responsible for the maintenance of information systems?

Отв: a programmer

57. In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______

Отв: Parent, Child

58. The complete information about an entity in a database is called…

Отв: Record

Which of the following is the correct order of keywords for SQL SELECT statements?

Отв: Select, From, Where

Is the act ferreting out previously unknown patterns and relationships from a set of data.

Отв: Data mining

61. The three activities in an information system that produce the information organizations use to control operations are…

Отв: data analysis, processing, and feedback.

Which of the following statements is true about information?

Отв: It is the ability to make predictions based on data.

63. The process of removing the deficiencies and loopholes in the data is called as....

Отв: Cleaning up of data.

64. The Synonym for data mining is …

Отв: Knowledge discovery in database

65. Concept description is the basic form of the …

Отв: Descriptive data mining

66. Data modeling technique used for data marts is …

Отв: Dimensional modeling

Which one manages both current and historic transactions?

Отв: Online Analytical Processing (OLAP)

Which of the following employees data mining techniques to analyze the intent of a user query,provided additional generalized or associated information relevant to the query?

Отв: Intelligent query answering

Which of the following process includes data cleaning, data integration, data selection, data

Transformation, data mining, pattern evolution and knowledge presentation?

Отв: KDD process

70. A client device designed so that most processing and data storage occurs on the client side describes:

Отв: Fat Client

Which of the following is NOT a likely configuration of a Client-Server System?

Отв: Single Client- Multiple Server System

Which of the following statements regarding Client-server computing are true?

Отв: The Client server environment is typically homogeneous and single-vendor. The hardware flat form and

Operating system of Client and Server are usually the same

73. In the Client-Server architecture, the component that processes the request and sends the response is…

Отв: Server

Which of the following is an example of an URL?

Отв: Www.google.com

75. The principle of serial equivalence for distributed transactions says that…

Отв: When several transactions are executed concurrently, the result should be the same as if they had been executed in sequence