Deakin University Scholarship

Address
P.O.Box125, Belmount Victoria 3216 Australia.

Eligibility
For Master’s Degree in any subjects . a) First class Bachelor’s & Master’s Degree . b) Good in English.

Categories: Australia Tags:

SQL interview questions

SQL interview questions

Which of the following statements contains an error?

SELECT * FROM emp WHERE empid = 493945;
SELECT empid FROM emp WHERE empid= 493945;
SELECT empid FROM emp;
SELECT empid WHERE empid = 56949 AND lastname = ‘SMITH’;

Which of the following correctly describes how to specify a column alias?

Place the alias at the beginning of the statement to describe the table.
Place the alias after each column, separated by white space, to describe the column.
Place the alias after each column, separated by a comma, to describe the column.
Place the alias at the end of the statement to describe the table.

The NVL function

Assists in the distribution of output across multiple columns.
Allows the user to specify alternate output for non-null column values.
Allows the user to specify alternate output for null column values.
Nullifies the value of the column output.

Output from a table called PLAYS with two columns, PLAY_NAME and AUTHOR, is shown below. Which of the following SQL statements produced it?

PLAY_TABLE
————————————-
“Midsummer Night’s Dream”, SHAKESPEARE
“Waiting For Godot”, BECKETT
“The Glass Menagerie”, WILLIAMS
SELECT play_name || author FROM plays;
SELECT play_name, author FROM plays;
SELECT play_name||’, ‘ || author FROM plays;
SELECT play_name||’, ‘ || author PLAY_TABLE FROM plays;

Issuing the DEFINE_EDITOR=”emacs” will produce which outcome?

The emacs editor will become the SQL*Plus default text editor.
The emacs editor will start running immediately.
The emacs editor will no longer be used by SQL*Plus as the default text editor.
The emacs editor will be deleted from the system.

The user issues the following statement. What will be displayed if the EMPID selected is 60494?

SELECT DECODE(empid,38475, “Terminated”,60494, “LOA”, “ACTIVE”)
FROM emp;
60494
LOA
Terminated
ACTIVE

