Data Base Management System (DBMS)/Basics of Database Management System (DBMS) Set 3 Sample Test,Sample questions

  1. Home
  2. Back

Question: 
  In access, the best types of queries to use for data analysis are:

1.Select querie

2.Parameter queries

3.Action queries

4.All of the above

Posted Date:-2022-06-28 14:11:09

Question: 
 How do you filter by selection?

1. A. Right click the field value and select filter by selection from the shortcut menu

2.Find and double click the value on which you want to base the filter

3.Find and select the value on which you want to base the filter and select tools>filter by selection from the menu

4. None of the above

Posted Date:-2022-06-28 14:05:04

Question: 
 In a relational schema, each tuple is dividedinto fields called

1.Relations

2.Domains

3.Queries

4.All of the above

Posted Date:-2022-06-28 14:03:19

Question: 
 What does the Special Effect button on the formatting toolbar do?

1.t lets you add animation to your forms and reports to make them more entertaining and amusing

2.It lets you select a transitional effect for how a form opens and closes

3. It applies a 30d effect to a selected control

4.None of the above

Posted Date:-2022-06-28 13:44:17

Question: 
 What is the corresponding text for the <#1/1/ 95# validation rule setting?

1.Neter a value less or more than 1,195

2.Value must be less than 95 characters

3.. Enter a date before 1995

4.All of above

Posted Date:-2022-06-28 13:51:56

Question: 
 Which of the following is NOT a type of Microsoft Access database object?

1.Queries

2.Workbooks

3.Forms

4.Tables

Posted Date:-2022-06-28 13:57:43

Question: 
. What are the columns in a Microsoft Access table called?

1.Rows

2.Fields

3.Cells

4.Records

Posted Date:-2022-06-28 14:09:46

Question: 
A command that lets you cange one or morefields in a record is

1.Insert

2.Modify

3.Look up

4.All of the above

Posted Date:-2022-06-28 13:38:22

Question: 
A logical schema

1. Is the entire database

2.Describes how data is actually stored on disk

3.Is a standard way of organizing information into accessible parts

4.All of the above

Posted Date:-2022-06-28 13:41:09

Question: 
A subset of characters within a data field is known as

1.Record

2.File

3.Data string

4.Byte

Posted Date:-2022-06-28 14:01:25

Question: 
A top to bottom relationship among the items in a database is established by a

1.Hierarchical schema

2.Network Schema

3.Relational schema

4.All of the above

Posted Date:-2022-06-28 13:37:31

Question: 
Customers, Orders. What’s their best relationship?

1.Many-to-many

2.One-to-many

3.One-to-many

4.All of the above

Posted Date:-2022-06-28 13:47:42

Question: 
If a piece of data is stored in two places in the database, then a

1.Storage space is wasted

2.Changing the data is one spot will cause data inconsistency

3.It can be more easily accessed

4.Both (A) and (B)

Posted Date:-2022-06-28 14:08:57

Question: 
Pivot Table report data must meet which of the following criteria?

1.It must be in tabular form, have unique column labels, and each row must represent a unique piece of data

2. Any dates should be formatted with the data format and blank rows or columns should be removed

3. It must be in tabular form, have unique column lagels, and all rows must be sorted

4.Both (A) and (B)

Posted Date:-2022-06-28 13:46:48

Question: 
The complete picture of data stored in database is known as

1.Record

2.Scheme

3.System flowchart

4.DBMS

Posted Date:-2022-06-28 14:00:04

Question: 
The executive responsible for the data processing function in an organization is

1.PM

2.DBMS

3.DP

4.DPM

Posted Date:-2022-06-28 13:56:47

Question: 
The number of logical records in a physical record is

1.group

2.blocking factor

3.sector

4.field

Posted Date:-2022-06-28 13:30:35

Question: 
What is a fast way to adjust the width of a column?

1. Right click the left side of the column heading

2.Double click the left side of the column heading

3.Double click the right side of the column heading

4.Select tools>adjust column width from the menu

Posted Date:-2022-06-28 14:06:31

Question: 
What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?

1.Object Viewer

2.Object Browser

3.Type Library Spy

4.None of the above

Posted Date:-2022-06-28 13:53:25

Question: 
What is the purpose of the page field on a pivot table report?

1. It creates a new page for each type of data

2. It allows the data within the the Pivot Table report to be filtered

3.It displays a title for the Pivot Table report

4.None of the above

Posted Date:-2022-06-28 13:42:46

Question: 
Which control does access use to link data access page components to access data?

1.Microsoft Dynamic Data Control

2.Microsoft Data Connection Control

3.Microsoft Office Data Source Control

4.None of the above

Posted Date:-2022-06-28 13:48:54

Question: 
Which of the following is a database management system?

1.Ms-Word

2.Lotus 1-2-3

3.Oracle

4.None of above

Posted Date:-2022-06-28 13:50:48

Question: 
Which of the following is not a data type ?

1.Picture/graphic

2.Data/time

3.Texst

4.Number

Posted Date:-2022-06-28 13:55:51

Posted on by R4R Team

More MCQS

  1. Data Base Management System (DBMS) Mcq set 1
  2. Data Base Management System (DBMS) Mcq set 2
  3. DBMS Multiple Choice Questions and Answers
  4. Basics of Database Management System (DBMS) Set 1
  5. Basics of Database Management System (DBMS) Set 2
  6. Basics of Database Management System (DBMS) Set 3
Search
R4R Team
R4Rin Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on R4R.in website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!