Sunday, January 12, 2014

oDesk JavaScript 1.8 Test answer

Analyze the following code snippet. What will be the output of this code?



<html>
<body>
<script type="text/javascript">
var str = "The drain of the plane is plain";
var patt1 =/ain/g;
document.write(str.match(patt1));
</script>
</body>
</html>
a. 1
b. ain
c. 7,29
d. 7
e. ain,ain
Which of the following is the correct syntactical representation of a generator expression in JavaScript?
a. var doubles = [i * 2 for (i in it)];
b. var doubles = [i * 2 for [i in it]];
c. var doubles = (i * 2 for (i in it));
d. var doubles = {i * 2 for (i in it)};
What is the output of the following JavaScript code?

s2 = new String("2 + 2")
document.write(eval(s2));
a. 4
b. 2+2
c. Error
d. None of the above
Consider the following code snippet. Which of the given options would be used in E4X to change the color of the descendant node chair?

var element = <Home>
    <Room>
    <Furniture>
    <chair color="Brown"/>
    </Furniture>
    </Room>
    </Home>
a. element.chair.color="light brown"
b. element.chair.@color="light brown"
c. element..chair.@color="light brown"
Consider the code snippet below. Which of the given options represents the correct sequence of outputs when this code is executed in E4X?

var p1 = <p>Kibology for all.</p>;
  alert(p1.name().uri);
  default xml namespace = 'http://www.w3.org/1999/xhtml';
  var p2 = <p>Kibology for all.</p>;
  alert(p2.name().uri);
  default xml namespace = '';
  var p3 = <p>Kibology for all.</p>;
  alert(p3.name().uri);
b. '','',''
d. None of the above
Which of the following is not a valid JavaScript operator?
a. *=
b. /=
c. %=
d. ^+
Which of the following is not a valid String method?
a. link()
b. italics()
c. str()
d. sup()
Which of the following methods is used to add and/or remove elements from an array and modify them in place?
a. push
b. slice
c. join
d. splice
In JavaScript, the encodeURI() function is used to encode special characters. Which of the following special characters is/are an exception to that rule?
a. £
b. €
c. @
d. $
e. a and b
f. c and d
Which of the following is not a valid Date Object method in JavaScript?
a. parse()
b. setDay()
c. setTime()
d. valueOf()
Which of the following results is returned by the JavaScript operator "typeof" for the keyword "null"?
a. function
b. object
c. string
d. number
Which of the following can be used to create attribute values by placing variables and expressions within them?
a. []
b. ()
c. {}
d. <>
What will the function NaN return for the condition NaN == NaN?
a. true
b. false
c. error
d. 0
Which of the following modifiers must be set if we use the Javascript lastIndex Object Property during pattern matching?
a. i
b. m
c. g
d. s
Which of the following two JavaScript code snippets is the more efficient and why?

CODE SNIPPET 1

<script language="javascript">
    for(i=0;i<document.images.length;i++)
    document.images[i].src="blank.gif";
</script>

CODE SNIPPET 2

<script language="javascript">
    var theimages = document.images;
    for(i=0;i<theimages.length;i++)
    theimages[i].src="blank.gif";
</script>
a. Both codes are equally efficient.
b. The first code is more efficient because it contains less code.
c. The first code is more efficient because it employs object caching.
d. The second code is more efficient because it employs object caching.
Which of the following is used to solve the problem of enumerations in JavaScript?
a. let
b. Regex
c. Generators
d. E4X
Is the following statement regarding expression closures in JavaScript true or false?

The syntax function(x) {return x*x;} can be written as function(x) x*x.
a. True
b. False
Which of the given options represents the correct length when alert(Emp..*.length()); is applied to the following code?

var Emp = <Emp>
  <name>Mark</name>
  <likes>
    <os>Linux</os>
    <browser>Firefox</browser>
    <language>JavaScript</language>
    <language>Python</language>
  </likes>
</Emp>
a. 11
b. 5
c. 6
d. 12
Analyze the following code snippet. What will be the output of this code?

