DML Commands Guide: SELECT, INSERT, UPDATE, DELETE Explained, Exams of Computer Applications

Learn the essential Data Manipulation Language (DML) commands for managing data in relational databases. This guide covers the syntax and usage of SELECT, INSERT, UPDATE, and DELETE with practical SQL examples to query and modify your database effectively.

Typology: Exams

2024/2025

Available from 11/26/2025

PROF-DURK
PROF-DURK 🇰🇪

2.5K documents

1 / 176

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29
pf2a
pf2b
pf2c
pf2d
pf2e
pf2f
pf30
pf31
pf32
pf33
pf34
pf35
pf36
pf37
pf38
pf39
pf3a
pf3b
pf3c
pf3d
pf3e
pf3f
pf40
pf41
pf42
pf43
pf44
pf45
pf46
pf47
pf48
pf49
pf4a
pf4b
pf4c
pf4d
pf4e
pf4f
pf50
pf51
pf52
pf53
pf54
pf55
pf56
pf57
pf58
pf59
pf5a
pf5b
pf5c
pf5d
pf5e
pf5f
pf60
pf61
pf62
pf63
pf64

Partial preview of the text

Download DML Commands Guide: SELECT, INSERT, UPDATE, DELETE Explained and more Exams Computer Applications in PDF only on Docsity!

