Thursday, November 20, 2008

MS Access Objective Questions

Access Oracle follows only seven Codd's rule. True False A
Access Access is a true RDBMS.


True False B
Access
In a table records are stored in rows and fields in columns.


True False A
Access Text type field stores maximum 256 characters.


True False B
Access Memo field stores 64,000 characters.


True False A
Access In Yes / No field -1 stands no and 0 stands for yes.


True False B
Access The lostfocus event occurs when a form or control looses the focus.

True False
A
Access We can not set a background picture in a report.


True False B
Access We can see the report preview from tools menu à layout preview.


True False B
Access Report header / footer sections does not come normally.


True False A
Access We can have subform within a subform.

True False
A
Access We can type new values in a list box.


True False B
Access When referential integrity is enforced, you can't enter a value in the foreign key field of the related table that doesn't exist in the primary key of the primary table.


True False A
Access When the cascade delete related records check box is set, deleting a record in the primary table deletes any related records in the related table.


True False A
Access If you want to see the SQL code that is generated by the query select Tools à SQL view from the menu.

True False
B
Access If you give a format property and an input mask the input mask gets precedence.


True False B
Access A primary key is a must in a table.


True False B
Access Double data type takes 4 bytes of space.


True False B
Access There is one-to-many relationship between mainform and subform.


True False A
Access You can not specify default value for a field.


True False B
Access Foreign key must be primary key of another table.


True False A
Access If required field property is turned on the user must enter something in this field in order to save the data.


True False A
Access In access you can copy the only structure of the table without the records.


True False A
Access A macro can be run automatically when a database opens.


True False A
Access A report can only be based on table.


True False B
Access In access page footer comes before report footer in all pages.


True False B
Access Currency is not a valid data type in access.


True False B
Access In append query the table where the data will be appended should have the same structure and primary key.


True False A
Access It is possible to enter a Null value in the foreign key.


True False A
Access It is not possible to set two fields of a table as primary key.


True False B
Access In access you can store the information of a video files in table.

True
False
A
Access In access, sorting the records in a table changes the order in which the records are displayed.


True False A
Access In access after you select all the fields necessary for the query, access builds the SQL in the background.


True False A
Access To run a macro automatically, the name of the macro is




AUTOEXEC AUTOEXEC.BAT AUTO None of the above A
Access In Validation rule <>0 means



entry is not null entry must be a nonzero value none of the above B
Access In input masks (999) 999-9999 means




(206) 555-0248 ( ) 555-0248 both of the above none of the above C
Access You can copy records from one table to another table in the current database or another database.



Update query Append query Maketable query B
Access To delete all orders placed in 1990 we have to use




Update query Append query Maketable query Delete query D
Access To increase salary by 5% we have to use



Update query Append query Delete query A
Access In access relationships are



one-to-one one-to-many both of the above C
Access Access lets you set up following kinds of joins -




Only Inner join Only outer join Only self join None of the above D
Access Extension of an access database is



.dbf
.mdb
.doc .ppt B
Access It allows you to set the message that appears if the validation rule fails.




validation rule validation text default value all of the above B
Access Primary key field must be



not null and unique null and unique not null and indexed A
Access You can store picture in a field of data type




picture OLE Object None of the above a & b B
Access An example of calculated query is



label control text control both a & b C
Access Line control is a example of



bound control unbound control calculated control B
Access There is one-to-many relationship between mainform and subform.


True False A
Access Access support full RDBMS concept. True False B
Access Using multiple row , we can not create primary key. True False B