Related Questions
What is the correct answer?
4
Following is not a database model
A. network database model
B. relational database model
C. Object Oriented database model
What is the correct answer?
4
Which field type can store photos?
C. Both of these can be used
D. Access tables cant store photos
What is the correct answer?
4
Which of the following statement is true?
A. Foreign key fields dont allow duplicate values
B. In primary key field you can enter duplicate value
C. In an indexed field you may or may not enter duplicate value depending upon setting
D. All statements are true
What is the correct answer?
4
To create a new table, in which method you dont need to specify the field type and size?
A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
What is the correct answer?
4
A database language concerned with the definition of the whole database structure and schema is ________
What is the correct answer?
4
Which of the following is NOT a type of Microsoft Access database object?
What is the correct answer?
4
What does the show check box in query design window indicate
A. It indicates whether the field is to be used or not
B. It indicates whether the field is to be displayed in query result or not
C. It indicates whether the field names to be displayed in query result or not
What is the correct answer?
4
Both conditions display on the same row in the design grid when ___operator is in use
What is the correct answer?
4
The___ operator will cause a record to be selected only if two or more conditions are satisfied
What is the correct answer?
4
Cascade update option
A. means do not change the value in the primary key field if that record has related records in another table
B. means change all the related records in child tables if the record in parent table is changed
What is the correct answer?
4
It is a sign or symbol that specifies, operator, and values that produce a result
What is the correct answer?
4
The complete information about an entity in a database is called
What is the correct answer?
4
If you write criteria values vertically (one in a row) it will mean
What is the correct answer?
4
A part of database that stores only one type of data is
What is the correct answer?
4
To duplicate a controls formatting you can use___
What is the correct answer?
4
A __________ enables you to view data from a table based on a specific criterion
What is the correct answer?
4
It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
What is the correct answer?
4
The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
What is the correct answer?
4
Which of the following is not a type of relationship that can be applied in Access database
D. All of above can be applied
What is the correct answer?
4
It is most common type of query. It retrieves records from one or more tables and then displays the
What is the correct answer?
4
The key uniquely identifies each record in a table.
What is the correct answer?
4
If you need to edit a relationship
A. Right click the relationship line and choose Edit Relationship
B. Double click the relationship line
What is the correct answer?
4
In table design view, which key can be used to switch between the field names and properties panels?
What is the correct answer?
4
When entering field name, how many characters you can type in maximum?
D. Any number of character
What is the correct answer?
4
If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:
What is the correct answer?
4
Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
What is the correct answer?
4
What do you mean by one to many relationship between Student and Class table?
A. One student can have many classes
B. One class may have many student
C. Many classes may have many students
D. Many students may have many classes
What is the correct answer?
4
The default and maximum size of text field in Access
C. 266 characters & 64000 characters
What is the correct answer?
4
To create queries in Access
A. You can drag and drop fields on query builders
B. you can type the SQL command in SQL view
C. You can use query wizard or design view
What is the correct answer?
4
In one-to-many relationship the table in one side is called _______ and on many side is called _______