oDesk Test Answer key 3D Max 9

Dear Freelancer,
Today i am sharing with you oDesk Test Answer key 3D Max 9. it,s may be very helpful for 3D MAX workers. 
If you have any question or suggest about oDesk Test Answer key 3D Max 9. Please post a comment below.  
Which kind of curve can trim surfaces in NURBS Modeling ?

a. CV curve on the surface
b. Point curve on the surface
c. Vector projected curve
d. All of the above

State whether True or False.

Wire Parameters works only with parameters that can be animated.

a. True
b. False

Refer to the given image.Which option will you choose to edit the region both in the rendered frame window and in the active viewport?


a. A
b. B
c. C
d. None of these

State whether True or False.Volume lights support negative multiplier values.

a. True
b. False

State whether True or False.Global shadow parameters cannot be exported while exporting a 3ds file.

a. True
b. False


State whether True or False.You need at least one camera in your scene to use the Panorama Exporter.

a. True
b. False

When does the bevel profile modifier fail?

a. When you delete the original beveling profile
b. When you create an object using an open spline
c. When you create an object using a closed spline
d. All of the above

State whether True or False.The reactor plane object acts in only one direction.

a. True
b. False

Which information do the IGES log files not provide?

a. List of the entity types encountered and created
b. Summary of the entities processed
c. Name of the file processed
d. None of these

State whether True or False.The Summary Info displays the statistics about the saved scene.

a. True
b. False

State whether True or False.If more than one cameras are in the scene, the material editor uses the first camera listed in the track view hierarchy.

a. True
b. False

Refer to the image.Which option displays clip track in the motion mixer?
a. A
b. B
c. C
d. None of these

State whether True or False.The Renderable Spline modifier cannot be applied to NURBS curves.

a. True
b. False

Which file saves only footstep data?

a. STP
b. BIP
c. CSM
d. BVH  

Which type of object cannot be used with the surface constraint?

a. Quad Patches (single quad patches)
b. Cylinder
c. Cylinder with a bend modifier applied on it
d. Loft

To which kind of objects can you apply a displacement map (standard material)?

a. Compound objects
b. Extended Primitives
c. NURBS Surfaces
d. All of the above

Refer to the given image.

What is the use of the shape visible to the renderer option in photometric light?
a. It makes a photometric light self illuminating
b. It sets the overall quality of shadows
c. It animates shadows of photometric light
d. All of the above

State whether True or False.The Fire effect does not cast any light or shadows in the scene.

a. True
b. False

Refer to the given image. What kind of curve is the green curve in relation to the red curve?
a. Transform curve
b. Mirror curve
c. Offset curve
d. Blend curve

For which of the following options does the image motion blur not work?

a. Anything with an Optimize
b. NURBS objects
c. MeshSmooth on polygons with Keep Faces Convex on
d. All of the above

State whether True or False.Curve approximation parameters are not animatable in NURBS Modeling.

a. True
b. False

State whether True or False.The MAXScript debugger lets you stop or continue the execution of the suspended code.

a. True
b. False

Which of the following switches starts 3ds max in a minimized mode and never allows you to open the window for interactive usage?

a. -mip
b. -mxs
c. -silent
d. None of the above




Refer to the given image.

What happens if we turn off the lock sample option in the mental ray renderer rollout?
a. The mental ray renderer uses a quasi-random variation in the sample pattern from frame to frame
b. The mental ray renderer uses the same sampling pattern for every frame of an animation
c. You cannot turn off this option
d. None of these
Refer to the given image.What is the use of the landscape option in water simulation?



a. It defines water using a rectangular area
b. It simulates non-rectangular surfaces and obstacles inside the water
c. Both a and b
d. None of the above
Refer to the given image.Why is the fuzz feature used in hair light attributes rollout?
a. It illuminates and casts shadows from the hair
b. It sets the softness of the shadow edges
c. Both a and b
d. None of the above
Refer to the given image.Which option renders hair shadows but not the hair?


a. A
b. B
c. C
d. D
Refer to the given image.What purpose does the relative option serve while loading the animation XML file?

a. It starts the loaded motion at the current values of the selected objects in the scene
b. It tells how existing keys are treated when the animation is loaded
c. It inserts the motion at the chosen frame
d. All of the above
Refer to the given image.When does a name appear in boldface and italics?

