Braindumps Microsoft MCSD Dumps

70-410,70-411,70-412,70-413,70-414,70-417,70-461,70-462,70-463,70-464,70-465,70-480,70-483,70-486,70-487

Home » [Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 71-80

[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 71-80

EnsurePass
2017 Sep Microsoft Official New Released 77-605
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/77-605.html

MOS: Using Microsoft Office Access 2007

Question No: 71

Which of the following statements are true about the referential integrity? Each correct answer represents a part of the solution. Choose all that apply.

  1. It ensures that the relationship between two tables remains synchronized during deletes.

  2. It ensures that the relationship between two tables remains synchronized during updates.

  3. It enforces data validity by restricting the datatype.

  4. The foreign key in any referencing table must always refer to a valid row in the referenced table.

Answer: A,B,D

Explanation: Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table. Referential integrity ensures that the

relationship between two tables remains synchronized during updates and deletes. For a foreign key to be valid, it must contain either the value NULL, or an existing key value from the primary or unique key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link to the primary key column should be created in the related table. Answer: C is incorrect. The domain integrity enforces data validity by restricting the datatype.

Question No: 72

Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer contains a database named Sales. The database contains two tables named Products and Orders. Peter creates a relationship between the Products and Orders tables. Which of the following types of data integrity has he applied?

  1. Domain

  2. Referential

  3. Entity

  4. Primary key

Answer: B

Explanation: Peter has applied a referential integrity. Referential integrity means that the foreign key in any referencing table must always refer to a valid row in the referenced table. Referential integrity ensures that the relationship between two tables remains synchronized during updates and deletes. For a foreign key to be valid, it must contain either the value NULL, or an existing key value from the primary or unique key columns referenced by the foreign key. To enforce referential integrity, a foreign key column link to the primary key column should be created in the related table. Answer: A is incorrect. Domain integrity enforces data validity by restricting the data type, valid values (using CHECK constraints and rules), and range of possible values (using FOREIGN KEY constraints) for columns in a table. Answer: C is incorrect. Entity integrity enforces the uniqueness of rows in a table.

The uniqueness of rows can be enforced by the identifier column(s) through indexes, UNIQUE constraints, PRIMARY KEY constraints, or IDENTITY properties. Answer: D is incorrect. Primary key is not a type of data integrity. A table usually has a column or combination of columns whose values uniquely identify each row in the table. This column (or columns) is called the primary key. Primary key ensures that no duplicate or null values are entered in the column (or columns) defined as primary key columns. This enforces integrity of the table. A primary key can be created by defining a primary key constraint while creating or altering a table. A table can have only one primary key constraint. As primary key constraints ensure uniqueness, they are often defined by using an identity column.

Question No: 73

Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Human Resource. Peter has to delete some tables from the database through SQL statements. Which of the following statements will he use to accomplish the task?

  1. DROP TABLE lt;table_namegt; FROM DATABASE

  2. DROP TABLE lt;table_namegt;

  3. DELETE TABLE lt;table_namegt; FROM DATABASE

  4. DELETE TABLE lt;table_namegt;

Answer: B

Explanation: In order to accomplish the task, Peter will use the following statement: DROP TABLE lt;table_namegt; Here, the DROP TABLE statement is used to drop the table and the

lt;table_namegt; specifies the name of the table to be deleted. The drop table statement removes the table from the database. It can only be recovered if the backup of the database is present. Answer: A is incorrect. The DROP TABLE lt;table_namegt; FROM DATABASE generates an error. Answer: C and D are incorrect. There is no such statement as DELETE TABLE.

Question No: 74

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The computer contains a database named Human Resource created in Microsoft Office Access 2007. The database contains several tables. Andrew wants to establish a relationship between two tables named Employees and Department. Which of the following rules will Andrew take into consideration while establishing this relationship?

  1. The datatype of the primary key column must be compatible with the datatype of the foreign key column.

  2. The primary key column name must match with the foreign key column name.

  3. The NOT NULL attribute should be defined for the primary key column and the foreign key column.

  4. The name of the primary key table and the foreign table must be the same.

Answer: A

Explanation: When a relationship is to be established between two tables, the datatype of the primary key column and the foreign column must be the same. If the datatypes are not same, the relationship will be established but data cannot be retrieved by creating a query that will join two tables. It will give type mismatch error. Answer: B is incorrect. It is not mandatory to give same names for the primary key and the foreign key columns. But datatype compatibility is mandatory. Answer: D is incorrect. A database cannot have two tables with the same name. Answer: C is incorrect. The NOT NULL attribute is mandatory for the primary key column as it does not accept null values. But the NOT NULL attribute is not mandatory for the foreign key column.

Question No: 75

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft office 2007 installed on it. The company uses Microsoft Office 2007 database named Human Resource. Users use a Visual basic application to retrieve data from the database. Andrew wants to ensure that users are not directly connected to the tables in a database. Which of the following objects will he create to accomplish the task?

  1. A form

  2. A temporary table

  3. A query

  4. A report

Answer: C

Explanation: In order to accomplish the task, Andrew will create a query. A query can be created for either a single table or joining two or more tables. The query acts as a virtual table and users can retrieve data from it. The Visual Basic application can be connected to the fields of query to retrieve data. Answer: A, D, and B are incorrect. A Visual Basic application cannot be connected to a form, report, or macro.

Question No: 76

Andrew works as an Access Developer for AccessSoft Inc. The company has a Windows Vista computer on which Microsoft Office 2007 is installed. The computer contains a database named Sales. The database contains a table named Orders. James has to create a form for the table. He wants to ensure that when the form is opened in the Form View, all the order numbers are displayed in the list box control. Which of the following properties of the list box control will he use to accomplish the task?

  1. RecordSource

  2. ControlSource

  3. RowSource

  4. TextFormat

Answer: C

Explanation: In order to accomplish the task, Andrew will use the Row Source property. The RowSource property belongs to the combo box and list box controls. When these controls are bound to a column by the RowSource property, all the data of the column is displayed in the list box or the combo box. Answer: B is incorrect. The ControlSource property bounds a control to a field of a table. If a control is bound to a field by using this property, the control is known as a bound control. If the value of this property is blank, the control is known as an unbound control. If the ControlSource property contains an expression, the control is known as a calculated control. Answer: A is incorrect. The RecordSource property belongs to the form and report objects. This property binds the object to a source from which data is to be retrieved. This source can be a table or a query. When a form or a report is bound to a table or a query, the controls can be bound to a column of the table through the ControlSource property. Answer: D is incorrect. The TextFormat property of a control helps to change a text to rich text format. This helps to apply multiple formatting options for the text in a control. A user can change the format of the text to bold, italics, etc., The user can also change the font of the selected text and can apply other types of formatting.

Question No: 77

You have a home computer with Microsoft Office 2007 installed on it. When you open the Access database, you find that the Access Options are not visible there. You examine all settings and get that the Allow Full Menus check box is clear. Now, you want to retrieve all of the Access Options. Which of the following key sequences will you use to accomplish the task?

  1. Ctrl G

  2. F11

  3. Alt F11

  4. Shift

Answer: D

Explanation: In order to accomplish the task, you should hold the Shift key when you open the database and then, select the Allow Full Menus check box. Answer: B is incorrect. The F11 key sequence is used to display the Navigation Pane on the left side of the Access window. Answer: C is incorrect. The Alt F11 key sequence is used to open the Visual Basic Editor (VBE). Answer: A is incorrect. The Ctrl G key sequence is used to view the Immediate window.

Question No: 78

Andrew works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office Access 2007 installed on it. The company uses a Microsoft Office Access 2007 database named Sales. The database contains several tables. Andrew has to display a query from two tables named Products and Orders. By mistake, the Customer table is also added to the query. He selects the Customer table and presses the Delete key on the keyboard. Which of the following actions will take place in this scenario?

  1. The table will be removed from the query.

  2. The table will exist in the query but the data will be deleted.

  3. The table will be deleted from the database.

  4. An error will be generated.

Answer: A

Explanation: When a table is selected in a query and the Delete key is pressed, the table is removed from the current query. This procedure can be used to remove unwanted tables in a query. A table can also be removed from a query by right-clicking the table and selecting the Remove Table option.

Question No: 79

Peter works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer with Microsoft Office 2007 installed on it. The company uses Microsoft Office Access 2007 database named Human Resource. Peter has to create a table named Employees through SQL statement that will contain the following columns: FName LName DOB DateofJoining Which of the following SQL scripts will he use to accomplish the task?

  1. CREATE TABLE Employees (

    FName Text, LName Text, DOB Date/Time,

    DateofJoining Date/Time

    )

  2. CREATE TABLE Employees (

    FName Text LName Text DOB Date/Time

    DateofJoining Date/Time

    )

  3. CREATE TABLE Employees (

    FName AS Text, LName AS Text, DOB AS Date/Time,

    DateofJoining AS Date/Time

    )

  4. CREATE TABLE Employees (

FName AS Text LName AS Text DOB AS Date/Time

DateofJoining AS Date/Time

)

Answer: A

Explanation: In order to accomplish the task, Peter will use the following SQL script:

CREATE TABLE Employees (

FName Text, LName Text, DOB Date/Time,

DateofJoining Date/Time

)

Here, CREATE TABLE is a DDL statement used to create tables. Employees is the name of the table that is to be created as mentioned in the scenario. FName, LName, DOB, DateofJoining are the columns that are to be included in the tables. Text, Date/Time are the datatypes which tell what type of data can be included in a column. While creating a table, all the columns should have a datatype and should be comma-separated.

Question No: 80

James works as a Database Designer for AccessSoft Inc. The company has a Windows Vista-based computer that has Microsoft Office 2007 installed. The computer has a database named Sales. The database contains four tables that are related to each other through the primary and foreign keys. The database is not normalized. In order to normalize the database, James has to delete some columns from the tables. Which of the following syntaxes will he use to accomplish the task?

  1. DROP COLUMN lt;column;_namegt;

  2. ALTER TABLE lt;table_namegt;DROP COLUMN lt;column_namegt;

  3. ALTER TABLE lt;table_namegt;ALTER COLUMN lt;column_namegt; DROP

  4. ALTER DATABASE lt;database_namegt;DELETE COLUMN lt;column_namegt;

Answer: B

Explanation: In order to accomplish the task, James will use the following syntax:

ALTER TABLE lt;table_namegt; DROP COLUMN lt;column_namegt;

The properties of a column can be modified by using the ALTER TABLE statement. This statement can be used to accomplish the following tasks:

Add and drop columns Add and drop constraints

Answer: C is incorrect. The following syntax will generate an error: ALTER TABLE lt;table_namegt;

ALTER COLUMN lt;column_namegt; DROP

Answer: A is incorrect. The DROP COLUMN clause works inside the ALTER TABLE statement. If it is used without the ALTER TABLE statement, it will generate an error.

Answer: D is incorrect. There is no such clause as DELETE COLUMN in the ALTER TABLE statement.

100% Free Download!
Download Free Demo:77-605 Demo PDF
100% Pass Guaranteed!
Download 2017 EnsurePass 77-605 Full Exam PDF and VCE

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 EnsurePass IT Certification PDF and VCE

HOT EXAM!
[Free] 2017(Sep) EnsurePass Examcollection Microsoft 77-605 Dumps with VCE and PDF 61-70

Name of author

Name: admin

Leave a Reply