Question

plz help me in these questions and follow me and plz give me right answer ​

Answer 1

Answer:

A) The OLE Object data type allows you to store complex data, such as pictures, graphs, or sounds, which can be edited or displayed through a dynamic link to another Windowsbased application. ... The Hyperlink data type lets you store a simple or complex "link" to an external file or document.

B) A select query is the most common type of query. ... A parameter query is a query that when run displays its own dialog box prompting you for information, such as criteria for retrieving records or a value you want to insert in a field.

C) A relational database is one that contains multiple tables of data that relate to each other through special key fields. ... Relational databases are far more flexible (though harder to design and maintain) than what are known as flat file databases, which contain a single table of data.

Explanation:

Hope it helps you ☺️

Please mark it as brainliest and follow me ...

Answer 2

Here is your answer :-

Differentiate between the following :-

(a) OLE database and hyperlink database :-

••OLE DATATYPE :-

1. object linking and embedding,denoting a set of techniques for transferring an object from one application to another.

2. it is an API designed by Microsoft which allows accessing data from a variety of sources

in an uniform manner.

3. For example :- when you add an image in powerpoint.

•• HYPERLINK DATATYPE :-

1. Hyperlink is a type of text which when we clicked it opens a new document or file or a web page. it's Access provide the option to add hyperlink to a database.

2. In this we link a document in another document with the help of URL.

3. For example :- <a href = "example.com/ somefile.html"> See document </ a >.

(b) select query and parameter query :-

•• Select query :-

1. The select query helps in retrieving of data from one or more tables.

2. It displays the record in a data sheet.

3. it also helps in grouping the data to calculate the sum, average etc.

•• parameter query :-

1. This query use the input as criteria that control the results.

2. It retrieves the data from the table according to the input.

3. it is like select query but it is asks for input before it runs.

(c) Flat file database and Relational database :-

•• Flat file database :-

1. In flat file database we store data in single table.

2. In flat file database we do not create any relation between the tables.

3. For example :- MS Excel

•• Relational database :-

1. In relational database wester data is in multiple tables.

2. In relational database we can link those tables to get a single piece of information.

3. For example :- Oracle

Hope it helps you!!!!

PLEASE MARK IT AS BRAINLIEST!!!!!