DML (ASCP) EXAM LATEST 2024/2025 WITH ACTUAL QUESTIONS AND CORRECT VERIFIED ANSWERS/ALREADY GRADED A+ the radioactive method used to measure red cell survival uses which of the following isotopes? - .....ANSWER SH AS 51Cr which condition can be associated with macrocytes and large ovalocytes? - .....ANSWER ... f% ZW megaloblastic anemia which alpha thalassemia syndrome has the genotype - a/aa? - .....ANSWER ...f WA silent carrier alpha thalessemia minor genotype - .....ANSWER TFA oS --/aa, -a/-a hemoglobin H disease genotype - .....ANSWER ... 4% AW --/-a 2) a laboratory test to determine heparin levels in a patient's plasma is? - .... ANSWER ... f & Anti-factor Xa assay a small child has albino characteristics, photophobia, frequent pyogenic infection, and her blood smear shows giant dark granules in her monocytes and granulocytes. what is the diagnosis? - .....ANSWER ...f% W chediak hegashi syndrome pelger heut is associated with bi-lobed neutrophil alder rielly is associated with genetic mucopoly saccharidoses You are evaluating a potentially malignant effusion (e.g. peritoneal or pleural fluid) and you note cells that appear to be some type of tumor cells. How would you follow up/report this? - ....ANSWER ... % @ Consult a pathologist and confirm that the specimen has been sent to cytology for analysis Which of the following represent other hemoglobin gene loci that occur on the same chromosome As the beta chain loci? - .... ANSWER ...W% W Delta and gamma 4| A balloon-like bulge filled with blood formed due to a weakness in the wall of a blood vessel is known as: - seeee ANSWER ... A WZ Aneurysm An example of a neoplastic proliferative disease of the plasma cells is: - ....ANSWER ...WZ%W Multiple myeloma (also known as plasma cell myeloma) A peripheral smear demonstrates a population of cells composed of red cells that are mostly 5 - 5.5 um in diameter. The CBC data shows RDW of 13% (reference range 11.5-14.5%). Which of the following morphologies is consistent with these findings? - sesee ANSWER ... Y% W Microcytosis, low variation of cell volume A few dark blue staining granular inclusions located near the periphery of an erythrocyte are most likely: - oom ANSWER ... WZ W Pappenheimer bodies Fifty percent blasts are found on a peripheral blood smear. The cells are large (3-5x the size of a lymphocyte) with a nucleus that contains homogeneous fine chromatin and two to three nucleoli. There is moderate blue-grey cytoplasm with Aver rods. What 5| leukemia is most likely? - .....ANSWER ...WZ% WZ Acute myelogenous leukemia (AML) Which ethnic group has the highest incidence of hereditary hemochromatosis in the United States? - sesee ANSWER ... YW W Caucasians Where is the main site of action for monocytes after diapedesis? - .... ANSWER ... WZ W Body tissues Methylene blue stain works by: - ....ANSWER ... 7% A Staining cellular components that have an acidic pH such as ribosomes, DNA, and RNA Which white blood cell population would have the MOST side scatter when analyzed using flow cytometry? - we. ANSWER ... Y% WY Granulocytes All of the following methods are used in the diagnosis and classification of acute leukemia, EXCEPT? - seses ANSWER ... YW W Reticulocyte count Complaints of pain from a patient with sickle cell disease are most likely associated with which of the 7\ Platelets= 5°1049/L Bone Marrow M:E ratio= 3:1 megakaryocytes= increased these results are most suggestive of which condition? - exc ANSWER ... Y% W Immune (idiopathic) thrombocytopenic purpura Why is hereditary hemochromatosis (HH) thought to be underdiagnosed? - .... ANSWER ... 47 WA Its early symptoms are nonspecific and vague, and generally do not get serious until later in life. Which of the following is an important technique consideration in order to obtain consistently high quality bone marrow smears? - ..... ANSWER ... WW Select or concentrate bone marrow spicules, ensuring they are transferred to the slide. Which of the following red cell inclusions are often found in peripheral blood smears of patients with sideroblastic anemia? - ..... ANSWER ... 7 A Pappenheimer bodies A peripheral blood smear with many myeloid cells was presented for morphology review (see image on the right). Toxic granulation and vacuoles in the neutrophil most likely represent which of the following conditions? - sesee ANSWER ... Y% W Septicemia The cells which release von Willebrand's Factor (vWF) are: - .... ANSWER ...Y% W Platelets and endothelial cells An increased reticulocyte count MAY be found in all of the following conditions, EXCEPT2 - .... ANSWER ... 47 A Aplastic anemia Which of the following assays is commonly used to confirm the diagnosis of Activated Protein C resistance? - sesee ANSWER ... YW W Factor V Leiden Mutation Assay Ristocetin is used in certain von Willebrand Factor (VWF) functional assays. The reason it is used is because: - .....ANSWER ... WZ AW Ristocetin enhances binding of vWF to platelet GPlb. All of the cells listed below function as a phagocyte, EXCEPT? - ..... ANSWER ...W W Eosinophils 10 | Which potent inhibitor of platelet aggregation is released by endothelial cells? - .... ANSWER ... 7 A Prostacyclin manual white blood cell count was performed by the hematology technologist. The cell counts for both sides were 99 and 164 respectively. All nine large squares were counted on each side. The dilution for this kit was pre-measured at 1:100. What should the technologist report as the white cell count? - ....ANSWER ... 7 A Cannot report Which of the following is a clinical symptom that is associated with thrombocytopenia? - ....ANSWER AS S& Petechiae What is a common early laboratory marker of hereditary hemochromatosis (HH)? - .....ANSWER ..F% A Increased serum ferritin Which of the following hemoglobins is known to migrate with HbS during electrophoresis when an alkaline gel, such as cellulose acetate, is used? - ..... ANSWER ... 7 A D | Degenerated erythrocyte cytoplasmic organelles that contain iron are called: - ....ANSWER ..7% A Pappenheimer bodies Toxic granulation is seen most frequently in: - sesee ANSWER ... WY AW Bacterial infections What is the MOST likely explanation for a patient with sickle cell anemia whose hemoglobin has dropped to 4 g/dl and has a reticulocyte count of 0.1%? - sesee ANSWER ... A AW Aplastic crisis All of the following disorders would affect the results of a Prothrombin time (PT) EXCEPT? - .... ANSWER ... 7 A Factor VIII deficiency If a patient has three inactive alpha globin genes, which of the four alpha (a) thalassemia classifications would he/she have? - ..... ANSWER ...W% &@ Hb H disease All of the following can cause erroneously decreased automated platelet counts EXCEPT? - .... ANSWER .- A SY WEC fragmentation 13 | As one of the morphological families of parasites, a feature that characterizes various Nematode species Is: - ANSWER ... 4% A Filariform larvae may serve as an infective form for humans. An acid-fast bacillus is isolated and produces an orange pigment when grown in either the light or the dark. Which type of organism has most likely been isolated? - sesee ANSWER ... Y% WZ Scotochromogen Streptococcus pneumoniae can be isolated from peritoneal fluid and identified by molecular testing. One method of testing used to identify Streptococcus pneumoniae is molecular hybridization. All of the following steps must be followed to ensure that false positive results do not occur when testing for Streptococcus pneumoniae EXCEPT? - ....ANSWER eS A Inhibitors must be removed The adult fluke related to the 100 um ovum, as illustrated in the image shown, most commonly inhabits the lung parenchyma. The ovum, as may be observed in a sputum specimen, has a smooth, slightly thickened shell with a prominent shouldered operculum as seen at the left lower end. A developing larvae is observed within, retracting from the inner marginof the shell leaving a clear space. Infections with this fluke are endemic in the 14] orient, in West Africa, in South and Central America and may be observed in patients elsewhere after travel to one of these regions. Humans become infected after ingestion of poorly cooked crab meat or crayfish contaminated with metacercariae. Intermittent chest pain, and cough with occasional spitting up of blood (hemoptysis) may be experienced after infection. From the choices below, select the trematode species related to this ovum. - .....ANSWER ...wW WZ Parogonimus westermani The suspicious form in this photograph was recovered from a bone marrow sample and measures 11 um in length. What is the MOST likely identification of this organism? - ..... ANSWER ...WZ W Leishmania promastigote What specimen type should be gently minced before inoculating fungal media? - .....ANSWER ... WY W Tissue Nocardia farcinica has been distinguished from other embers of the Nocardia asteroides complex because most strains are resistant to several extended spectrum antimicrobial agents and other antibiotics commonly used to treat nocardia infections, and are more commonly recovered from patients with severe underlying illness. Each of these characteristics are 16 | Of the Gram-negative bacilli listed below, which is motile with polar tufts of flagella and can produce yellow - .... ANSWER ...wW W Burkholderia cepacia illustrated in the image to the right is a tube of tryptophane agar with a positive indole reaction, as seen by the red ring top of the medium. It is necessary to use xylene extraction and Ehrlich's reagent rather than the conventional Kovac's when detecting indole production by which of the following organisms: - sesee ANSWER ... % WZ O Chryseobacterium (Flavobacterium) meningosepticum Which organism will cause amebiasis and is considered pathogenic? - .... ANSWER ... WZ W Entamoeba histolytica Which of the following parasites is known to contain cytoplasmic ingested red blood cells in the trophozoite morphologic form? - ....ANSWER ... 7% W E. Histolytica and E. Gingivalis What is the purpose of the iodine that is used in the Gram stain procedure? - .....ANSWER ... WZ W Fixes the 17 | crystal violet to the cellular components of gram-positive bacteria. Which of the following arthropods are an important part of the life cycle of Plasmodium species? - sesee ANSWER ... WY W Anopheles What organism matches the tissue morphological features of separate hyphae, 5-10 um in diameter that exhibit dichotomous branching - ....ANSWER ... 7 A Aspergillus species Enterobius vermicularis infection is acquired by: - sone ANSWER ... Y% WM Ingestion or inhalation of egg The minimum time of retention for microbiology test reports is? - ....ANSWER .. VW YW 2 years What bacteria is responsible for the bubonic plaque? - secee ANSWER ... WZ A Yersinia pestis A vaginal swab for anaerobic culture is received in the laboratory. How should this specimen be handled? - secee ANSWER ... WW The specimen should be rejected 19 | All of the following Mycobacterium species will cause tuberculosis, EXCEPT? - ..... ANSWER ... 7 A Mycobacterium leprae All of the following information should be included in a direct microscopic examination of a Gram stained culture smear report EXCEPT: - .....ANSWER ... 47 A Flattened cells Which of the following represents the lower reference limit for semen volume? - ..... ANSWER ... 7% AW 1.5 mL or 2.0 mL (2-5 mL) Leucine crystals in urine - ....ANSWER ... WW Maple syrup urine disease Which of the following may cause a false-positive protein reading on a urinalysis dipstick? - .....ANSWER GS SG Urine specimen is highly pigmented alkaline urine, high specific gravity 20 | In a patient with acute glomerulonephritis you would expect to find all of the following in the urine EXCEPT: - sesee ANSWER ... AY W Yeast All of the following are standard methods for measuring the specific gravity of urine, EXCEPT: - .....ANSWER SA A Freezing point depression All of the following urinalysis findings may correlate with the presence of a yeast infection, EXCEPT: - .... ANSWER WA JS 3+ red blood cells All of the following white blood cells would produce a positive leukocyte esterase test, EXCEPT? - .....ANSWER .. A% SA Lymphocytes All of the following tests are part of the routine semen analysis, EXCEPT: - .....ANSWER ... WW Fructose level Detection of a fruity odor in a fresh urine sample may be indicative of all of the following EXCEPT: - seses ANSWER ... WZ W Bacterial infection