Home
Current Affairs January 2024

What is the correct answer?

4

The___ operator will cause a record to be selected only if two or more conditions are satisfied

A. Or

B. If or

C. Range

D. And

Correct Answer :

D. And


Related Questions

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

A. Foreign key

B. Native key

C. Composite key

D. Primary key

What is the correct answer?

4

What is the maximum length a text field can be?

A. 120

B. 255

C. 265

D. 75

What is the correct answer?

4

If you write criteria values vertically (one in a row) it will mean

A. OR conditions

B. AND conditions

C. NOT condition

D. None of above

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

D. None of above

What is the correct answer?

4

Which of the following database object hold data?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

The task of arranging data in order is called

A. Searching

B. Sorting

C. Ordering

D. Shorting

What is the correct answer?

4

A part of database that stores only one type of data is

A. Report

B. Field

C. Query

D. Record

What is the correct answer?

4

When entering field name, how many characters you can type in maximum?

A. 60

B. 64

C. 68

D. Any number of character

What is the correct answer?

4

A search value can be an exact value or it can be

A. Logical Operator

B. Relationship

C. Wild card character

D. Comparison operation

What is the correct answer?

4

Which is not a view to display a table in Access?

A. Datasheet View

B. Design View

C. Pivot Table & Pivot Chart View

D. None of above

What is the correct answer?

4

Which of the following database object produces the final result to present?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

Which of the following store command to retrieve data from database?

A. Forms

B. Reports

C. Queries

D. Tables

What is the correct answer?

4

It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,

A. Parameter

B. Select

C. crosstab

D. Append

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

D. All of above

What is the correct answer?

4

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

A. a doctors sign

B. thin + sign

C. outline rectangle

D. None of above

What is the correct answer?

4

The database language that allows you to access or maintain data in a database

A. DCL

B. DML

C. DDL

D. None of above

What is the correct answer?

4

A __ name must be unique within a database

A. Table

B. Field

C. Record

D. Character

What is the correct answer?

4

What are the columns in a Microsoft Access table called?

A. Rows

B. Records

C. Fields

D. Columns

What is the correct answer?

4

Query design window has two parts. The upper part shows

A. Name of fields, field type and size

B. Tables with fields and relationships between tables

C. Criteria

D. Sorting check boxes

What is the correct answer?

4

Which of the following may not be a database?

A. Data presented in table in MS Word document

B. Data entered in Excel spreadsheet

C. A presentation created in PowerPoint

D. A telephone diary

What is the correct answer?

4

When a picture or other graphic image is placed in the report header section it will appear____

A. Once in the beginning of the report

B. At the top of every page

C. Every after record break

D. On the 1st and last pages of the report

What is the correct answer?

4

Which of the following is not a database object?

A. Tables

B. Queries

C. Relationships

D. Reports

What is the correct answer?

4

Which of the following expresses correct order?

A. Characters, Fields, Records, Tables, Files, Databases

B. Characters, Fields, Records, Tables, Database, Files

C. Databases, Tables, Files, Records, Field, Character

D. Files, Databases, Tables, Records, Fields, Characters

What is the correct answer?

4

A database object in MS Access that stores a question about the data in database?

A. Table

B. Form

C. Query

D. Report

What is the correct answer?

4

How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

A. Query Wizard

B. Look up Wizard

C. Form Wizard

D. Report Wizard

What is the correct answer?

4

In one-to-many relationship the table in one side is called _______ and on many side is called _______

A. Child , Parent

B. Parent , Child

C. Brother , Sister

D. Father , Son

What is the correct answer?

4

To create primary key for a table when in design view

A. Type PRIMARY in field type box when creating required field

B. Mark the Primary check box in field name of required field

C. Click the Primary Key button in Design ribbon when the cursor is in required field

D. None of the above

What is the correct answer?

4

Which of the following can be an example of a database?

A. Address book of all the suppliers of a company

B. Salary sheet of all the employees of a company

C. Records of daily sales transactions of a company

D. All of above

What is the correct answer?

4

In a database table, the category of information is called ____________

A. tuple

B. field

C. record

D. All of above

What is the correct answer?

4

A small button with three dots usually displayed at the right of field properties box

A. Make button

B. Expression button

C. Build button

D. None of above