Question

multiple choices question (mcq)

(1) In which of the following types of database a single table or file stores all the data ?
(a) flat- file database
(b) Relational database
(c) Distributed database
(c) all of these

(2) DML Stands for
(a) Data manipulative language
(b) Data manipulation language
(c) Database manipulation language
(d) Data management languagse

(3) which of the following refers to uniquely identifying a record in a table?
(a) field
(b) primary key
(c) record
(d) foreign key

(4) which of the following is not a data type available in ms access 2010?
(a) Text
(b) memo
(c) number
(d) string

(5) which of the following tools are used to create a form in Ms access 2010?
(a) form
(b) form design
(c) blank form
(d) all of these ​

Answer 1

Answer:

1 (c) 2 (d)3 (c)4 (d) 5 (d)

Answer 2

Answer

1. Flat- file database

2.Data manipulation language

3.Primary key

4.String

5. Form

Explanation

Flat file database - A flat file database is a database that is stored in a file called a flat file. Records follow a consistent format and have no structure for indexing or identifying relationships between records. The file is simple. Flat files can be plain text files or binary files.

Data - manipulation language

Data Manipulation Language (DML) is a subset of the operations used to insert, delete, and update data in a database. DML is often a sub-language of larger languages such as SQL. DML contains some of the language operators.

Primary key

A primary key, also known as a primary keyword, is a key in a relational database that is unique to each record. This is a unique identifier such as: Driver's license number, phone number (including area code), or vehicle identification number (VIN). Relational databases can only have one primary key. Primary keys are usually displayed as columns in relational database tables.

String

The alphabet unit contains any series of letters that are literally translated into text. For example, "hello world" and "LKJH019283" are both examples of the character unit. In a computer program, a character unit is attached to the variable as shown in the example below.

Formtool

A form is a representation of a GUI window. The form usually contains components and controls, including an OK and Cancel buttons. These objects provide a high level of abstraction from standard or custom widgets. These widgets are usually much easier to work with than the API that underlies the GUI.

#SPJ3