UPWORK TEST » October 29, 2015

Daily Archives: October 29, 2015

Upwork Internet Programming

Paypal Integration for Web Skills Test 2016

Published by:

1. In which of the following buttons is the PayPal Account Optional feature available?

Answers:

  1. Buy Now buttons
  2. Subscription buttons
  3. Cart buttons
  4. Shopping buttons
  5. Donation buttons

2. If the Auto Return feature is enabled in the PayPal profile, which of the following PayPal payments will it apply to?

Answers:

  1. Buy Now
  2. Shopping Cart
  3. Subscription
  4. Donation buttons
  5. Gift Certificate

3. While making a DoDirectPayment API call, which of the following Parameters must be included in the Name-Value string?

Answers:

  1. PAYMENTACTION
  2. ACCT
  3. STREET
  4. FIRSTNAME
  5. COUNTRYCODE
  6. LASTNAME
  7. ZIP
  8. IPADDRESS

4. Which of the following are valid refund types for the REFUNDTYPE parameter of the RefundTransaction request?

Answers:

  1. FULL
  2. PARTIAL
  3. HALF
  4. OTHER
  5. PENALTY
  6. NONE

5. While creating a Buy Now button using Merchant Services, which of the following parameters are optional under Item Details?

Answers:

  1. Item name/service
  2. Weight
  3. Currency
  4. Item ID/number
  5. Buyer’s default country

6. PayPal offers a notification validation method called “Use Shared Secrets” which ensures validity of data and decreases network traffic to and from your website. Under what conditions should you use this method in your website to notify transactions?

Answers:

  1. If you are using an SSL enabled web server.
  2. If you are using the notify_url variable on each individual payment transaction.
  3. If you are using a shared website hosting service.
  4. If you are using website verification certificates.
  5. If you are using Encrypted Website Payments.

7. Out of the following PayPal payment processing solutions, which ones do not require any programming skills (HTML/API) for implementation?

Answers:

  1. Website Payments Pro
  2. Website Payments Standard
  3. Payflow Pro
  4. Payflow Link
  5. Email Payments
  6. Virtual Terminal

8. Which of the following does PayPal recommend merchants to display on the return URL?

Answers:

  1. Item name
  2. Amount paid
  3. Payer email
  4. Shipping address
  5. PayPal transaction id
  6. Refund instructions

9. Which of the following values are allowed for the cmd form field?

Answers:

  1. _cart
  2. _xclick
  3. _s-xclick
  4. _cmdcart
  5. _notify_url
  6. _donate

10. While making a request to the PayPal server, which of the following API security parameters are required if you are using a PayPal API certificate?

Answers:

  1. USER
  2. PWD
  3. SIGNATURE
  4. VERSION
  5. SUBJECT

11. Which of the following form actions are used to make test payments using the PayPal Sandbox?

Answers:

  1. action=”https://www.sandbox.paypal.com/cgi-bin/webscr” method=”post”
  2. action=”https://www.sandbox.paypal.com/cgi-bin/webscr” method=”get”
  3. action=”https://www.developers.paypal.com/cgi-bin/” method=”post”
  4. action=”https://www.developers.sandbox.paypal.com/cgi-bin/webscr” method=”get”

12. Which of the following parameters are optional in a SetExpressCheckout request?

Answers:

  1. TOKEN
  2. RETURNURL
  3. PAYMENTACTION
  4. CANCELURL

13. If you are using encryption for your Buy Now button, which of the following statements are true?

Answers:

  1. Encrypted HTML code does not support option fields.
  2. Encrypted HTML code cannot be tinkered with.
  3. Encrypted HTML code can be used for email payment links.
  4. Encryption does not protect payment details from fraudulent alteration.

14. Which of the following statements are correct with regard to Payment Data Transfer(PDT)?

Answers:

  1. PDT requires Auto Return to be enabled.
  2. PDT will post data for refunds.
  3. PDT will not post data for reversals.
  4. If the customer closes the browser window before redirection, the notification will be missed.

15. Which of the following parameters are required in a DoExpressCheckoutPayment request?

Answers:

  1. AMT
  2. RETURNURL
  3. PAYMENTACTION
  4. PAYERID
  5. TOKEN

16. Which of the following statements are true for PayPal Account Optional?

Answers:

  1. It allows customers to make payments without having a Paypal account.
  2. It allows merchants to receive payments without having a Paypal account.
  3. PayPal Account Optional is enabled by default.
  4. The PayPal Account Optional feature is not available for Subscription buttons.

17. Which of the following APIs are related to authorization and capture?
Answers:

  1. DoCapture
  2. DoAuthorization
  3. DoDirect
  4. DoVoid

18. Which of the following statements are not true?

Answers:

  1. The merchant is the one who sells goods or services.
  2. The customer is the one who holds the payment instrument.
  3. The payment processor is a financial institution such as American Express, Discover, MasterCard, Visa, JCB or Diners Club.
  4. The credit card association is the entity that processes credit card transactions and settles funds for merchants.

19. What do you mean by the term Settlement?

Answers:

  1. The issuing of a refund order at the request of the customer.
  2. The process of authenticating and verifying the identity of the customer.
  3. The process of authorizing the merchant to charge customer’s card at any future date, such as in the case of a subscription
  4. payment.
  5. The crediting of the payment to the merchant’s account.

20. For a DoDirectPayment API call, which of the following values will be used with the PAYMENTACTION parameter to make the final sale for a credit card?

Answers:

  1. Sale
  2. Authorization
  3. Order
  4. Pay

21. If the user closes the browser before redirection, which of the following is correct for Payment Data Transfer (PDT) and Instant Payment Notification (IPN)?

Answers:

  1. The transaction notification will be missed in case of PDT.
  2. The transaction notification will be missed in case of IPN.
  3. The transaction notification will not be missed for IPN or PDT.
  4. The transaction notification will be missed for IPN and PDT.

22. While using the SOAP API with Certificate Security, where will you post your request for a live transaction?

Answers:

  1. https://api.paypal.com/nvp/
  2. https://api.paypal.com/2.0/
  3. https://api-3t.paypal.com/nvp/
  4. https://api-3t.paypal.com/2.0/

23. Which of the following services will be used to import an API certificate into the Microsoft Windows certificate store?

Answers:

  1. WinMgmt.exe
  2. WinHttpsCertCfg.exe
  3. WinHttpCertCfg.exe
  4. msvsmon.exe

24. While using the SOAP API with Certificate Security, where will you post your request for a test transaction?

Answers:

  1. https://api.paypal.com/nvp
  2. https://api.sandbox.paypal.com/nvp/
  3. https://www.sandbox.paypal.com/cgi-bin/webscr
  4. https://api.sandbox.paypal.com/2.0/

25. Which of the following parameters must be specified in a GetExpressCheckoutDetails request?

Answers:

  1. METHOD
  2. BUSINESS
  3. TOKEN
  4. PAYERID

26. In Express Checkout, how can you suppress the display of the shipping address on the PayPal payment pages?

Answers:

  1. By setting NOSHIPPING=1
  2. By setting ADDROVERRIDE=0
  3. By setting NOSHIPPING=0
  4. By setting ADDROVERRIDE=1

27. In a Name Value Pair (NVP) string, which character is used to separate the Name-Value pairs from one another and which character is used to separate the “Name” from the “Value” within each Name-Value pair?

Answers:

  1. = and $
  2. & and =
  3. & and @
  4. = and &

28. You have been asked by your client to set up a Paypal solution for her website. The client is asking for the following features:

1. Checkout will take place on the PayPal website.
2. Customers are not required to have a PayPal account in order to make a purchase.
3. The shopping cart will be on the client’s website.

Which of the following PayPal solutions can you recommend to your client?

Answers:

  1. Payflow Pro
  2. Payflow Link
  3. Email Payments
  4. Virtual Terminal

29. Does the button creation tool for PayPal Shopping Cart buttons support the encryption of the code it generates?

Answers:

  1. Yes
  2. No

30. While using the NVP API with Certificate Security, where will you post your request for a live transaction?

Answers:

  1. https://api-3t.paypal.com/nvp
  2. https://www.paypal.com/cgi-bin/webscr
  3. https://api.paypal.com/nvp
  4. https://www.paypal.com

31. While using the NVP API with Certificate Security, where will you post your request for a test transaction?

Answers:

  1. https://api.paypal.com/nvp/
  2. https://api.sandbox.paypal.com/nvp/
  3. https://www.sandbox.paypal.com/cgi-bin/webscr/
  4. https://api-3t.sandbox.paypal.com/nvp/

32. After how much time does the token expire in Express Checkout?

Answers:

  1. 1 hour
  2. 2 hours
  3. 3 hours
  4. It never expires

33. In Express Checkout, by default which method will be used to make the final sale?

Answers:

  1. SetExpressCheckout
  2. DoExPressCheckoutPayment
  3. GetExpressCheckoutDetails
  4. DoAuthorization

34. What will happen if you assign different notification URLs for Instant Payment Notification(IPN) in your account profile and in your programming code?

Answers:

  1. The programming code URL will override the account profile URL.
  2. The account profile URL will override the programming code URL.
  3. Both URLs will receive the same notification information.
  4. An error will be produced due to the mismatch of the two URLs.

35. Is a customer allowed to dispute the charge of a payment made from his or her PayPal account?

Answers:

  1. Yes
  2. No

36. What is the default value of the PAYMENTACTION parameter in Express Checkout?

Answers:

  1. Sale
  2. Authorization
  3. Order
  4. Pay

37. While using the NVP API with Signature Security, where will you post your request for a live transaction?

Answers:

  1. https://api-3t.paypal.com/nvp
  2. https://www.paypal.com/cgi-bin/webscr
  3. https://api.paypal.com/nvp
  4. https://www.paypal.com

38. Upto what limit of the original amount can you reauthorize a transaction in PayPal?

Answers:

  1. 115%
  2. 100%
  3. 125%
  4. 105%

39. Out of the following PayPal payment processing solutions, which is best suited for allowing merchants to accept payments via phone, fax or email?

Answers:

  1. Payflow Pro
  2. Website Payments Standard
  3. Email Payments
  4. Payflow Link
  5. Virtual Terminal

40. Which of the following security features is not supported by any of the PayPal payment processing solutions?

Answers:

  1. Secure Sockets Layer (SSL) protocol
  2. Verification by Visa
  3. Electronic Firewall Monitoring
  4. Site Verification Certificates
  5. Encryption with key length of 128 bits
  6. Mastercard SecureCode
  7. Address Verification Services (AVS)

41. Out of the following PayPal payment processing solutions, which one allows a customer to checkout on the merchant’s website?

Answers:

  1. Email Payments
  2. Website Payments Standard
  3. Payflow Pro
  4. Payflow Link
  5. Virtual Terminal

42. State whether the following statement True or False?

“The email address that you use to register on Paypal Developer Central must be the same as your live PayPal email address.”

Answers:

  1. True
  2. False

43. What should be the value of the AMT parameter in case of a RefundTransaction request when the REFUNDTYPE is FULL?

Answers:

  1. AMT=0
  2. AMT=-1
  3. AMT=full
  4. Do not set AMT.

44. Your client would like her customers to be able to checkout by phone. Which PayPal solution will you recommend to your client?

Answers:

  1. Payflow Pro
  2. Payflow Link
  3. Email Payments
  4. Virtual Terminal

45. For a DoDirectPayment API call, which of the following values will be used with the PAYMENTACTION parameter to authorize payment for later capture?

Answers:

  1. Sale
  2. Authorization
  3. PostAuthorization
  4. Pay
  5. PayAuth

46. What do you mean by the term Authorization?

Answers:

  1. The process of verifying that the customer’s credit card is valid, active and has sufficient credit limits.
  2. The process of authenticating and verifying the identity of the merchant.
  3. The process of authorizing the merchant to charge the customer’s card at any future date, such as in the case of a subscription payment.
  4. The process of debiting the payment from the customer’s account and crediting it to the merchant’s account.

47. What is the greatest value allowed in the SetExpressCheckout request for the AMT parameter?

Answers:

  1. $5,000 USD
  2. $20,000 USD
  3. $10,000 USD
  4. $50,000 USD
  5. $25,000 USD

48. Which of the following statements is true?
Answers:

  1. A complaint occurs when a customer registers a complaint about a payment with PayPal. A chargeback occurs when a customer registers a complaint with the credit card company.
  2. A chargeback occurs when a customer registers a complaint about a payment with PayPal. A complaint occurs when a customer registers a complaint with the credit card company.
  3. A chargeback and a complaint are identical.

49. During each PayPal API request session, how many times must the API credentials be included?

Answers:

  1. They are required only with the first request.
  2. They are required with every request.
  3. They are required only with the last request.
  4. They are not required at all.

50. What will be the value of PAYMENTACTION in Express Checkout so as to authorize payment for multiple captures?

Answers:

  1. Order
  2. Sale
  3. MulSale
  4. MulAuth

51. Which of the options represents the correct sequence for making an online payment?

1.The customer selects the item to purchase and provides his/her credit card information.

2.The payment gateway sends the information to the processor which in turn routes it to the credit card issuer.
3.On receiving the relevant information, the merchant sends it to the payment processor.
4.The payment processor forwards the transaction results to the merchant, who then decides whether to accept or reject the order.
5.The bank which issued the credit card authorizes or declines the payment and sends the transaction result to the payment processor.

Answers:

  1. 1,2,3,4,5
  2. 1,3,2,5,4
  3. 1,4,3,2,5
  4. 1,3,4,2,5

52. In Express Checkout by default, which method will be used to make the final sale?

Answers:

  1. SetExpressCheckout
  2. DoExPressCheckoutPayment
  3. GetExpressCheckoutDetails
  4. DoAuthorization

53. Which of the following variables will be used to differentiate between live PayPal IPN and Sandbox IPN?

Answers:

  1. ipn
  2. testipn
  3. test_ipn
  4. None of the above.

54. Which of the following URLs will you visit to access or create a PayPal Sandbox account?

Answers:

  1. https://developer.paypal.com
  2. https://www.paypal.com
  3. https://www.sandbox.paypal.com
  4. https://www.sandbox.paypaldeveloper.com/

55. While using Express Checkout, where will you post your request for a test transaction?

Answers:

  1. https://api.paypal.com/nvp
  2. https://api.sandbox.paypal.com/nvp
  3. https://www.sandbox.paypal.com/cgi-bin/webscr
  4. https://api-3t.sandbox.paypal.com/nvp

56. In a SetExpressCheckout request, which parameter will be used to specify the image to appear at the top left of the payment page?

Answers:

  1. HEADERIMG
  2. HDRBORDERCOLOR
  3. HDRIMG
  4. PAYFLOWIMG
  5. IMGHDR

57. While using the SOAP API with Signature Security, where will you post your request for a live transaction?

Answers:

  1. https://api-3t.paypal.com/nvp/
  2. https://www.paypal.com/cgi-bin/webscr/
  3. https://api.paypal.com/2.0/
  4. https://api-3t.paypal.com/2.0/

58. Which of the following HTML variables will be used to “Override Page Styles” on Individual Transactions for your Website Payment buttons?

Answers:

  1. page_style
  2. paypalpage_style
  3. cust_style
  4. custome_page_style

59. Which of the following payment solutions includes Address Verification Services (AVS)?

Answers:

  1. Payflow Pro
  2. Email Payments
  3. Payflow Link
  4. Virtual Terminal
  5. All of the above

60. If you are using L_AMTn and/or L_QTYn in a DoDirectPayment API call, which of the following parameters must also be specified?

Answers:

  1. AMT
  2. ITEMAMT
  3. ITEMTAX
  4. ITEM

1,126 total views, 2 views today

Upwork Internet Programming

LAMP Test 2016

Published by:

1. Which of the following are correct regarding Linux devices?

Answers:

  1. The character devices work with data streams
  2. The sockets are special-purpose I/O files offering a type of network interface
  3. A block device’s total size varies and a program has random access to any block in the device
  4. A named pipe is like a character device, but there is another process at the other end of the I/O stream instead of a kernel driver

2. Which of the following are correct regarding the .htaccess file in an Apache server?

Answers:

  1. The name ‘.htaccess’ is universally acceptable
  2. Any text editor can be used to create or make the changes to the .htaccess files
  3. An .htaccess file is simply a text file containing Apache directives
  4. Directives residing in the .htaccess file apply to the documents in the directory where the .htaccess file is located

3. Which of the following are correct with regard to indexes in MySql?
Answers:

  1. With clustered indexes, the primary key and the record itself are “clustered” together
  2. When your data is almost always searched through via its primary key, clustered indexes can make lookups drastically slow
  3. With separate indexes on first_name and last_name, MySQL can eliminate rows based on both fields
  4. Indexes are not always used to locate matching rows for a query

4. Which of the following statements are incorrect regarding referential integrity?

Answers:

  1. A foreign key can refer to a primary key
  2. A foreign key can refer to a unique key
  3. The on delete cascade clause will work only if there is a reference to a primary key
  4. The referred key can either be in the same table or in some other table
  5. A foreign key can be composite
  6. Referential integrity can only be applied while creating the table

5. Mike Johnson is running Apache on an extremely busy server where hundreds of requests per second is a requirement. He might have to change the default hard limits set in the MPM module. Which of the following hard limits should he change?

Answers:

  1. HARD_SERVER_LIMIT
  2. HARD_THREAD_LIMIT
  3. HARD_MPM_LIMIT
  4. HARD_PROCESS_LIMIT

6. Which of the following MySQL field names are correct?

Answers:

  1. EmpNo
  2. 25Block
  3. #AccountID
  4. _CustomerName
  5. Product.Name

7. The include directive inserts the text of a document into the SSI document being processed. Which of the following statements has the correct syntax for the include directive?

Answers:

  1. include file=”path”
  2. include virtual=”URL”
  3. include directive=”path”
  4. All of the above

8. Refer to the small php script given below:

<?php
class person{
function getSal()
{
. . .
. . .
}
}
class emp extends person{
function getSal()
{
???
}
}
?>
The getSal() of emp has to behave exactly as getSal() of person. Which of the following lines of code would you use to replace the ‘???’

Answers:

  1. parent::getSal();
  2. person::getSal();
  3. parent::getSal;
  4. person::getSal;

9. Which of the following statements are correct with respect to the get_browser function of PHP?

