OA3

` [Established by Govt. of Kerala]

Practical Examination – November 2011 Part I – OFFICE (Access) (Time: 45 Minute)

Marks: 50

1. Create a database ‘PERSONAL’ to have a table ‘TABLE1’ with the structure as (1 x 10 marks=10 Marks) specified below. NAME TEXT, SIZE=50 REGNUM NUMBER IDNUM

TEXT, SIZE=45

2. Design a Form as specified below. (1 x 10 marks=10 Marks)

3. Enter the following data into the database through the above form (1 x 5 marks=5 Marks) RAJAN THOMAS JAYASREE MOHAMMED KRISHNAN KUTTY KABANI NILA KAVERI VANDHANA

1425256 1425257 1425258 1425259 1425260 1425261 1425262 1425263

AB01 AB02 AB03 AB04 AB05 AB06 AB07 AB08

4. Execute the queries on the table ‘TABLE1’. (5 x 5 marks=25 Marks)

a) b) c) d) e)

Rename the table ‘TABLE1’ to ‘STUDENTS’ List the records with NAME starting with the letter ‘K’ Delete the record with REGNUM ‘1425260’. Update the record with IDNUM ‘AB07’ to ‘AC07’ Sort the NAME in the ascending order.

OA 3.pdf

Create a database 'PERSONAL' to have a table 'TABLE1' with the structure as. specified below. ... a) Rename the table 'TABLE1' to 'STUDENTS'. b) List the ...

294KB Sizes 0 Downloads 214 Views

Recommend Documents

DMCN Dierick OA
three-dimensional displacement of the centre of mass of the body (CMb) during .... platform to trigger data and provide the mean forward walk- ing speed of ...

OA Seniority List.pdf
Sign in. Loading… Whoops! There was a problem loading more pages. Retrying... Whoops! There was a problem previewing this document. Retrying.

OA Presentation11.pdf
Page 2 of 18. Snoring and OSA. Snoring is produced by obstruction of air movement during. breathing while sleeping. Snoring during sleep may be the first sign of OSA. OSA is the most common types of sleep apnea, it is caused by. partial or complete o

TN-fisheries-DEPARTMENT-OA-POST-APPLICATION-FORM ...
TN-fisheries-DEPARTMENT-OA-POST-APPLICATION-FORM-DOWNLOAD.pdf. TN-fisheries-DEPARTMENT-OA-POST-APPLICATION-FORM-DOWNLOAD.pdf.

3.OA.7divisionsquares-1.pdf
4. Players continue to take turns. A player who draws a line that completes a square. writes their initials inside it. The player may also draw an extra line on the ...

OA-Industrial Development Corporation.pdf
www.keralapsctips.blogspot.in. Page 2 of 2. OA-Industrial Development Corporation.pdf. OA-Industrial Development Corporation.pdf. Open. Extract. Open with.

ph color chart OA multi
4.0. 5.0. 5.5. 6.0. 6.5. 7.0. 7.5. 8.0. 8.5. 9.0. 9.5. 10. pH. Universal Indicator Color Chart. 4.0. 5.0. 5.5. 6.0. 6.5. 7.0. 7.5. 8.0. 8.5. 9.0. 9.5. 10. pH. Universal Indicator Color Chart. 4.0. 5.0. 5.5. 6.0. 6.5. 7.0. 7.5. 8.0. 8.5. 9.0. 9.5. 10.

OA-HOSA SLC Achievements.pdf
Silver - Ngoc-Han Cao. 4th - Bryant Nguyen. Medical ... 10th - Merrin Joseph. Page 3 of 6. OA-HOSA SLC Achievements.pdf. OA-HOSA SLC Achievements.pdf.

BOMF 5K OA 2017.pdf
45 Phil Sandick 272 34 M 10 30-34 23:55.6 7:43/M. 46 Arielle Ennis 95 27 F 2 25-29 24:00.4 7:45/M. 47 Taylor Ourada 237 24 F 4 20-24 24:04.4 7:46/M. Results ...

oa phone meetings pdf
Download now. Click here if your download doesn't start automatically. Page 1 of 1. oa phone meetings pdf. oa phone meetings pdf. Open. Extract. Open with.

Visiestuk OA SHB 2017.pdf
Page 2 of 2. Visiestuk OA SHB 2017.pdf. Visiestuk OA SHB 2017.pdf. Open. Extract. Open with. Sign In. Main menu. Displaying Visiestuk OA SHB 2017.pdf.

OA Sixth Form Admissions Policy.pdf
Students who attended Oldbury Academy Sixth Form in the previous academic year will automatically be eligible. for consideration for entry to Year 13. Page 2 of 3. Whoops! There was a problem loading this page. OA Sixth Form Admissions Policy.pdf. OA

OA Sixth Form Admissions Policy.pdf
Loading… Page 1. Whoops! There was a problem loading more pages. Retrying... OA Sixth Form Admissions Policy.pdf. OA Sixth Form Admissions Policy.pdf.

Visiestuk OA SHB 2017.pdf
Visie SHB op Open Access vastgesteld in de ledenvergadering van het Samenwerkingsverband. Hogeschoolbibliotheken op 18 maart 2017. Inleiding.

Urgent Action requested on OA-60.pdf
illiterate Group Ds has been denied grant of ACP-I/II due to. qualification. ... Bihar SEB v. Bijay Bhadur ... Urgent Action requested on OA-60.pdf. Urgent Action ...

TN-Directorate-of-Govt-Exam-OA-Post-Application-Form-Download.p.pdf
Page 3 of 5. TN-Directorate-of-Govt-Exam-OA-Post-Application-Form-Download.p.pdf. TN-Directorate-of-Govt-Exam-OA-Post-Application-Form-Download.p.pdf.

Urgent Action requested on OA-60.pdf
Both the cases can be decided on the same verdict. WP(C).No. 8495 of 2009 (Z) Dated 24TH DAY OF MAY 2016. It is requested to issue necessary instruction ...

Cheap OA-9X Desktop Full Motion Dual Arm Laptop+Tablet PC ...
Cheap OA-9X Desktop Full Motion Dual Arm Laptop+Tabl ... Notebook 10-15 inch and All Tablet PC 7-10 inch.pdf. Cheap OA-9X Desktop Full Motion Dual Arm ...

How to manually view your PA and OA numeric scores.pdf ...
Page 1 of 3. How to manually view your PA and OA numeric score. Step 1: Open your coaching report. Step 2: Right click on the overall assessment bar at the top and choose “Inspect”. Step 3: On the upper right-hand panel, make sure Elements is sel