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