Answers:

  1. It is used to extract the client’s browser information
  2. It requires the browscap.ini to be placed on the server
  3. It requires the browscap.ini to be placed on the client
  4. None of the above is correct

10. Which of the following are the valid operations that MySQL performs simultaneously when a table is dropped?

Answers:

  1. It removes all the rows from the table
  2. It drops all the table’s indexes
  3. It removes all dependent views
  4. It removes all dependent procedures

11. Sometimes it is necessary to create a temporary file to collect output for use by a later command. While creating such a file, you must make sure that the filename is unique enough so that no other programs accidentally write on the temporary file. Which of the following are correct with regard to creation of temporary files?

Answers:

  1. mktemp command can be used to create temporary filenames
  2. The $$ special variable can be used to construct a temporary filename based on the process ID
  3. All Linux flavors come with mktemp
  4. You must use exit in the handler to explicitly end script execution

12. The architecture of MySql sets it apart from nearly every other database server. Which of the following are correct about different layers of MySql?

Answers:

  1. The topmost layer is composed of the services that are not unique to MySQL
  2. The second layer is made up of storage engines
  3. The third layer is made up of storage engines
  4. The interface between the second and the third layers is a single API not specific to any given storage engine

13. Which of the following statements are correct with respect to PHP connections?

Answers:

  1. mysql_pconnect keeps the connection open across multiple requests
  2. mysql_connect keeps the connection open across multiple requests
  3. mysql_pconnect opens up a database connection for each page load
  4. mysql_connect opens up a database connection for each page load

14. Which of the following can be used to implement data validation while creating a table in MySql?

Answers:

  1. Checking constraint with specified values
  2. Referential constraint by creating a foreign key for another table
  3. Default value of a column
  4. Null constraint

15. You have just installed a Linux system. You have upgraded the kernel and packages to the latest versions and you have turned off all unnecessary services and daemons. What else should you do to enhance security on the system?

Answers:

  1. Change the root password
  2. Set up a telnet session
  3. Audit your log files
  4. Turn off network card

16. During heavy INSERT, UPDATE, and DELETE activity, indexes slow down the performance. Which of the following setting controls this behavior?

Answers:

  1. compound index
  2. index_timer
  3. delay_key_write
  4. None of the above

17. Which of the following ways of creation of a virtual web site is not supported by Apache?

Answers:

  1. Name-based
  2. IP-based
  3. Multiple main servers
  4. None of the above

18. Which of the following is correct with regard to the statements given below?

Statement 1: If the internal network uses nonroutable IP addresses for either security or cost reasons, you can use a proxy server to provide Internet resources to hosts that normally cannot access the Internet.
Statement 2: Using a caching proxy such as Apache (with mod_perl), you can provide seemingly faster access to Internet resources to the local users.

Answers:

  1. Statement 1 is true but statement 2 is false
  2. Statement 1 is false but statement 2 is true
  3. Both the statements are true
  4. Both the statements are false

19. Which of the following is the standard authentication module, which implements Basic HTTP authentication?

Answers:

  1. mod_auth
  2. mod_auth_dbm
  3. mod_auth_digest
  4. mod_access
  5. None of the above

20. What do you infer from the following code?

<?php
$str = ‘Dear Customer,nThanks for your query. We will reply very soon.?n Regards.n Customer Service Agent’;
print $str;
?>

Answers:

  1. Only the first “n” character will be recognized and the new line will be inserted
  2. The last “n” character will not be recognized and only the first two parts will come in the new lines
  3. All the “n” characters will work and the text will be printed on the respective new lines
  4. All will be printed on one line irrespective of the “n” characters

21. You have a table phone_book with 2 billion rows in it. Adding an index on last_name will require a lot of space. If the average last_name is 8 bytes long, you are looking at roughly 16 GB of space for the data portion of the index. Which of the following will help in reducing the size of index space?

Answers:

  1. Indexing only the first 4 bytes
  2. Indexing on partition
  3. Keeping the index in more than one file
  4. None of the above

22. Which of the following helps to keep an eye on the existing number of objects of a given class without introducing a non-class member variable?

Answers:

  1. Addition of a member variable that gets incremented in the default constructor and decremented in the destructor
  2. Addition of a local variable that gets incremented in each constructor and decremented in the destructor
  3. Addition of a static member variable that gets incremented in each constructor and decremented in the destructor
  4. This cannot be accomplished since the creation of objects is being done dynamically via “new”

23. Which of the following is the correct way to check whether the cookie is set or not before retrieving the value from “LoginCookie”?

Answers:

  1. isset($COOKIE[‘LoginCookie’])
  2. isset($_COOKIE[‘LoginCookie’])
  3. isCookieSet(‘$LoginCookie’)
  4. isCookieSet([‘$LoginCookie’])

24. How would you convert the date set in the following format into a PHP timestamp?

$date = “Monday, July 28, 2008 @ 12:15 am”;

Answers:

  1. $date = replace(“@ “,””,$date); $date = strtotimestamp($date);
  2. $date = replace(“@ “,””,$date); $date = strtotime($date);
  3. $date = str_replace(“@ “,””,$date); $date = strtotime($date);
  4. $date = str_replace(“@ “,””,$date); $date = strtotimestamp($date);

25. Refer to the code given below and select the while condition from the following options:

$db = mysql_connect(“localhost”,”root”);
mysql_select_db(“mydb”,$db);
$result = mysql_query(“select state_id, state_text from states”);

if ($result)
{
echo “<SELECT NAME=’state_id’>”;
while (…condition…)
{
echo “<OPTION VALUE=””.$myrow[“state_id”].””>”.
$myrow[“state_text”].” </OPTION> “;
}
echo “</SELECT>”;
}

Answers:

  1. $myrow = mysql_fetch_array()
  2. $myrow
  3. $myrow = mysql_fetch_array($result)
  4. $myrow = fetch_array($result)

26. The Manager and Office classes are as follows:

<?php
class Manager{
function printName() {
echo “Manager”;
}
}
class Office{
function getManager() {
return new Manager();
}
}

$ofc = new Office();
???

?>
Which of the following should replace ‘???’ to obtain the value of printName() function?

Answers:

  1. $ofc->getManager()->printName();
  2. new Office()->getManager()->printName();
  3. $ofc->getManager->printName;
  4. Office::getManager()::printName();

27. Which of the following is correct with regard to the statements given below?

Statement 1: When you set up Apache on an Internet host it can respond to an HTTP request for that host.
Statement 2: Apache does not allow virtual hosts to inherit configuration from the main server, which makes the virtual host configuration quite manageable in large installations.

Answers:

  1. Statement 1 is true but statement 2 is false
  2. Statement 1 is false but statement 2 is true
  3. Both the statements are true
  4. Both the statements are false

28. rpm -Uvh filename- 1.2-2.i386.rpm can be used to install an RPM package. What functions does it perform?

Answers:

  1. It installs with additional information and hash marks
  2. It upgrades with additional information and hash marks
  3. It does not upgrade if an older package is not already installed. If the older package exists, then it upgrades with additional
  4. information and hash marks
  5. It installs the package with additional information and hash marks, then removes the old packages

29. You want to see the block and character devices for which your system currently has drivers. Which of the following commands should you use in this scenario?

Answers:

  1. list /proc/devices
  2. show /proc/devices
  3. find /proc/devices
  4. cat /proc/devices
  5. None of the above

30. ‘Perfect Services’ provides financial services worldwide. You want to display data from the table pers for joining_date from #1/1/2005# to #31/12/2005# and the job should either be of an analyst, a clerk or a salesman. Which of the following is correct?

Answers:

  1. select * from Pers where joining_date from #1/1/2005# to #31/12/2005#, job=Analyst or clerk or salesman
  2. select * from Pers where joining_date between #1/1/2005# to #31/12/2005#, job=Analyst or job=clerk or job=salesman
  3. select * from Pers where joining_date between #1/1/2005# and #31/12/2005# and (job=Analyst or clerk or salesman)
  4. None of the above

31. Based on the code given below, what will be the value of $num if mytable contains 12 records?

$result=mysql_query(“DELETE from mytable”);
$num=mysql_affected_rows();

Answers:

  1. 0
  2. 1
  3. 12
  4. undefined

32. Refer to the following declarations of the php variables:

$company = ‘ABS Ltd’;
$$company = ‘, Sydney’;
?>
Which of the following is not a correct way of printing ‘ABS Ltd , Sydney’?

Answers:

  1. echo “$company $$company”;
  2. echo “$company ${$company}”;
  3. echo “$company ${‘ABS Ltd’}”;
  4. echo “$company {$$company}”;

33. When Apache receives a URL request, it processes the request by serving the file to the client (the Web browser). It provides you with a flexible mechanism for rewriting the requested URL to a new one using custom URL rewrite rules. Which of the following is an incorrect server variable for URL Rewrite rules?

Answers:

  1. SERVER_PROTOCOL
  2. SERVER_SOFTWARE
  3. HTTP_REFERER
  4. REMOTE_FORWARD
  5. REMOTE_ADDR

34. What will be the output of the following code?

$Rent = 250;
function Expenses($Other)
{
$Rent = 250 + $Other;
return $Rent;
}
Expenses(50);
echo $Rent;

Answers:

  1. 300
  2. 250
  3. 200
  4. The program will not compile

35. Whenever you create a table, MySQL stores the table definition in a file with the same name as the table. Which of the following is the extension of the table definition file?

Answers:

  1. .tab
  2. .frm
  3. .tbk
  4. .str
  5. None of the above

36. To start the MySql server in Linux, you type the following from the command line:

bin/safe_mysqld &

What does the ‘&’ mean in the command mentioned above?

Answers:

  1. It forces Mysql to ask the password
  2. It forces Mysql to run in the background
  3. It logins with windows login credentials
  4. None of the above

37. Which of the following statements are true with regard to comparisons in PHP5?

Answers:

  1. With the “= =” operator, two object instances are equal if they have the same attributes and values, and are instances of different classes
  2. With the “= =” operator, two object instances are equal if they have the same attributes and values, and are instances of the same class
  3. With the (===) operator, object variables are identical if and only if they refer to the same instance of the same class
  4. With the (===) operator, object variables are identical if and only if they refer to a different instance of the same class

38. Which of the following queries will correctly retrieve the ages and addresses of those students who have been studying in the school for the last 2 years?

Answers:

  1. $SQL_QUERY=”select age,address from student where regdate =”; $SQL_QUERY .= “DATE_SUB(CURRENT_DATE,Interval 2 YEAR)”;
  2. $SQL_QUERY=”select age,address from student where regdate =”; $SQL_QUERY .= “DATE_SUB(CURRENT_DATE,Interval 2)”;
  3. $SQL_QUERY=”select age,address from student where regdate =”; $SQL_QUERY .= “CURRENT_DATE-2”;
  4. $SQL_QUERY=”select age,address from student where regdate =”; $SQL_QUERY .= “Year(CURRENT_DATE)-Year(CURRENT_DATE-2)”;

39. Check the structure of the following tables:

Employee
———
Empno
Employeename
Salary
Deptno

Department
———
Deptno
Departname

Mike wants to see the departments that have more than 100 employees. Which of the following queries returns the required result?

Answers:

  1. Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100);
  2. Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100);
  3. Select departname from department where count(deptno) > 100;
  4. Select departname from department where deptno in (select count(*) from employee where count(*) > 100);

40. Refer to the statements given below and identify which of the following is correct.

Statement 1: Without any indexes, the database uses a lot of disk I/O and can effectively pollute the disk cache.
Statement 2: Some extra disk space and a bit of CPU overhead is sacrificed on each INSERT, UPDATE, and DELETE query while using indexes.

Answers:

  1. Statement 1 is true but statement 2 is false
  2. Statement 1 is false but statement 2 is true
  3. Both the statements are true
  4. Both the statements are false

41. Which of the following subdirectory of the root directory provides system statistics through a directory-and-file interface which you can browse with standard Unix tools?

Answers:

  1. etc
  2. sbin
  3. proc
  4. lib
  5. None of the above

42. State whether true or false:

By allowing the use of .htaccess files in user (or customer or client) directories, you are essentially extending a bit of your Webmaster privileges to anyone who can edit those files.

Answers:

  1. True
  2. False

43. Which of the following statements are true?

Statement 1: mysql_fetch_object – Returns an object with properties that correspond to the fetched row, or FALSE if there are no more rows
Statement 2: mysql_fetch_row- Returns a positive MySQL result resource to the query result, or FALSE on error.

Answers:

  1. All the statements are true
  2. All the statements are false
  3. Only Statement 1 is true
  4. Only statement 2 is true

44. Based on the code given below, what will be the value of, $num, if mytable contains 20 records out of which 10 have myprice=19, 5 have myprice=20 and 5 have myprice=2, before running the mysql_query?

$resultSet=mysql_query(“UPDATE mytable set myprice = 20 where myprice < 20”);
$num=mysql_affected_rows();

Answers:

  1. 0
  2. 1
  3. 5
  4. 10
  5. 15
  6. 20

45. You want to enable SSI for a directory called ‘/www/mysite/htdocs/parsed’. Which of the following is the correct configuration to be added in httpd.conf?

Answers:

  1. <Directory “/www/mysite/htdocs/parsed”> Options +Includes SetFilter INCLUDES </Directory>
  2. <Directory “/www/mysite/htdocs/parsed”> SetOutputFilter INCLUDES </Directory>
  3. <Directory “/www/mysite/htdocs/parsed”> Options Included </Directory>
  4. <Directory “/www/mysite/htdocs/parsed”> Options +Includes SetOutputFilter INCLUDES </Directory>
  5. None of the above

46. Which of the following is introduced in PHP5?

Answers:

  1. __construct
  2. __construct and __destruct
  3. __constructor and __destructor
  4. __constructor

47. ‘Web Logic’, a web hosting company, has two system administrators, and one of them has just been terminated from his position. What is the first thing that the current administrator should do to enhance security?

Answers:

  1. Change the employee’s account password
  2. Set an expiration date on the employee’s account
  3. Disable the employee’s account
  4. Change the root password

48. A user is trying to set a new password for his account. He wants to use the name of the company “MNC” as his password. Why would the system not allow this password?

Answers:

  1. The minimum length of a password should be at least six characters
  2. The characters cannot be in alphabetical order
  3. Capital letters in a password cannot be used
  4. The password is already in use by another user

49. The Apache source distribution comes with a script called configure that allows you to configure the source tree before you compile and install the binaries. Which of the following is an incorrect option for the configure script?

Answers:

  1. –cache-file=file
  2. –help-file
  3. –exec-prefix=eprefix
  4. –libexecdir=dir
  5. None of the above

50. Which sequence will run successfully for the code given below?

<?php
function Expenses()
{
function Salary()
{

}
function Loan()
{
function Balance()
{ }
}

}
?>

Answers:

  1. Expenses();Salary();Loan();Balance();
  2. Salary();Expenses();Loan();Balance();
  3. Expenses();Salary();Balance();Loan();
  4. Balance();Loan();Salary();Expenses();

51. Which of the following is correct for specifying the default value?

Answers:

  1. function GetDiscount($Type = “Special”) { . . . }
  2. function GetDiscount(Type := “Special”) { . . . }
  3. function GetDiscount($Type := “Special”) { . . . }
  4. function GetDiscount($Type : “Special”) { . . . }

52. What will be the output of the following code?

$var1=”a”;

$$var1=”b”;

echo “$var1 $a”;

Answers:

  1. a b
  2. $var1 $a
  3. Error: $a is undefined
  4. Error: Parse error in line 2 ($$var1 = “b”)

53. Which of the following commands will you use if you need to strip the extension off of a filename or get rid of the directories in a full pathname?

Answers:

  1. relativename
  2. basename
  3. firstname
  4. None of the above

54. One of your PHP pages is very heavy and loading it takes about two minutes. But before it loads, a browser timeout occurs. Which of the following will help solve this problem?

Answers:

  1. set_time_limit(60);
  2. set_time_out(60);
  3. set_time_limit(150);
  4. set_time_out(150);

55. Food Cart Accounting System (FOCAS) is maintaining products in the products table, and wants to see the products which are 50 or more than 50 short of the minimum stock limit. The structure of the Products table is:
ProductID
ProductName
CurrentStock
MinimumStock

Two possible queries are:

Query 1:select * from products where currentStock>MinimumStock+50
Query 2:select * from products where currentStock-50>MinimumStock

Which of the following is correct?

Answers:

  1. Query 1 is true but Query 2 is false
  2. Query 1 is false but Query 2 is true
  3. Both the queries are true
  4. Both the queries are false

56. Indexes are known to speed up the search but they have some limitations also. Which of the following queries take much time despite having indexes on table?

Answers:

  1. select * from articles (body) match against (‘database’)
  2. select * from pages where page_text like “%buffy%”
  3. select last_name from phone_book where last_name rlike “(son|ith)$”
  4. select * from articles where body = “%database%”
  5. All of the above

57. Read the following code snippet:

1. for filename in *; do
2. if [ -f $filename ]; then
3. ls -l $filename
4. file $filename
5. else
6. echo $filename is not a regular file.
7. fi
8. done

What does ‘-f’ in line 2 mean?

Answers:

  1. It stores a file name in the memory
  2. It tests all the items in the current file
  3. It tests all the items in the current working directory
  4. None of the above

58. What is the function of the ‘swapon’ command while installing Linux in the command line interface mode?

Answers:

  1. It creates a swap area in RAM
  2. It activates a created swap partition
  3. It creates a swap partition
  4. It creates and activates a swap partition

59. What is the condition indicated if only the LI appears while attempting to boot a Linux system with LILO?

Answers:

  1. Primary boot loader has been started
  2. Secondary boot loader has been loaded
  3. Tertiary boot loader has been loaded
  4. Secondary boot loader signals it has been loaded

60. What will happen if the following code is executed?

$resultSet = mysql_query(“SELECT fname, lname FROM customers”)
for ($nIndex = 0; $nIndex < mysql_num_rows($resultSet) ; $nIndex++)
{
if (!mysql_data_seek($resultSet, $nIndex))
{
echo “Cannot seek to row $nIndexn”;
continue;
}

if(!($row = mysql_fetch_object($resultSet)))
continue;

echo “$row->fname $row->lname<br />n”;
}

