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 |
Thursday, November 20, 2008
MS Access Objective Questions
Labels:
DBMS,
Objective Questions
Subscribe to:
Posts (Atom)