21. There are three types of data found in a spreadsheet:
A. Numbers, formulas, labels
B. Data, words, numbers
C. Words, numbers, labels
D. Equations, data, numbers
Ans: A
22. How we save database file in MS Access 2007 for Ms Access 2000?
A Save As MS Access 2000 Database
B Save Only
C Save Object As
Ans: A
23. When creating a new database in Microsoft Access, at what point is the user REQUIRED (i.e., the latest possible time) to name the database file within the Access software program?
A After some data has been entered into the tables for that database.
B Before the user exits the program, after having completed the desired work.
C Before the user creates any tables, immediately after giving the command to create a new database.
D After the tables and the relationship layout have been created, but before data is entered into the tables.
E After the tables have been created, but before the relationship layout is created
Ans: C
24. When creating a database in Microsoft Access _________________.
A Referential integrity is only enforced for those relationships for which the database designer or user places a check mark in a box for "enforce referential integrity" during or after creation of the relationships in the relationship layout.
B In Access it is impossible to create a table without designating a primary key.
C Foreign keys must be specified for each table.
D To delete a relationship, simply deleting one of the tables involved in the relationship will do the trick.
E All data entry problems will result in error messages
Ans: A
25. The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the __________.
A Datasheet View
B Design View
C SQL View
D Dashboard view
E Field View
Ans: B
26. You can add a row using SQL in a database with which of the following?
A. Add
B. Create
C. Insert
D. Make
Ans: C
27. The command to remove rows from a table 'CUSTOMER' is:
A. REMOVE FROM CUSTOMER …
B. DROP FROM CUSTOMER …
C. DELETE FROM CUSTOMER WHERE …
D. UPDATE FROM CUSTOMER …
Ans: C
28. What does White box database testing Involves?
A. testing of database triggers and logical views
B. performs module testing of database functions, triggers, views, SQL queries
C. validates database tables, data models, database schema etc
D. checks rules of Referential integrity.
E. All of the above
Ans: E
29. Database Checkpoints are Supported in All Environments.
A. TRUE
B. FALSE
Ans: A
30. Database checkpoint are displayed in the Expert View as a checkpoint.
A. Dbtable.checkpoint
B. Datatable.check
C. Dbtable.check
D. Dtable.check
Ans: C
A. Numbers, formulas, labels
B. Data, words, numbers
C. Words, numbers, labels
D. Equations, data, numbers
Ans: A
22. How we save database file in MS Access 2007 for Ms Access 2000?
A Save As MS Access 2000 Database
B Save Only
C Save Object As
Ans: A
23. When creating a new database in Microsoft Access, at what point is the user REQUIRED (i.e., the latest possible time) to name the database file within the Access software program?
A After some data has been entered into the tables for that database.
B Before the user exits the program, after having completed the desired work.
C Before the user creates any tables, immediately after giving the command to create a new database.
D After the tables and the relationship layout have been created, but before data is entered into the tables.
E After the tables have been created, but before the relationship layout is created
Ans: C
24. When creating a database in Microsoft Access _________________.
A Referential integrity is only enforced for those relationships for which the database designer or user places a check mark in a box for "enforce referential integrity" during or after creation of the relationships in the relationship layout.
B In Access it is impossible to create a table without designating a primary key.
C Foreign keys must be specified for each table.
D To delete a relationship, simply deleting one of the tables involved in the relationship will do the trick.
E All data entry problems will result in error messages
Ans: A
25. The view in which the field data types and field properties for a database table can be seen in Microsoft Access is called the __________.
A Datasheet View
B Design View
C SQL View
D Dashboard view
E Field View
Ans: B
26. You can add a row using SQL in a database with which of the following?
A. Add
B. Create
C. Insert
D. Make
Ans: C
27. The command to remove rows from a table 'CUSTOMER' is:
A. REMOVE FROM CUSTOMER …
B. DROP FROM CUSTOMER …
C. DELETE FROM CUSTOMER WHERE …
D. UPDATE FROM CUSTOMER …
Ans: C
28. What does White box database testing Involves?
A. testing of database triggers and logical views
B. performs module testing of database functions, triggers, views, SQL queries
C. validates database tables, data models, database schema etc
D. checks rules of Referential integrity.
E. All of the above
Ans: E
29. Database Checkpoints are Supported in All Environments.
A. TRUE
B. FALSE
Ans: A
30. Database checkpoint are displayed in the Expert View as a checkpoint.
A. Dbtable.checkpoint
B. Datatable.check
C. Dbtable.check
D. Dtable.check
Ans: C
No comments:
Post a Comment