Answers:

  1. The fnames and lnames of all the customers will be printed
  2. The lnames and fnames of all the customers will be printed
  3. The fnames and lnames of all the customers will be printed in the reverse order
  4. Only the fname and lname of the first customer will be printed
  5. Only the fname and lname of the last customer will be printed

61. Which of the following are correct with regard to the sbin subdirectory of the root directory in Linux?

Answers:

  1. It is the place to find system executables
  2. Programs in sbin directories pertain to system management
  3. Regular users usually do not have sbin components in their command paths
  4. All of the above

62. You are facing a low key buffer problem. You want to increase the size of the key buffer from what it was set to at the startup. Which of the following is the correct syntax to perform this?

Answers:

  1. mysql> SET buffer=50M;
  2. mysql> SET key_buffer=50M;
  3. mysql> SET GLOBAL key_buffer=50M;
  4. mysql> SET DEFAULT key_buffer=50M;
  5. None of the above

63. Which of the following is correct with regard to the statements given below?

Statement 1: The current implementation of the optional proxy module does not support reverse proxy or the latest HTTP 1.1 protocol.
Statement 2: Apache can be turned into a caching (forward) proxy server.

Answers:

  1. Statement 1 is true but statement 2 is false
  2. Statement 1 is false but statement 2 is true
  3. Both the statements are true
  4. Both the statements are false

64. You have defined three variables $to, $subject, and $body to send an email. Which of the following methods would you use to send an email?

Answers:

  1. mail($to,$subject,$body)
  2. sendmail($to,$subject,$body)
  3. mail(to,subject,body)
  4. sendmail(to,subject,body)

65. You have to upload a file named “SalesFile” using the form post method mentioned below. What should be the code in line 3 to accomplish the same?

1 <input type=”hidden” name=”MAX_FILE_SIZE” value=”30000″ />
2 Send this file:
3
4 <input type=”submit” value=”Send File” />

Answers:

  1. <input name=”SalesFile” type=”file” />
  2. <input name=”SalesFile” Upload=”true” />
  3. <input filename=”SalesFile” type=”Upload” />
  4. <input filename=”SalesFile” Upload=”true” />

66. Where would you install LILO to allow a dual bootable system on a ‘system’ which already has Microsoft Windows NT 4.0 with an installed NTFS partition?

Answers:

  1. Master Boot Region
  2. First sector of the NTFS partition
  3. Last sector of the boot partition
  4. First sector of the boot partition

67. Which permission setting allows a user to run an executable with the permission of the owner of that file?

Answers:

  1. Read
  2. SUID
  3. Write
  4. SSH

68. Which of the following lines of the class mentioned below should be commented to execute the code without errors?

1 class Insurance
2 {
3 function clsName()
4 {
5 echo get_class($this);
6 }
7 }

8 $cl = new Insurance();
9 $cl->clsName();
10 Insurance::clsName();

Answers:

  1. Line 8 and 9
  2. Line 10
  3. Line 9 and 10
  4. All the three lines 8,9, and 10 should be left as it is

69. Consider the following sample code:

$x = 0xFFFE;
$y = 2;
$z = $x && $y;
What will be the value of $z?

Answers:

  1. 0
  2. 1
  3. 2
  4. 3
  5. 4

70. You are building Apache from the source distribution. Which of the following is a mandatory requirement for Apache installation?

Answers:

  1. ANSI C Compiler
  2. Perl 5 Interpreter
  3. Dynamic Shared Object support
  4. None of the above

71. Refer to the classes that are defined as follows:

abstract class BaseCls{
protected abstract function getName();
}

class ChildCls extends BaseCls{

}
Which of the following implementations of getName() is invalid in ChildCls?

Answers:

  1. protected function getName(){}
  2. function getName(){}
  3. private function getName(){}
  4. public function getName(){}

72. You want to open a file in the PHP application and you also want this application to issue a warning and continue execution, in case the file is not found. Which of the following idea functions would you use in this scenario?

Answers:

  1. include()
  2. require()
  3. nowarn()
  4. getFile(false)

73. You need to allow only selected users from the users file into a particular area and you do not want to keep the username information in your .htaccess files. Which of the following is a correct statement to allow a group of users?

Answers:

  1. require usergroup <group name>
  2. require group <group name>
  3. require users <group name>
  4. require <group name>

74. You have an HTML file called mypage.html and you want to store meta headers of this html page. Which of the following directives specifies the filename extension for metainformation files?

Answers:

  1. MetaExt
  2. MetaFileType
  3. MetaExtension
  4. MetaSuffix

75. John Mark, an administrator, wants to set the Web server so that it will not show a directory listing if a user requests a page which is a directory. Which modification should he set up in the httpd.conf?

Answers:

  1. User
  2. ServerName
  3. Remove indexes from configuration file
  4. DocumentRoot

76. Which of the following special variables of a shell script holds the number of arguments passed onto the script?

Answers:

  1. $~
  2. $*
  3. $#
  4. $@

77. When a Unix program finishes, it leaves an exit code for the parent process that started the program. The exit code is a number. Which of the following numbers is returned if the program ran without problems?

Answers:

  1. 0
  2. 1
  3. 13
  4. 108
  5. None of the above

78. Which of the following is correct regarding the statements given below?

Statement 1: Before the server can send the page to the browser it must send the http headers.
Statement 2: session_start() is used to send some headers.

Answers:

  1. Statement 1 is true but statement 2 is false
  2. Statement 1 is false but statement 2 is true
  3. Both the statements are true
  4. Both the statements are false

79. Which program automatically determines the number of blocks in a device and sets some reasonable defaults?

Answers:

  1. mkbds4
  2. mke2fs
  3. mksdef
  4. mkcntd
  5. None of the above

80. Which of the following statements is incorrect with regard to PHP interfaces?

Answers:

  1. A class can implement multiple interfaces
  2. An abstract class cannot implement multiple interfaces
  3. An interface can extend multiple interfaces
  4. Methods with the same name, arguments and sequence can exist in the different interfaces implemented by a class

81. A construction company is working on three projects: mall construction, residential construction and building business towers. A civil engineer can work only on one type of construction project but more than one civil engineer can work on one project whereas a sales person can handle any type of projects and any number of sales people can work on one project. Define the nature of the relationship between (civil engineer and projects) and (sales person and projects)?

Answers:

  1. one to many, one to one
  2. one to one, one to many
  3. many to one, many to many
  4. many to one, many to one

82. A production house has two sale outlets. Both the outlets are maintaining their data separately in servers A and B. The MD wants to see the sale of both the outlets in one report. Both the outlets use the same structure of the Sales table. Which of the following methods will you adopt to create this report?

Answers:

  1. Select * from A.Sales join B.Sales
  2. Select * from A.Sales union all B.Sales
  3. select * from A.Sales,B.Sales
  4. None of the above

83. Refer to the following statement:

Select CustomerName, AccountNumber from Customers where AccountNumber in(select AccountNumber from Transactions where TransactionDate=#12/12/2005#)

Which of the following is correct?

Answers:

  1. In the sub query, * should be used instead of AccountNumber
  2. The sub query can return only one row, so “in” should be replaced with “=in” the prime query
  3. The sub query should be used first
  4. None of the above

929 total views, 2 views today

Upwork Internet Programming

JSON Test 2016

Published by:

1. Which of the following properties form part of the response to a JSON-RPC method invocation?

Answers:

  1. result
  2. error
  3. params
  4. id
  5. method

2. Which of the following properties are contained in the request for a JSON-RPC method invocation?

Answers:

  1. result
  2. method
  3. params
  4. error

3. Which of the following statements is/are not correct about the JSON-RPC?

Answers:

  1. It wraps an object, allowing you to call methods on that object and get the return values.
  2. It does not allow multiple calls to be sent to a peer which may be answered out of order.
  3. It does not provide the idea of getting error responses.
  4. It allows for bidirectional communication between the service and the client.

4. Which of the following methods is/are provided by JSONRequest?

Answers:

  1. src
  2. get
  3. cancel
  4. style

5. Which of the following parameters can be passed in the JSONRequest.post request?

Answers:

  1. src
  2. done
  3. id
  4. send

6. Which of the following parameters can be passed in the JSONRequest.get request?

Answers:

  1. url
  2. done
  3. send
  4. src

7. Which of the following is/are true with regard to JSONRequest?

Answers:

  1. It is a two way data interchange between any page and any server.
  2. It can combine programs and data services from multiple sources on a single page.
  3. It accumulates random delays before acting on new requests when previous requests have failed.
  4. It can be used to retrieve JSON-encoded values and other text formats.

8. Which of the following statements is/are true about modules with reference to JSON?

Answers:

  1. Every node in the module’s parent chain must also have a CSS display property of dynamic.
  2. Modules cannot have negative CSS margins.
  3. The CSS display property of a module must be static.
  4. Modules can be clipped by the CSS clip property.

9. Which of the following JSONPath syntaxes will you use in order to filter all books where price is less than $10?

Answers:

  1. $.book[@.price<10)]
  2. $..book[?(@.price<10)]
  3. //book[price<10]
  4. $.book[,(@.price<10)]

10. Which of the following statements is correct about JSON?

Answers:

  1. It is a lightweight data interchange format.
  2. It is a superset of JavaScript.
  3. It is a language independent text format.
  4. It is a general serialization format.

11. Which of the following is the correct syntax for declaring a <module> tag in JSON?

Answers:

  1. <module name=”NAME” path=”URL” style=”STYLE”>
  2. <module id=”NAME” url=”URL” style=”STYLE” />
  3. <module name=NAME path=”URL” style=”STYLE” >
  4. <module id=”NAME” src=”URL” style=”STYLE” />

12. What is the significance of the arrow before the following code in JSON?

–> { “method”: “echo”, “params”: [“Hello JSON-RPC”], “id”: 1}

Answers:

  1. It shows the data sent to the service.
  2. It shows the data coming from the service.
  3. It shows the notification message from the service.
  4. It shows the root element set for the message transfer.

13. In order to find the authors of all the books in the store, which of the JSONPath codes will you use?

Answers:

  1. $.store.book[*].author
  2. $..author
  3. /store.book.author
  4. $store.book.author

14. What will be the output of the code shown above?

Answers:

  1. OpenDoc 3
  2. CloseDoc 4
  3. CreateDoc 2
  4. Syntax Error

15. In order to find the price of everything in the store, which of the JSONPath codes will you use?

Answers:

  1. $.store.price
  2. $store..price[*]
  3. $.store..price
  4. //store.price[*]

16. Which of the following is a valid JSONPath expression?

