Today's Topic Database Table and Queries Conceptual Solved MCqs

Q1) The maximum number of tables in a database are:

1. 0!
2. 02
3. 03
4. Many

Answer:Many

Explanation:The maximum number of "permanent" tables in a database is 67,108,863

Q2) The data in table is entered in:

1. Design view
2. Data sheet view
3. Normal view
4. Layout view

Answer: Data sheet view

Explanation:The datasheet view enables you to see any data that has been entered into the table.

Q3) What is the default field size of a text data-type in MS- Access.

1. 2
2. 5
3. 20
4. 50

Answer:50

Explanation:The default field size of a text field is 50 characters.

Q4) Create Command is used to insert:

1. Table
2. View
3. Report
4. Query

Answer:Table

Explanation:The CREATE TABLE statement is used to create a new table in a database.

Q5) How many query views are available in MS- Access?

1. 2
2. 3
3. 4
4. 5

Answer:5

Explanation: There are five types of query in Access. Different queries are: Select queries • Action queries • Parameter queries • Crosstab queries • SQL queries.

Q6) Which wildcard replaces one character only?

1. *
2. ?
3. :
4. !

Answer:?

Explanation:Wildcards take the place of one or more characters in a search term. A question mark (?) is used for single character searching.

Q7) How many types of relationship?

1. 5
2. 4
3. 3
4. 2

Answer:3

Explanation:One to one, One to many, Many To Many

Q8) Which of the following is degree of a table?

1. Total number f rows
2. Total number of columns
3. Total number of cells
4. Total number of foreign keys

Answer:Total number of columns

Explanation:Total number of columns

Q9) Which key is used to move fleld to field in table window in datasheet view?

1. Table
2. Esc
3. Enter
4. Spacebar

Answer:Enter

Explanation:Enter

Q10) Every table must have a:

1. Foreign key
2. Composite key
3. Primary key
4. Sort key

Answer: Primary key

Explanation: Primary key

Q11) To find a name that start with S, the criteria is written as:

1. S#?
2. S#
3. 9S
4. s*

Answer:s*

Explanation:s*

Q12) Which field type can be indexed? .

1. Memo
2. Number
3. Hypertink
4. DLE

Answer:Hypertink

Explanation:Hypertink

Q13)To find four character names that starts with H the criteria is specified as?

1. H%a
2. H?4
3. H272?
4. Ht

Answer:H?4

Explanation:H?4

Q14)In a relational database, a single piece of infermation is called:

1. Field
2. Record
3. Entity
4. Attribute

Answer:Attribute

Explanation:Attribute

Q15) Each separate piece of information stored in a record is called:

1. Form
2. Field
3. Table
4. Relation

Answer: Field

Explanation: Field

Q16) Which of the Following view is used to modify data in table?

1. Layout view
2. Design view
3. Datasheet view
4. Divot view

Answer:Design view

Explanation:Design view

Q17) Which view is used to add, edit or delcte record from table:

1. Record view Ms
2. Datasheet view
3. Design view
4. Edit view

Answer: Datasheet view

Explanation: Datasheet view

Q18)A virtual table that is constructed from other tables is called:

1. Tuple
2. Table
3. view
4. report

Answer:view

Explanation:view

Q19) Table views are available in Microsoft Access

1. 1
2. 2
3. 3
4. 4

Answer:4

Explanation:4

Q20)The maximum length of text type field in MS- Access is:

1. S0 characters
2. 250 characters
3. 155 characters
4. 255 characters

Answer:255 characters

Explanation:255 characters

Q21) Which dats type can be used to define a field that consist of any numbers to be used in calculations

1. Text
2. Number
3. Memo
4. Data

Answer:Number

Explanation:Number

Q22) Which data type can be used to defined a field that contains data content such as chart, picture or graphic object?

1. Hyperiink
2. Memo BE
3. Auto Number
4. OLE Object

Answer:OLE Object

Explanation:OLE Object

Q23) Which symbol indicates that you are editing a record?

1. Pencil
2. Black arrow
3. Asterisk
4. Key

Answer:Asterisk

Explanation:Asterisk

Q24) _________ is used to retrieve data from one or more tables.

1. Macro
2. Table
3. Query
4. Form

Answer:Query

Explanation:Query

Q25) To find all names start with M from student table, the criteria is:

1. Like "M?"
2. Like “"M-"
3. Like "M#"
4. Like "M *"

Answer:Like "M *"

Explanation:Like "M *"

Q) A request to get information from Database is called?

1. Report
2. Query
3. Table
4. View

Answer:Query

Explanation:Query

Q27) The graphical query is KNOWN as:

1. Desien grid
2. Query form
3. View form

Answer:Desien grid

Explanation:Desien grid

Q28) Which data type is default type in Access?

1. Text
2. Memo
3. Auto number
4. Number Text

Answer:Text

Explanation:Text