ODESK SKILL TEST QUESTION MS ACCES 2000

ODESK Changing How the World Works.

   Item No: 1 of 40            Time Remaining: 0:40:00

 Question:

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

                       

             

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 2 of 40               Time Remaining: 0:39:08

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 3 of 40               Time Remaining: 0:38:53

 Question:

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.

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 4 of 40               Time Remaining: 0:38:41

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 5 of 40               Time Remaining: 0:38:29

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 6 of 40               Time Remaining: 0:38:18

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 7 of 40               Time Remaining: 0:38:06

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 8 of 40               Time Remaining: 0:37:55

 Question:

What is the maximum number of fields that may be assigned to an index?

a.         8

b.         10

c.         5

d.         1

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 9 of 40               Time Remaining: 0:37:44

 Question:

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.

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 10 of 40             Time Remaining: 0:37:27

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 11 of 40             Time Remaining: 0:37:17

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 12 of 40             Time Remaining: 0:37:06

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 13 of 40             Time Remaining: 0:36:54

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 14 of 40             Time Remaining: 0:36:43

 Question:

What will be the result for the following expression:

Len("Robert King")

a.         12

b.         11

c.         10

d.         8

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 15 of 40             Time Remaining: 0:36:30

 Question:

Which items other than column names can you include in the select clause?

a.         Arithmetical expressions

b.         Column aliases

c.         Concatenated columns

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 16 of 40             Time Remaining: 0:36:16

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 17 of 40             Time Remaining: 0:36:01

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 18 of 40             Time Remaining: 0:35:45

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 19 of 40             Time Remaining: 0:35:28

 Question:

In the relational model, the columns of a table are also called:

a.         Attributes

b.         Rows

c.         Constraints

d.         Column

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 20 of 40             Time Remaining: 0:35:10

 Question:

Which of the following aggregate functions can be used in a report?

a.         Sum()

b.         Count()

c.         Both a and b

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 21 of 40             Time Remaining: 0:35:01

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 22 of 40             Time Remaining: 0:34:49

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 23 of 40             Time Remaining: 0:34:38

 Question:

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')

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 24 of 40             Time Remaining: 0:34:27

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 25 of 40             Time Remaining: 0:34:15

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 26 of 40             Time Remaining: 0:34:05

 Question:

Which event will you use to draw a border around the page in a report?

a.         Deactivate

b.         Page

c.         No Data

d.         Activate

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 27 of 40             Time Remaining: 0:33:43

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 28 of 40             Time Remaining: 0:33:33

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 29 of 40             Time Remaining: 0:33:20

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 30 of 40             Time Remaining: 0:32:59

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 31 of 40             Time Remaining: 0:32:45

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 32 of 40             Time Remaining: 0:32:34

 Question:

How many twips is 1 inch equal to?

a.         1440 twips

b.         567 twips

c.         20 twips

d.         100 twips

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 33 of 40             Time Remaining: 0:32:17

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 34 of 40             Time Remaining: 0:32:05

 Question:

Which of the following is not a section of a report?

a.         Page header

b.         Page footer

c.         Detail

d.         Summary

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 35 of 40             Time Remaining: 0:31:54

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 36 of 40             Time Remaining: 0:31:39

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 37 of 40             Time Remaining: 0:31:25

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 38 of 40             Time Remaining: 0:31:14

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 39 of 40             Time Remaining: 0:30:49

 Question:

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

                       

Report an issue with this question

                       

           

Powered by    ®

ODESK Changing How the World Works.

Item No: 40 of 40             Time Remaining: 0:30:35

 Question:

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

                       

Report an issue with this question

          This is the last question of your test.                    

                       

           

Powered by    ®

1.00