Answers:

  1. /.store.book[0].title/*
  2. $.store.book[0].title
  3. //.store.book[0].title//*
  4. $..store.book[0].title

17. Which of the following statements correctly describes the following syntax?

{“state”:{optional:true},”town”:{“required”:”state”,optional:true}}

Answers:

  1. An instance includes a state property and a town property which is optional.
  2. An instance may or may not include a state property which is optional. If a town property is not included, the state property is optional.
  3. An instance must include a state property if a town property is included. If a town property is not included, the state property is optional.
  4. The declaration syntax is incorrect. You can not declare optional values in an array.

18. Which of the following elements of JSONPath can be used to apply the filter(script) expression?

Answers:

  1. [,]
  2. ?()
  3. //
  4. [.]

19. State whether true or false.

JSONRequest allows the connection when the Content-Type in both directions is an application/jsonrequest.

Answers:

  1. True
  2. False

20. JSON does not allow you to create an empty object.

Answers:

  1. True
  2. False

21. Which of the following correctly describes the disallow property of the JSON Schema?

Answers:

  1. It indicates that the property will be used for volatile values that should not be persisted with.
  2. It indicates that the instance property should not be changed.
  3. It specifies that an instance property is an internal property that should not be made visible to the users.
  4. This attribute may take the same values as the “type” attribute.

22. Which of the following correctly describes the function of the JSON.stringify method in JSON?

Answers:

  1. It accepts a string and revives it into an object.
  2. It converts a JavaScript object into a JSON string.
  3. It converts a JSON object into a text.
  4. It converts a JSON string into a JavaScript object.

23. Which of the following properties should be declared first in order to define a schema from an instance?

Answers:

  1. $schema
  2. $ref
  3. $default
  4. &id

24. Which of the following schema properties takes schema as value in JSON?

Answers:

  1. extends
  2. pattern
  3. options
  4. transient

25. While using JSONRequest.cancel, what will happen to the request if it is still in the outgoing message queue?

Answers:

  1. It will be deleted from the queue.
  2. It will abort.
  3. It will call the done function of the request with an exception message of “cancelled”.
  4. None of the above

26. Which of the following JSONPath elements represents the root object/element?

Answers:

  1. /
  2. $
  3. @
  4. .

27. What does the [start:end:step] element of JSONPath signify?

Answers:

  1. It represents a subscript operator.
  2. It represents recursive descent.
  3. It represents attribute access.
  4. It represents an array slice operator.

28. In order to find the last book, which of the JSONPath codes will you use?

Answers:

  1. //book[(,length-1)] $..book[-1]
  2. $..book[(@.length-1)] $.book[-1:]
  3. $..book[(@length-1)] $.book[-1]
  4. $..book[(@.length-1)] $..book[-1:]

29. Which of the following parameter values cannot be serialized in JSONRequest?

Answers:

  1. timeout
  2. done
  3. url
  4. send

30. Which of the following schema properties does not need to be validated by JSON validators?

Answers:

  1. format
  2. pattern
  3. enum
  4. transient

31. Which of the following schema properties always has a unique value for all its instances in JSON?

Answers:

  1. requires
  2. identity
  3. readonly
  4. disallow

32. Which of the following features of JSON has the property of exemption from the same origin policy?

Answers:

  1. JSONRequest
  2. Module
  3. JSONT
  4. JSLint

33. In the above code snippet, what is the purpose of declaring the JSONRequest.post?

Answers:

  1. It will queue the request and call the done function.
  2. It will queue the request and return the request number.
  3. It will queue the request and return the request number and authentication information.
  4. None of the above

34. Which of the following serialization formats is/are supported by JSON?

Answers:

  1. Recurring structures
  2. Invisible structures
  3. Functions
  4. None of the above

35. If a schema property is declared false, which of the following attributes can not be used to extend the schema?

Answers:

  1. pattern
  2. transient
  3. format
  4. additionalProperties

36. Which of the following correctly describes the term tuple typing in JSON Schema?

Answers:

  1. Properties should be an object type with property definitions corresponding to instance object properties.
  2. It provides an enumeration of possible values that are valid for the instance property. It should be an array, and each item in the array should represent a possible value for the instance value.
  3. Items should be a schema or an array of schemas and the instance value should be an array with all the items in the array conforming to this schema.
  4. It indicates the format of the data from among predefined formats. This property does not need to be validated by validators.

37. Which syntax is correct for the jsonPath() function during the implementation of JSONPath?

Answers:

  1. jsonPath(src, expr [, args])
  2. jsonPath(obj, expr [, args],URL)
  3. jsonPath(obj, expr [, args])
  4. jsonPath(obj, expr [, args],src)

38. In the code snippet below, which line contains an error?

Line1: {
Line2: “id”:”person”,
Line3: “type”:”object”,
Line4: “properties”:{
Line5: “name”:{“type”:”string”},
Line6: “age”:{“type”:”integer”}
Line7: }
Line8: }
Line9: {
Line10:”id”:”marriedperson”,
Line11: “extends”:{“ref”:”person”},
Line12: “properties”:{
Line13: “age”:{“type”:”integer”,
Line14: “minimum”:17},
Line15: }
Line16: }

Answers:

  1. Line 3
  2. Line 6
  3. Line 11
  4. Line 12

39. Which of the following correctly describes the JSON Schema?

Answers:

  1. It is intended to provide validation and interaction control of the JSON data.
  2. It is a JSON Object that defines the various attributes of the instance.
  3. It does not support the serialization/deserialization tools.
  4. It is a JSON extension wherein a prefix is specified as an input argument of the call itself. This prefix is typically the name of a callback function.

40. Which of the following parameters of JSONRequest hold/s the information of implicit authentication and cookies during post operation?

Answers:

  1. src
  2. done
  3. send
  4. url

1,941 total views, 4 views today

Upwork Internet Programming

Facebook Development Test 2016

Published by:

1. In which situations will you recieve the $API_EC_TIMEOUT error?

Answers:

  1. When the user’s login credentials for Facebook are incorrect.
  2. When the applications API key is invalid.
  3. When the user already has an application session open with another application.
  4. When the current session key expires.

2. Finished applications that have been submitted show up in…

Answers:

  1. Google
  2. Developers Discussion Group
  3. Developers News Feed
  4. Facebook Application Directory

3. A developer has to be logged in to use the test console.

Answers:

  1. True
  2. False

4. A Facebook application can have an infinite session:

Answers:

  1. True
  2. False

5. For a balanced and centered profile box your content must be about how many pixels wide?

Answers:

  1. 75px
  2. 180px
  3. 220px

6. To override your callback url you must pass the following parameter to the Facebook API:

Answers:

  1. override
  2. url
  3. canvas
  4. nextpage

7. How does the Facebook API tie accepted IP addresses to your application?

Answers:

  1. The first IP to connect to the application is always allowed and the rest are disabled.
  2. A variable called valid_ips is passed upon logging into the application.
  3. When the api_key variable is passed to FBAPI the API can pull these IP’s from your application profile.

8. Applications can send notification messages to a Facebook user’s inbox.

Answers:

  1. True
  2. False

9. How can an application publish a user action to the public news feed?

Answers:

  1. fql.publishStory
  2. notifications.send
  3. feed.publishActionOfUser
  4. Facebook servers do this automatically.

10. FQL stands for…

Answers:

  1. Facebook Quotation Layer
  2. Free Query Logistics
  3. Facebook Query Logistic
  4. Facebook Query Layer
  5. Facebook Query Language

11. API stands for…

Answers:

  1. A Programmatic Inheritance
  2. Alpha Production Interface
  3. Alpha Programming Service
  4. Application Programming Interface

12. Which of the following is not a FQL table?

Answers:

  1. user
  2. friend
  3. email_address
  4. group
  5. group_member

13. Email notifications are sent in plain text only; they do not support html.

Answers:

  1. True
  2. False

14. How do you change the format that Facebook methods will use to return data to your application?

Answers:

  1. Change the format in your application preferences.
  2. Your application must format the data to the type you want.
  3. Your application will pass a ‘format’ GET variable to the API indicating a supported format.
  4. You cannot change the format; Facebook only supports XML.

15. Email notifications must always include the fb:name tag in the beginning email body.

Answers:

  1. True
  2. False

16. When creating a photo album, what is the default return value for cover_pid?

Answers:

  1. 1
  2. the same as your album_id
  3. 101
  4. 0

17. If your API key is invalid you will receive the following error number from the Facebook API:

Answers:

  1. 1
  2. 3
  3. 565
  4. 101
  5. 102

18. A user must log into Facebook before using your application.

Answers:

  1. True
  2. False

19. Email notifications can be sent by passing the email param to which method?

Answers:

  1. notifications.send
  2. notification.sendEmail
  3. notify.email
  4. notifications.email

20. Error code 103 indicates that your signature is incorrect.

Answers:

  1. True
  2. False

21. The FQL syntax equivalent to the friends.get method is…

Answers:

  1. SELECT friends FROM user_friends WHERE userid1=loggedInUid
  2. SELECT this FROM friends WHERE uid1=loggedInUid
  3. SELECT uid2 FROM friend WHERE uid1=loggedInUid
  4. SELECT user_friends FROM users WHERE (uid1=loggedInUid and friends=uid2)

22. Error code 103 indicates that….

Answers:

  1. The application has reached the maximum amount of requests allowed.
  2. The service is not allowed at this time.
  3. The submitted call_id has not incremented since the last call_id was passed.
  4. An unknown error has occurred.

23. At most an application can send how many notifications per day?

Answers:

  1. 60
  2. 40
  3. 25
  4. 10

24. FBML stands for…

Answers:

  1. Facebook Meeting Layer
  2. Facebook Manipulation Layer
  3. Facebook Mega Language
  4. Facebook Markup Language

25. Desktop applications must use which protocol when executing the auth.createToken method?

Answers:

  1. HTTP
  2. HTTPS
  3. IMAP
  4. JSON

26. Facebook API is only compatible with open source servers like Linux.

Answers:

  1. True
  2. False

27. What are Profile Action Links?

Answers:

  1. Links on your application which lead to a user’s profile.
  2. Links on a user’s profile at the bottom of the page leading to your application.
  3. Links under the user’s profile picture which link to more information about their use of your application.

28. Facebook Applications can use cross-domain scripting by submitting which variable when authenticating the auth token?

Answers:

  1. sig
  2. domain_script
  3. callback
  4. script_token

29. Which of the following is not an event RSVP status?

Answers:

  1. attending
  2. not sure
  3. declined
  4. not_replied

30. On the application’s About Page a user will always see all of the developer’s personal Facebook account information.

Answers:

  1. True
  2. False

31. How can you find out which of the user’s friends are also subscribed to your application?

Answers:

  1. You cannot find this out.
  2. fql.query(“select user, uid from friends where app_id='”.$appID.”‘);
  3. friends.getAppUsers()

32. The FB API requires only one key to be passed when connecting.

Answers:

  1. True
  2. False

33. The only way to get the Facebook ID of the user who is logged in is to use this method: users.getLoggedInUser

Answers:

  1. True
  2. False

34. Which Hex color code does Facebook use for the Header and Links?

Answers:

  1. #3b5998
  2. #ddefef
  3. rgb(244,344,22)
  4. #ccc

35. FQL supports certain string function calls that can evaluate a string before executing a query.

Answers:

  1. True
  2. False

36. Within a Facebook Application the ‘canvas page’ is…

Answers:

  1. A small box on the user’s profile page for the application to run in.
  2. A large news feed box on the user’s profile page that the application runs in.
  3. A sidebar application that runs in the user’s profile.
  4. The right column of the Facebook site. It can be as large, or larger than a user’s profile page.

37. The Facebook v1 API supports SOAP protocols.

Answers:

  1. True
  2. False

1,158 total views, 6 views today

Upwork Internet Programming

ASP.NET with SQL Server Test 2016

Published by:

1. You are creating an ASP.NET application that is hosted on your company’s Web server. You want to access a database with minimal effort. What you will not do?

Answers:

  1. Begin a transaction
  2. Create a connection to the database
  3. Create a data set using an adapter object
  4. Use the data set to display data or to change items in the database
  5. Update the database from the data set
  6. Close the database connection
  7. Check for transaction errors

2. Which of the following are aggregate functions in SQL?

Answers:

  1. Avg
  2. Select
  3. Order By
  4. Sum
  5. Union
  6. Group by
  7. Having

3. You create an ASP.NET application for an online insurance site PremiumInsurance. A page named PersonalDetails.aspx has the following Page directive:

<%@ Page Language=”VB” CodeBehind=”PersonalDetails.aspx.vb” AutoEventWireup=”false” inherits=”InsApp.PersonalDet”%>

PersonalDetails.aspx had a TextBox control named MemberID in which the user can enter a Personal MemberID. The HTML code for this control is as follows:

<asp:TextBox ID=”MemberID” Columns=”20″ Runat=”server”/>
You need to implement a TextChanged event handler for MemberID. You want this event handler to retrieve information about a person by using an XML Web service that charges for each access. The page will then be redisplayed with additional information about the vehicle obtained from the XML Web service.
You are implementing the TextChanged event handler. Which two courses of action should you take? (Each correct answer presents part of the solution. Choose two)

Answers:

  1. In the Page directive for PersonalDetails.aspx, ensure that the AutoEventWireup attributes is set to “true”.
  2. In the Page directive for PersonalDetails.aspx, ensure that the EnableViewState attribute is set to “true”.
  3. In the MemberID HTML element, ensure that the AutoPostback attribute is set to “false”. Include code for the client-side onserverchange event to submit the Web Form for processing by the server.
  4. In the MemberID HTML element, ensure that the AutoPostback attribute is set to “true”. Include code in the TextChanged event handler to query the XML Web service.

4. The simplest query must include at least________ and _________.

Answers:

  1. A select clause
  2. A where clause
  3. A from clause
  4. A group by clause
  5. A having clause
  6. An order by clause

5. You are the software engineer for Premium Corp.. One of the pages in an ASP.NET application contains the following declaration:

<%@ Register Tagprefix=”WoodySideBankControls” Namespace=”WoodySideBankNameSpace” Assembly=”MyAssembly” %>

The assembly named MyAssembly contains a custom server control named CSC1. Which of the following code samples will properly render CSC1 on the Web page?

Answers:

  1. <WoodySideBankControls:CSC1 id=”Control1″ runat=”server” />
  2. <WoodySideBankNameSpace:CSC1 id=”Control1″ runat=”server” />
  3. <WoodySideBankControls:Control1 id=”CSC1″ runat=”server” />
  4. <WoodySideBankNameSpace:Control1 id=”CSC1″ runat=”server” />

6. LAST_NAME DEPARTMENT_ID SALARY
ALLEN 10 3000
MILLER 20 1500
King 20 2200
Davis 30 5000

Which of the following Subqueries will execute without any error?

Answers:

  1. SELECT distinct department_id FROM employees Where salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
  2. SELECT distinct department_id FROM employees Where salary > (SELECT AVG(salary) FROM employees GROUP BY department_id);
  3. SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
  4. SELECT distinct department_id FROM employees Where salary > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
  5. SELECT distinct department_id FROM employees Where salary < (SELECT AVG(salary) FROM employees GROUP BY department_id);

7. What will happen if you query the emp table as shown below:

select empno, DISTINCT ename, Salary from emp;

Answers:

  1. EMPNO, unique value of ENAME and then SALARY are displayed
  2. EMPNO, unique value ENAME and unique value of SALARY are displayed
  3. DISTINCT is not a valid keyword in SQL
  4. No values will be displayed because the statement will return an error

8. You are debugging an ASP.NET application for Premium Corp.. Users will use the application to produce reports. Your application contains several Debug.WriteLine statements. Which window in Visual Studio .NET should you use to inspect output from the Debug.WriteLine statements?

Answers:

  1. Command
  2. Locals
  3. Output
  4. Breakpoints

9. Examine the query:-

select (2/2/4) from tab1;

where tab1 is a table with one row. This would give a result of:

Answers:

  1. 4
  2. 2
  3. 1
  4. .5
  5. .25
  6. 0
  7. 8
  8. 24

10. Is it possible to insert several rows into a table with a single INSERT statement?

Answers:

  1. No
  2. Yes

11. You use a Command object to retrieve employee names from the employee table in the database. Which of the following will be returned when this command is executed using ExecuteReader method?

Answers:

  1. DataRow
  2. DataSet
  3. DataTable
  4. DataReader

12. Which of the following are the valid methods of the SqlTransaction class?

Answers:

  1. Commit
  2. Terminate
  3. Save
  4. Close
  5. Rollback

13. Which of the two statements is true?

(a)MSIL code is platform independent
(b)CLR is platform dependent

Answers:

  1. Only (a) is true, (b) is false
  2. Only (b) is true, (a) is false
  3. Both (a) and (b) are true
  4. Both (a) and (b) are false

14. Consider the following two statements relating to ASP.NET and choose the most appropriate option:

Statement 1: Value types are allocated on a stack
Statement 2: Reference types are allocated on a managed CLR Heap

Answers:

  1. Statement 1 is true and statement 2 is false
  2. Statement 2 is true and statement 1 is false
  3. Both statements 1 and 2 are true
  4. Both statements 1 and 2 are false

15. You are debugging a Visual Basic.NET application. You add a variable to the watch window. When Visual Basic enters break mode, the Value of the expression variable is “”. What is the most likely cause of the problem?

Answers:

  1. The variable is not currently in scope.
  2. The variable has been defined as public.
  3. The variable has been defined as private.
  4. The variable has not been defined in this project.

16. Check the following code:

Public Shared Sub UpdateData(ByVal sql As String,ByVal connectionString As String, ByVal dataTable As DataTable)

Dim da As New OleDb.OleDbDataAdapter()
Dim cnn As New OleDb.OleDbConnection(connectionString)
dataTable.AcceptChanges()
da.UpdateCommand.CommandText = sql
da.UpdateCommand.Connection = cnn
da.Update(dataTable)
da.Dispose()
End Sub

You are creating an ASP.NET application that will be used by companies to quickly create information portals customized to their business. Your application stored commonly used text strings in application variables for use by the page in your application. You need your application to initialize these text strings only when the first user accesses the application. What should you do?

Answers:

  1. Add code to the Application_OnStart event handler in the Global.asax file to set the values of the text strings.
  2. Add code to the Application_BeginRequest event handler in the Global.asax file to set the values of the text strings.
  3. Add code to the Session_OnStart event handler in the Global.asax file to set the values of the text strings.
  4. Include code in the Page.Load event handler for the default application page that sets the values if the text strings when the
  5. IsPostback property of the Page object is False.
  6. Include code in the Page.Load event handler for the default application page that sets the values of the text strings when the IsNewSession property of the Session object is set to True.

17. Examine the code given below:

SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000

Which of the following statements is correct with regard to this code?

Answers:

  1. It returns employees whose salary is 50% more than $23,000
  2. It returns employees who have 50% commission rate or salary greater than $23,000
  3. It returns employees whose salary is 50% less than $23,000
  4. None of the above

18. Evaluate the following SQL statement:

SELECT e.employee_id,( (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus))) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id;�

What will happen if all the parentheses are removed from the calculation?

Answers:

  1. The value displayed in the CALC_VALUE column will be lower
  2. The value displayed in the CALC_VALUE column will be higher
  3. There will be no difference in the value displayed in the CALC_VALUE column
  4. An error will be reported

19. You are creating an ASP.NET page for Premium Consultants. You create a GridView control that displays past purchases made by the user. The GridView control is populated from an existing database when the page is created. The page contains TextBox controls that allow users to update their personal information, such as address and telephone number. You need to ensure that the page is refreshed as quickly as possible when users update their contact information.
What should you do?

Answers:

  1. Set the Enabled property of the GridView control to false.
  2. Set the EnableViewState property of the GridView to false.
  3. Write code in the Page.Load event handler that populates the GridView control only when the IsPostBack property of the page is false.
  4. Write code in the Page.Load event handler that populates the GridView control only when the IsPostBack property of the page is true.

20. Sam is developing an application that enables the users to perform read and write operations on text files. He uses structured exception handling to handle the errors. He writes the code for closing all the files that were opened in the Finally block. Which of the following is true regarding the Finally block?

Answers:

  1. Finally block will be executed only if an error occurs
  2. Finally block is executed after Catch block when no error occurs
  3. Finally block is executed after Try block regardless of whether an error occurs
  4. Finally block is executed only when no error occurs

21. You are creating an ASP.NET application that will record each customer’s entry. It is possible that thousands of entries could be posted at any given time. Your application will be hosted on twenty Web servers. As customers enter information into your application, maintaining state information will be important. This information should be stored securely and should be capable of being restored in the event that a Web server is restarted. Customers will enter data into three separate pages in your application. Which of the following methods of storing state information would best suit the situation?

Answers:

  1. View State
  2. Hidden fields
  3. State Server
  4. Application state
  5. SQL Server

22. You are creating an ASP.net application to enter timesheet data intuitively. Users will enter data using a DataGrid. You have added a button column to your DataGrid. The button column uses a custom button to allow users to initiate some calculations on the data in the grid. Which event does the DataGrid control raise when the custom button is clicked?

Answers:

  1. EditCommand
  2. OnClick
  3. ButtonClicked
  4. ItemCommand

23. Which line of code should you use to copy the edited rows from dataset productInfo into another dataset productChanges?

Answers:

  1. productChanges = productInfo.GetChanges(DataRowState.Detached)
  2. productChanges = productInfo.GetChanges()
  3. productChanges.Merge(productInfo, true)
  4. productChanges.Merge(productInfo, false)

24. You are maintaining data for its products in the Products table, and you want to see those products, which are 50 items that is currentStock or more than 50 but less than the minimum stock limit of items. The structure of the Products table is:

ProductID
ProductName
CurrentStock
MinimumStock

Two possible queries are:

(a)select * from products where currentStock > MinimumStock + 50
(b)select * from products where currentStock – 50 > MinimumStock

Choose the appropriate option with regard to the above queries.

Answers:

  1. (a) is correct
  2. (b) is correct
  3. (a) and (b) both are correct
  4. (a) and (b) both are incorrect

25. How you will generate a report with minimum network traffic?

Answers:

  1. Use Microsoft SQL Server indexes to optimize the data calculations
  2. Implement the calculations in a business layer class
  3. Implement the calculations in a data layer class
  4. Use Microsoft SQL Server stored procedures for the data calculations

26. You are creating an ASP.NET Web site for your company. The Web site will use both Microsoft(R) .NET Framework server controls and ActiveX controls. You want to use Microsoft Visual Studio(R) .NET to create a Setup and Deployment project to package the ActiveX controls. Which project type should you create?

Answers:

  1. Cab
  2. Merge Module
  3. Web Setup
  4. Setup

27. In SQL Server, you should avoid the use of cursors because:

Answers:

  1. They are very difficult to implement
  2. Programs with cursors take more time to run, hence performance degrades
  3. Programs with cursors are more lengthy, hence they consume more space/memory
  4. No, you must maximize the use of cursors because they improve performance

28. Which one of the following correctly selects rows from the table myTable that have null in column column1?

Answers:

  1. SELECT * FROM myTable WHERE column1 is null
  2. SELECT * FROM myTable WHERE column1 = null
  3. SELECT * FROM myTable WHERE column1 EQUALS null
  4. SELECT * FROM myTable WHERE column1 NOT null
  5. SELECT * FROM myTable WHERE column1 CONTAINS null

29. Consider the following queries:

1. select * from employee where department LIKE ‘[^F-M]%’;
2. select * from employee where department = ‘[^F-M]%’;

Select the correct option:

Answers:

  1. Query 2 will return an error
  2. Both the queries will return the same set of records
  3. Query 2 is perfectly correct
  4. Query 2 would return one record less than Query 1

30. You need to install an online parcel tracking application and its supporting assemblies so that the application and its assemblies can be uninstalled using the Add/Remove Programs Control Panel applet. What should you do?

Answers:

  1. Use a Web installation package for the Web application. Use the Global Application Cache (GAc)utility, GACUtil.exe, to install the supporting assemblies into the GAC.
  2. Use Xcopy deployment for the Web application and its supporting assemblies.
  3. Use Xcopy deployment to deploy the Web application. Use merge modules to install the supporting assemblies.
  4. Use a Web installation package to install the Web application and the supporting assemblies.

31. Which of the following is not a valid SQL operator?

Answers:

  1. Between..and..
  2. Like
  3. In
  4. Is null
  5. Having
  6. Not in
  7. All of the above are valid.

32. You create an ASP.NET page that allows a user to enter a requested delivery date in a TextBox control named txtDelDate. The date must be no earlier than two business days after the order date, and no later that 60 business days after the order date. You add a CustomValidator control to your page. In the Properties window, you set the ControlToValidate property to txtDelDate. You need to ensure that the date entered in the txtDelDate TextBox control falls within the acceptable range of values. In addition, you need to minimize the number of round trips to the server. What should you do?

Answers:

  1. Set the AutoPostBack property of txtDelDate to False. Write code in the ServerValidate event handler to validate the date.
  2. Set the AutoPostBack property of txtDelDate to True. Write code in the ServerValidate event handler to validate the date.
  3. Set the AutoPostBack property of txtDelDate to False. Set the ClientValidationFunction property to the name of a script function contained in the HTML page that is sent to the browser.
  4. Set the AutoPostBack property of txtDelDate to True. Set the ClientValidationFunction property to the name of a script function contained in the HTML page that is sent to the browser.

33. In ASP.NET, the exception handling should be used:

Answers:

  1. to signal the occurrence of unusual or unanticipated program events
  2. to redirect the program’s normal flow of control
  3. in cases of potential logic or user input errors
  4. in case of overflow of an array boundary

34. How can you view the results of Trace.Write() statements?

Answers:

  1. By enabling page tracing
  2. By enabling application tracing
  3. By enabling server tracing
  4. By looking up the system.log file

35. Which of the following are false for ASP.NET events?

Answers:

  1. Events are specialized forms of delegates
  2. Events are used to support the callback event notification model
  3. The signature of any event handler is fixed
  4. All of the above are true

36. What will happen if the Server configuration file and the Application configuration file have different values for session state?

Answers:

  1. The Server configuration will always override the Application configuration
  2. The Application configuration will always override the Server configuration
  3. The Server configuration will override the Application configuration if allowOverride is set to “false” in the settings in the Server configuration file
  4. The Application configuration will override the Server configuration if allowOverride is set to “false” in the settings in the Server configuration file

37. A company has the following departments:

Marketing, Designing, production, Packing

What will be the result of the following query?

select * from table where department < ‘marketing’;

Answers:

  1. The query will return “Designing, Packing”
  2. The query will return “Designing, production, Packing”
  3. The query will return “packing”
  4. Strings cannot be compared using < operator
  5. The query will return “Designing”

38. Your company, StoreIt Inc has stored the text of several journals in a Microsoft SQL Server 7.0 database. Each sentence is stored in a separate record so that the text can be retrieved with the finest granularity. Several of these works are many thousands of printed pages in length. You are building a Web application that will allow registered users to retrieve data from these volumes. When a user of your Web application requests large amounts of text, your application must return it in the most efficient manner possible. How should you build the large String object that is required to provide the most efficient response to the user?

Answers:

  1. Use a RichTextBox object to hold the data as it is being concatenated.
  2. Use the Append method of the String class.
  3. Use the String class and the & operator.
  4. Use the StringBuilder class.

39. The sales database contains a customer table and an order table. For each order there is one and only one customer, and for each customer there can be zero or more orders. How should primary and foreign key fields be placed into the design of this database?

Answers:

  1. A primary key should be created for the customer_id field in the customer table and also for the customer_id field in the order table
  2. A primary key should be created for the order_id field in the customer table and also for the customer_id field in the order table
  3. A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the customer_id field in the order table
  4. A primary key should be created for the customer_id field in the customer table and a foreign key should be created for the order_id field in the order table
  5. None of these

40. You want to access data from the “Customer” table in the database. You generate a DataSet named “MyDataSet” by adding “Customer” table to it. Which of the following statements should you use to load the data from the database into “MyDataSet” which has been loaded with multiple tables, using a SqlDataAdapter named “MyAdapter”?

Answers:

  1. MyAdapter.Fill(MyDataSet,”Customer”)
  2. MyAdapter.Fill(“MyDataSet”,Customer)
  3. MyAdapter.Fill(MyDataSet)
  4. MyAdapter.Fill(“MyDataSet”)

41. What is the order of precedence among the following operators?

1 IN
2 NOT
3 AND
4 OR

Answers:

  1. 1,2,3,4
  2. 2,3,4,1
  3. 1,2,4,3
  4. 1,4,3,2
  5. 4,3,2,1
  6. 4,1,2,3
  7. 4,2,1,3
  8. 3,2,1,4

42. Which query will display data from the Pers table relating to Analysts, clerks and Salesmen who joined between 1/1/2005 and 1/2/2005?

Answers:

  1. select * from Pers where joining_date from ‘1/1/2005’ to ‘1/2/2005’, job= ‘Analyst’ or ‘clerk’ or ‘salesman’
  2. select * from Pers where joining_date between ‘1/1/2005’ to ‘1/2/2005’, job= ‘Analyst’ or job= ‘clerk’ or job= ‘salesman’
  3. select * from Pers where joining_date between ‘1/1/2005’ and ‘1/2/2005’ and (job= ‘Analyst’ or ‘clerk’ or ‘salesman’)
  4. None of the above

43. What is the correct order of clauses in the select statement?

1 select
2 order by
3 where
4 having
5 group by

Answers:

  1. 1,2,3,4,5
  2. 1,3,5,4,2
  3. 1,3,5,2,4
  4. 1,3,2,5,4
  5. 1,3,2,4,5
  6. 1,5,2,3,4
  7. 1,4,2,3,5
  8. 1,4,3,2,5

44. Which of the following queries is valid?

Answers:

  1. Select * from students where marks > avg(marks);
  2. Select * from students order by marks where subject = ‘SQL’;
  3. Select * from students having subject =’SQL’;
  4. Select name from students group by subject, name;
  5. Select group(*) from students;
  6. Select name,avg(marks) from students;
  7. None of the above

45. Which of the following is the syntax for creating an Index?

Answers:

  1. CREATE [UNIQUE] INDEX index_name OF tbl_name (index_columns)
  2. CREATE [UNIQUE] INDEX OF tbl_name (index_columns)
  3. CREATE [UNIQUE] INDEX ON tbl_name (index_columns)
  4. CREATE [UNIQUE] INDEX index_name ON tbl_name (index_columns)

46. You have developed a custom server control and have compiled it into a file named FirstReport.dll.
The code is displayed below:

<%@ Register TagPrefix=” CertKing Tag” Namespace=”ReportNS” Assembly=” CertKing Report” %>

You want to set the PageNumber property of the control to 77.

Which of the following lines of code should you include in your Web Form?

Answers:

  1. < CertKing Tag:ReportNS PageNumber=”77″ runat=”server” />
  2. <myReport PageNumber=”77″ src=”rptctrl” runat=”server” />
  3. < CertKing Tag:myReport PageNumber=”77″ runat=”server” />
  4. <% Control TagName=”myReport” src=”rptctrl” runat=”server” %>

47. You are creating an ASP.NET page for your company’s Web site. Customers will use the ASP.NET page to enter payment information. You add a DropDownList control named oPaymentTypeList that enables customers to select a type of credit card and bank accounts. You need to ensure that customers select a credit card type. You want a default value of Select to be displayed in the oPaymentTypeList control. You want the page validation to fail if a customer does not select a payment type from the list. What should you do?

Answers:

  1. Add a RequiredFieldValidator control and set its ControlToValidate property to oPaymentTypeList. Set the InitialValue property of the RequiredFieldValidator control to Select.
  2. Add a RequiredFieldValidator control and set its ControlToValidate property to oPaymentTypeList. Set the DataTextField property of the oPaymentTypeList control to Select.
  3. Add a CustomValidator control and set its ControlToValidate property to oPaymentTypeList. Set the DataTextField property of the oPaymentTypeList control to Select.
  4. Add a RegularExpressionValidator control and set its ControlToValidate property to oPaymentTypeList. Set the ValidateExpression property of the RegularExpressionValidator control to Select.

48. How can you change “Hansen” into “Nilsen” in the LastName column in the Persons Table?

Answers:

  1. UPDATE Persons SET LastName = ‘Nilsen’ WHERE LastName = ‘Hansen’
  2. UPDATE Persons SET LastName = ‘Hansen’ INTO LastName = ‘Nilsen’
  3. SAVE Persons SET LastName = ‘Nilsen’ WHERE LastName = ‘Hansen’
  4. SAVE Persons SET LastName = ‘Hansen’ INTO LastName = ‘Nilsen’

49. You create an ASP.NET application for ABC Corporation. The project manager requires a standard appearance for all Web applications. Standards are expected to change periodically. You need to enforce these standards and reduce maintenance time. What would you do?

Answers:

  1. Create a Microsoft Visual Studio .NET Enterprise template
  2. Create a sample HTML page
  3. Create a sample ASP.NET Web form
  4. Create a cascading style sheet

50. Which operator will be evaluated first in the following statement:

select (age + 3 * 4 / 2 – 8) from emp

Answers:

  1. +
  2. /
  3. *

51. When you make some changes to the configuration file, do you need to stop and start IIS to apply the new settings?

Answers:

  1. Yes
  2. No

52. What is wrong with the following query:

select * from Orders where OrderID = (select OrderID from OrderItems where ItemQty > 50)

Answers:

  1. In the sub query, ‘*’ should be used instead of ‘OrderID’
  2. The sub query can return more than one row, so, ‘=’ should be replaced with ‘in’
  3. The sub query should not be in parenthesis
  4. None of the above

53. Which of the following is the default configuration file for each application in ASP.NET?

Answers:

  1. config.web
  2. web.config
  3. sys.config
  4. config.sys

54. In which sequence are queries and sub-queries executed by the SQL Engine?

Answers:

  1. primary query -> sub query -> sub sub query and so on
  2. sub sub query -> sub query -> prime query
  3. the whole query is interpreted at one time
  4. there is no fixed sequence of interpretation, the query parser takes a decision on the fly

55. You are developing a website that has four layers. The layers are user interface (web pages), business objects, data objects, and database. You want to pass data from the database to controls on a web form. What should you do?

Answers:

  1. Populate the data objects with data from the database. Populate the controls with values retrieved from the data objects.
  2. Populate the business objects with data from the database. Populate the controls with values retrieved from the business objects.
  3. Populate the data objects with data from the database. Populate the business objects with data from the data objects. Populate
  4. the controls with values retrieved from the business objects
  5. Bind the controls directly to the database.

56. Consider the following two tables:

1. customers( customer_id, customer_name)
2. branch ( branch_id, branch_name )

What will be the output if the following query is executed:

Select *, branch_name from customers,branch

Answers:

  1. It will return the fields customer_id, customer_name, branch_name
  2. It will return the fields customer_id, customer_name, branch_id, branch_name
  3. It will return the fields customer_id, customer_name, branch_id, branch_name, branch_name
  4. It will return an empty set since the two tables do not have any common field name
  5. It will return an error since * is used alone for one table only

57. Which of the following are not true in ASP.NET?

Answers:

  1. A try block can have more than one catch blocks
  2. Every try block must have a catch block
  3. Every try block must have a finally block
  4. All exception classes are to be derived from System.Exception

58. XYZ is creating an e-commerce site for PremiumBoutique. The site is distributed across multiple servers in a Web farm. Users will be able to navigate through the pages of the site and select products for purchase. XYZ wants to use a DataSet object to save their selections. Users will be able to view their selections at any time by clicking a Shopping Cart link. XYZ wants to ensure that each user’s shopping cart DataSet object is saved between requests when the user is making purchases on the site. How can this requirement be implement?

Answers:

  1. Create a StateBag object. Use the StateBag object to store the DataSet object in the page’s ViewState property
  2. Use the HttpSessionState object returned by the Session property of the page to store the DataSet object. Use the Web.config file to configure an out-of-process session route
  3. Use the Cache object returned by the page’s Cache property to store a DataSet object for each user. Use an HttpCachePolicy object to set a timeout period for the cached data
  4. Use the Session_Start event to create an Application variable of type DataSet for each session. Store the DataSet object in the Application variable

59. In ASP.NET, which of the following is not an event of the Page class?

Answers:

  1. Init
  2. Load
  3. Error
  4. Abort

60. Is the FROM clause necessary in every SELECT statement?

Answers:

  1. Yes
  2. No

61. Which DLL is responsible for processing the page requests running on the server?

Answers:

  1. Internet Server Application Programming Interface
  2. Internet Information Server Program
  3. Webserver interface
  4. IIS Application

62. What is the total no. of events in Global.asax file in Asp.NET?

Answers:

  1. 20
  2. 25
  3. 19
  4. 32

63. Which of the following datatypes is not supported by SQL-Server?

Answers:

  1. Character
  2. Binary
  3. Logical
  4. Date
  5. Numeric
  6. All are supported

64. It is time for the annual sales awards at your company. The awards include certificates awarded for the five sales of the highest sale amounts. You need to produce a list of the five highest revenue transactions from the Orders table in the Sales database. The Orders table is defined as follows:

CREATE TABLE Orders (
OrderID Int IDENTITY NOT NULL,
SalesPersonID Int NOT NULL,
RegionID Int NOT NULL,
OrderDate Datetime NOT NULL,
OrderAmount Int NOT NULL )

Which statement will produce the report correctly?

Answers:

  1. SELECT TOP 5 OrderAmount, SalesPersonID FROM orders
  2. SELECT TOP 5 OrderAmount, SalesPersonID FROM orders ORDER BY OrderAmount DESC
  3. SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders
  4. SELECT TOP 5 WITH TIES OrderAmount, SalesPersonID From Orders ORDER BY OrderAmount

65. Consider the transaction:

Begin Transaction
Create table A ( x smallint, y smallint)
Create table B ( p smallint, q smallint)

Update A set x=600 where y > 700
Update B set p=78 where q=99

If @@ error != 0
Begin
RollBack Transaction
Return
End

Commit Transaction

Select the correct option:

Answers:

  1. The transaction will work perfectly fine
  2. It will report an error
  3. The error handling routine contains a syntax error
  4. None of the above
  5. Both b and c

66. A production house needs a report about the sale where total sale of the day is more than $20,000. Which query should be used?

Answers:

  1. select * from orders where sum(amount) > 20000
  2. select * from orders where sum(amount) > 20000 order by OrderDate
  3. select * from orders group by OrderDate having sum(amount)>20000
  4. select * from orders group by OrderDate where sum(amount) > 20000

67. In ASP.NET, the control’s value set during the postback can be accessed in:

Answers:

  1. Page_Init
  2. Page_Load
  3. Both Page_Init and Page_Load
  4. Neither in Page_Load nor Page_Init

68. Which of the following connectionstring in Web.Config is correct if Microsoft SQL Server database named ClassList resides on a server named Neptune is to be used?

Answers:

  1. <add key=”SqlConnect” value=”Data Source=Neptune;Initial Catalog=ClassList;Persist Security Info=True;User ID=xyz;Password=abc”>
  2. <add key=”SqlConnect” value=”Data Source=ClassList;Initial Catalog=Neptune;Persist Security Info=True;User ID=xyz;Password=abc”>
  3. <add key=”SqlConnect” value=”Data Source=abc;Initial Catalog=xyz;Persist Security Info=True;User ID=Neptune;Password=ClassList”>
  4. <add key=”SqlConnect” value=”Data Source=abc;Initial Catalog=xyz;Persist Security Info=True;User ID=ClassList;Password=Neptune”>

69. What does the following line of code do?

<%@ Register tagprefix=”ril” Tagname=”test” Src=”rilTest.ascx” %>

Answers:

  1. Register a new web site
  2. Register a new tag
  3. Register a new user control
  4. Register a new web page

70. In which of the following namespaces is the Assembly class defined?

Answers:

  1. System.Assembly
  2. System.Reflection
  3. System.Collections
  4. System.Object

71. What data types do the RangeValidator control support?

Answers:

  1. Integer, String, and Date
  2. char, String, and Date
  3. Integer, String, and varchar
  4. Integer, bool, and Date

72. Examine the two SQL statements given below:

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC

SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC

What is true about them?

Answers:

  1. The two statements produce identical results
  2. The second statement returns an error
  3. There is no need to specify DESC because the results are sorted in descending order by default
  4. None of the above

73. You are creating an ASP.NET application. The application will be deployed on intranet. Application uses Microsoft Windows authentication. More than 100 users will use the ASP.NET application simultaneously. What setting should be done by the project manager regarding user authentication?

Answers:

  1. Add the following element to the authentication section of the Web.config file: <allow users=”?”/>
  2. Use the Configuration Manager for your project to designate the user’s security context.
  3. Write code in the Application_AuthenticateRequest event handler to configure the application to run in the user’s security context.
  4. Add the following element to the system.web section of the Web.config file: <identity impersonate=”true”/>

74. The names of those departments where there are more than 100 employees have to be displayed. Given two relations, employees and departments, what query should be used?

Employee
———
Empno
Employeename
Salary
Deptno

Department
———
Deptno
Departname

Answers:

  1. Select departname from department where deptno in (select deptno from employee group by deptno having count(*) > 100);
  2. Select departname from department where deptno in (select count(*) from employee group by deptno where count(*) > 100);
  3. Select departname from department where count(deptno) > 100;
  4. Select departname from department where deptno in (select count(*) from employee where count(*) > 100);

75. Which of the following constraints can be used to enforce the uniqueness of rows in a table?

Answers:

  1. DEFAULT and NOT NULL constraints
  2. FOREIGN KEY constraints
  3. PRIMARY KEY and UNIQUE constraints
  4. IDENTITY columns
  5. CHECK constraints
  6. 76. Consider the following two statements and choose the most appropriate option:

1. For configuration, ASP.NET uses IIS Metabase
2. For configuration, ASP.NET uses an XML based configuration system

Answers:

  1. 1 only
  2. 2 only
  3. Both 1 and 2
  4. Neither 1 nor 2

77. Which of the following is not a valid ASP.NET Web form control?

Answers:

  1. <ASP:Panel>
  2. <ASP:Div>
  3. <ASP:TableCell>
  4. <ASP:ImageButton>

78. Which of the following has the highest order of precedence in SQL Server?

Answers:

  1. Functions and Parenthesis
  2. Multiplication, Division and Exponents
  3. Addition and Subtraction
  4. Logical Operations

79. You are a web developer for an international literary website. Your application has a lot of text content that requires translation and few executable components. Which approach would you use?

Answers:

  1. Detect and redirect
  2. Use run-time adjustment
  3. Use satellite assemblies
  4. Allow the client browser to decide

80. Study the situation described below and identify the nature of relationship?

Each student can enroll into more than one class. Each class can accommodate more than one student.

Answers:

  1. 1 to N
  2. 1 to 1
  3. M to N to 1
  4. M to N
  5. N to 1

81. Which of the following objects is required by the Dataset to retrieve data from a database and to save updated data back to the database?

Answers:

  1. DataAdapter
  2. DataReader
  3. Command
  4. Connection

82. You want to display the titles of books that meet the following criteria:

1. Purchased before November 11, 2002
2. Price is less than $500 or greater than $900

You want to sort the result by the date of purchase, starting with the most recently bought book.
Which of the following statements should you use?

Answers:

  1. SELECT book_title FROM books WHERE price between 500 and 900 AND purchase_date < ’11/11/2002′ ORDER BY purchase_date;
  2. SELECT book_title FROM books WHERE price IN (500, 900) AND purchase_date< ’11/11/2002′ ORDER BY purchase date ASC;
  3. SELECT book_title FROM books WHERE price < 500 OR>900 AND purchase_date DESC;
  4. SELECT Book_title FROM books WHERE (price < 500 OR price > 900) AND purchase_date < ’11/11/2002′ ORDER BY purchase date DESC

83. You create an ASP.NET page named ProjectCalendar.aspx that shows scheduling information for projects in your company. The page is accessed from various other ASP and ASP.NET pages hosted throughout the company’s intranet. All employees on the intranet use Internet Explorer. ProjectCalendar.aspx has a Calendar control at the top of the page. Listed below the Calendar control is detailed information about project schedules on the data selected. When a user selects a date in the calendar, the page is refreshed to show the project schedule details for the newly selected date. Users report that after viewing two or more dates on ProjectCalendar.aspx, they need to click the browser’s Back button several times in order to return to the page they were viewing prior to accessing ProjectCalendar.aspx.
You need to modify ProjectCalendar.aspx so that the users need to click the Back button only once. What to do?

Answers:

  1. Add the following statement to the Page.Load event handler for ProjectCalendar.aspx: Response.Expires(0)
  2. Add the following statement to the Page.Load event handler for ProjectCalendar.aspx: Response.Cache.SetExpires (DateTime.Now())
  3. Add the following attribute to the Page directive for ProjectCalendar.aspx: EnableViewState=”True”
  4. Add the following attribute to the Page directive for ProjectCalendar.aspx: SmartNavigation=”True”

84. How can you pop-up a window to display text that identifies the author of the book?

Answers:

  1. For each image, set the AlternateText property to specify the text you want to display, and set the ToolTip property to True.
  2. In the onmouseover event handler for each image, add code that calls the RaiseBubbleEvent() method of the
  3. System.Web.UI.WebControls.Image class.
  4. In the onmouseover event handler for each image, add code that calls the ToString() method of the
  5. System.Web.UI.WebControls.Image class.
  6. For each image, set the ToolTip property to specify the text you want to display.

85. Consider the query:
SELECT name
FROM Student
WHERE name LIKE ‘_a%’;
Which names will be displayed?

Answers:

  1. Names starting with “a”
  2. Names containing “a” as the second letter
  3. Names starting with “a” or “A”
  4. Names containing “a” as any letter except the first

86. View the following Create statement:

1 Create table Pers
2 (EmpNo Int not null,
3 EName Char not null,
4 Join_dt Datetime not null,
5 Pay Int)

Which line contains an error?

Answers:

  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. None

87. 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 descending order of the CurrentStock column.

Answers:

  1. Select * from Products order by CurrentStock,ProductGroup
  2. Select * from Products order by CurrentStock DESC,ProductGroup
  3. Select * from Products order by ProductGroup,CurrentStock
  4. Select * from Products order by ProductGroup,CurrentStock DESC
  5. None of the above

88. Which of the following is not a service provided by Common Language Runtime (CLR)?

Answers:

  1. Garbage collection
  2. Multiple platform support
  3. Code verification
  4. Code access security

89. Which of the following is the way to handle Unmanaged Code Exceptions in ASP.NET?

Answers:

  1. Server.GetLastError()
  2. Exception ex
  3. Raise Error
  4. None of above

90. Consider the following table structure of students:
rollno int
name varchar(20)
course varchar(20)

What will be the query to display the courses in which the number of students
enrolled is more than 5?

Answers:

  1. Select course from students where count(course) > 5;
  2. Select course from students where count(*) > 5 group by course;
  3. Select course from students group by course;
  4. Select course from students group by course having count(*) > 5;
  5. Select course from students group by course where count(*) > 5;
  6. Select course from students where count(group(course)) > 5;
  7. Select count(course) > 5 from students;
  8. None of the above

91. In Windows built-in authentication, what will happen with the following set of statements?

<system.web>
<authorization>

<deny users=”RIL”/>

<allow users=”RIL”/>

</authorization>
</system.web>

Answers:

  1. The user RIL is first denied and then allowed access
  2. The user RIL is denied access because the <deny> element takes precedence over the <allow> element
  3. An error is generated because deny and allow cannot both be assigned to the same user
  4. Can’t say. It depends on the Windows OS version

92. When designing a database table, how do you avoid missing column values for non-primary key columns?

Answers:

  1. Use UNIQUE constraints
  2. Use PRIMARY KEY constraints
  3. Use DEFAULT and NOT NULL constraints
  4. Use FOREIGN KEY constraints
  5. Use SET constraints

93. In SQL Server, which of the following is not a control statement?

Answers:

  1. if…else
  2. if exists
  3. do…while
  4. while
  5. begin…end

94. You are developing an application to take orders over the Internet. When the user posts back the order form, you first check to see whether he is a registered customer of your company. If not, you must transfer control to the Register html page. Which method should you use to effect this transfer?

Answers:

  1. Response.Redirect()
  2. Server.Transfer()
  3. Server.Execute()
  4. Page.ProcessRequest()

95. The STUDENT_GRADES table has these columns:

STUDENT_ID INT
SEMESTER_END DATETIME
GPA FLOAT

Which of the following statements finds the highest Grade Point Average (GPA) per semester?

Answers:

  1. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL
  2. SELECT (gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL
  3. SELECT MAX(gpa) FROM student_grades WHERE gpa IS NOT NULL GROUP BY semester_end
  4. SELECT MAX(gpa) GROUP BY semester_end WHERE gpa IS NOT NULL FROM student_grades
  5. SELECT MAX(gpa) FROM student_grades GROUP BY semester_end WHERE gpa IS NOT NULL

96. You create an ASP.NET page named Customer.aspx. Customer.aspx contains a Web user control that displays a drop-down list box of Cities. The Web user control is named CityList, and it is defined in a file named CityList.ascx. The name of the DropDownList control in City.ascx is CuCity. You try to add code to the Page.Load event handler for Customer.aspx, but you discover that you cannot access CuCity from code in Customer.aspx. You want to ensure that code within Customer.aspx can access properties of CuCity.
What should you do?

Answers:

  1. In the code-behind file for CityList.ascx, add the following line of code: Protected CuCity As DropDownList
  2. In the code-behind file for Customer.aspx, add the following line of code: Public CuCity As DropDownList
  3. In the code-behind file for Customer.aspx, add the following line of code: Protected CuCity As DropDownList
  4. In the code-behind file for CityList.ascx, add the following line of code: Public CuCity As DropDownList

97. You are creating an ASP.NET application for AutoMart Internet Web site. A toolbar is required that will be displayed at the top of each page in the Web site. The toolbar will contain only static HTML code. The toolbar will be used in only AutoMart website. You plan to create the toolbar as a reusable component for your application. You need to create the toolbar in a minimum possible time. Which method will you adopt?

Answers:

  1. Add a new component class to your ASP.NET project. Use HTML server controls to design the toolbar within the designer of the component class.
  2. Create a new Web Control Library project. Create the toolbar within a Web custom control.
  3. Add a new Web user control to your ASP.NET project. Create the toolbar within the Web user control.
  4. Add a new Web Form to your ASP.NET project. Use HTML server controls to design the toolbar within the Web Form and save the
  5. Web Form with an ascx extension.

98. You are creating an ASP.NET application that will run on your company’s intranet. You want to control the browser window and respond immediately to non-post-back events. Which should you use?

Answers:

  1. Server-side code
  2. Use the Browser object’s VBScript or JavaScript properties to test if the browser can run scripts
  3. Use the Browser object’s Cookies
  4. Client-side scripts

1,806 total views, 4 views today

Upwork Internet Programming

AJAX Test 2016

Published by:

1. Which of the following is/are true regarding AJAX?

Answers:

  1. It’s an engine developed by Microsoft to load web pages faster
  2. It’s merely a concept with many implementation methods (XMLHttpRequest, iFrames…)
  3. It’s a server side scripting language used to serve partial parts of a webpage
  4. It’s a good way to reduce network traffic, if used correctly
  5. None of the above

2. Which of the following browsers provide XMLHttpRequest property?

Answers:

  1. Internet Explorer 5
  2. Internet Explorer 6
  3. Internet Explorer 7
  4. Firefox 2.0
  5. Safari 3.0

3. What is true regarding XMLHttpRequest.abort()?

Answers:

  1. It can only be used with async requests
  2. It will remove the onreadystatechange event handler
  3. It will send an abort message to the remote server
  4. It changes readyState to 4 (aborted)
  5. None of the above

4. What is the third (async) parameter of the XMLHttpRequest open method?

Answers:

  1. If true, the request doesn’t return anything.
  2. If true, the javascript engine is blocked while making the request
  3. If true, the send method returns immediately
  4. If true, the request object is destroyed when ‘send’ is executed
  5. If true, callbacks are executed

5. What is the correct way to have the function checkState called after 10 seconds?

Answers:

  1. window.setTimeout(checkState, 10);
  2. window.setTimeout(checkState, 10000);
  3. window.setTimeout(checkState(), 10);
  4. None of the above

6. document.write (“Hello”); will pop a dialog box with “Hello” in it.

Answers:

  1. true
  2. false

7. The format of an HTTP request is given below:

<request-line>

<headers>
<blank line>

[<request-body>]

Which of the following is not passed in the request-line?

Answers:

  1. Type of request
  2. Resource to access
  3. Version of HTTP
  4. Browser name
  5. None of the above

8. Is it possible to make a page “reload-safe” when using AJAX?

Answers:

  1. no
  2. yes, if each AJAX request modifies the server side context, which would render a page similar to the actual JS modified page, if reloaded.

9. How can you create an XMLHttpRequest under Internet Explorer 6?

Answers:

  1. var oReq = new XMLHttpRequest ();
  2. var oReq = new ActiveXObject (“MSXML2.XMLHTTP.3.0”);
  3. var oReq = new IEHttpRequest (“XML”);
  4. None of the above

10. The X in AJAX refers to XML, but is it possible to make a request for plain text data by using AJAX?

Answers:

  1. yes
  2. no

11. In the following list, which ones are used to fetch the result data of an XMLHttpRequest?

Answers:

  1. responseData
  2. responseBody
  3. responseString
  4. responseText
  5. responseXML

12. Is it possible to create and manipulate an image on the client with AJAX?

Answers:

  1. yes
  2. no

13. Is it always possible to make requests to multiple websites with different domain names from an AJAX client script?

Answers:

  1. yes
  2. no

14. Is it possible to make some system calls on the client with AJAX?

Answers:

  1. Yes
  2. No

15. Is the loading of an AJAX enabled web page any different from the loading of a normal page?

Answers:

  1. No
  2. Yes

16. You want to update the following element with the XMLHttpRequest status. Which of the following approaches is correct for the

purpose?

<div id=”statusCode”></div>

Answers:

  1. var myDiv = document.getElementById (“statusCode”); myDiv.innerHTML = req.statusCode;
  2. var myDiv = document.getElementById (“statusCode”); myDiv.innerHTML = req.status;
  3. var myDiv = document.getElementById (“statusCode”); myDiv.setStatus (req.statusCode);
  4. var myDiv = document.getElementById (“statusCode”); myDiv.status = req.status;
  5. None of the above

17. Which HTTP server does AJAX require?

Answers:

  1. Apache
  2. Sun application server
  3. lighttpd
  4. Microsoft web server
  5. Any HTTP server will work

18. Which of the following is a block comment in JavaScript?

Answers:

  1. <!– –>
  2. /* */
  3. //
  4. #
  5. –[[ ]]