<html>
<body>
<script type="text/javascript">
var str = "Visit Gardens(now)";
var patt1 = new RegExp("(now)", "g");
patt1.test(str);
document.write(RegExp.lastParen);
</script>
</body>
</html>
a. now
b. (now)
c. 15
d. 19
Which of the following is the correct way to create an XML object in E4X?
a. var languages = new XML('JavaScriptPython');
b. var languages XML = new XML('JavaScriptPython');
c. var languages =
    JavaScript
    Python
    ;
d. All of the above are correct.
e. a and c
f. b and c
Which of the following Array methods in JavaScript runs a function on every item in the Array and collects the result from previous calls, but in reverse?
a. reduce()
b. reduceRight()
c. reverse()
d. pop()
Which of the following can be achieved using JavaScript?
a. Reading or writing from external files
b. Accessing or modifying browser settings
c. Launching the default email application of the client
d. All of the above can be achieved using JavaScript.
Which of the following objects is the top-level object in the JavaScript hierarchy?
a. Navigator
b. Screen
c. Window
d. Document
Which of the following Javascript Regular Expression modifiers finds one or more occurrences of a specific character in a string?
a. ?
b. *
c. +
d. #
Which of the following is the correct syntax for using the Javascript exec() object method?
a. RegExpObject.exec()
b. RegExpObject.exec(string)
c. RegExpObject.exec(parameter1,parameter2)
d. None of the above
Analyze the following code using the source property of Regular Expressions. What will be the output of the below code snippet?

<html>
<body>
<script type="text/javascript">
var str = "Visit Garden\Showcase";
var patt1 = new RegExp("en\S","g");
document.write("The regular expression is: " + patt1.source);
</script>
</body>
</html>
a. The regular expression is: en\S
b. The regular expression is: 11
c. The regular expression is: enS
d. The regular expression is: 10
Which of the following options can be used for adding direct support for XML to JavaScript?
a. E4X
b. regex
c. Generators and Iterators
d. let
Which of the following options is used to access the attributes in E4X?
a. @
b. ::
c. #
d. *
Which of the following statements regarding let in JavaScript is not correct?
a. The let definition defines variables whose scope is constrained to the block in which they're defined. This syntax is very much like the syntax used for var.
b. The let expression lets you establish variables scoped only to a single expression.
c. The let keyword provides a way to associate values with variables within the scope of a block, and affects the values of like-named variables outside the block.
d. You can use let to establish variables that exist only within the context of a for loop.
Which of the following are not global methods and properties in E4X?
a. ignoreComments
b. ignoreWhiteSpace
c. setName()
d. setNamespace()
e. a and b
f. c and d
What will be the output of the following code?

  var x = 5;
  var y = 0;
  document.write( let(x = x + 10, y = 12) x+y + ",");
  document.write(x+y);
a. 27,5
b. 22,5
c. 27,22
d. None of the above
Which of the following is not a valid method in generator-iterator objects in JavaScript?
a. send()
b. throw()
c. next()
d. stop()
Using the concept of "iterators" and "generators" in JavaScript, what will be the output of the following code?

function testGenerator()
{
  yield "first";
document.write("step1");
  yield "second";
document.write("step2");
  yield "third";
document.write("step3");
  }
var g = testGenerator();
document.write(g.next());
document.write(g.next());
a. firststep1second
b. step1step2
c. step1
d. step1step2step3
Which of the following DOM objects can be used to determine the resolution of the screen?
a. It is not possible to determine the resolution of the screen.
b. Screen object
c. Document object
d. Window object
e. None of the above
Analyze the following code snippet. What will be the output of this code?

<html>
<body>
<script type="text/javascript">
var str = "The rose";
var patt1 = new RegExp("rose", "g");
patt1.test(str);
document.write("rose found. index now at: " + patt1.lastIndex);
</script>
</body>
</html>
a. rose found. index now at: 5
b. rose found. index now at: 4
c. rose found. index now at: 8
d. No output
Which of the following options can be used to delete a child node of an XML object in E4X?
a. delete xmlobject.child;
b. delete xmlobject.child[0];
c. delete xmlobject.@attribute;
d. All of the above
Analyze the following code snippet, which uses a Javascript Regular Expression Character Set. What will be the output of this code?

