Question

Which of the following would not be considered a database program? Oracle MYSQL Sybase Access All of the choices are databases Question 2 (1 point) In Access database, forms and reports can be based on saved queries. True False Question 3 (1 point) In Access database, Form view displays all fields but only one record, while Datasheet view displays several records at a time. True False Question 4 (1 point) A field that uniquely identifies a particular record in a table is called a principal index primary key secondary master foreign master key

Answer 1

Question 1

Oracle, MySQL, Sybase, and Access, all are very commonly used database programs.

So option 5 would be correct: All of the choices are databases.

Question 2

Microsoft Access has a very unique feature of reports and forms where reports and forms can be created on the basis of the query result of a saved query.

So, the correct answer would be True

Question 3

In Access, since forms are used to input the data and that can be done on a single record at a time. So, form view displays one record at a time. Datasheet view displays several records at a time.

So, the correct answer is True

Question 4:

A record in the database is uniquely defined by a key that is called Primary Key.

The correct answer would be the primary key.

Let's look into other options:

Principle index: There is nothing like the principle index in the database. The principle index is the primary key.

Secondary master: Again, there is nothing like 'secondary master' in databases.

Foreign master key: There is nothing like a foreign master key in databases. However foreign key does exist in the database but this is the primary key of the parent table and it doesn't uniquely identify the record.

This completes the requirement. Let me know if you have any queries.

Thanks!