19. It might be needed to set the request content-type to XML explicitly. How can you do so for an XMLHttpRequest Object?

Answers:

  1. myReq.setContentType (“text/xml”);
  2. myReq.contentType = “text/xml”;
  3. myReq.overrideContentType (“xml”);
  4. myReq.contentType = “xml”;
  5. myReq.setRequestHeader (“Content-Type”, “text/xml”);

20. Does JavaScript 1.5 have exception handling?

Answers:

  1. yes
  2. no

21. Which of the following cannot be resolved by using AJAX?

Answers:

  1. Partial page processing
  2. Unresponsiveness of web pages
  3. Server side communication initiation
  4. Server crashes (failover)
  5. None of the above

22. Can AJAX be used with HTTPS (SSL)?

Answers:

  1. yes
  2. no

23. Which of the following list is/are true regarding AJAX?

Answers:

  1. It can only be implemented with the XMLHttpRequest object
  2. It can be used to update parts of a webpage without reloading it
  3. It can be used to make requests to the server without blocking the user (async)
  4. It requires a special AJAX enabled web server
  5. It cannot be used under Internet Explorer

24. Can WebDav methods like PROPFIND be used with XMLHttpRequest.open()?

Answers:

  1. Yes
  2. No

25. Which of the following request types should be used with AJAX?