<html>
<body>
<script type="text/javascript">
var str = "Is this enough?";
var patt1 = new RegExp("[^A-J]");
var result = str.match(patt1);
document.write(result);
</script>
</body>
</html>
a. I
b. Is
c. s
d. I,s,
Consider the code below. What will be the final value of the variable "apt"?

var apt=2;
apt=apt<<2;
a. 2
b. 4
c. 6
d. 8
e. 16
Is the following statement true or false?

A function becomes a generator if it contains one or more yield statements.
a. True
b. False
What does the following JavaScript code do?

<html>
<body>
<script type="text/javascript">
function validate()
{
var chk="ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
var ok="yes";
var temp;
var field1=document.getElementById("t1");
var field=field1.value.substring(field1.value.length-1,field1.value.length);
if(chk.indexOf(field)=="-1")
{
      alert("error");
      field1.value=(field1.value).slice(0,field1.value.length-1);
}
}
</script>
<input type="text" id="t1" onkeyup="validate()" onkeypress ="validate()"/>
</body>
</html>
a. The code will cause an error alert to be displayed if a numeric character is entered, and the numeric character is removed.
b. The code will cause an error alert to be displayed if a non-numeric character is entered, and the non-numeric character is removed.
c. The code will cause an error alert to be displayed if a numeric character is entered, and the value of textbox is reset.
d. The code will cause an error alert to be displayed if a non-numeric character is entered, and the value of textbox is reset.
Analyze the following code snippet. What will be the output of this code?

<html>
<body>
<script type="text/javascript">
var str = "Visit Gardens(now)";
var patt1 = new RegExp("(now)", "g");
patt1.test(str);
document.write(RegExp.lastParen);
</script>
</body>
</html>
a. no
b. (no)
c. 15
d. 19

Which of the following is the correct method for getting the date of February 1 of the current year into a variable called "newDate"?
a. var d = new Date();
    newDate=new Date(d.getFullYear(), 1, 2);
b. var d = new Date();
    newDate=new Date(d.getFullYear(), 2, 1);
c. var d = new Date();
    newDate=new Date(d.getFullYear(), 1, 1);
d. var d = new Date();
    newDate= (d.getFullYear(), 1, 1);
Which of the following can be used to create attribute values by placing variables and expressions within them?
a. []
b. ()
c. {}
d. <>
Which of the following Javascript Regular Expression Character Classes finds any non-digit character in a given string?
a. \W
b. \S
c. \B
d. \D
Which of the following objects in JavaScript contains the collection called "plugins"?
a. Location
b. Window
c. Screen
d. Navigator
Which of the following Javascript Regular Expression object methods is used to search a string for a specified value and return the result as true or false?
a. exec()
b. compile()
c. return()
d. test()
Which of the following methods is not a valid Array object method in JavaScript?
a. reverse
b. shift
c. unshift
d. splice
e. All of the above are valid.
In an HTML page, the form tag is defined as follows:

<form onsubmit="return Validate()" action="http://www.mysite.com/">

The validate() function is intended to prevent the form from being submitted if the name field in the form is empty. What will the validate() function look like?
a. <script type="text/javascript">
    function Validate()
    {
    if(document.forms[0].name.value == "")
        return true;
    else
        return false;}
    </script>
b. <script type="text/javascript">
    function Validate()
    {
    if(document.forms[0].name.value == "")
        return false;
    else
        return true;
    }
    </script>
c. <script type="text/javascript">
    function Validate()
    {
    if(document.forms[0].name== "")
        return false;
    else
    return true;
    }
    </script>
d. <script type="text/javascript">
    function Validate()
    {
    if(document.forms[0].name == "")
        return true;
    else
        return false;
    }
    </script>
