Hello world!
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!
1 comment December 18th, 2011
Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!
1 comment December 18th, 2011
>
Add comment November 22nd, 2011
2 comments September 14th, 2011
>
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC
Posted by http://easyeran.blogspot.com/
Which of the following is not a numeric group function?
Avg
Count
Highest
Max
Stdev
Sum
Posted by http://easyeran.blogspot.com/
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));
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
Which of the following clauses are not allowed in a single row sub-query?
From
Where
Group by
Having
Order by
Wh
at is the collection of information stored in a database at a particular moment called?
Schema
Instance
Table
Cluster
View
Index
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
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’)
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
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
="color: grey; font-style: italic;">--------
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)
What does the term DDL stand for?
Data Description Language
Dynamic Data Language
Data Definition Language
Data Derived Language
Descriptive Data Language
The concept of data independence is similar to the concept of ________
Data type
Abstract data type
Consolidation
Isolation
What are the programs that execute automatically whenever DML operations are performed on tables called?
Triggers
Procedures
Functions
None of the above
What clause should be used to display the rows of a table in ascending order of a particular column?
Where
Order By
Group By
Having
First Group By and then Having
Like
Between
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
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
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))
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
_________ is the operation that displays certain columns from the table.
Restriction
Intersection
Join
Union
Projection
Selection
Extraction
SubQuery
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);
Which of the following are aggregate functions in SQL?
Avg
Select
Order By
Sum
Union
Group by
Having
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;
The primary key index does not allow ________ data in a field.
Numeric
Character
Date
Null
Duplicate
All of the above
Posted by http://easyeran.blogspot.com/
1 comment May 31st, 2011
>
Q.NO.1.
1 comment May 26th, 2011
>
To Starting your freelancing job is somewhat challenging. There are a number of things that you should consider in clinching your desired freelance job. I personally love freelancing jobs as I don’t have to go to an office sitting for hours and getting some badly commands from my Boss. I am free and I do what I love to do. I do my jobs sitting on my relaxing armchair whenever I love. However, truth be told that, it’s not easy to get a freelance job unless you know the exact and appropriate strategies. There are millions of people around the world who seek freelance jobs every day. But do all of them get their desired job? However, no big deal, I am going to tell you how to get a freelance job by the means of odesk.
1. Getting An Overall Idea:
People around the world are getting smarter day by day by the means of technological advancement. However, before starting your freelance career, I personally believe that you have to have a crystal and clear idea about a freelance site. However, visit the website and get an overall idea. Go to you tube and see the animated video. Here are the links:
Website: www.odesk.com
You Tube: http://www.youtube.com/results?search_query=odesk
2. Sign Up:
I hope you have got a clear idea about odesk. However, now it’s time to sign up. Go to the website and sign up by filling some pieces of information. Sadly, most of the new freelancers don’t seem interested in uploading a photograph. But, I personally think, a photograph is an important thing for your freelance career. Visibility is very important to a buyer. Make sure that you fill everything with valid and correct information.
3. Complete Your Profile:
It’s very disappointing that, most of the new providers don’t complete their profile on odesk. However, in order to get your first freelance job, you have to complete your profile with legitimate information. Make sure that you fill all categories correctly including portfolio projects, employment history, education, certifications etc. Your profile will look good and you will have better chance of getting your first freelance jobs upon completing your profile.
Ø Be careful in choosing/writing your objectives. Your objective should focus on your skills.
Ø Be careful in choosing your hourly rate. It’s recommended that in the primary stage it shouldn’t be more than $ 12/ hour. You may increase/ decrease the rate later.
4. Take Some Tests:
Taking some tests make your profile attractive that simply helps you get your first freelance job. However, on odesk you will find hundreds of tests. For instance if you are a PHP developer, you may take php tests, if you are article writer; you should take some writing skill test. However, I recommend that every new provider who is looking for a freelance job should take Basic English language proficiency tests. Such as, US English basic skills test, UK English test etc. In order to get a freelance job, it’s important that you have minimum English language proficiency.
5. Make a Good Cover Letter:
Well, it’s time to make a good cover letter. A cover letter is one of the key elements of getting your first freelance job. However, so what is a cover letter? A cover letter is kind of letter that primarily includes your skills, qualifications, work experience etc. This is the first thing that your buyer will notice prior to hiring you. For each and every job, you have to apply with a cover letter. However, I added some cover letter in my blog. See here “Free Ebooks Section.”
Finally, I can say that it may take a few days for you to get your first freelance job by the means of odesk. However, you would be surprised that, it took me almost a month to get a job. The situation was like that I lost the hope of getting a job. Nevertheless, the reason was that, my profile wasn’t complete and my job cover letter wasn’t appealing. So, be patient and consistent. Your desired job is waiting for you.
Add comment May 26th, 2011
>
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
Add comment May 26th, 2011
>
Some Times We are Suffer a Problem with earn in Online ,This is Bidding Problem .
No Problem You Can Earn Online Easily In MICROWORKERS.COM
You Earn UP to $4 Per Day.
So You Get Your Decision .
Add comment May 26th, 2011
>
Add comment May 25th, 2011
>
Add comment May 22nd, 2011