a. When a modifier is applied to two or more pipelines
b. When a modifier is instanced and is part of an instanced pipeline
c. When you choose the 'make unique' button
d. None of the above
Refer to the given image.Which of the following options is applied to Havok 3 only?

a. A
b. B
c. C
d. All of the above
Which controller does the Walkthrough Assistant use for the camera rotation?
a. Spline
b. Corner
c. Bezier
d. All of the above
State whether True or False.

You cannot animate haze value.

a. True
b. False
Which information is not imported when you import a 3DS file?
a. Fog, Layered Fog, and Distance Cue
b. Transparency Falloff Settings
c. 3D Surfer Patch Data
d. Morph Keys
With which type of objects does a Flex modifier work?
a. NURBS
b. Patches
c. FFD space warps
d. All of the above
State whether True or False.When the simulator decreases dT, it shows "dT decreased" on the Cloth Simulation dialog along with the message.
a. True
b. False
Refer to the given image. 
Which option in NURBS surfaces dialog box is the option selected by default?
a. A
b. B
c. C
d. None of the above
Refer to the given image.Which option of the cap holes modifier should be turned off, so that the faces in the capped holes are assigned a new ID?
a. A
b. B
c. C
d. None of these
Refer to the given image.When is the 'not shared' option active?
a. When the proxy object's pivot point is aligned with that of the rigid body
b. When you specify a proxy object by clicking the proxy button
c. When multiple objects with different simulation geometry settings are selected and cannot be chosen by the user
d. All of the above
Which type of objects are not supported by the Channel Info utility?
a. Mesh
b. Polygon
c. Patch
d. NURBS
State whether True or False.In character studio, you can import both rotation and position type motion-capture files.
a. True
b. False
Which rendering features does the mental ray renderer support?
a. Output dithering options
b. G-buffer options in post processing and image file output
c. Both of the above
d. None of these
State whether True or False.In rigid body dynamics, each body has six degrees of freedom to move: three translational degrees of freedom and three rotational degrees of freedom.
a. True
b. False
Which type of projection does the Camera Map per Pixel map use if we turn off �?mask uses the camera projection’ feature?
a. Mask uses the same camera projection as the Texture and ZBuffer Mask
b. Mask uses the object's UVW coordinates
c. Both a and b
d. None of these
Which option in the physique modifier defines a link's area of influence on mesh vertices?
a. A
b. B
c. C
d. D
Which of the following behaviors force delegates to move away from a target?
a. Surface arrive behavior
b. Orientation behavior
c. Speed vary behavior
d. Repel behavior
Refer to the given image.Which option in the file properties box displays the scene information available after the scene has been saved?
a. A
b. B
c. C
d. None of these
Refer to the image.

In the camera tracker utility's batch track rollout, which error code means that the color variance delta threshold has been exceeded?
a. Next
b. Jd
c. Me
d. Vd
Refer to the given image.

What is the function of the 'reveal location' in the explorer?
a. It launches a copy of Windows explorer to display the folder where the map is saved
b. It launches a copy of Windows browser to make an instance of the material or map
c. It launches a copy of Windows browser to create a new material
d. All of the above
Refer to the given image.

