Odesk MS Acces 2000 Test Questions
Question: 1
In Access 2000, you can
control the access that a user has to data through permissions. The 'Insert
data' permission allows a user to:
a. view, modify, insert and
delete data
b.view, modify, insert but not
delete data
c.view and insert but not
modify or delete data
d.view but not modify, insert
or delete data
Question: 2
The Nz Data-Type conversion
function is new to Access 2000. What function does it perform?
a. It converts a NULL Value
to the user determined value
b. It converts only a NULL
Value to 0 and a zero length string is left unaffected
c. It converts an odd integer
to 0
d. It converts an even
integer to 1
Question: 3
While designing a table in
Access, an appropriate data type helps in which of the following ways?
a. It saves space in your
database.
b. It can improve join
operations.
c. It can improve performance
of table locks.
d. It could lead to fast data
retrieval and updates.
Question: 4
Access 2000 saves new
databases in the default database folder. From where can you specify the path
of this folder?
a. Tools? Options? General?
Default database folder
b. Options? Tools?
General-> default database folder
c. View? Options? General?
Default database folder
d. Tools? Startup? Options?
Default database folder
Question: 5
The student_grades table has
these columns:
student_id number
semester_end date
gpa number
Which of the following
statements finds the highest Grade Point Average (GPA) per semester?
a. Select max(gpa) from student_grades
where gpa is not null
b. Select (gpa) from
student_grades group by semester_end where gpa is not null
c. Select max(gpa) from
student_grades where gpa is not null group by semester_end
d. Select max(gpa) group by
semester_end where gpa is not null from student_grades
e. Select max(gpa) from student_grades group by
semester_end where gpa is not null
Question: 6
What effect does the Strcomp
function have on a text field data type?
a. It compares the length of
two strings and returns the value 1 if the difference is even and the value 0
if the difference is odd
b. It compares the number of
capital letters, small letters and spaces in two strings and returns the result
as an integer between 0 and 255
c. It compares the number of
blank spaces contained in two different strings and returns the difference as
an integer
d. It compares two strings
for equivalence and returns the integer result of the comparison
Question: 7
Which of the following
queries is correct?
a. Select * from students order
by marks where subject = 'SQL'
b. Select name from students
order by subject
c. Select * from students
having subject ='SQL'
d. Select name from students
group by name
Question: 8
What is the maximum number of
fields that may be assigned to an index?
a. 8
b. 10
c. 5
d. 1
Question: 9
What is the maximum number of
tables that can be joined in a Select query?
a. 2
b. 4
c. 10
d. Any number of tables can
be joined.
Question: 10
Choose the appropriate Query
for the Products table where data should be displayed primarily in the
ascending order in the ProductGroup column. Secondary sorting should be in the
descending order in the CurrentStock column.
a. Select * from Products order
by CurrentStock,ProductGroup
b. Select * from Products
order by CurrentStock DESC,ProductGroup
c. Select * from Products order
by ProductGroup,CurrentStock
d. Select * from Products
order by ProductGroup,CurrentStock DESC
e. None of the above
Question: 11
You have a table named
Students in which there is a column called Studentname for storing the names of
the students. What will be the correct Query to display the names of the
students in reverse alphabetical order?
a. Select Studentname from
students reverse
b. Select Studentname from
students reverse name
c. Select Studentname from
students order by name descending
d. Select Studentname from
students order by name reverse
e. Select Studentname from
students order by Studentname desc
f. Select desc Studentname
from students
g. Select reverse Studentname
from students
Question: 12
The students table has two
fields, firstname and lastname. Which of the following Select Queries will only
return the lastname from the students table?
a. Select firstname and
lastname from students
b. Select lastname from
students
c. Select firstname from
students
d. Select * from students
Question: 13
Instr() returns a number
specifying the position of the first occurrence of one string within another.
What will be the result of the following:
InStr(1,
"Northwind", "r")
a. 3
b. 2
c. 1
d. 4
Question: 14
What will be the result for
the following expression:
Len("Robert King")
a. 12
b. 11
c. 10
d. 8
Question: 15
Which items other than column
names can you include in the select clause?
a. Arithmetical expressions
b. Column aliases
c. Concatenated columns
Question: 16
Which one of the following
correctly selects rows from the table myTable that have null in column1?
a. Select * from myTable
where column1 is null
b. Select * from myTable
where column1 = null
c. Select * from myTable
where column1 EQUALS null
d. None of the above
Question: 17
You can use the
RunPermissions property in a multi-user environment with a secure workgroup to
override the existing user permissions. What effect does the 'Owners' setting
of the RunPermissions property have?
a. It allows all users their
own permissions to view or run the query
b. It allows a user to view,
modify and insert but not delete data
c. It allows all users the
owner's permissions to view or run the query
d. It allows users to view
but not modify data
Question: 18
How many databases can be
opened at one time in a single Access 2000 instance?
a. One
b. Two
c. Three
d. Ten
e. Fifty
Question: 19
In the relational model, the
columns of a table are also called:
a. Attributes
b. Rows
c. Constraints
d. Column
Question: 20
Which of the following
aggregate functions can be used in a report?
a. Sum()
b. Count()
c. Both a and b
Question: 21
Which property of the group
header, group footer, or detail section should you change if you want each
group or record in a report to start on a new page:
a. NewRowOrCol property
b. ForceNewPage property
c. SetNewPage property
d. defaultForceNewPage property
Question: 22
How do you hide duplicate
data on a report?
a. By Setting the
'HideDuplicates' property to Yes
b. By Setting the
'DuplicateRecords' property to No
c. By Setting the 'DuplicateRecords' property to
No and setting the 'GrpKeepTogether' property to 'Per Page'
d. Duplicate Data should be
handled at the time of data entry and cannot be controlled while reporting
Question: 23
Consider the following
tables:
Books
---------
BookId
BookName
AuthorId
SubjectId
PopularityRating (the
Popularity of the book on a scale of 1 to 10)
Language (such as French,
English, German etc)
What is the query to
determine which German books (if any) are more popular than all the French
books?
a. Select bookname from books
where language = 'German' and popularityrating = (Select popularityrating from
books where language='French')
b. Select bookname from books
where language = 'German' and popularityrating > (Select popularityrating
from books where language = 'French')
c. Select bookname from books
where language = 'French' and popularityrating > (Select
max(popularityrating) from books where language = 'German')
d. Select bookname from books
where language = 'German' and popularityrating > (Select
max(popularityrating) from books where language = 'French')
Question: 24
Which of the property will
you use for printing the section at the top of the next page if it can't print
the entire section on the current page.?
a. GrpKeepTogether Property
b. KeepTogether
c. FastLaserPrinting Property
d. SinglePagePrint
Question: 25
Access 2000 lets you restrict
entries to text fields so as to control the formatting of the entered data
through input masks. The 0 placeholder for input masks of the Text Field data
type allows the data entry of which of the following types of data?
a. Numbers (0-9) or sign
(+/-) required
b. Numbers (0-9) optional (a
space if nothing is entered)
c. Numbers (0-9) or space
optional (a space if nothing is entered)
d. Letter (A-Z) required
Question: 26
Which event will you use to
draw a border around the page in a report?
a. Deactivate
b. Page
c. No Data
d. Activate
Question: 27
How would you insert the Date
and Time into a report?
a. Select the Layout view. On
the Formatting tab, in the Controls group, click Date and Time.
b. Select the Design view. On
the Design tab, in the Controls group, click Date and Time.
c. Either a or b
d. None of the above
Question: 28
Which Query can you use to
delete records from the product table?
a. Delete from product where
productid=1
b. Delete * from product
where productid=1
c. Delete productid=1 from
product
d. None of above
Question: 29
In what form do file data
sources (also called DSN files) store connection information?
a. In the Windows Registry
b. In a Table located at
Windows/System Folder/dsnrecord.mdb
c. In a Table located at Windows/Access2000/dsnrecord.mdb
d. In a text file
Question: 30
How can you specify whether a
user can add or delete data in a form or not?
a. In the form's property box,
set 'Data entry' to Yes or No
b. In the form's property
box, set 'AllowDeletions' and/or 'AllowAdditions' to Yes or No
c. In the form's property
box, set 'Data entry' to Yes and 'Recordset Type' to Dynaset
d. In the form's property
box, set 'Record Locks' to No Locks or All record
Question: 31
In Access 2000, you can
control the access that a user has to data through permissions. The 'Update
data' permission allows a user to:
a. view and modify but not insert
or delete data
b. view, modify, insert and
delete data
c. view, modify, insert but
not delete data
d. view but not modify,
insert or delete data
Question: 32
How many twips is 1 inch
equal to?
a. 1440 twips
b. 567 twips
c. 20 twips
d. 100 twips
Question: 33
Under the Advanced options
for the Access system, there is an option entitled 'Open Databases Using Record
Level Locking'. Which of the following are true when this option is marked?
a. Access locks the record
that is being updated
b. Access locks the page that
is being updated
c. Access locks the table
that is being updated
d. Access locks the database
that is being updated
Question: 34
Which of the following is not
a section of a report?
a. Page header
b. Page footer
c. Detail
d. Summary
Question: 35
A database contains two
tables named Credits and Debits. Which of the following types of data integrity
will have to be applied to create a relationship between the Credits and the
Debits tables?
a. Primary Key
b. Indexes
c. Referential
d. Entity
Question: 36
What is the function of the
format painter?
a. It copies a table design
to the buffer for later use
b. It copies a control's
format to another control
c. It helps to format a
report so that it looks tidy and presentable
d. It copies a report design
to the buffer for later use
Question: 37
What is the error in the
following Query?
select name from students
where name = (select name from students order by name)
a. The order by clause in the
subquery should be preceded with a group by clause
b. The group by clause should
be applied to the outer query
c. An order by clause is not
allowed in a subquery
d. There is no error
Question: 38
Which of the following
clauses is not allowed in a sub-query?
a. group by
b. having
c. order by
d. None of the above
Question: 39
What effect does the 'Cascade
Update Related Fields' option in the Edit Relationships dialog box have?
a Data updated in the main
table will automatically be updated in the related table
b. Whenever a parent record
is deleted, all child records in the linked table are deleted
c. Whenever the record is 0
or NULL, it is not allowed to be entered into the table
d. Whenever the record is
NULL, it is not allowed to be entered into the table
Question: 40
Which of the following
statements are correct about the Report Snapshots and the Snapshot Viewer?
a. Using the Snapshot Viewer,
you can electronically distribute Access Reports using either e-mail or a Web
browser
b. A Report Snapshot
preserves the two-dimensional layout, graphics, and other embedded objects of
the report
c. The Snapshot Viewer
consists of a stand-alone executable program, a Snapshot Viewer control
(Snapview.ocx), and other related files
d. A Report Snapshot is a
file with a .snp extension
No comments:
Post a Comment