There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.
3 9548We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
1 1518Post New Amdocs SQL Server Interview Questions
Tell me why haven't you worked recently? : insurance sales
what is the gate of ftp server in redhat linux?
I WANT SECURITY PAPER MILL, HOSHANGABAD TEST PAPER.KINDLY SEND TO MY MAIL ID
What is the roadmap for apache driver version one.0?
what is the age limit for groups1 examination
how to start mysql server? : Sql dba
How software tester can use constants and variables in scripts?
Explain about a tricky situation for which you found a very simple solution?
How can primeng be used with angular2?
create a job that splits the data in the Jobs.txt file into
four output files. You will direct the data to the
different output files using constraints. • Job name:
JobLevels
• Source file: Jobs.txt
• Target file 1: LowLevelJobs.txt
− min_lvl between 0 and 25 inclusive.
− Same column types and headings as Jobs.txt.
− Include column names in the first line of the output file.
− Job description column should be preceded by the
string “Job
Title:” and embedded within square brackets. For example, if
the job description is “Designer”, the derived value
is: “Job
Title: [Designer]”.
• Target file 2: MidLevelJobs.txt
− min_lvl between 26 and 100 inclusive.
− Same format and derivations as Target file 1.
• Target file 3: HighLevelJobs.txt
− min_lvl between 101 and 500 inclusive.
− Same format and derivations as Target file 1.
• Rejects file: JobRejects.txt
− min_lvl is out of range, i.e., below 0 or above 500.
− This file has only two columns: job_id and reject_desc.
− reject_desc is a variable-length text field, maximum
length
100. It should contain a string of the form: “Level out of
range:
Explain parent-child context setup. How does it work? What are the advantages?
Give the balance sheet schedules ,what is differe tax, GIVE THE RATES OF DIFFERED TAX FOR THE YEAR 2008-09
What are the challenges in applying AI to environmental issues?
What are your salary requirements at Schlumberger?
What deals that have been announced publicly are we currently involved in?