Answers:

  1. HTTP GET request for retrieving data (which will not change for that URL)
  2. HTTP POST request for retrieving data (which will not change for that URL)
  3. HTTP GET should be used when the state is updated on the server
  4. HTTP POST should be used when the state is updated on the server

26. When may asynchronous requests be used?

Answers:

  1. To submit data to the server
  2. To retrieve data from the server
  3. To load additional code from the server
  4. To download an image
  5. All of the above

27. Can AJAX be used with offline pages?

Answers:

  1. yes
  2. no

28. Is it possible to access the browser cookies from a javascript application?

Answers:

  1. yes
  2. no

29. Can a client AJAX application be used to fetch and execute some JavaScript code?

Answers:

  1. yes
  2. no

30. Which of the following is not a JavaScript operator?

Answers:

  1. new
  2. delete
  3. this
  4. typeof
  5. All of the above are Javascript operators

31. The server returns data to the client during an AJAX postback. Which of the following is correct about the returned data?

Answers:

  1. It only contains the data of the page elements that need to be changed
  2. It contains both the data of the whole page and the data that needs to be changed in separate blocks
  3. It contains the data of the whole page
  4. It may contain anything
  5. None of the above

32. When doing an AJAX request, will the page be scrolled back to top as with normal requests?

Answers:

  1. Yes
  2. No

33. What language does AJAX use on the client side?

Answers:

  1. JavaScript
  2. AppleScript
  3. PHP
  4. Ruby
  5. Java

34. Can AJAX be used with PHP?

Answers:

  1. yes
  2. no

35. Javascript uses static bindings.

Answers:

  1. true
  2. false

36. Which of the following is not a valid variable name in JavaScript?

Answers:

  1. _my_var
  2. 2myVar
  3. MY_VAR
  4. __MyVar2__
  5. All are valid

37. Is JavaScript the same as Java?

Answers:

  1. yes
  2. no

38. What is NOSCRIPT tag for?

Answers:

  1. To prevent the page scripts from executing
  2. To shield a part of a page from being modified by JS (like aDiv.innerHTML = ‘something’ has no effect)
  3. To enclose text to be displayed if the browser doesn’t support JS
  4. NOSCRIPT tag doesn’t exist
  5. None of the above

39. In the following list, which states are valid?

XMLHttpRequest.readyState
Answers:

  1. 0, The request is not initialized
  2. 1, The request has been set up
  3. 2, The request has been sent
  4. 3, The request is in process
  5. 4, The request is complete
  6. All of the above.

40. What is the standardized name of JavaScript?

Answers:

  1. Java
  2. NetscapeScript
  3. ECMAScript
  4. XMLScript
  5. WebScript

41. Which language does AJAX use on the server side?

Answers:

  1. JavaScript
  2. PHP
  3. Java
  4. Ruby
  5. Any language supported by the server

42. Which of the following is/are not addressed by AJAX?

Answers:

  1. Partial page update
  2. Offline browsing
  3. Server side scripting
  4. All of the above

43. Which of the following are drawbacks of AJAX?

Answers:

  1. The browser back button cannot be used in most cases
  2. It makes the server and client page representation synchronization more difficult
  3. It loads the server too much
  4. It’s not supported by older browsers
  5. It augments the used bandwidth significantly

44. What is the correct way to execute the function “calc()” when an XMLHttpRequest is loaded?

Answers:

  1. myRequest.onreadystatechange = calc;
  2. myRequest.onload = calc;
  3. myRequest.execute = calc;
  4. myRequest.addCallback (calc, “loaded”);
  5. None of the above

45. Can an HTML form be sent with AJAX?
Answers:

  1. yes
  2. no

46. What is the correct syntax to create an array in JavaScript?

Answers:

  1. var array = Array.new;
  2. var array = [];
  3. var array = new Array;
  4. var array = new Array ();
  5. None of the above

47. Can you call responseBody or responseText to get a partial result when the readyState of an XMLHttpRequest is 3(receiving)?

Answers:

  1. Yes
  2. No

48. Can an AJAX application communicate with other applications on the client computer?

Answers:

  1. Yes
  2. No

49. Which of the following describes the term ‘Asynchronous’ correctly?

Answers:

  1. Ability to handle processes independently from other processes
  2. Processes are dependent upon other processes
  3. Processes are not fully dependent on other processes
  4. None of the above

50. What is the correct syntax to include a script named myScript.js into a page?

Answers:

  1. <script href=”myScript.js”>
  2. <script name=”myScript.js”>
  3. <script src=”myScript.js”>
  4. <script root=”myScript.js”>

51. Consider the following function:

function foo ()
return 5;

}

What will the following code do?

var myVar = foo;

Answers:

  1. Assign the integer 5 to the variable myVar
  2. Assign the pointer to function foo to myVar
  3. Do nothing
  4. Throw an exception
  5. None of the above

52. What should be called before ‘send ()’ to prepare an XMLHttpRequest object?

Answers:

  1. prepare ()
  2. open ()
  3. init ()
  4. build ()
  5. None of the above

53. Can you start multiple threads with JavaScript?

Answers:

  1. Yes
  2. No

54. What is the common way to make a request with XMLHttpRequest?

Answers:

  1. myReq.request();
  2. myReq.get();
  3. myReq.post(null);
  4. myReq.send(null);
  5. myReq.sendRequest(null);

55. Can AJAX be used to move files on the client-side?

Answers:

  1. Yes
  2. No

56. Which of the following status codes denotes a server error?

Answers:

  1. 100
  2. 200
  3. 300
  4. 501
  5. 500

57. When a user views a page with JavaScript in it, which machine executes the script?

Answers:

  1. The client machine running the Web Browser
  2. The server serving the JavaScript
  3. A central JavaScript server like root DNS
  4. None of the above

3,582 total views, 3 views today

Upwork Internet Concepts

Social Media Marketing Test 2016

Published by:

1. What is the character limit for posts on Twitter?

Answers:

  1. No limit
  2. 100 characters
  3. 140 characters
  4. 200 characters

2. How can a company place itself as an expert in a certain area of expertise?

Answers:

  1. Post updates which brag about the company
  2. Actively answer questions in the Q&A section of the site
  3. Post comments on competitors pages stating how they are inferior
  4. Answer the questions in all the categories, even the ones in which the company is not engaged.

3. What type of status updates would drive visitors to the company site?

