SEO Learning and oDesk Test Answer

JavaScript Test Solution

1. What’s relationship between JavaScript and ECMAScript? –
ECMAScript is yet another name for JavaScript (other names include LiveScript).
The current JavaScript that you see supported in browsers is ECMAScript revision 3.
2. What are JavaScript types? –
Number, String, Boolean, Function, Object, Null, Undefined.
3. How do you convert numbers between different bases in JavaScript? –
Use the parseInt() function, that takes a string as the first parameter, and the base as
a second parameter. So to convert hexadecimal 3F to decimal, use parseInt (“3F”, 16);
4. What does isNaN function do? –
Return true if the argument is not a number.
5. What is negative infinity? –
It’s a number in JavaScript, derived by dividing negative number by zero.

6. What boolean operators does JavaScript support? –
&&, || and !
7. What does “1″+2+4 evaluate to? –
Since 1 is a string, everything is a string, so the result is 124.
8. How about 2+5+”8″? –
Since 2 and 5 are integers, this is number arithmetic, since 8 is a string, it’s concatenation,
so 78 is the result.
9. What looping structures are there in JavaScript? –
for, while, do-while loops, but no foreach.
10. How do you create a new object in JavaScript? –
var obj = new Object(); or var obj = {};
11. How do you assign object properties? –
obj["age"] = 17 or obj.age = 17.
12. What’s a way to append a value to an array? –
arr[arr.length] = value;
13. What is this keyword? -
It refers to the current object.

Answer of Windows XP Test

Which of the following statements is true if you open an existing file, make changes to it, and save it with a new name? Posted by odesk test answers
The original file will be deleted.
The original file remains unchanged.****
The changes will be saved in the original file
The original file is sent to the Recycle Bin

Question 2
The left side of the Start menu contains two parts, separated by a thin horizontal line. The Windows XP term for manually inserting a shortcut to one of your chosen applications into the top part of the left side (by using the right-context menu of the application in Windows Explorer) is called:

Attaching an application to the Start menu. ****
Pinning an application to the Start menu
Placing an application into the Start menu.
Porting an application to the Start menu

Odesk Joomla Test Solution

1.The index.php file is a combination of HTML and PHP code.

answer: True

2.What is the default super administrator account for Joomla called?

answer: Administrator

3.Which of the following PHP directives are important to Joomla execution to define an alternate compression library if the standard library is not available?

answer: extension_dir

4.Which of the following files is archive and contains the actual CB component that you must install into Joomla while downloading CB?

answer: com_comprofiler

5.Which option will you choose to set the site metadata for the installed website?

answer: Global Configuration

6.What will happen if we set the SSL enabled option to On?

answer: This option will make the link from the menu begin with an https://

oDesk Joomla 1.5 Test Answers

The index.php file is a combination of HTML and PHP code.
Answer: True
What is the default super administrator account for Joomla called?
Answer: Administrator
Which of the following PHP directives are important to Joomla execution to define an alternate compression library if the standard library is not available?
Answer: extension_dir
Which of the following files is archive and contains the actual CB component that you must install into Joomla while downloading CB?
Answer: com_comprofiler
Which option will you choose to set the site metadata for the installed website?
Answer: Global Configuration
What will happen if we set the SSL enabled option to On?
Answer: This option will make the link from the menu begin with an https://
The core editor events apply to plug-ins that provide editor functionality such as TinyMCE or XStandard Lite.
Answer: True
Which PHP file does the index.php file load to provide the menu bar to the administrator interface?
Answer: Toolbar.php
Which of the given database systems is supported by Joomla?
Answer: Mysql
Which of the following is the default editor of Joomla?
Answer: TinyMCE
Joomla provides an abstracted method called getEscaped() that returns the escaped string regardless of the target database.
Answer: False
From which package are the classes (i.e JSite, JAdministrator and JInstallation) which make up the Joomla CMS application extended?
Answer: Installer
What is not true about JoomlaXplorer?
Answer: None of the above
Which of the following is a system event?
Answer: OnDisplay
Which Joomla file provides the central logic of the template, including any module and component display?
Answer: Index.php
When will you use SMTP authentication mail settings?
Answer: When you want to use an internal mail server
What do you understand by the type of error?
Answer: It means that STRICT_ALL_TABLES is enabled
Which path variable holds the path of the currently executing application?
Answer: All of the above
Which user events occur with plug-ins that are installed for the front end of the system?
Answer: Both a and b
Which type of positioning elements define a concrete area such as a p, td, div or table in a CSS file?
Answer: Block elements

