Certification Questions

Q:

Which dml command is used in conjunction with @@identity?

A) INSERT and UPDATE B) UPDATE and DELETE
C) SCOPE_IDENTITY and IDENT_CURRENT D) Commit and rollback
 
Answer & Explanation Answer: C) SCOPE_IDENTITY and IDENT_CURRENT

Explanation:

Using automatically incrementing IDENTITY columns is very popular with database developers. You don’t need to explicitly calculate unique surrogate keys when inserting new data, the IDENTITY column functionality does that for you. The IDENTITY feature also allows you to specify useful Seed and Increment properties. When you use an INSERT statement to insert data into a table with an IDENTITY column defined, SQL Server will generate a new IDENTITY value.

 

You can use the @@IDENTITY variable and the SCOPE_IDENTITY and IDENT_CURRENT functions to return the last IDENTITY value that has been generated by SQL Server. This is very useful when you need to return the key for the row that has just been inserted, back to the caller.

Report Error

View Answer Report Error Discuss

8 5296
Q:

What is the Purpose of a Project Charter?

Answer

 


1. Project Charter refers to a statement of objectives in a project.


 
2. It provides a preliminary delineation of roles and responsibilities, outlines the project objectives, identifies the main stakeholders, and defines the authority of the project manager.


 
3. It serves as a reference of authority for the future of the project. The terms of reference are usually part of the project charter.

Report Error

View answer Workspace Report Error Discuss

4 1620
Q:

Why do you need common fields in a Database?

Answer

A database that contains multiple tables related through common fields.


A common field is a field of data that is shared among all forms in a database. Without them, it would be difficult and/or time-consuming to create other forms.

Report Error

View answer Workspace Report Error Discuss

6 1930
Q:

MOV extension refers usually to what kind of files?

A) Audio B) Movies or other Videos
C) Images D) Documents
 
Answer & Explanation Answer: B) Movies or other Videos

Explanation:

A .MOV file is a common multimedia container file format developed by Apple. It may contain multiple tracks that store different types of media data and is often used for saving movies and other video files.

Report Error

View Answer Report Error Discuss

3 1848
Q:

Dynamic Search Ads would be most helpful for

A) Campaigns that need to reduce exposure on competitive keywords. B) Websites with hundreds or thousands of products, services, or listings that frequently change.
C) A local restaurant with a dynamically changing menu that offers fresh new entrees every few months. D) Moving an ads position dynamically in whatever direction a users eyes are looking.
 
Answer & Explanation Answer: B) Websites with hundreds or thousands of products, services, or listings that frequently change.

Explanation:

Dynamic Search Ads are the simplest way to find the customers searching on Google for indubitably what you offer. This is an ideal way for with a well-developed website or with a large inventory. Businesses with websites that contain a lot of content or well-structured URLs will see the best results from using Dynamic Search Ads. 

 

Even well managed Adwords account with many keywords can miss relevant searches, experiance delays in getting ads added for new products or it may be out of Sync with what the website originally have.

 

How to Target : 

You can target 

        • All the web pages  (or)

 

        • Specific webpages containing certain keywords.

 

Benefits of Dynamic Search Ads :

        • Save time. No more mapping keywords, bids, and ad text to each product on your website. Plus, Dynamic Search Ads may help you advertise to new markets faster than other alternatives.
        • Frequent, automatic updates to your ads. When you make changes to pages in our index, we'll crawl your website again to help ensure that your ads are as up to date as possible.
        • Show relevant, dynamically generated headlines with your ads. When a customer's search is relevant to your product or service, AdWords will dynamically generate an ad with a clear headline for the most relevant page on your site.
Report Error

View Answer Report Error Discuss

6 4818
Q:

What is plug and play ?

Answer

Plug and Play is a technology wherein hardware components that are installed on PC's using Microsoft operating system are immediately recognized and made usable. This means that the drivers necessary to make it work are already available in the operating system package.

Report Error

View answer Workspace Report Error Discuss

5 579
Q:

Why that you cannot overload the scope resolution operator (::) ?

Answer

The main reason why the (::) cannot be overloaded is that only operators that take in values as parameters can be overloaded. The scope resolution operator does not take a value as parameter.

Report Error

View answer Workspace Report Error Discuss

5 688
Q:

Paint programs keep track of every __________ placed on the screen.

A) Object B) Image
C) Color D) Pixel
 
Answer & Explanation Answer: D) Pixel

Explanation:
Report Error

View Answer Report Error Discuss

5 1601