Answers:

  1. An update telling friends they hope to see them all soon
  2. A link to a new press release hosted on the company site
  3. A link to a third party hosting a company press release
  4. A picture of the CEO

4. What is meant by A/B testing in marketing?

Answers:

  1. Testing of 2 different products
  2. Testing 2 versions of an advertisement to see which elicits the best response
  3. Clinical testing of medical products before legally allowing them for sale
  4. Testing via 2 mediums, such as radio and television

5. Using which of the following two methods can a company ensure that the proper audience finds their YouTube videos?

Answers:

  1. Post links on the company blog to the YouTube videos
  2. There is no method to effectively direct people to the company videos
  3. Use of keywords
  4. Sending out mail advertisements

6. How does a blog directly impact sales of a company?

Answers:

  1. It tells customers what products to buy
  2. It can be used to talk negatively about the competition
  3. It is typically used as the way to disperse company coupons
  4. Typically a blog does not directly create sales

7. What is meant by “micro-blogging”?

Answers:

  1. Blogging daily
  2. Blogs which are posted by companies, not individuals
  3. Blogs with limited individual posts, limited by character count typically
  4. Blogging from mobile devices

8. What do Connections on LinkedIn effectively represent?

Answers:

  1. Random strangers who found the company
  2. People the company has sold product or services to
  3. An avenue to disperse coupons
  4. People and other companies the user is connected to directly

9. What is the term adopted for updates posted by Twitter users?

Answers:

  1. Tweets
  2. Twoots
  3. Twinks
  4. Posts

10. Which of the following is an easy way to track the website hits of a specific marketing campaign with a link to the company website?

Answers:

  1. Hire a web specialty firm
  2. Implement special software
  3. Creating landing pages specific for each campaign
  4. There is no way to know where traffic comes from

11. What feature does LinkedIn offer for pay accounts?

Answers:

  1. Ability to post pictures
  2. Increased abilities to connect directly and send messages to people
  3. Ability to post in Groups and create a Group
  4. Ability to block users

12. What is meant by Brand Management?

Answers:

  1. Managing the marketing staff
  2. Management of the marketing budget
  3. The company executive management team
  4. Creating a consistent image for the company

13. What traditional marketing technique is YouTube closest to?

Answers:

  1. Print advertising
  2. Television advertising
  3. Radio advertising
  4. Mail advertising

14. Why is it important to have a company blog hosted on the company web domain versus a third party blogging site?

Answers:

  1. Required by law
  2. Search engine rankings will include hits on the blog as part of the overall website hits
  3. Requires less effort to maintain
  4. Cannot be hacked easily

15. What is the general purpose of posting a video blog routinely to YouTube?

Answers:

  1. It allows the company to hard sell its products
  2. It allows the company to drive website traffic to its blog
  3. It can be used to disperse the company contact information
  4. It allows followers to create a personal connection with the employees of the company

16. What is the ultimate goal of a social network marketing plan?
Answers:

  1. To satisfy investors in the company
  2. To justify spending in marketing
  3. To find investors for a company
  4. Drive potential customers to the company and give them an action item to perform

17. What is “guerilla marketing”?

Answers:

  1. Marketing geared towards animal lovers
  2. Marketing which relies on time and energy rather than a large dollar budget
  3. Aggressive sales techniques
  4. Marketing using a large scale national budget

18. How does YouTube serve a dual purpose in social media marketing?

Answers:

  1. It can be used as a company blog as well as video advertisements
  2. It can be used for company pictures and videos
  3. It can be used to host the company website as well as videos
  4. It can be used as the forum for dispersing company videos, as well as a host when embedding videos in sites outside of YouTube

19. What is a “wiki”?

Answers:

  1. Form of blogging
  2. A new social networking site
  3. Interconnected and user generated knowledge management systems
  4. A tool for posting to social media networks

20. What should a company do for commercial advertisements on YouTube in order to maximize their effectiveness?

Answers:

  1. Ask the watcher to visit the company site at the end of the video
  2. Make the videos at least 5 minutes long
  3. Make the videos under 10 seconds
  4. Have the CEO featured in the advertisement

21. What is the overall goal of social media marketing for companies?

Answers:

  1. Generate sales
  2. Increase company headcount
  3. Increase their web presence
  4. Help accelerate product launches

22. What is one measure a company can use to validate the usefulness of its video posts on YouTube?

Answers:

  1. The number of followers
  2. The amount of views of the video
  3. The number of videos the company has up
  4. The sales volume of the company

23. How can a company create a forum for dialogue on LinkedIn?

Answers:

  1. Post updates to the company status
  2. Use of Groups
  3. Change the company profile regularly
  4. Post demeaning comments for the competitors’ pages

24. How is site traffic useful in evaluating marketing?

Answers:

  1. Overall site traffic can be followed and a general idea of marketing’s impact on it can be determined
  2. There is no correlation between site traffic and marketing
  3. Ads can send receivers to a specific landing page, which can be tracked
  4. Product sales from the company website can be attributed directly to the marketing campaign

25. Why is there no specific definition of what is social media marketing?

Answers:

  1. There is no governing body over social media marketing
  2. Companies cannot come to one definition
  3. The concept is relatively new compared to traditional marketing and is still being defined
  4. It has not yet been widely accepted

26. How do ebooks represent a form of marketing?

Answers:

  1. They are often free, include useful information, and direct the reader onto the company which created the ebook for further information
  2. They are not a form of marketing
  3. They can be placed on free sites where paid advertisements generate income
  4. They can be used to defame the competition

27. Which of the following is an important aspect of creating blogs and posting content?

Answers:

  1. Using a witty user name
  2. Posting at least once a month to the blog
  3. Social Media Optimization
  4. Using humor

28. How can a company convert posts on Twitter to sales?

Answers:

  1. Write demeaning points about the competition
  2. Write posts about personal information of the CEO
  3. Creating posts which drive followers to their site
  4. Constantly post updates about how the company needs more sales

29. What style of videos can a company post on YouTube?

Answers:

  1. Video Blogs
  2. Television Commercials
  3. Product Demonstrations
  4. All of the above

30. Which of the following would be leveraging both social network and traditional marketing?

Answers:

  1. Handing out print advertisements with a coupon for a store
  2. A print advertisement in a magazine which drives people to a website where there is a free trial offer
  3. Posting an advertisement on a message board
  4. Hosting a video ad on YouTube not otherwise seen elsewhere

31. How does creating a social network marketing plan differ from a traditional marketing plan?

Answers:

  1. The brand image should be completely different for social marketing
  2. The staff requirements and skill sets for social marketing are different
  3. There is no need for a social marketing plan, but social marketing plan is required for traditional marketing
  4. Other than the method of delivery, a marketing plan either way will be similar

32. What non financial measure of marketing is important to track?

Answers:

  1. CEO performance
  2. Number of new hires in marketing
  3. Number of impressions
  4. New customer acquisition

33. What is a “vlog”?

Answers:

  1. Video Log
  2. Video Blog
  3. Log of blog activity
  4. New technology to aid in blogging

34. What are the four P’s of marketing?

Answers:

  1. Product, Price, Place, Promotion
  2. Price, Popularity, People, Placement
  3. Popularity, Product, Promotion, People
  4. People, Price, Promotion, Placement

35. What should a company post on Twitter?

Answers:

  1. New product launches
  2. Significant company news
  3. Occasional day to day posts of interest
  4. All of the above

36. What would the marketing budget section of a marketing plan consist of?

Answers:

  1. The cost to write the plan
  2. The expected costs for each ad campaign based on the delivery method
  3. The overall marketing budget for a year
  4. The marketing personnel job descriptions

37. What is the method for being linked to other users on LinkedIn?

Answers:

  1. Followers
  2. Connections
  3. Friends
  4. Associates

38. How often should a marketing plan be revisited?

Answers:

  1. Never, once written it is complete
  2. As often as needed in order to revisit the plan of action and revise any new actions
  3. At company board meetings
  4. During the financial review of the company each month

39. What place does Pricing have in marketing?

Answers:

  1. Higher prices guarantee a higher revenue stream
  2. The company should actively market how much their products cost
  3. Different pricing levels can be tested to see what elicits the best consumer response
  4. Marketing based on the pricing level relative to competition is important

40. Why is it important to post to a blog regularly?

Answers:

  1. It reduces the cost per blog post
  2. Keep readers engaged and also gives search engines content to index
  3. It gives the social media marketing specialist something to do
  4. It allows more chances for the company to put down the competition

41. What is meant by the concept of “viral” in social media?

Answers:

  1. Social media which is spread to viewers by the consumer, growing in popularity
  2. It is a method of branding a company
  3. Advertising which can easily be emailed
  4. Marketing advertisements which are not serious

42. How can LinkedIn serve the company aside from social network marketing?

Answers:

  1. Job openings can easily be dispersed to qualified candidates on LinkedIn
  2. Company pictures can be posted to the profile
  3. Negative press about the competition can be easily spread
  4. Pricing lists can be posted

43. What is a “call to action”?

Answers:

  1. Giving an advertisement’s receiver a specific direction such as ‘visit the site’
  2. Using telemarketing to reach out to potential customers
  3. Defaming the competition
  4. Creating a new marketing campaign

44. How far into the future should a company plan its marketing activities?

Answers:

  1. Up to 1 year
  2. 5 years
  3. 1 month
  4. Indefinitely

45. What is the main reason traditional marketing will never completely go away?

Answers:

  1. It is cheaper than social media marketing
  2. All companies are required by law to use traditional marketing techniques
  3. There are better tax write offs for traditional marketing
  4. It’s proven to work time and again

46. What style of blogging would be most effective for building relationships with customers?

Answers:

  1. Using the blog only for press releases
  2. Posting resumes of the company officers
  3. Posting articles about how terrific the company is, and putting down the competition
  4. Writing posts about the company and its ups and downs from inside, personalized approach

47. What can a company do to offset the cost of running a blog?

Answers:

  1. Place ads on the blog which generate pay per click income
  2. Charge users a fee to read the blog
  3. Only allow past customers to read the blog
  4. Require a monthly membership to the entire company website

48. What methods of social network marketing should a company always use?

Answers:

  1. Blogging only
  2. Twitter, Blogs, Facebook
  3. YouTube
  4. Depends on the company, their product, their audience

49. What is a contingency plan?

Answers:

  1. A second written plan in case management doesn’t like the original plan
  2. A detailed marketing plan
  3. A set of actions to be taken if the original plan does not perform as anticipated
  4. A marketing plan written just for social networking

50. How can a company use the same material for both traditional and social network marketing?

Answers:

  1. Posting a luring comment on Twitter to the company site
  2. Selling ad space on the company website
  3. Utilizing a television ad campaign online as well on their site and sites such as YouTube
  4. Creating a magazine print ad with the company website

51. What is “social media optimization”?

Answers:

  1. Creating content which easily creates publicity via social networks
  2. Writing clear content
  3. Creating short content which is easily indexed
  4. Hiring people to create content for social networks

52. What is meant by the “blogosphere”?

Answers:

  1. The act of writing a blog
  2. Specific niche blog community
  3. The interconnected community of blogs via linking to each other
  4. Advertising done via blogging

53. Which type of marketing would a company blog be considered?

Answers:

  1. Social Network Marketing
  2. Traditional Marketing
  3. Both
  4. Neither

54. What is a method of marketing on Facebook which can reach several users by spending money?

Answers:

  1. Pay money for a better quality Facebook account
  2. Pay a third party to make posts to your account
  3. Charge a fee for users to be your friends
  4. Facebook Pay Per Click placed advertisements

55. What can a company do on Facebook apart from their page to create a following?

Answers:

  1. Post more updates than usual
  2. Post controversial posts
  3. Use several pictures
  4. Use Groups, both company originated and posting to other groups

56. What do updates to Facebook status resemble most closely?

Answers:

  1. Video blogs
  2. Posts on Twitter
  3. A company white paper
  4. Articles on LinkedIn

57. What is another term for “social media”?

Answers:

  1. Media Optimization
  2. Consumer Generated Media
  3. Advertising Socialization
  4. Consumer Media Advertising

58. What should be the length of an effective blog post?

Answers:

  1. Several pages in length
  2. No more than a few sentences
  3. A few sentences mixed with several links to other sites and references
  4. A few paragraphs

59. What is meant by “Marketing Creative”?

Answers:

  1. The employees in the marketing department
  2. The content for marketing and its creative aspect
  3. The methods used to distribute marketing material
  4. The branding image of the company

60. What is the term used for a person who is receiving updates of another Twitter user’s updates?

Answers:

  1. User
  2. Follower
  3. Connection
  4. Friend

61. What does the product portion of the 4 P’s of marketing focus on?

Answers:

  1. The product or service being marketed to consumers
  2. The manufacturing process
  3. How the price will be set for the product
  4. How the new product will be promoted

6,064 total views, 18 views today

Upwork Internet Concepts

Salesforce Test 2016

Published by:

1. Which of the following are true?

Answers:

  1. Force.com is a Platform as a service (PaaS) application.
  2. Salesforce is a Software as a Service (SaaS) application.
  3. Salesforce is a Platform as a service (PaaS) application.
  4. Force.com is a Software as a Service (SaaS) application.

2. Which of the following are the Application Development Components of Salesforce?

Answers:

  1. Apex Code
  2. AppExchange
  3. ERP Connectors
  4. VisualForce

3. What is the syntax for the logout() API call?

Answers:

  1. LogoutResult = binding.logout();
  2. LogoutResult = binding.logout (string username, string password);
  3. LogoutResult = binding.logout (string username);
  4. LogoutResult = binding.logout (string password);

4. You have a static resource archive named Testpack in your VisualForce organization which contains an image file named hills.jpg. You want to reference this image file in your VisualForce page. Which of the following Code Snippets can be used to achieve the desired result?

Answers:

  1. <apex:image url=”{!$Resource.Testpack}” width=”50″ height=”50″ />
  2. <apex:image url=”{!URLFOR($Resource.Testpack , ‘hills.jpg’)}” width=”50″ height=”50″ />
  3. <apex:image url=”{!($Resource.Testpack , ‘hills.jpg’)}” width=”50″ height=”50″ />
  4. <apex:image url=”hills.jpg” width=”50″ height=”50″ />

5. Which of the following Managed package Components contain a Subscriber and Developer Editable attribute?

Answers:

  1. Apex Class
  2. Apex Trigger
  3. Home Page Layout
  4. None of the above

6. Which of the following is/are required to convert a Lead into an Account and Contact?

Answers:

  1. You must be logged in.
  2. You must have the “Convert Leads” permission and the “Edit” permission on leads.
  3. You must have the “Create” and “Edit” permission on Accounts and Contact objects.
  4. All of the above

7. What is the field type of the AccountNumber field name of the Account object?

Answers:

  1. string
  2. int
  3. picklist
  4. textarea

8. Which of the following are examples of Assignment operator expressions?

Answers:

  1. +=
  2. /=
  3. >>=
  4. All of the above

9. What type of object can be added to your organization’s information using the create() API call?

Answers:

  1. Account
  2. Contact
  3. Both a and b

10. Which of the following fields of the Case API object cannot be updated?

Answers:

  1. AccountId
  2. Description
  3. CaseNumber
  4. ParentId
  5. OwnerId

11. In which type of Salesforce Edition can a Managed package be created?

Answers:

  1. Group
  2. Professional
  3. Enterprise
  4. Unlimited
  5. Developer

12. Which of the following Access Levels can be granted under Apex Managed Sharing?

Answers:

  1. Read Only
  2. Private
  3. Read/Write
  4. All of the above

13. What is the description of the Lead object?

Answers:

  1. It defines a prospect or potential Opportunity.
  2. It defines the rules that assign an owner to a Lead.
  3. It defines the status of a Lead, such as Open, Qualifed, or Converted.
  4. It associates a word or short phrase with a Lead.

14. The following is a VisualForce code snippet:

<apex:page standardController=”Account”>
<apex:pageBlock title=”Contacts”>
<apex:pageBlockTable value=”{!account.Contacts}” var=”contact”>
<apex:column value=”{!contact.Name}”/>
<apex:column value=”{!contact.MailingCity}”/>
<apex:column value=”{!contact.Phone}”/>
</apex:pageBlockTable>
</apex:pageBlock>
</apex:page>

It displays the Name, Mailing City, Phone details of a particular contact. Which of the following modifications will enable the above VisualForce code to return the data as a Microsoft Excel sheet?

Answers:

  1. <apex:pageBlock title=”Contacts” contenttype=”application/vnd.ms-excel”>
  2. <apex:page standardController=”Account” contenttype=”application/vnd.ms-excel”>
  3. <apex:pageBlockTable value=”{!account.Contacts}” var=”contact”contenttype=”application/vnd.ms-excel”>

15. The following is a VisualForce code snippet:

<apex:page standardController=”Account” recordSetVar=”accounts”>

Answers:

  1. It is an example of VisualForce Standard Controllers.
  2. It is an example of VisualForce Standard List Controllers.
  3. It is an example of VisualForce Custom Controllers.

16. Which of the following API calls are supported by the AssignmentRuleHeader soap?

Answers:

  1. create()
  2. merge()
  3. update()
  4. All of the above

17. A Custom Component named “myCustomComponent” is created and has the following code:

<apex:component>
<b>
<apex:outputText value=”This is a custom component.”/>
</b>
</apex:component>

Which of the following code snippets depicts the correct way to call the above custom component in a VisualForce page, provided, both of these are defined in the same namespace?

Answers:

  1. <apex:page standardController=”Account”> <c:myCustomComponent/> </apex:page>
  2. <apex:page standardController=”Account”> <apex:myCustomComponent/> </apex:page>
  3. <apex:page standardController=”Account”> <apex:component name=”myCustomComponent” /> </apex:page>

18. Which of the following User Permissions are needed to create test drives and publish AppExchange packages to AppExchange?

Answers:

  1. Download AppExchange Packages
  2. Create AppExchange Packages
  3. Upload AppExchange Packages

19. State whether the following statement is True or False.

In the Iteration method of accessing components, the concept of DOM ids is used.

Answers:

  1. False
  2. True

20. Which of the following objects is associated with errors relating to create(), update(), and delete() method calls?

Answers:

  1. DeployMessage object
  2. AsyncResult object
  3. RetrieveMessage object