Which of the following files does the “/includes” directory not contain?
Answer: None of the above
Which option will you select to install or to add the module to your website?
Answer: C
Why does Joomla use templateDetails.xml files?
Answer: All of the above
Which of the following events is activated after content rendering is complete for content type plug-ins?
Answer: OnAfterDisplayContent
All the Joomla settings are contained within a PHP class called JConfig.
Answer: True
In which PHP file is the central configuration data for Joomla contained?
Answer: configuration.php
What is not true about the MD5 hash value?
Answer: Each password in Joomla is stored as a MD5 hash value
There are two root classes for the Joomla framework: JFactory and JVersion.
Answer: True
Which option will you select to find unpublished articles?
Answer: Article manager
What do you understand from the following code?
Answer: SQL statement is executed against the Joomla database to find empty data fields
Which SEO settings will you activate to make Joomla article URL shown in picture A appear as shown in picture B?
Answer: B
In which option are errors, warnings and references logged?
Answer: None of the above
Which type of files can media manager not upload?
Answer: None of the above
Which among the following switches display the current version of PHP?
Answer: -v
The Joomap extension uses the style-sheets from the currently selected default template to display the sitemap in the site style.
Answer: True
Which type of server technology is used by Joomla?
Answer: All of the above
Which of the following is not true about the FrontPage Manager?
Answer: You cannot select your content for the FrontPage from all the contents
What happens if the Text Separator Field is left empty while using the breadcrumbs module in the module manager?
Answer: None of the above
Which of the following support libraries must you include when you are doing a manual compile of PHP to use with Joomla?
Answer: All of the above
What is the role of the template metadata file in the system?
Answer: It contains the basic authorship information

Odesk WordPress 2.8 Test Answer

1.Question:A possible way to collect real-time statistics about traffic to a WordPress site is to _______________.

a) use a built-in tool

b) use a plug-in (Answer)

c) use a widget

d) None of the above

2.Question: In order to to display a widget, the user must _____

a) Set he “Show Property” of the desired widget to “true”

b) Drag the desired widget of the side bar (answer)

php odesk test Question Answer old

Question 1

The setrawcookie() method of setting cookie is different from php standard method of cookie setting as :

It does not allow expiry time to be set
It can be used only once
It does not url- ENCODE the value on its own
It does not allow domain setting

Ans: C

Question 2

IF visibility is not defined for a method /member then it is treated as public static.

True
False

Ans: B

oDesk English Vocabulary Test (U.S. Version) Answers

Wondering how to get into Top 10% or 20% in oDesk English Vocabulary Test (U.S. Version)? Here are some answers to help you enlighten your knowledge and help pass the English Vocabulary Test!

1. Choose the word or phrase that is most nearly an antonym of the word below. Itinerant
a. permanent
b. flexible
c. transient
d. dissatisfied
2. Complete the following sentence by choosing the correct homophone from the options below.
This experiment was designed to _____ certain behaviors from the test subjects.

oDesk U.S English Basic SkillsTest

Now Finally Question & Answers
Question 1:

Choose the series of prepositions that best completes the following sentence.

Charlotte knew________the secret investigation_________her past, but she closed her eyes to it and pretended it wasn’t happening.

Answer: a. of, about

Question 2:

Choose the series of adjectives and adverbs that best completes the following sentence.

Odesk test answers - SQL Test

Question 1

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

The two statements produce identical results
The second statement returns an error
There is no need to specify DESC because the results are sorted in descending order by default

Question 2

Question 3

Examine the data in the EMPLOYEES table given below:

ALLEN 10 3000
MILLER 20 1500
KING 20 2200
DAVIS 30 5000

Which of the following Subqueries work?

SELECT * FROM employees where salary > (SELECT MIN(salary) FROM employees GROUP BY department_id);
SELECT * FROM employees WHERE salary = (SELECT AVG(salary) FROM employees GROUP BY department_id);
SELECT distinct department_id FROM employees Where salary > ANY (SELECT AVG(salary) FROM employees GROUP BY department_id);
SELECT department_id FROM employees WHERE SALARY > ALL (SELECT AVG(salary) FROM employees GROUP BY department_id);
SELECT department_id FROM employees WHERE salary > ALL (SELECT AVG(salary) FROM employees GROUP BY AVG(SALARY));

Question 4

Which of the following statements are true?

With DDL you can create and remove tables, schemas, domains, indexes and views
Select, Insert and Update are DCL commands
Grant and Revoke are DML commands
Commit and Rollback are DCL commands

Question 5

Question 6

Question 7

The overall logical structure of a database can be expressed graphically by:

Data Flow Chart
Flow Chart
Directed Chart
Entity-Relationship Diagram
None of the above

Question 8

Consider the following tables:

Books
------
BookId
BookName
AuthorId
SubjectId
PopularityRating (the popularity of the book ON a scale of 1 TO 10)
Languagе (such AS French, English, German etc)

Subjects
---------
SubjectId
Subject (such AS History, Geography, Mathematics etc)

Authors
--------
AuthorId
AuthorName
Country

What is the query to determine which German books(if any) are more popular than all the French?