SELECT (TO_CHAR(NVL(SQRT(59483), “INVALID”)) FROM DUAL is a valid SQL statement.

TRUE
FALSE

The appropriate table to use when performing arithmetic calculations on values defined within the SELECT statement (not pulled from a table column) is

EMP
The table containing the column values
DUAL
An Oracle-defined table

Which of the following is not a group function?

avg( )
sqrt( )
sum( )
max( )

Once defined, how long will a variable remain so in SQL*Plus?

Until the database is shut down
Until the instance is shut down
Until the statement completes
Until the session completes

The default character for specifying runtime variables in SELECT statements is

Ampersand
Ellipses
Quotation marks
Asterisk

A user is setting up a join operation between tables EMP and DEPT. There are some employees in the EMP table that the user wants returned by the query, but the employees are not assigned to departments yet. Which SELECT statement is most appropriate for this user?

select e.empid, d.head from emp e, dept d;
select e.empid, d.head from emp e, dept d where e.dept# = d.dept#;
select e.empid, d.head from emp e, dept d where e.dept# = d.dept# (+);
select e.empid, d.head from emp e, dept d where e.dept# (+) = d.dept#;

Developer ANJU executes the following statement: CREATE TABLE animals AS SELECT * from MASTER.ANIMALS; What is the effect of this statement?

A table named ANIMALS will be created in the MASTER schema with the same data as the ANIMALS table owned by ANJU.
A table named ANJU will be created in the ANIMALS schema with the same data as the ANIMALS table owned by MASTER.
A table named ANIMALS will be created in the ANJU schema with the same data as the ANIMALS table owned by MASTER.
A table named MASTER will be created in the ANIMALS schema with the same data as the ANJU table owned by ANIMALS.

User JANKO would like to insert a row into the EMPLOYEE table, which has three columns: EMPID, LASTNAME, and SALARY. The user would like to enter data for EMPID 59694, LASTNAME Harris, but no salary. Which statement would work best?

INSERT INTO employee VALUES (59694,’HARRIS’, NULL);
INSERT INTO employee VALUES (59694,’HARRIS’);
INSERT INTO employee (EMPID, LASTNAME, SALARY) VALUES (59694,’HARRIS’);
INSERT INTO employee (SELECT 59694 FROM ‘HARRIS’);

Which three of the following are valid database datatypes in Oracle? (Choose three.)

CHAR
VARCHAR2
BOOLEAN
NUMBER

Omitting the WHERE clause from a DELETE statement has which of the following effects?

The delete statement will fail because there are no records to delete.
The delete statement will prompt the user to enter criteria for the deletion
The delete statement will fail because of syntax error.
The delete statement will remove all records from the table.

Creating a foreign-key constraint between columns of two tables defined with two different datatypes will produce an error.

TRUE
FALSE

Dropping a table has which of the following effects on a nonunique index created for the table?

No effect.
The index will be dropped.
The index will be rendered invalid.
The index will contain NULL values.

To increase the number of nullable columns for a table,

Use the alter table statement.
Ensure that all column values are NULL for all rows.
First increase the size of adjacent column datatypes, then add the column.
Add the column, populate the column, then add the NOT NULL constraint.

Which line of the following statement will produce an error?

CREATE TABLE goods
(good_no NUMBER,
good_name VARCHAR2 check(good_name in (SELECT name FROM avail_goods)),
CONSTRAINT pk_goods_01
PRIMARY KEY (goodno));
There are no errors in this statement.

MAXVALUE is a valid parameter for sequence creation.

TRUE
FALSE

Which of the following lines in the SELECT statement below contain an error?

SELECT DECODE(empid, 58385, “INACTIVE”, “ACTIVE”) empid
FROM emp
WHERE SUBSTR(lastname,1,1) > TO_NUMBER(’S’)
AND empid > 02000
ORDER BY empid DESC, lastname ASC;
There are no errors in this statement.

Which function below can best be categorized as similar in function to an IF-THEN-ELSE statement?

SQRT
DECODE
NEW_TIME
ROWIDTOCHAR

Which two of the following orders are used in ORDER BY clauses? (choose two)

ABS
ASC
DESC
DISC

You query the database with this command

SELECT name
FROM employee
WHERE name LIKE ‘_a%’;

Which names are displayed?
Names starting with “a”
Names starting with “aR
or “A”
Names containing “aR
as second character
Names containing “aR
as any letter except the first

Categories: Interview Questions Tags:

The Queen’s University of Befast : Visiting Fellowship

Address
The Secretary to Academic Council, The Queen’s University of Belfast, Belfast BT7 1NN, Northern Ireland.

Eligibility
Doctoral degree or research of an equivalent standard. Those who are presently doing research in the University or have done research within the past five years are not eligible.

Application details
Probable Date of Application : 10 January.

Other Information
Value of Fellowship : 13,941 to 17,007 Pounds p.a. depending on qualification and experience.

Categories: UK - Art/Law/Literature Tags:

CPWD – Junior Engineers (Civil/Electrical)

Basic Information regarding Exam
An All India Competitive Examination is held for recruitment to the grade of Junior Engineers (Civil/Electrical) in Central Public Works Department.

Age limit
(i) l8 to 25 years. Upper age limit is relaxable upto 5 years for SC/ST and in certain cases of displaced persons;
(ii) Relaxable for Departmental candidates employed in CPWD having prescribed qualification upto 35 years (40 for SC/ST);
(iii) Relaxable for Physically Handicapped persons upto ten years;
(iv) Relaxable for Ex-Servicemen by the length of Military Service plus 3 years.
Read more…

Categories: Miscellaneous Examinations Tags:

British Telecom Cambridge Scholarships (India)

Address
The Cambridge Common Wealth Trust (TPG ), c/o Nehru Trust for Cambridge University, Teen Murti House, Teen Murti Marg, New Delhi – 110011.

Eligibility
Candidates should have a good academic record.
Age : 26 years (on 1st October).

Period of scholarship
Three years.

Application details
1st September for the following year for postgraduate studies. 15th October for affiliated students.

Other Information
Subjects : Telecommunication and related subjects.
Level : Second Bachelor’s Taught postgraduate.

Categories: Britain Tags:

National Board of Higher Mathematics Scholarships for Research Awards

Eligibility
a) Master’s Degree in physics /Mathematics or Statistics. b) Register his name for Ph.D.in Mathematical Science.

