56 NOT Answered Yet Test Questions:
1. What effect does the 'Cascade Update Related Fields' option in the Edit Relationships dialog box have?
Answers:
• Data updated in the main table will automatically be updated in the related table
• Whenever a parent record is deleted, all child records in the linked table are deleted
• Whenever the record is 0 or NULL, it is not allowed to be entered into the table
• Whenever the record is NULL, it is not allowed to be entered into the table
2. The students table has two fields, firstname and lastname. Which of the following Select Queries will only return the lastname from the students table?
Answers:
• Select firstname and lastname from students
• Select lastname from students
• Select firstname from students
• Select * from students
3. Which items other than column names can you include in the select clause?
Answers:
• Arithmetical expressions
• Column aliases
• Concatenated columns
4. Which of the following is not a section of a report?
Answers:
• Page header
• Page footer
• Detail
• Summary
5. Which of the following is not a data type?
Answers:
• OLE Object
• Hyperlink
• Yes/No
• Attachment
6. Which one of the following correctly selects rows from the table myTable that have null in column1?
Answers:
• Select * from myTable where column1 is null
• Select * from myTable where column1 = null
• Select * from myTable where column1 EQUALS null
• None of the above
7. What is the correct order of the clauses in the select statement?
1.select
2.order by
3.where
4.having
5.group by
Answers:
• 1,2,3,4,5
• 1,3,5,4,2
• 1,3,5,2,4
• 1,3,2,5,4
8. Which Query can you use to delete records from the product table?
Answers:
• Delete from product where productid=1
• Delete * from product where productid=1
• Delete productid=1 from product
• None of above
9. Which event will you use to draw a border around the page in a report?
Answers:
• Deactivate
• Page
• No Data
• Activate
10. Which of the following statements about the Primary Key are correct?
Answers:
• It cannot be null
• It must be unique
• There can only be one primary key defined per table
• All of the above
11. 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?
Answers:
• Numbers (0-9) or sign (+/-) required
• Numbers (0-9) optional (a space if nothing is entered)
• Numbers (0-9) or space optional (a space if nothing is entered)
• Letter (A-Z) required
12. Which of the following clauses is not allowed in a sub-query?
Answers:
• group by
• having
• order by
• None of the above
13. What effect does the Strcomp function have on a text field data type?
Answers:
• 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
• 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
• It compares the number of blank spaces contained in two different strings and returns the difference as an integer
• It compares the two in a way specified by its third argument and returns -1,0 or 1 according to the comparison type
14. In the relational model, the columns of a table are also called:
Answers:
• Attributes
• Rows
• Constraints
• Column
15. Which event will you use to cancel the previewing or printing of the report?
Answers:
• Deactivate
• Page
• No Data
• Activate
16. How can you change the tab order of a Control in a data access page?
Answers:
• In the Properties of the Control, change the TabIndex property box, type the new tab order number
• In the Properties of the Control, change the TabOrder property box, type the new tab order number
• In the Properties of the Control, change the TabSetting property box, type the new tab order number
• In the Properties of the Control, change the TabRanking property box, type the new tab order number
17. 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?
Answers:
• Primary Key
• Indexes
• Referential
• Entity
18. 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?
Answers:
• Select bookname from books where language = 'German' and popularityrating = (Select popularityrating from books where language='French')
• Select bookname from books where language = 'German' and popularityrating > (Select popularityrating from books where language = 'French')
• Select bookname from books where language = 'French' and popularityrating > (Select max(popularityrating) from books where language = 'German')
• Select bookname from books where language = 'German' and popularityrating > (Select max(popularityrating) from books where language = 'French')
19. Where does Access 2000 store the default properties for displaying and printing the contents of tables and reports?
Answers:
• SYSTEM.MBA
• SYSTEM.MDW
• In the Windows registry
• In the Office 2000 folder of Windows
20. 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?
Answers:
• Access locks the record that is being updated
• Access locks the page that is being updated
• Access locks the table that is being updated
• Access locks the database that is being updated
21. 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?
Answers:
• Select max(gpa) from student_grades where gpa is not null
• Select (gpa) from student_grades group by semester_end where gpa is not null
• Select max(gpa) from student_grades where gpa is not null group by semester_end
• Select max(gpa) group by semester_end where gpa is not null from student_grades
• Select max(gpa) from student_grades group by semester_end where gpa is not null
22. Which query will be used to return the current date?
Answers:
• Select GetDate()
• Select Date()
• Select Date
• Select CurrentDate()
23. 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")
Answers:
• 3
• 2
• 1
• 4
24. 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:
Answers:
• NewRowOrCol property
• ForceNewPage property
• SetNewPage property
• defaultForceNewPage property
25. Which of the following aggregate functions can be used in a report?
Answers:
• Sum()
• Count()
• Both a and b
26. The Nz Data-Type conversion function is new to Access 2000. What function does it perform?
Answers:
• It converts a NULL Value to the user determined value
• It converts only a NULL Value to 0 and a zero length string is left unaffected
• It converts an odd integer to 0
• It converts an even integer to 1
27. What is the maximum number of tables that can be joined in a Select query?
Answers:
• 2
• 4
• 10
• Any number of tables can be joined.
28. Which of the following statements are correct about the Report Snapshots and the Snapshot Viewer?
Answers:
• Using the Snapshot Viewer, you can electronically distribute Access Reports using either e-mail or a Web browser
• A Report Snapshot preserves the two-dimensional layout, graphics, and other embedded objects of the report
• The Snapshot Viewer consists of a stand-alone executable program, a Snapshot Viewer control (Snapview.ocx), and other related files
• A Report Snapshot is a file with a .snp extension
29. What is the maximum number of fields that may be assigned to an index?
Answers:
• 8
• 10
• 5
• 1
30. Access 2000 saves new databases in the default database folder. From where can you specify the path of this folder?
Answers:
• Tools→ Options→ General→ Default database folder
• Options→ Tools→ General-> default database folder
• View→ Options→ General→ Default database folder
• Tools→ Startup→ Options→ Default database folder
31. State whether True or False.
In Access 2000, one can easily create a backup copy of the current Access database or of the current Access project by choosing the appropriate Access menu command.
Answers:
• True
• False
32. 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.
Answers:
• Select * from Products order by CurrentStock,ProductGroup
• Select * from Products order by CurrentStock DESC,ProductGroup
• Select * from Products order by ProductGroup,CurrentStock
• Select * from Products order by ProductGroup,CurrentStock DESC
• None of the above
33. What is the maximum number of indexes that you can create in an Access 2000 table?
Answers:
• 8
• 16
• 32
• 64
34. Which of the following queries is correct?
Answers:
• Select * from students order by marks where subject = 'SQL'
• Select stname from students order by subject
• Select * from students having subject ='SQL'
• Select stname from students group by stname
35. Which Query will you use to count the number of records in a result set?
Answers:
• Select count(*) as total from students
• Select count(amount) as total from students
• Select total from students
• Select * from students
36. How would you insert the Date and Time into a report?
Answers:
• Select the Layout view. On the Formatting tab, in the Controls group, click Date and Time.
• Select the Design view. On the Design tab, in the Controls group, click Date and Time.
• Either a or b
• None of the above
37. The 'Required' and 'AllowZeroLength' properties control how blank fields are handled. If you want to be able to distinguish between a field that is blank because the information is unknown and a field that is blank because it doesn't apply, how will you set the properties?
Answers:
• Set the 'Required' property to No and the 'AllowZeroLength' property to Yes
• Set the 'Required' property to No and the 'AllowZeroLength' property to No
• Set the 'Required' property to Yes and the 'AllowZeroLength' property to Yes
• Set the 'Required' property to Yes and the 'AllowZeroLength' property to No
38. A Database has two tables named Products and Orders. The tables are joined by a column called ProductID. You have created a view named View1, which combines the data from both the tables. If the Products table is dropped accidentally, what will happen when the users try to retrieve the data through View1?
Answers:
• Only the data of the Products table will be retrieved.
• Only the data of the Orders table will be retrieved.
• An error will be generated.
• The data will be successfully retrieved.
39. 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?
Answers:
• It allows all users their own permissions to view or run the query
• It allows a user to view, modify and insert but not delete data
• It allows all users the owner's permissions to view or run the query
• It allows users to view but not modify data
40. 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.?
Answers:
• GrpKeepTogether Property
• KeepTogether
• FastLaserPrinting Property
• SinglePagePrint
41. While designing a table in Access, an appropriate data type helps in which of the following ways?
Answers:
• It saves space in your database.
• It can improve join operations.
• It can improve performance of table locks.
• It could lead to fast data retrieval and updates.
42. How can you specify whether a user can add or delete data in a form or not?
Answers:
• In the form's property box, set 'Data entry' to Yes or No
• In the form's property box, set 'AllowDeletions' and/or 'AllowAdditions' to Yes or No
• In the form's property box, set 'Data entry' to Yes and 'Recordset Type' to Dynaset
• In the form's property box, set 'Record Locks' to No Locks or All record
43. In what form do file data sources (also called DSN files) store connection information?
Answers:
• In the Windows Registry
• In a Table located at Windows/System Folder/dsnrecord.mdb
• In a Table located at Windows/Access2000/dsnrecord.mdb
• In a text file
44. In Access 2000, you can control the access that a user has to data through permissions. The 'Insert data' permission allows a user to:
Answers:
• view, modify, insert and delete data
• view, modify, insert but not delete data
• view and insert but not modify or delete data
• view but not modify, insert or delete data
45. What is the function of the format painter?
Answers:
• It copies a table design to the buffer for later use
• It copies a control's format to another control
• It helps to format a report so that it looks tidy and presentable
• It copies a report design to the buffer for later use
46. How many twips is 1 inch equal to?
Answers:
• 1440 twips
• 567 twips
• 20 twips
• 100 twips
47. Which of the following options most clearly defines the meaning of a bound HTML Control on a data access page?
Answers:
• A Control that is bound to the HTML code residing online on a Web Server
• A Control that displays information in the HTML code which is later used for publishing data on the internet
• A Control that is bound to the HTML code that is stored in a field in a table
• A Control that computes user defined expressions and stores the result in an table in the form of the HTML code.
48. What is the error in the following Query?
select name from students where name = (select name from students order by name)
Answers:
• The order by clause in the subquery should be preceded with a group by clause
• The group by clause should be applied to the outer query
• An order by clause is not allowed in a subquery
• There is no error
49. In Access 2000, you can control the access that a user has to data through permissions. The 'Update data' permission allows a user to:
Answers:
• view and modify but not insert or delete data
• view, modify, insert and delete data
• view, modify, insert but not delete data
• view but not modify, insert or delete data
50. What will be the result for the following expression:
Len("Robert King")
Answers:
• 12
• 11
• 10
• 8
51. By adding a background picture to a Report, you can simulate a watermark. You can determine the proportions of the picture by setting the PictureSizeMode property. This property has three settings. What are they?
Answers:
• Stretch
• Color
• Clip
• Zoom
• Width
52. 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?
Answers:
• Select Studentname from students reverse
• Select Studentname from students reverse name
• Select Studentname from students order by name descending
• Select Studentname from students order by name reverse
• Select Studentname from students order by Studentname desc
• Select desc Studentname from students
• Select reverse Studentname from students
53. How do you hide duplicate data on a report?
Answers:
• By Setting the 'HideDuplicates' property to Yes
• By Setting the 'DuplicateRecords' property to No
• By Setting the 'DuplicateRecords' property to No and setting the 'GrpKeepTogether' property to 'Per Page'
• Duplicate Data should be handled at the time of data entry and cannot be controlled while reporting
54. How many databases can be opened at one time in a single Access 2000 instance?
Answers:
• One
• Two
• Three
• Ten
• Fifty
55. If you have to store a hyperlink in a field of an Access 2000 table, which data type would be most suitable?
Answers:
• OLE Object
• char
• hyperlink
• memo
56. Which of the following properties will you use for printing a section at the top of the next page if the entire section cannot be printed on the current page?
Answers:
• GrpKeepTogether Property
• KeepTogether
• FastLaserPrinting Property
• SinglePagePrint
No comments:
Post a Comment