select bookname from books where language='German' and popularityrating = (select popularityrating from books where language='French')
select bookname from books where language='German' and popularityrating> (select popularityrating from books where language='French')
select bookname from books where language='French' and popularityrating> (select max(popularityrating) from books where language='German')
select bookname from books where language='German' and popularityrating> (select max(popularityrating) from books where language='French')

Question 9

Which statements are true for views?

The definition of a view is stored in data dictionary
Views provide a more secure way of retrieving data
Views are actually Tables and store data in the same manner as Tables
All of the above

Question 10

Consider the following tables:

Books
------
BookId
BookName
AuthorId
SubjectId
PopularityRating (the popularity of the book ON a scale of 1 TO 10)
Languagе (such AS French, English, German etc)

Subjects
---------
SubjectId
Subject (such AS History, Geography, Mathematics etc)

Authors
--------
AuthorId
AuthorName
Country
What is the query to determine which Authors have written books on two or more subjects?

select AuthorName from Authors where Authorid in (select Authorid from Books group by SubjectId having count(*)>1)
select AuthorName from Authors where BookId in (select BookId from Books group by BookId having count(*)>1)
select AuthorName from Authors where Authorid in (select Authorid from Books group by SubjectId,Authorid having count(*)>1)
select AuthorName from Authors where Authorid in (select Authorid from Books group by Authorid having count(*)>1)

Question 11

What does the term DDL stand for?

Data Description Language
Dynamic Data Language
Data Definition Language
Data Derived Language
Descriptive Data Language

Question 12

The concept of data independence is similar to the concept of ________

Data type
Abstract data type
Consolidation
Isolation

Question 13

What are the programs that execute automatically whenever DML operations are performed on tables called?

Triggers
Procedures
Functions
None of the above

Question 14

Question 15

What is the error in the following query if the Students table contains several records?

SELECT name FROM students WHERE name =
(SELECT name FROM students ORDER BY name);

= should be replace by in operator
Order by clause in the subquery should be preceded with a group by clause
Order by clause in the subquery can be used only if the where and group by clauses have been applied
Group by clause should be applied to the outer query
An order by clause is not allowed in a subquery
There is no error

Question 16

How can data be accessed by users who do not have direct access to the tables?

By creating views
By creating triggers
By creating stored procedures
None of the above

Question 17

Consider the following tables:

Books
------
BookId
BookName
AuthorId
SubjectId
PopularityRating (the popularity of the book ON a scale of 1 TO 10)
Languagе (such AS French, English, German etc)

Subjects
---------
SubjectId
Subject (such AS History, Geography, Mathematics etc)

Authors
--------
AuthorId
AuthorName
Country

What is the query to determine which Authors have written at least 1 book with a popularity rating of less than 5?

select authorname from authors where authorid in (select authorid from books where popularityrating<5)
select authorname from authors where authorid in (select authorid from books where popularityrating<=5)
select authorname from authors where authorid in (select BookId from books where popularityrating<5)
select authorname from authors where authorid in (select authorid from books where popularityrating in (0,5))

Question 18

An RDBMS performs the following steps:
1)It calculates the results of the group functions of each group
2)It groups those rows together based on the group by clause
3)It orders the groups based on the results of the group functions in the order by clause
4)It chooses and eliminates groups based on the having clause
5)It chooses rows based on the where clause
Arrange the above steps in the correct order of execution:

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

Question 19

Question 20

There is a column c1 in the table t to which a primary key pk is to be added. What will be the correct syntax?

Alter table t add primary key(c1);
Alter table t add constraint pk primary key(c1);
Alter table t add (constraint pk primary key(c1));
Alter table t add pk constraint primary key(c1);

Question 21

Question 22

A table Students has a column called name which stores the names of the students. What will be the correct query to display the names of the students in reverse order?

Select name from students reverse;
Select name from students reverse name;
Select name from students order by name descending;
Select name from students order by name reverse;
Select name from students order by name desc;
Select desc name from students;
Select reverse name from students;

Question 23

oDesk Skill test Answer Sheet

oDesk Readiness Test Answer 2012

oDesk SEO Skill Test

oDesk Photoshop-CS3 skill test Test Answer

Odesk English Spelling Test (U.S. Version)

Odesk test answers - SQL Test

Odesk U.S English Basic Test Answer

Odesk English Vocabulary Test U.S.

Php 5 Odesk skill test Answer

Wordpress test Answer

Odesk joomla test slution

Windows XP Odesk test Answer

Odesk Photoshop CS3 Skill Test answers 2012

1.Q: Changing units on the Info Palette automatically changes the units on Rulers.

A: TRUE

2.Q: Which of the following Filters cannot be applied to a Smart Object?

A: Pattern Maker

3.Q: With which of the given options does the Signal Strength Meter appear?

A: It appears when you choose 'merge to hdr command'

4.Q: Channels can not be added to which of the following image modes?

A: Bitmap

5.Q: Which among the following Modes does not support layers?

A: All of the above