For which type of hair rendering options is the Refractions and ray-traced option available?
a. Buffer
b. Geometry
c. Mr prim
d. All of the above
What is not true about skin utilities?
a. Skin utilities work by matching bones from one character to another
b. To use skin utilities, you must have two meshes to which the skin modifier has been applied
c. Both the meshes should be in the current scene
d. None of the above
What happens if we turn on the show sample option in the render set up dialog box?
a. Sample location is rendered as streaks
b. Sample location is rendered as red dots
c. A message appears on the screen
d. Nothing happens
Which asset tracking dialog icon indicates that you are not logged in to the provider?
a. A
b. B
c. C
d. D
What is true about mirroring motion?
a. The mirrored motion does not replace the existing motion for the biped
b. The position of a keyless object is mirrored
c. This feature mirrors only those biped tracks that have at least one key
d. All of the above
The setup option is not available in the view image file. In which dialog box is this option available?
a. Render Output File dialog box
b. Viewport Background dialog box
c. Both a and b
d. None of the above
Which type of a deformable body is a three-dimensional closed triangular mesh?
a. Rope
b. Cloth
c. Deforming mesh
d. Soft body
Which of the following data types for controlling colors works with the RGB and HSV color values?
a. Point3
b. Color
c. Both a and b
d. None of the above
Which projection modifier has no parameters?
a. Relax modifier
b. Push modifier
c. Projection holder modifier
d. All of the above
Which of the following controllers is automatically assigned when you add a target camera?
a. The list controller
b. The look at controller
c. The linear controller
d. None of the above
What you can not do with the Trajectories?
a. Convert the path to a spline object
b. Derive a new path from a spline object
c. Collapse transforms
d. None of these
In the mental ray indirect illumination rollout, what will happen if the decay is set to 2?
a. The energy does not decay and photons provide equal indirect illumination throughout the scene
b. The energy decays proportionally to its distance from the light with linear falloff
c. The energy decays at an inverse square rate
d. None of the above
State whether True or False.When you switch over from a target camera to a free camera, no animation applied to the camera's target is lost.
a. True
b. False
Which of the following types of modifier is not available with the edit normals modifier?
a. Unspecified
b. Specified
c. Explicit
d. Implicit
Which test will you perform on an object to know whether it is convex or concave?
a. Concave test
b. Convexity test
c. Cavex test
d. All of the above

Which of the following apparatuses is used to create atmospheric effects?
a. BoxGizmo
b. SphereGizmo
c. CylGizmo
d. All of the above
State whether True or False.Trajectories are not displayed while you play an animation using the In Place mode.
a. True
b. False
Which operation does not remove animation from a NURBS object or sub-object?
a. Make Independent
b. Reparameterize
c. Fuse
d. None of the above
How is the camera map modifier (object-space version)different from the camera map modifier (world-space version)?
a. It applies UVW mapping coordinates to the object
b. It updates the object's mapping coordinates on every frame
c. Both a and b
d. None of the above
Which of the following file formats does Material Editor not support?
a. RPF
b. IFL
c. DDS
d. None of the above
For which type of shadow generation is Optimizations rollout available?
a. Mental ray shadow map
b. Ray traced shadow map
c. Shadow map
d. Area shadow
What is not true about a constraint solver?
a. For a simple constraint to take part in the simulation, you first need to add it to a constraint solver
b. It acts as a container for the cooperative constraints
c. To be valid, a constraint solver should be associated with a valid rigid body collection
d. All of the above
When will you use motion flow rather than motion mixer?
a. When you want to work with biped crowds or create random motion
b. When you want to create a specific animation for an object from several clips
c. When you want to specify that some motions be applied only to specific body parts
d. All of the above
To which part of the body does the Inverse Kinematics not apply?
a. Legs
b. Clavicles
c. Toes
d. All of the above
What is the use of the camera correction modifier?
a. It uses the three-point perspective in which vertical lines appear to converge with height
b. It applies the two-point perspective to a camera view
c. Both a and b
d. None of the above
In which type of a soft body does the reactor deform the underlying mesh directly?
a. Freeform deformation (FFD) bodies
b. Mesh-based soft bodies
c. Both a and b
d. None of the above
Refer to the given image.What do blue biped IK keys represent as displayed in the track view and on the track bar?
a. They represent planted keys
b. They represent sliding keys
c. They represent body-space IK keys with a non-zero value for IK Blend
d. None of these
State whether True or False.Ambient color mapping is not visible in ViewPorts or renderings unless the level of the ambient light is greater than the default value of the black.
a. True
b. False
Which of the following �?proxy in reactors’ is applied per rigid body rather than per object?
a. Display proxy
b. Geometry proxy
c. Both a and b
d. None of the above
What do you understand by the N links in the physique initialization dialog?
a. Vertices are influenced by more than one link
b. Vertices are influenced by only one (1) link
c. Vertices are influenced by all overlapping envelopes
d. All of the above
Refer to the given image.Which icon in the layer list indicates unfreeze?
a. A
b. B
c. C
d. D

Microsoft Access 2015 Test Answer

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 Answer.
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"
Subscribe to: Posts (Atom)