Other Information
Value of research award : Rs.2700/-pm for initial 2 years & then Rs.3000/-pm for further period plus Rs.5000/- pa towards contingencies. Period of award : Initially for one year & extended up to 5 years if necessary.

Categories: Scholarships in Mathematicals Tags:

Jawaharlal Nehru Memorial Fund.

Address
The Administrative Officer, Jawaharlal Nehru Memorial Fund, Teen Murti House, New Delhi,Delhi.

Eligibility
Post-graduate degree in first division
Age : Minimum 35 years.

Application details
31st May.

Other Information
Scope for studies : Science policy, Technology, Global restructuring, Philosophy, History, Civilization, Culture, Environment, Economic, suitable Development.

Categories: Doctoral Fellowship PSTs Tags:

Graduate Level Combined Examination-Main Examination (Group-B)

Basic Information regarding Exam
The Staff Selection Commission shall hold a Combined Main Examination for candidates who have been declared qualified in the Preliminary Examination. The nationality, age, qualifications, physical/medical standards are same as mentioned in Preliminary Examination details.

Examination Fee
Rs 60/- (Rupees Sixty Only). No fee for SC/ST/Ex-S/PH.

Plan of Examination

General Note about Examination Scheme
Scheme and the Subjects for the main examination: (Conventional Type) for Recruitment to the Posts of Divisional Acctts/ Auditors/UDCs.
The Main Examination will consist of the following two papers :

1 Paper I (Part a)
Subjects – General English
Marks – 50

2 Paper (Part b)
Subjects – General Studies (Option to answer in Hindi or English)
Duration – 2 Hours including Paper 1 (Part a)
Marks – 50

3 Paper II
Subjects – Arithmetic (Option to answer in Hindi or in English)
Duration – 2 Hours
Marks – 100 Read more…

Categories: SSC Examinations Tags:

British Gas University of Strathclyde Foreign and Common Wealth Office Post Graduate Scholarships

Address
The Registrar General, University of Strathclyde, Glasgow G1 1XQ, Scotland, U.K.

Period of scholarship
One year.

Application details
Last Date : February.

Other Information
6 scholarships are offered worldwide for studies in Engineering, Applied Sciences, Business administration level at postgraduate by research or instruction. Outstanding candidates can be considered for Ph.D. level.
Value: Airfares, tuition fees, living expenses, allowance for books and Pre course language tuition, if required.

Categories: Britain Tags:

The Institute of Mathematics Scholarships

Address
Chief Administrative Officer, the Institute of Mathematical Sciences, Taramani, Madras.

Eligibility
M.Sc. or equivalent degree in Mathematics/Physics/Computer Science with an excellent academic record and a strong motivation for research. Exceptionally a talented B.Sc., B.Tech. or B.E. candidates with proven aptitude for research may also apply. Selected candidates undergo vigours course work and work towards Ph.D.degree.

Application details
Last Date : April

Other Information
The Institute of Mathematical Sciences offers research fellowships in mathematical, theoretical Physics and theoretical Computer Science. The fellowships carry a stipend of Rs 2200/-pm during the first two years and thereafter may be enhanced to Rs 2500/- pm.

Categories: Scholarships in Mathematicals Tags:

National Geographic Society (Research In Science Pertinent To Geography)

