All categories

2 years ago

What is an index? What are the advantages and disadvantages of using indexes? How do you use SQL to create an index?

Computers and Technology

1 answer:

damaskus [11]2 years ago

4 0

Answer:

In DBMS, an index is a physical structure that stores the values for a specific column in a table. An index can be used to extract specific information from data and access records within a table more quickly without having to scan the whole table.

An Index can be made up of one or more columns of a table and each index maintains a list of values within that field that are sorted in ascending or descending order. Indexes cannot be seen by the users, but they are just used to speed up the queries and improve the performance of a database application

You might be interested in

Select the correct answer.

storchak [24]

Answer:

B. Planning

Explanation:

I believe the developer establishes the project goals in the planning phase.

6 0

4 years ago

What is a sign that content is

Sidana [21]

D. All of the above

7 0

4 years ago

Read 2 more answers

In the RGB model, which color is formed by combining the constituent colors?

iogann1982 [59]

If you combine maximum values of Red Green and Blue you will get white.

4 0

3 years ago

Read 2 more answers

Select the correct text in the passage.

Serjik [45]

Answer:

The answer to this question is given below in the explanation section.

Explanation:

As you know that noise distracts the process of communication. It is anything that distorts a message between two communicators. Noise can take many forms, such as playing the radio in the background, another person interfering with the conversation, and any other distraction that prevent the receiver from paying attention to what the sender is saying.

So, in this question, the noise phrase in the given passage is written in bold.

<em>Ben wanted to call his friend Kevin for a game of football. He rang up Kevin and was about to mention the game.</em> Just then, a car nearby honked loudly. <em>Kevin said that he couldn’t hear what Ben said. Ben then repeated what he had said earlier.</em>

A car honked nearly when Ben and Kevin are communicating with each other is considered noise. A car honked is a noise in the process of communication.

4 0

3 years ago

A/an ____ file saves a workbook as a comma-delimited text file for use on another windows operating system??

aleksandrvk [35]

Answer:

The correct option is D

D) CVS

Explanation:

A CVS file saves a workbook as a comma-delimited text file for use on another windows operating system. It ensures that line breaks, tab characters and other characteristics are interpreted correctly.

A CVS file stands for Comma Separated Value file, which basically allows the data to be saved in tabular format. However they differ from other spreadsheet file types because you can only have a single sheet in a file. Moreover, you cannot save cell, column or row in it.

7 0

3 years ago