21. Which of the following keywords are used with reference to Classes, Objects and Interfaces in the Apex Code?

Answers:

  1. final
  2. instanceof
  3. without sharing
  4. All of the above

22. Apex allows developers to lock sObject records while they are being updated in order to prevent race conditions and other thread safety problems. Which of the following keywords is used, in SOQL statements for Locking?

Answers:

  1. TABLOCK
  2. COMMIT
  3. ROWLOCK
  4. FOR UPDATE

23. Which of the following field properties is not supported for the PersonContactId field name of the Account object?

Answers:

  1. Create
  2. Filter
  3. Nillable
  4. None of the above

24. Which of the following properties is not associated with Managed Packages?

Answers:

  1. Subscriber Deleteable
  2. IP Protection
  3. Automatic Renaming
  4. Upgradeable

25. In which type of relationships among objects is the object not deleted when its related product is deleted?

Answers:

  1. Master-Detail
  2. Many-to-Many
  3. Lookup
  4. All of the above

26. A VisualForce page definition consists of VisualForce Markup, which is made up of <apex:page> tags. How many such tags

are allowed in a VisualForce page?

Answers:

  1. Only One
  2. Two
  3. Three
  4. Unlimited

27. What is the data type of the size property of the QueryResult object returned by a query() call?

Answers:

  1. int
  2. boolean
  3. string
  4. textarea
  5. sObject

28. What is the maximum number of characters in the OldValue field of SolutionHistory object?

Answers:

  1. 100
  2. 255
  3. 755
  4. 1000
  5. There is no limit.

29. In order to modify existing customizations in an organization using XML metadata files, which of the following method calls will be used?

Answers:

  1. deploy()
  2. create()
  3. update()
  4. All of the above

30. Which type of the CRM approach does Salesforce follow?

Answers:

  1. Operational CRM
  2. Sales Force Automation(SFA) CRM
  3. Analytical CRM
  4. Sales Intelligence CRM

31. Unit tests are class testing methods that verify whether a particular piece of code is working properly. Which of the following is not a feature of Unit tests?

Answers:

  1. Unit test methods take no arguments.
  2. A Unit test commits data to the database.
  3. Unit tests send no emails.
  4. Unit test methods are always flagged with the testMethod keyword in the method definition.

32. Which of the following Typographical Conventions is used to represent variables in Apex?

Answers:

  1. Bold
  2. Italics
  3. Bold Italics
  4. Regular Italics

33. What is the maximum number of Custom Apps that can be created using the Developer Edition?

Answers:

  1. 1
  2. 5
  3. 10
  4. Unlimited

34. What is the difference between the queryAll() and queryMore() calls?

Answers:

  1. queryAll() returns the records count of more than 500 returns while queryMore() also returns the records that have been deleted because of a merge or delete.
  2. queryMore() returns the records count of more than 500 while queryAll() also returns the records that have been deleted because of a merge or delete.
  3. queryAll() returns the records when the Ids are not known while queryMore() returns the records with known Ids.
  4. queryMore() returns the records when the Ids are not known while queryAll() returns the records with known Ids.

35. Which of the following methods is not defined under ApexClass ?

Answers:

  1. deploy()
  2. retrieve()
  3. create()
  4. describeMetadata()

1,824 total views, 7 views today

Upwork Internet Concepts

RSS 2.0 Test 2016

Published by:

1. Which of the following child elements are mandatory in the <channel> element of an RSS feed?

Answers:

  1. <category>
  2. <title>
  3. <language>
  4. <description>
  5. <path>
  6. <link>

2. Which of the following statements is true about RSS aggregators?

Answers:

  1. RSS aggregators can be web based.
  2. RSS aggregators can be desktop based.
  3. RSS aggregators can be mobile based.

3. Which of the following child elements of the <image> element are mandatory?

Answers:

  1. <url>
  2. <width>
  3. <link>
  4. <width>
  5. <description>
  6. <height>
  7. <title>

4. Which of the following is the most appropriate definition of an RSS Aggregator?

Answers:

  1. A block of code used to create links in RSS feeds
  2. A site or program that gathers and sorts out RSS feeds
  3. A control to add information to your website

5. On which of the following technologies is RSS based?

Answers:

  1. CFML
  2. SBML
  3. XML
  4. SMIL

6. Which of the following elements defines the last-modified date of the content of a feed?

Answers:

  1. <skipDays>
  2. <pubDate>
  3. <lastBuildDate>
  4. <generator>

7. If a <guid> sub-element is included in an <item> element in your RSS feed, which attribute must be set to “true” to consider guid as a url that points to the full item described by the <item> element?

Answers:

  1. url
  2. source
  3. link
  4. isPermaLink

8. What is the extension of an RSS feed when it is published on the web?

Answers:

  1. .css
  2. .rss
  3. .xml
  4. .rfd

9. Which of the following are the required attributes of the <cloud> sub-element of the <channel> element in an RSS feed?

Answers:

  1. path
  2. version
  3. registerProcedure
  4. Both a and c

10. Look at the following RSS feed:

<?xml version=”1.0″ encoding=”ISO-8859-1″ ?>
<rss version=”2.0″>
<channel>
<title>Expert rating Solutions</title>
<link>http://expertrating.com</link>
<description>web building tutorials</description>
<item>
<title>RSS Tutorial</title>
<link>http://expertrating.com/rss</link>
<description>New RSS tutorial </description>
<image>
<url>http://www.expertrating.com/rss/erschoolspic.gif</url>
<title>expertrating.com</title>
<link>http://expertrating.com</link>
</image>
</item>
</channel>
</rss>

What is wrong with the above code?

Answers:

  1. The <image> element is not the sub element of <item>
  2. A mandatory attribute of the <channel> element is missing.
  3. A mandatory attribute of the <item> element is missing.
  4. <title> is not sub element of <image> element.

11. Which of the following hexadecimal references must be used by a publisher when encoding the “&” character in an RSS feed?

Answers:

  1. &#x3E;
  2. &#x26;
  3. AT&#x26;
  4. &#x3C;

12. Which of the following hexadecimal references must be used by a publisher when encoding the “<” character in an RSS feed?

Answers:

  1. &#x3E;
  2. &#x26;
  3. AT&#x26;
  4. &#x3C;

13. What is the meaning of the word ‘Syndication’ in RSS terminology?

Answers:

  1. Sharing of content among different websites
  2. Publishing of content in different websites
  3. Communicating between different websites
  4. Flow of content between different websites

14. Which of the following is the correct syntax for writing a comment in an RSS feed?

Answers:

  1. <%– This is an RSS comment –%>
  2. <!– This is an RSS comment !>
  3. <“%– This is an RSS comment –%”>
  4. <!– This is an RSS comment –>
  5. <“–This is an RSS comment–“>

15. An enclosure element in an RSS feed is shown below:

<enclosure url=”http://www.expertrating.com/media/3d.wmv” length=”78645″ type=”video/wmv” />
The length attribute specifies the length of the enclosed file in _________.

Answers:

  1. Bits
  2. Bytes
  3. Kilobytes
  4. Megabytes

16. What is the character count limit of the data that can be contained in any element of an RSS feed?

Answers:

  1. 100 characters
  2. 400 characters
  3. 500 characters
  4. There is no limit

17. The mechanism of fetching a webpage and pulling out relevant parts for an RSS feed is known as______.

Answers:

  1. Feed Integration
  2. Feed Scraping
  3. Self Scraping
  4. Self Integration

18. Which of the following is included in an RSS feed for the modularization of the feed?

Answers:

  1. Description element
  2. Namespace
  3. Version attribute
  4. Channel element

19. Which of the following elements is used to add new features to an RSS feed without changing the core specifications?

Answers:

  1. <link>
  2. <channel>
  3. <modules>
  4. <update>

20. Which of the following is true about the <ttl> element of an RSS feed?

Answers:

  1. It specifies the number of seconds left before the next modification can be done to the feed.
  2. It specifies the number of seconds an RSS feed can stay cached before refreshing it from the source.
  3. It specifies the number of minutes left before the next modification can be done to the feed.
  4. It specifies the number of minutes an RSS feed can stay cached before refreshing it from the source.

21. The peer-to-peer protocol that supports RSS is ________.

Answers:

  1. Napster protocol
  2. XML protocol
  3. WinMX
  4. BitTorrent

22. Which of the following attributes is mandatory for an <atom:link> element in an RSS feed?

Answers:

  1. title
  2. href
  3. hreflang
  4. type
  5. length

23. Which of the following hexadecimal references must be used by a publisher when encoding the “>” character in an RSS feed?

Answers:

  1. &#x3E;
  2. &#x26;
  3. AT&#x26;
  4. &#x3C;

24. Which of the following values must be assigned to the “rel” attribute of an <atom:link> element to describe the original source of the entry in an RSS feed?

Answers:

  1. related
  2. self
  3. via
  4. enclosure

25. For all elements defined in the RSS specification enclosing character data, the text should be interpreted as plain unformatted text.
Which of the following child elements of the <item> element is the ONLY exception to the above statement?

Answers:

  1. <source>
  2. <category>
  3. <title>
  4. <comments>
  5. <description>
  6. <link>

26. The <channel> element of an RSS feed may contain each of the following optional elements only once.Which of the following elements is an exception to the above statement?

Answers:

  1. <language>
  2. <category>
  3. <copyright>
  4. <image>
  5. <cloud>

27. What is the use of the rdf:resource attribute in an RSS feed?

Answers:

  1. The rdf:resource attribute is used by metadata to carry links.
  2. The rdf:resource attribute is used to assign an identifier to each item.
  3. The rdf:resource attribute is used to keep track of the relationship between items.
  4. The rdf:resource attribute is used to integrate the feed into your publishing process.

1,203 total views, 7 views today

Upwork Internet Concepts

Knowledge of Google Webmaster Central Test 2016

Published by:

1. If you verify your site for Google Webmaster Tools at http://www.yoursite.com/blogs/, you can not see errors with URLs for ______.

Answers:

  1. http://www.yoursite.com/blogs/
  2. http://www.yoursite.com/blogs/new/
  3. http://www.yoursite.com
  4. http://www.yoursite.com/tests/

2. Which of the following should be used to permanently remove the cached version of your page from Google search results?

Answers:

  1. no follow tag.
  2. meta noarchive tag.
  3. meta archive tag.

3. Increasing the Googlebot crawl rate for your website ______

Answers:

  1. will increase the number of Googlebot requests per second.
  2. has no effect on how often Googlebot crawls your site.
  3. will reduce the number of Googlebot requests per second.
  4. is not possible.

4. The following question is based on the above diagram.

Clicking on the test python online link will ______.

Answers:

  1. take you to the top search queries page.
  2. a Google search page showing search results for the query test python online.
  3. show the position in search results for the query test python online.
  4. show you the percentage of search queries contributed by the query.

5. If you want your users to visit http://www.yourwebsite.com instead of http://yourwebsite.com, you should ______

Answers:

  1. use the URL removal tool.
  2. use Webmaster Tools to set your preferred domain.
  3. display a message on http://yourwebsite.com about the new address.

6. Removing www.yourwebsite.com using the URL removal tool will also remove http://yourwebsite.com from Google’s index.

Answers:

  1. Yes
  2. No

7. Specialized Google Sitemap formats:

Answers:

  1. are not specific to Google and can be used by other search engines as well.
  2. are specific to Google and are not used by other search engines.
  3. are specific to Google and Yahoo.

8. Webmaster Tools does not show:

Answers:

  1. who is linking to your website and how.
  2. which pages on your website get the most links.
  3. which keyword searches drive the most traffic to your website.
  4. which webpages of your site are generating the least revenue.

9. If the Webmaster Tools data shows missing Titles in the pages of your website, ______.

Answers:

  1. no action is required on your part.
  2. the missing titles must be replaced as soon as possible.
  3. you must submit a new sitemap at the earliest convenience.
  4. you must submit a new robots.txt file for the pages with the missing page titles.

10. The crawl errors shown in Google webmaster tools do not include:

Answers:

  1. not followed
  2. not found
  3. restricted by robots.txt
  4. images without alt text

11. Which of the following stats about Googlebot crawl activity are not shown in Google webmaster tools?

Answers:

  1. Pages crawled per day
  2. Kilobytes downloaded per day
  3. Time spent downloading a page
  4. Custom reports

12. Files in the URLs that are protected by authentication:

Answers:

  1. can not be retrieved by Google.
  2. can be retrieved by Google but can not be cached by it.
  3. can be indexed by Google.

13. Registering the misspellings of a well known website as a domain for your website ______.

Answers:

  1. is acceptable
  2. is considered a misleading practice

14. If you submit a News sitemap for your website, Google News will:

Answers:

  1. use normal crawl methods to search and index your news site.
  2. blacklist your website.
  3. give preference to your website in search results.

15. In case you feel the expected keywords are missing from the Google webmasters keywords page, you should:

Answers:

  1. contact your website hosting service.
  2. change the meta content of your pages.
  3. intensify the Google AdWords campaigns for the keywords.
  4. review the Crawl Errors page for your site and take corrective action, if required.

16. A Sitemap file can contain no more than ______.

Answers:

  1. 5,000 URLs.
  2. 5,000 characters.
  3. 50,000 URLs.
  4. 50,000 characters.

17. Enabling your web server to support the “If-Modified-Since” HTTP header:

Answers:

  1. is not possible.
  2. reduces the crawl rate of your site by Googlebot.
  3. enhances the performance of your web server.
  4. allows your web server to tell Google whether your content has changed since it last crawled your site.

18. If you set the Geographic target of your website as Canada,

Answers:

  1. Google will consider your website better optimized to search results when users choose show pages from Canada while using Google search.
  2. Google will consider your website better optimized to search results in default web search.
  3. Google will consider your website better optimized to search results for paid search results.
  4. Google will consider your website better optimized for image search results.

19. Choose the incorrect statement.

Answers:

  1. Content Analysis helps to identify potential issues with the content on your site.
  2. The robots.txt analyzer tool helps you to make sure you are not accidentally blocking Googlebot from crawling your site.
  3. You must place your Video Sitemap at a publicly accessible URL.
  4. It is not possible to remove the pages of your website from Google’s search results.

20. The above graphic shows:

Answers:

  1. the information about user search queries that have returned pages from your site
  2. the images from your site not crawled by Google
  3. the issues encountered by Google while crawling your site

21. You can report about a website to Google which indulges in buying or selling “paid links” through Webmaster Tools.

Answers:

  1. True
  2. False

22. The first page you see on logging into Google Webmaster tools is______.

Answers:

  1. Dashboard
  2. Overview
  3. Tools
  4. Statistics

23. A custom crawl rate set for Google Webmaster Tools is valid for ______.

Answers:

  1. 90 days
  2. 30 days
  3. 180 days
  4. 7 days

24. State whether true or false:

The data displayed in Google Webmaster Tools may be different from the data shown by other tools such as Google Analytics.

Answers:

  1. True
  2. False

25. Google recommends adding _______ version of your website to Google Webmaster Tools.

Answers:

  1. any one
  2. every
  3. only the web
  4. only the mobile

26. The above error message can be customized by:

Answers:

  1. creating a new 404 page and redirecting your custom 404 page to it.
  2. modifying the sitemap.
  3. saving a new robots.txt file.
  4. customizing and adding a 404 widget to your custom 404 page.

27. What is the maximum number of links that should be displayed on a single page according to Google Webmaster guidelines?

Answers:

  1. Fewer than 75
  2. Fewer than 100
  3. Fewer than 500
  4. There is no such limit.

28. If you specify your preferred domain as http://www.yoursite.com and Google finds a link to your site that is formatted as

http://yoursite.com, it will be followed as ______.

Answers:

  1. https://www.yoursite.com
  2. http://www.yoursite.com
  3. www.yoursite.com
  4. http://yoursite.com

29. Google Webmaster Tools does not______.

Answers:

  1. show which keyword searches drive the most traffic to your website
  2. allow the submission of a Sitemap
  3. show funnel visualization
  4. provide the robots.txt analyzer tool

30. The appearance of which of the following in Google Webmaster Tools could be a sign that your site has been hacked?

Answers:

  1. Unexpected Googlebot activity
  2. Unexpected keywords like “Viagra” in the keywords page
  3. Unexpected change in the Google crawl rate
  4. Unexpected pages linking to your website in sitelinks

31. Specialized Google Sitemap formats do not include:

Answers:

  1. Video Sitemaps
  2. Mobile Sitemaps
  3. News Sitemaps
  4. Apps Sitemaps
  5. Geo Sitemaps

32. Moving the slider of the Set Custom crawl rate to a faster pace______

Answers:

  1. is recommended only if you are experiencing traffic problems with your server.
  2. is not possible.
  3. may increase the Googlebot traffic on your server.
  4. may reduce the freshness and number of the crawled pages.

33. Google determines the “recommended crawl rate” based on ______.

Answers:

  1. the number of pages in your site
  2. the page rank of your site’s homepage
  3. the number of links pointing to your website
  4. the popularity of your website

34. Webmaster Tools helps you see your site:

Answers:

  1. the way search engines see it.
  2. the way Google sees it.
  3. the way internet users see it.
  4. the way your Ad viewers see it.

35. Google Webmaster Tools does not:

Answers:

  1. help you to see your site the way Google does.
  2. show which pages on your site get the most links.
  3. show the number of unique page views during a given time period.
  4. show who is linking to your site and how.

36. Google Webmaster Tools does not help you to see ______.

Answers:

  1. when Googlebot last visited your site
  2. the URLs which Google could not crawl
  3. how your site is indexed by Google
  4. your site’s popularity stats

37. To help Google determine how your site appears in Google’s country-specific search results, you should ______.

Answers:

  1. set a preferred domain
  2. define a geographical target
  3. define crawl rate
  4. change image search settings

38. While submitting a Sitemap, if you specify your site location as http://www.yoursite.com/, your URL list:

Answers:

  1. should contain the URLs that begin with http://yoursite.com/.
  2. should not contain the URLs that begin with http://www.yoursite.com/.
  3. should not contain the URLs that begin with http://yoursite.com/.

39. Setting a geographic target through Google Webmaster Tools:

Answers:

  1. will improve your site’s ranking in default search results.
  2. will not improve your site’s appearance in search results specific for the same geographic area.
  3. will improve your site’s appearance in search results specific for the same geographical area.

1,346 total views, 5 views today