Address
The secretary, Committee for Society, 17th & M Street N W, Washington DC20036, U.S.A.

Eligibility
Ph.D. or equivalent & associated with institutions of higher learning or other scientific & educational non-profit organisations or museums. Ph.D. candidates must submit their recent publication.

Other Information
Value of Scholarship : US$15,000 to 20,000 p.a.

Categories: USA Tags:

Intel interview questions

Intel interview questions

The following questions are used for screening the candidates during the first interview. The questions apply mostly to fresh college grads pursuing an engineering career at Intel.
Have you studied buses? What types?

Have you studied pipelining? List the 5 stages of a 5 stage pipeline. Assuming 1 clock per stage, what is the latency of an instruction in a 5 stage machine? What is the throughput of this machine ?

How many bit combinations are there in a byte?

For a single computer processor computer system, what is the purpose of a processor cache and describe its operation?

Explain the operation considering a two processor computer system with a cache for each processor.

What are the main issues associated with multiprocessor caches and how might you solve them?

Explain the difference between write through and write back cache.

Are you familiar with the term MESI?

Are you familiar with the term snooping?

Describe a finite state machine that will detect three consecutive coin tosses (of one coin) that results in heads.

In what cases do you need to double clock a signal before presenting it to a synchronous state machine?

You have a driver that drives a long signal & connects to an input device. At the input device there is either overshoot, undershoot or signal threshold violations, what can be done to correct this problem?

What are the total number of lines written by you in C/C++? What is the most complicated/valuable program written in C/C++?

What compiler was used?

What is the difference between = and == in C?

Are you familiar with VHDL and/or Verilog?

What types of CMOS memories have you designed? What were their size? Speed?

What work have you done on full chip Clock and Power distribution? What process technology and budgets were used?

What types of I/O have you designed? What were their size? Speed? Configuration? Voltage requirements?

Process technology? What package was used and how did you model the package/system? What parasitic effects were considered?

What types of high speed CMOS circuits have you designed?

What transistor level design tools are you proficient with? What types of designs were they used on?

What products have you designed which have entered high volume production?

What was your role in the silicon evaluation/product ramp? What tools did you use?

If not into production, how far did you follow the design and why did not you see it into production?

Categories: C++ Tags:

Hungarian Government Scholarship

Address
The Deputy Educational Adviser, Ministry of Human Resource Development, Department of Education, A-1/W-3 Curzon Road Barracks, Kasturba Gandhi Marg. New Delhi.

Number of scholarships
6 Seats

Eligibility
Uniformly good academic record with 60% or above marks at Master’s Degree in the subject concerned or related field.
Age: Below 33 years as on 1st July. The upper age limit is however relaxable upto two years for scheduled casts/scheduled Tribe candidates.

Other Information
Scholarships are offered for research in – a) Linguistics b) Literature c) Maths d) Economics
Value of Scholarship : Expenditure on boarding & lodging, internal travel related to the studies etc. is met by the Hungarian Government.

Categories: Other Countries Tags:

Kendriya Vidyala Sangathan (RP II Section): 18,Institutional Area,Shaheed Jeet Singh Marg, New Delhi-110016

Basic Information regarding Exam
Applications are invited from Indian Nationals for recruitment to the following posts to fill the vacancies of teachers in Kendriya Vidyala Sangathan.

Age limit
Post : I Primary Teachers
Age as on June 30 : 30 years or less

Post : II Trained Graduate Teachers
Age as on June 30 : 35 years or less

Post : III Post-Graduate Teachers
Age as on June 30 : 40 years or less Read more…

Categories: Miscellaneous Examinations Tags:

Windows admin interview questions

Windows admin interview questions

Describe how the DHCP lease is obtained. It’s a four-step process consisting of (a) IP request, (b) IP offer, © IP selection and (d) acknowledgement.