Which of the following is the correct way to create an XML object in E4X?
a. var languages = new XML('<languages     
    type="dynamic"><lang>JavaScript</lang><lang>Python</lang></languages>');
b. var languages XML = new XML('<languages   
    type="dynamic"><lang>JavaScript</lang><lang>Python</lang></languages>');
c. var languages = <languages type="dynamic">
    <lang>JavaScript</lang>
    <lang>Python</lang>
     </languages>;
d. All of the above are correct.
e. a and c
f. b and c
What does the following JavaScript code do? <head id="Head1" runat="server">
 
  <title></title>
  <script type="text/javascript">
    function validate() {
      var chk = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz";
      var ok = "yes";
      var temp;
      var field1 = document.getElementById("t1");
      var field = field1.value.substring(field1.value.length - 1, field1.value.length);
      if (chk.indexOf(field) == "-1") {
        alert("error");
        field1.value = (field1.value).slice(0, field1.value.length - 1);
      }
    }
</script>
</head>
<body>
<form id="form1" runat="server">
<input type="text" id="t1" onkeyup="validate()" onkeypress ="validate()"/>
</form>
</body>
a. The code will cause an error alert to be displayed if a non alphabet character is entered.
b. The code will cause an error alert to be displayed if ALPHABET character is entered.
c. The code will cause NO error alert to be displayed if a numeric character is entered.
d. The code will cause NO error alert to be displayed if a NON ALPHABET character is entered.

Tuesday, December 10, 2013

Slideshow Product Test Answers 2013

HI Friends,
Today i will discuses with you about of oDesk Slideshow Product Test Answers 2013.
I am sure your passing Score: 5.0
if you have any question or comment about Slideshow Product Test Answers 2013. Please post a comment.
Slideshow Product Test Answers 2013

1.Question:
By editing the translation, slideshow will automatically update the LQE tool.
a. True
b. False
Answer: b
2.Question:
Every project has a unique slideshow URL.
a. True
b. False
Answer: a
3.Question:
How do you review strings that have no screenshots in the slideshow?
a. You can’t, they don’t appear anywhere in slideshow
b. Click on the show message button
c. Navigate to the last slide of the slideshow
d. All of the above
e. None of the above
Answer: b
4.Question:
Which browser is the most optional to run slideshow on?
a. Internet Explorer
b. Firefox
c. Safari
d. Chrome
e. None of the above
Answer: b
5.Question:
What are the prerequisites required to being able to view a slideshow?
a. GCRT extension installed
b. Access to the external tc
c. A link to the slideshow
d. All of the above
e. None of the above
Answer: d
6.Question:
What is the correct order for leaving comments?
a. Reason for change, LQE code
b. LQE code, reason for change
c. Either order would work
d. All of the above
e. None of the above
Answer: b
7.Question:
Which of the following is not true of approving/reviewing suggestions?
a. You can select multiple suggestions at a time to approve or reject
b. You can’t approve two of the same suggestions at the same time
c. A blank page of suggestions means you have hit an error
d. They all are not true
e. None of the above
Answer: c
8.Question:
If you’re unable to edit a translation after you’ve been able to highlight it, it’s likely that:
a. You didn’t hit the escape key to lock the translation
b. You don’t have GCRT installed
c. The system feels the translation should not be edited
d. All of the above
e. None of the above
Answer: a
9.Question:
How do you get to the language you want to review?
a. The system automatically redirects to your language
b. Click on the link with your language
c. Select from the drop-down box
d. All of the above
e. None of the above
Answer: c
10.Question:
What basic information is provided in each slideshow?
a. Number of message to be reviewed
b. Number of screenshots to be reviewed
c. Number of message approved and rejected
d. All of the above
e. None of the above
Answer: a,b
11.Question:
What do you need to add the comments of slideshow when changes to translations?
a. LQE code
b. Your user email
c. Whether it is a major/minor error
d. All of the above
e. None of the above
Answer: a
12.Question:
Editing the strings automatically updates it to the TC (translation console).
a. True
b. False
Answer: b
13.Question:
How do you navigate to an entry to edit its translation?
a. Clicking on the arrow buttons for the messages
b. Clicking on the message directly scrolling through messages with the arrow keys on your keyboard
c. All of the above
d. None of the above
Answer: a, b

Friday, November 22, 2013

Microsoft Access 2010 Test Question

Hi Friends,
Today i am sharing with you Microsoft Access 2010 Test Answer. Here you can get all correct answer about Microsoft Access 2010 Test.
Which of the following conditions should be satisfied to create a one-to-one relationship between tables?
a. The primary key and foreign key fields must have a unique index.
b. The indexed property for the primary key and the foreign key fields should be set to Yes.
c. The common fields must have a unique index.
d. All of the above
Which of the following Aggregates expressions is not allowed in Query Columns context of a Web database?
a. Avg
b. Count
c. Sum
d. VarP
e. Like
What is the function of the icon marked as A (see image) when you are creating Macros in Microsoft Access 2010?


a. Close
b. Delete
c. Move up
d. Move Down
Which of the following statements is not true about the Work Offline option in an Access database linked to SharePoint?
a. Working offline allows you to work on SharePoint data locally.
b. Within Microsoft Access, data is visible to only those users who have permission to view it on SharePoint.
c. Discard All My Changes option lets you reject all changes made while offline.
d. Changes made in Access are synchronized with SharePoint when you reconnect.
Microsoft Access 2010 does not support more than _________ fields in a table.
a. 55
b. 155
c. 200
d. 255
Which of the following is true of the Ribbon interface?
a. Ribbons can be dragged and dropped to be on the side or the bottom of the screen.
b. Ribbons can be minimized or collapsed.
c. Ribbons can be replaced with command bars.
d. New ribbons can be created using the Office Ribbon Generator.
What is the purpose of Option Explicit?
a. It is a database object.
b. Requires variable declarations.
c. It contains all of the data access pages that are currently open in a Microsoft Access project.
d. It contains all open standard modules and class modules in a Microsoft Access database.
Which of the following are reserved for use by SharePoint and is not supported on the Web?
a. Solutions
b. Docs
c. Lists
d. UserInfo
e. Reports
Which one of the following correctly selects rows from the students table that have null in column1?
a. Select * from students where column1 is null
b. Select * from students where column1 = null
c. Select * from students where column1 EQUALS null
d. Select * from students where column1 NOT null
e. Select * from students where column1 CONTAINS null
What will be the result of the following?
InStr(1, "John Smith", "S")
a. 5
b. 6
c. 7
d. 4
Which of the following data-definition queries creates a table named Cars, with the following fields



a. CREATE Cars (Name TEXT(40), Year TEXT(4), Price CURRENCY)
b. CREATE TABLE Cars (Name TEXT(40), Year TEXT(4), Price CURRENCY)
c. CREATE TABLE Cars (Name(40), Year(4), Price)
d. CREATE Cars (Name(40), Year(4), Price)
Which of the following is true about a.accde file in Microsoft Access 2010?
a. It contains compiled VBA code to prevent users from viewing the code.
b. It can be saved as a.accdb file in order to make design changes.
c. It allows users to import forms and reports from other databases.
d. It allows users to view, but not modify VBA code.
How can you tell if a report has no records to display or print in Microsoft Access 2010?
a. By using the report's Error event.
b. By using the report's ApplyFilter event.
c. By using the report's NoData event.
d. By using the report's Filter event.
Which of the following is correct regarding Crosstab queries?
a. Multiple Value fields can be specified.
b. Multiple Column headings can be specified.
c. Multiple Row headings can be specified.
d. An unlimited number of columns can be returned.
What will happen when we select the option "Check for truncated number fields" (marked as A in the image) under Current Database settings?


a. The values visible in a column are truncated based on what can fit in the column.
b. Access displays numbers as "#####" when a column is too narrow to display the entire value.
c. Access displays numbers as "*****" when a column is too narrow to display the entire value.
d. Access expands the column if it is too narrow to display the entire value.
Which of the following is NOT possible when you link to an Excel worksheet from within Access?
a. You can append data to an existing table.
b. You can create a database containing multiple linked tables.
c. You can edit the Excel spreadsheet by making changes in to the linked table.
d. By creating a linked table any changes that are made to the data in Excel are automatically reflected in the linked table.
How do you start a Microsoft Access application so that the user can't see or use the Navigation Pane (or database container)?
a. Set the Access Option to hide the navigation pane, and press CTRL+F11 special keys.
b. Set the Access Option to hide the navigation pane, and press ALT+F1 special keys.
c. Set the Access Option to hide the navigation pane, and turn off special keys to prevent F11.
d. Set the Access Option to hide the navigation pane, and press CTRL+G special keys.
What is the purpose of the option marked as A (see image), under General options for working with Access?


a. It allows users to preview how a formatting option will appear.
b. It indicates that the text will be displayed in a format that is easier to read.
c. It enables ScreenTips and Enhanced ScreenTips.
d. Both b and c.
In a report with grouping, how can you display the count of records in each group?
a. Add a text box to the group's footer section and set its control source to =Count(*).
b. Set the report's Group Count property to True.
c. Add a label to the group's header section and set the Caption property to Count Rows.
d. Add a Summary control to the report's footer section.
Using the Package and Sign tool, how many databases can you add to a package that you want to distribute to other users in Microsoft Access?
a. Unlimited
b. 5
c. 1
d. 10
Using which of the following Microsoft Access 2010 database file formats, can we use the Package and Sign tool?
a. .accdb
b. .accdc
c. .accde
d. .mdb
Which text box property in Microsoft Access 2010 Reports allows the text box to be expanded so that all the text can be fit into it?
a. CanGrow
b. Reading Order
c. Display When
d. None of the above
How do you create a report for a Crosstab Query if certain column values are missing?
a. Set the Value field in the Crosstab.
b. Set the Column Heading field in the Crosstab.
c. Set the Pivot list in the Crosstab.
d. Set the report's Crosstab property to True
 
See the image above. How would you filter the table so that it returns names of only those students whose last name begins with A, O or Y?
a. Select lastname from students where lastname like '[A,O, Y]*'
b. Select lastname from students where lastname like '*[A, O, Y]'
c. Select lastname from students where lastname not like '*[A, O, Y]'
d. Select lastname from students where lastname not like '[A,O, Y]*'
e. Select lastname from students where lastname='A' or lastname='O'or lastname='Y'
When you run the Compatibility Checker in Microsoft Access 2010, in which of the following scenarios can you get the error- Access was unable to convert the query for use on the Web because it relies on an ORDER BY clause that is not supported on the Web?
a. Name of an order by element is not valid.
b. Name of source table is not valid.
c. Sort order is set to an option other than ascending or descending.
d. The expression is not valid.
e. All of the above
Which of the following elements are mandatory for the CREATE INDEX command?
a. The name of the index.
b. The ON argument.
c. The list of fields to be included in the index.
d. The name of the table that contains the fields that you want to index.
e. All of the above.
Which of the following Microsoft Access 2010 components can pose security risks in an untrusted database?
a. Action queries (queries that insert, delete, or change data)
b. Macros
c. Forms
d. VBA code
Which of the following is incorrect about the Quick Access Toolbar?
a. You can move the Quick Access Toolbar from its default location.
b. Toolbar can be minimized or collapsed.
c. You cannot display the Quick Access Toolbar on multiple lines.
d. You cannot increase the size of the buttons representing the commands by an option in Microsoft Office.
Which feature in Microsoft Access 2010 can be used to ensure consistency in appearance between forms and reports?
a. Web 2.0-like Controls
b. Web Browser Controls
c. Office Themes
d. Backstage View
What can you do in Report View that you cannot do in Print Preview in Microsoft Access 2010 Reports?
a. You can Filter, Copy, Search, etc.
b. You can make most, but not all, changes to your report.
c. You can display the structure of your report.
d. Resize report sections, such as Headers, Detail, and Footers
Microsoft Access uses indexes in a table to find data. Which of the following field types cannot be indexed?
a. OLE Object
b. Attachment
c. Memo
d. Calculated
Password protected databases offer:
a. Only one password with full rights.
b. Different user rights for different logins/passwords.
c. Integrated security with Active Directory.
d. Integrated security with Windows Logins.
What could be the problem when an error message "#Error" is received in a query?
a. The query is joining fields that have different data types.
b. A field's alias conflicts with a component of the expression for that field.
c. The object or the database is damaged.
d. The denominator of a calculated field is zero.
Which of the following describes the Data Execution Prevention (DEP) support for Office applications?
a. It is a software component that helps reduce the attack surface by identifying files that do not follow a valid file format definition.
b. It is a feature that helps mitigate attacks by enabling users to preview untrusted or potentially harmful files in a sandbox environment.
c. It is a hardware and software technology that helps harden the attack surface by preventing viruses and worms that exploit buffer overflow vulnerabilities from running.
d. All of the above
Which of the following is not true regarding Information Rights Management (IRM) for e-mail messages in Microsoft Access 2010?
a. It prevents restricted e-mail content from being copied by using the Print Screen feature in Microsoft Windows.
b. It restricts the e-mail content from being copied by using third-party screen-capture programs.
c. It prevents an unauthorized recipient from accessing e-mail content, including attachments.
d. It restricts content wherever the e-mail is sent.
Which of the following is not done when you compact a database?
a. Table records and objects are restructured and then stored in successive memory blocks.
b. Databases linked to the compacted database are compacted and repaired.
c. Table records are restored into their primary key order, if a primary key exists in the table.
d. The physical size of the database is reduced by making an exact duplicate of the database.
Which of the following is the correct way to enter the beginning or ending characters of the fields named (UnitPrice and CompanyName) in the AutoIndex onImport/Create field to create an Auto Index ?


a. unit.name
b. unit;name
c. unit,name
d. 'unit','name'
What is the advantage of a Class Module versus a Standard Module?
a. Encapsulation, Inheritance
b. Data Abstraction
c. Polymorphism
d. Reusability
What is the purpose of time stamping a digital signature in Microsoft 2010?
a. It helps mitigate integrity threats.
b. It ensures that digital signatures remain valid and legally defensible even if the certificate that is used to sign the document expires.
c. It enables you to specify cryptographic settings for encrypting documents.
d. It is a security tool that enables users to designate safe documents.
Suppose you want to use data from two tables in a query: tblCustomer and tblOrder. The two tables both have a field, CustomerID, that identifies a customer. Each record in the tblCustomer table may have one or more corresponding records in the tblOrder table, and the corresponding values can be determined by values in the CustomerID field. You now want to join the tables so that the query combines the records from the tables, excluding records from either table if there is no corresponding record in the other table. Which of the following FROM clauses will you use?
a. FROM [tblCustomer] LEFT JOIN [tblOrder] ON      
    [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
b. FROM [tblCustomer] RIGHT JOIN [tblOrder] ON
    [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
c. FROM [tblCustomer] INNER JOIN [tblOrder] ON
    [tblCustomer].[CustomerID]=[tblOrder].[CustomerID]
d. FROM [tblCustomer], [tblOrder]
What is the purpose of the Application Parts option in Microsoft Access 2010?
a. It enables you to reduce coding errors and easily incorporate more complex logic to create robust applications.
b. It integrates your Access reports using multiple data connections and information linked or imported from other sources.
c. It integrates your Access data with live web content.
d. It turns portions of your database into reusable templates.
If you want to encrypt a database by using a password, then the database must be opened in ________ mode.
a. Open Exclusive
b. Open Exclusive Read-Only
c. Open Read-Only
d. Open Password-Enabled
Layouts are guides to align controls that you add to your forms or reports. Which layout has been depicted in the image above?
a. Print Preview
b. Tabular format
c. Stacked format
d. Grid format
Suppose you want to apply a calculated field on a TextBox control to concatenate the values of the firstName and lastName fields, with a space between them.Which of the following expressions will you enter in the Expression Builder?
a. [firstName] +" "+[lastName]
b. [firstName] +" #"+[lastName]
c. [firstName] &" "& [lastName]
d. [firstName] &","& [lastName]
Which of the following functions determines if a phrase exists in a longer string?
a. InStr
b. Len
c. Trim
d. Left
What is the function of the 'Single Step' in Macros as shown in the image?
a. This command is saves expressions one at a time.
b. This command executes an action one at a time.
c. This command saves all queries in a single step.
d. This command saves all reports in a single step.
What happens when a user has a database open in Exclusive mode and another user attempts to open it?
a. The second user can open the database and make changes to objects and data.
b. The second user receives a 'File already in use' message.
c. The second user receives a 'File is deleted' message.
d. The second user can open the database and make changes to data, but not to objects.
Which form property determines whether the current record has been modified since it was last saved?
a. Cycle property
b. Dirty property
c. Filter property
d. FilterOn property
Which textbox property in Microsoft Access 2010 determines that the text box is bound, unbound or calculated?
a. RecordSource
b. ControlSource
c. CanGrow
d. RowSource
Which of the following is not a Relationship and Lookup error?
a. Lookups require an associated Relationship to be compatible with the Web.
b. Limit to List must be set to True if Allow Multiple Values is set to True.
c. Enable Referential Integrity must be False if Allow Multiple Values is set to True for a lookup.
d. A table with more than 220 fields is incompatible with the Web.
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)

What is the query to determine which German books (if any) are more popular than all the French books?
a. Select bookname from books where language='German' and popularityrating =(Select popularityrating from books where language='French')
b. Select bookname from books where language='German' and popularityrating > (Select popularityrating from books where language='French')
c. Select bookname from books where language='French' and popularityrating > (Select max(popularityrating) from books where language='German')
d. Select bookname from books where language='German' and popularityrating > (Select max(popularityrating) from books where language='French')
Which of the following rules apply when you use referential integrity?
a. You cannot delete a record from the primary table if matching records exist in the related table.
b. You cannot enter a value in the foreign key field of the related table that does not exist in the primary key of the primary table.
c. You can change the primary key value in the primary table, if that record has related records in the related tables.
d. All of the above
Which of the given text field properties should you set in order to force a user to enter a date value specifically in MM-DD-YYYY format?
a. Indexed
b. Validation Rule
c. Input Mask
d. Default Value
For what reason(s) can a digital signature or certificate be regarded as invalid?
a. The publisher is not a trusted publisher.
b. The digital signature has expired.
c. The certificate was not issued by a certified authority.
d. All of the above.
How can you share common objects between multiple projects in Microsoft Access 2010?
a. By customizing tabs.
b. By creating Data Macros.
c. By using a Web Browser Control.
d. By creating Application Parts.
A query that uses the BETWEEN operator for two numbers is identical to:
a. >= and <=
b. > and <
c. >= and <
d. > and <=
Choose the appropriate query for the Products table where data should be displayed primarily in ascending order of the ProductGroup column. Secondary sorting should be in the descending order of the CurrentStock column.
a. Select * from Products order by CurrentStock, ProductGroup.
b. Select * from Products order by CurrentStock DESC, ProductGroup.
c. Select * from Products order by ProductGroup, CurrentStock.
d. Select * from Products order by ProductGroup, CurrentStock DESC.
e. None of the above.
A company has the following departments:
Marketing, Designing, Production, Packing

What will be the result of the following query?

Select department from table where department < 'Marketing'
a. The query will return "Designing, Packing"
b. The query will return "Designing, Production"
c. The query will return "Production, Packing"
d. The query will return "Designing"