I can’t seem to access the Internet, don’t have any access to the corporate network and on ipconfig my address is 169.254.*.*. What happened? The 169.254.*.* netmask is assigned to Windows machines running 98/2000/XP if the DHCP server is not available. The name for the technology is APIPA (Automatic Private Internet Protocol Addressing).

We’ve installed a new Windows-based DHCP server, however, the users do not seem to be getting DHCP leases off of it. The server must be authorized first with the Active Directory.

How can you force the client to give up the dhcp lease if you have access to the client PC? ipconfig /release

What authentication options do Windows 2000 Servers have for remote clients? PAP, SPAP, CHAP, MS-CHAP and EAP. Read more…

Categories: Networking Tags:

The Mineral Industries Educational Trust : Minerals Industry scholarships and Bursaries

Address
The Secretary, The Mineral Industries Educational Trust, 6 St. Jame’s Square, London SW1Y 4LD, U.K.

Eligibility
Candidates with a high standard of general education. Postgraduate awards are available only to candidates with first class degrees in other subject, but who are seeking to transfer into the mineral industry. The awards are tenable at the following universities: Brimingham, Cardiff, Exeter, Leeds, Leicester, London(Royal Schools of Miners, Imperial College of Science, Technology and Medicine), Nottingham.

Period of scholarship
For the duration of the course, subject to satisfactory progress.

Application details
Probable Date of Application : February 28th.

Other Information
Scholarships and Bursaries are offered worldwide. Subject : Mining/Quarry Engineering, Mineral Processing, Extractive Metallurgy, Material Science, Mining Geology and Chemical Engineering. Level : Undergraduate, Taught Postgraduate. Value : For undergraduate Pounds 1,250 p.a. (bursaries) and Pounds (1,750 (scholarships), for post graduate pounds 2,000

Categories: UK - Engineering Science Tags:

University of London, Imperial College of Science, Technology and Medicine : Andre Dorfman Fellowship in Mining

Address
Assistant Registrar (Admissions), Imperial College of Science, Technology and Medicine, London, SW7 2AZ, U.K.

Eligibility
Applicants should hold a good honours degree in mining or an equivalent qualification.

Application details
Probable Date of Application : 15 March.

Other Information
This fellowship is offered worldwide at ;postgraduate level for a maximum of three years. Value : A some of maintenance plus college fees.

Categories: UK - Engineering Science Tags:

British Digestive Foundation

Address
The British Digestive Foundation, 3 St. Andrew’s Place Regent’s Park, London NW1 4LB, U.K.

Eligibility
Medical graduates with higher qualification recognised in the U.K. candidates must be supported by a Research Director in an establishment / project department of gastroenterology. The award is intended for younger trainees.

Categories: UK - Medical Science Tags:

University of Manchester Institute of Science and Technology (UMIST) : Burrows Moore Research Fellowship

Address
The Registrar, UMIST, PO Box 88, Manchester M60 1QD, U.K.

Eligibility
Candidates with graduate degree of any university who have been accepted for study at UMIST.

Other Information
Fellowship is offered worldwide. Subject : Chemical Engineering.

Categories: UK - Engineering Science Tags:

ITBP Sub- Inspector (Stenographer)

Basic Information regarding Exam
Applications are invited from male and female Indian citizens for the post of Sub- Inspector (Stenographers) in Indo-Tibetan Border Police.

Age limit
Between 18 to 25 years as on the date of recruitment ( relaxable upto 30 years for ST and upto 40 years for Govt. servants).

Minimum Educational Qualification
Matriculation or equivalent. Technical Qualification: Minimum speed of lOO words per minute in English Shorthand -and 30 words per minute in English typing or 80 words per minute in Hindi Shorthand and 25 words per minute in Hindi typing. The candidates having knowledge of shorthand and typing both in Hindi as well as in English will be accorded preference.

Details Regarding Selection Procedure

Other Information
Other details like Physical Standards, Method of Selection and How to Apply are
same as for ITBP Naik (CM).

Pages: Prev 1 2 3 4 5 6 7 8 9 10 ...27 28 29 Next