Scribd
Upload
362 views62 pages

Java and SQL

Ikm java and sql

Uploaded by

Shaik Sajid
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
362 views62 pages

Java and SQL

Ikm java and sql

Uploaded by

Shaik Sajid
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF or read online on Scribd
The structure of Table T is (ID1 NUMBER NOT NULL, ID2 NUMBER) Which of the following is substituted for ****** in the DELETE statement below to delete the rows which have duplicate values for ID2. DELETE FROM T tl WHERE ROWID > * ‘A) (SELECT MIN(ROWID) FROM T t2 WHERE t2.102 = t1.102) B) (SELECT COUNT(ROWID) FROM Tt2 WHERE t2.D1 = t1.ID1) ) (SELECT MAX(ROWID) FROM T t2 WHERE t2.ID1 = t1.1D2) D) (SELECT MIN(ROWID) FROM T) E) (SELECT MAX(ROWID) FROM T WHERE COUNT(ID2) >1) -14- Which of the following statements correctly describe the inter-compatibity feature of SQL data types? A) An INTEGER static value can be inserted into a NUMERIC(10, 0) column. 134. Apython script must generate a password of length n from a string. Neither the string that generates the password nor the generated password should have any duplicate characters. Which of following code snippets will accomplish this? Assume the variable values below: String = “avsdbc” n=3 ANS: I a. import random password = ' ‘ join{[Link](string) for _ in range(n)) b. string = [Link](string) Ist = [string for xin range(n}] password = ‘ join(|st) 131. which of the following flow contral statements are valid python instructions? ANS: a. while 132. which of the following statements are carrect regarding the code def myGenerator(stop): IT z=0 while 2 < stop: yield2* 2 zte1 B= myGenerator(4) for ning: print(n, end=" ) ANS: a. gis generator abject b. zisa yield abject c. the program outputs: 0 2.46 133. while True: tmp = [num[i]] + tmp l+=1 ifi>len(mum1): break num =tmp ANS: num1 = (17, 13, 11,7, 5, 3, 2] Num = num1[: : -1] 130. sort ip list in ascending numerical order? a. |[Link](Key=lambda address: list(map(str, [Link](’.’)))) 128. which of the following correctly describe what will be in f after executing the python code f=open([Link]’)readlines()[ ANS: AE] A: Afilehandle B: an error code C: A sorted array D: The content of the file ‘[Link]" £: A python list containing all the lines in ‘[Link]’. 129. class k: T def _init_(self}: self._foo = 10 def method (self): self._methodY 0) print (self._foo) def __methodY (self): self._foo +=1 o=k0) a) [Link]() b) 0,_food ¢) o.k_method¥() d) o_init() e)o._methodY() 127. which of the follawing python code snippets will prompt a user for input and read a single line of input a) line = input(*enter user input\n") b) import sys print({[Link],"enter user input\n")) readiline) ©) printf(enter the user input\n") line = fgets) d} import svs 125. ‘Which of the following code snippets will construct a function that returns the filename unchanged, and stores that function in the dictionary with operation name id? A; def fooffilename}: return filename functions[foa}=="id" B; def foolfilename): return filename functions(“id"](}=foo €: functions[“id"]= lambda filename: filename D: def foo(filename): return lambda filename:filename Functions["id"}=foa E: def foo(filename): return filename 124. Apython program is running and must open a file name “[Link]” in a subdirectory next? of a subdirectory next of the current directory(thus,two directories down). Which of the following are portable ways to accomplish this? OPTIONS: A: Import os Fh=open([Link](“next1”,"next2", "x", “out”)) B: import os path=os,[Link](“next1”,"next2”, “x”, “out”) fh=open(path) C: fh=open(“inextl /next2/[Link]") 123. Which of the following python functions will allow a developer to get the size of a OPTIONS: A; size =[Link](filename) B: import os f-opentfilename,""”) size=[Link](os.SEEK_SET) C: impart fileinfo Size=[Link](filename) D: import os Size =[Link](filename) E: import os Import stat Size =[Link](filename)[stat.ST_SIZE] C: fh=open(“next1/next2/[Link]”) D: fheopen(“next1\next2\[Link]”} E: import os Fh=open([Link](“nexti/next2/[Link]”)) 121, In the python class below , which of the following python names can be replayed by the word “this " without breaking or altering the current logic? class C: self.l=[Link] [Link]=C,count+L def getcount(self}: return self. (ANS-—-A) options: A. Self B. __init__ C. Def by D. Class —. Return 120. Which of the fallowing will be returned as the result of executing feopen(“filename”,”a”) in python? (ANS--D) Options: A. The content of the filename “filename” as a single string. B. A handle open to an empty file named “filename” which can be , if filename is not empty. C. The contents of the file “filename” as a list of lines. 122. Which of the following python code snippets can be used as a shorter version of the code below with the Walrus operator? Text=[Link]() While text: Do _something{Text) OPTIONS: A. while text:[Link](): do_somethi ngitext Aeadtine()) B. while text: text: [Link](): do_something([Link]()) do_something(text}) D. while text:= [Link](): do_something() E. while text: do_samething(text.=f()) 111, which of the following python functions will allow ato b to get the size ofa file in bytes? ANS: a. importos f= open (file, “r") size = [Link] (OS.SEEK_SET) bs b. import os import start size = [Link] (filename)|stat.ST_SIZE) 112. return xt+y+z elif x==7: retumn x*y*z else: return 42 113. which of the following correctly identify for nin range (2,10): for x in range (2,n): else: print(n) ANS: 4 114. once the bug is fixed and the status is changed to "IN TEST”, the tester tests the bug, If the bug Is not reproducible in the software tester changes the status to ANS: verified 109. while temperature<98.6: for iin samples: if i == temperature: temperature = temperature + 7 temperature = temperature + 1 ANS: 103 110. [Link] = [Link] +1 def method(self): [Link] = [Link] return [Link] is ANS: [Link]{)} 112. return x+y+z ellf x==7: return x*y*z else: return 42 74. While optimizing a python program, it is required to extract substring before and after a given separator and then return a three-tuple slices. Which of the following string Methods will help accomplish ANS: strip () De 75. Which of the following python code snippets will print the value of ‘1’? ANS: asi def test(): global a if True: return a else: a=2 print(test()) def getcount(self}; 51. Which of the following expressions can be used to open a binary file so that it contents can be read reliably on your systems? & ANS: of = openifilename, “rb”) 62. Which of the following python statement will return a tuple of two values from a and b ANS: a. return (x,y) b. returnx,y 23, foriin range(10): if i=5: break else: print({i) else: print("Here") ANS: & Whe 61. A programmer writes the python class below, able to handle managed attributes. Which of the following statements correctly define the concepts implemented in the class? class subject (}: _init__(self, name): [Link] = name def set (self, name): self,_name = name def get{sell): return self._name name = propertytget, set) ANS: a. get () and set () are python special methods. b. Attribute access can also be accomplished by overriding __getattr__and__setattr__ 34, Which of the following code snippets will construct a function with operation name id? ANS: a. def fooffilename): return filename functions{“id"] () = foo b. def footfilename): is return filename functions{foo] = “id” 46. Which of the following python code snippet can be While text = [Link]() While text: do_something(text} text = [Link](} ANS: While text : = [Link](): go_something{[Link]()) 37. A python program is running and must open a file name “[Link]” in a subdirectory next 2 of a subdirectory next J of the current directary(thus, two directories down), which of the following are portable ways to accomplish this? ANS: 1 Import os fh = open([Link]("next2”, “next2”, "x”, “out")) 22, 0 while i¢5: print{i) it=1 if i==3: break else: print(0) ANS: 0 fj 12. request = input(“what’s your favourite language?”) If request == “python”: response = “True!” else: response = “False” print(response) y Ans: a. response = (“True!” if request = “python” else “False”) b. response = “True!” if request == “python” else “False” 13. which of the following statements about UDP packets are correct? ANS: a. TCP packets have a higher rate of corruption in transit than UDP packets d. UDP packets have a larger packet header than TCP packets e. UDP packets have a maximum size of 512 bytes on an Ethernet network ANS: 4. Which of the following statements correctly describe Bidirectional Forwarding Detection(BFD) BFD is enabled on the interfaces and at the router level to detect neighbor adjacency failures b. BFD must use object tracking to defect failures Two modes are available: asynchronous and demand tad 20. Whatyis the output of the following code iz While True: If M3==0: Break Print(i} i#=1 ANS: 1 21. i=0 while i<3: print(i) i+=1 else: print(0)} ANS: oney oo 3. class vehicles: count=0 def _ init__(self, value}: [Link] = value [Link] += 1 def getvallself): return [Link] def getcount(cls): return [Link] counter = classmethod(getcount) typest=vehicles(“car”) ehicles(“Bus") rehicles("Bike”) Ans. Car Bus 33. 4. Which of the following statements correctly describe Bidirectional Forwarding Detection(BFD) ANS: a. BFD is enabled on the interfaces and at the router level to detect neighbor adjacency failures b. BFD must use object tracking to defect failures c. Two modes are available: asynchronous and demand 10. Which of the following lines of python code correctly format the output: Ans: a. Print (9% .2P" % 3.142) b> b. Print (“{: .2f}”. format (3.142)) c. Print ("{n: .2f)". format(n=3.142)) 11. What is the output of the following code? z=5 X= *456" While Z> -1: Y=x WY in ('2', 2", °3"}: Break M=X+¥ IY in (4%, S67); Continue Z=Z-1 Print(z) 11. What is the output of the following code? z=5 X= “456” While Z > -1: Y=X EY in ('1', 2", 3"): Break X=XNX+Y¥ If ¥in ('4", “S', 6"): Continue Z=Z-1 Print(Z) ANS: = -1 B) PL/SQL supports transporting the programs from one operating system to another and tailors them to the new environment. D) Since PL/SQL is a procedural language, it facilitates specifying the execution plan to the Oracle server in the form of SQL statements. 1. f=open(‘[Link]’).readlines{) A file handle A sorted array Anerror code The content of the file ' [Link]’ A python list contacting all the lines in ‘[Link]’ pangs ANS: a,d,e 2, def test(x}: if x%3==0: return test(x/3) if x%2==1: return x return test(2*x+1} test(100) Ans: 67 3. class vehicles: count=0 Consider the PL/SQL code snippet below. declare x boolean; y boolean; z boolean; begin z:= not (x and y) and (not x or y); ifz then dbms_output.put_line("TRUE'); elsif not z then dbms_output-put_line('FALSE’); else dbms_output.put line(NULL'); end if; end; Under which of the following values of X and Y is Z equal to TRUE? B) X:= TRUE Y= FALSE C) X= NULL Y= TRUE Under which of the fallowing values of X and Y Is Z equal to TRUE? B) X2= TRUE Y:= FALSE C) X:= NULL Y:= TRUE D) X:= TRUE Y:= TRUE a a Which of the following headers demonstrate correct specification of compound triggers in Oracle? A) CREATE OR REPLACE TRIGGER Trg_T COMPOUND FOR INSERT ON T B) CREATE OR REPLACE TRIGGER Tre_T FOR INSERT ON T £) CREATE OR REPLACE TRIGGER Jrg_T COMPOUND TRIGGER FOR INSERT ON T Which of the following statements correctly describe the validity of the PL/SQL code snippet below in the DECLARE section? vunumber CONSTANT NUMBER NOT NULL := 7; A) The statement will be valid if the NOT NULL keyword is removed. B) The statement will be va[id if the assignment operation is replaced with DEFAULT keyword. C) The statement will be valid if the assignment operation is removed. 26: A table, m_table is mutating for a row-level trigger. Which of the following statements correctly describe considerations applicable with tile mutating table, for any row-level trigger and for any statement-level trigger? A) While executing the row-level trigger, the values accessed from the m_table table can be recorded by using a PL/SQL table inside a nested table. B) The statement-level trigger comprises of the queries in which the values recorded from the rows level trigger applicable for the m_table table are used. C) Since the gp, table table is mutating for a row level trigger, the table can be queried neither ina row-level trigger nor in a statement-level trigger. D) The value recorded in the PL/SQL table cab be accessible by any row-level trigger, but they are not accessible for any statement-level trigger defined upon the m_table. E} By recording the values queried from the row-level trigger in a PL/SQL table wit table, multiple values from the m_table can be saved per update. ina nested ‘gato check salary; <> declare bonus number = 0.1; begin calc. [Link] = salary + calc. [Link]*bonus; if salary is null then ggte print endif; ' dbms_output,put linel'salary increased by’ || bonus*100 ||| ' per cent’); calc [Link] ale_salary.iteration +1; end cale_ bonus; calc_salary.bonus := 0.2; <> If salary < max_salary and iteration < 3 then ENU Sih pasty, A) salary increased by 10 per cent salary increased by 10 per cent salary increased by 10 per cent salary = 1111 €)_ salary increased by 10 per cent salary = 1111 D) salary increased by 10 per cent salary = 1331 E) salary increased by 10 per cent salary increased by 10 per cent I salary = 1331 _ vane 24 What is the output of executing the PL/SQL block below? declare s varchar2(100); begin What is the output of executing the PL/SQL block below? declare svarchar2(100); begin select coalesce(nullif(case when s=" then 10 when s <>" then 300 else nvl2(s, 200, 400) end,100),500) intos from dual; doms_output.put_line(’s=" [| 5); end; A) s=500 8) s=300 D) s=100 FE) s=200 What is the outcome of the query? SELECT COUNT(*} + COUNT(*) A) It returns 0 (zero) B) Itreturns 2 (two) D) Itreturns 1 (one) E) Itreturns NULL Which of the following statements correctly describe the usage of CHECK constraint in ANSI SQL? A) It cannot be applied on primary key columi C) It can contain search conditions and subqueries. D) It can refer a column or columns of the table in which the constraint is created. E) It can use dynamic parameter. ee Which of the following statements correctly describe the usage of the constructs supported in the syntax of the FOR loop given below? FOR a IN 10.100 LOOP A) The bounds 10..100 can be replaced with 100..10 and then the rest of the statement will get executed, 8) The FOR loop terminates with sn END statement, I C)_ The set of statements within the loop will not get executed if 10.,100is replaced with 10.10 D) E) Itis necessary to declare and define the data type of the counter a before using it in the FOR loop. What will be the outcome of executing the PL/SQL block? declare begin salary number bonus eration integer : max_salary constant ni goto check salary; <> declare bonus number 0.1; begin cale_salary.salary = salary + cale_salary.salary*bonus; if salary is null then 8) | C] Use UNION to display the employee data for employees not yet assigned to any department, D) Use CROSS JOIN to produce Cartesian product ofboth tables. E) Use FULL OUTER JOIN to display unmatched rows from both tables. es as There are two tables EIMP(ID, NAME. DEPTID) and DEPT(ID, NAME). EMP has 10 records and DEPT has 5 records. Based on this, which of the following are valid statements. SELECT * FROM EMP, DEPT; A) The query has a syntax error. B) The query will return 5 rows. D) The query will return 10 rows. £) The query will return 15 rows. Which of the following scenarios will an ANSI SQL subquery be utilized? T A) Find differences in aggregate sales done for all products in the current and previous year. B)_ Find the moving average of product sales in the current year against last five years. D) AVARCHAR(3) static value can be inserted into darerime column. Examine the ANS! SQL referential integrity definition in the ORDERS table below. ALTER TABLE orders ADD FOREIGN KEY(product_ id) REFERENCES products(product. id) MATCH FULL ON UPDATE RESTRICT What does the following statements interpret the referential update action in the PRODUCT table? A) There is no referential update action at all. The referential constraint only specifies a constraint check, B) Any change to a PRODUCT_ID in the PROCUDTS table causes the PRODUCT_ID column in matching rows of the ORDERS table to be set to its default value. C) Any change to a PRODUCT_ID in the PROCUDTS table causes the corresponding PRODUCT_ID value in the matching rows of the ORDERS to be set to default value E) Any change to a PRODUCT _ID in the PROCUDTS fable causes the sane change to the corresponding PRODUCT_ID column in the matching rows of the ORDERS table. Which of the following statements correctly describe the usage of CHECK constraint in ANSI SQL? A) It cannot be applied on primary key column D) 2) 12- ‘The ORDERS table reference the PRODUCTS table through the product id column. Which of the following are the valid outcomes for the referential integrity? A) (SELECT MIN(ROWID) FROM T t2 WHERE t2.1D2 = t1.1D2) B) (SELECT COUNT(ROWID) FROM T t2 WHERE t2.1D1 = t1.1D1) C) (SELECT MAX(ROWID) FROM T t2 WHERE t2.1D1 = t1.1D2) D) (SELECT MIN(ROWID) FROM T) E) (SELECT MAX(ROWID) FROM T WHERE COUNT(ID2) >1) 14. Which of the following statements correctly describe the inter-compatibjity feature of SQL. data types? A) _An INTEGER static value can be inserted into a NUMERIC(10, 0) column. C) A DOUBLE static value can be inserted into a TIME column. a) NULL B) Raise a VALUE_ERROR exception C)_ Raise aNO_DATA_FOUND exception D) 0 E) FALSE oe a a i - Which of the following are valid statements regarding the DEFAULT clause in an ANSI SQL INSERT statement? ‘A) Default values for columns can be randomly generated at the time of insert. 8) The default clause cannot be specified forall the columns in the INSERT stateme €) Ifthe default clause is Used, the column default is inserted as defined for the column in the table NATURAL JOIN sales s NATURAL JOIN customers c WHERE prod id= 148 A) It generates an error because all three tables must have a common column. 8) It generates an error because all columns used should have a qualifier. Q — — 8— Examine the CONTRACTORS table structure. CONT_ID NUMBER TASK_ID NUMBER STATUS VARCHAR2(10) TASK_START_DATE DATE TASK_END_DATE DATE USERID VARCHAR2(10) The unit supervisor would like to update the contractor status from NULL or ASSIGNtriED to COMPLETED using the following ANSI SQL statement. UPDATE CONTRACTORS SET Status = ‘COMPLETED! ********"884+* What does ***" '** need to be replaced with? B) WHERE STATUS = NULL AND STATUS = 'ASSIGNED' C) WHERE STATUS = NULL OR STATUS = 'ASSIGNED' D) WHERE STATUS IN(NULL, 'ASSIGNED') E) WHERE STATUS IS 'ASSIGNED' OR NULL C)_ Build an index for each column of the table, E) Build indexes on columns of integer type. I DEPARTMENTS: DEPARTMENT_ID - NUMBER(2) DEPT_NAME - VARCHAR2(48) DEPT_HEAD - NUMBER(4) LOC_CODE - VARCHAR2(5) What does the following statement interpret? SELECT FIRST_NAME || LAST_NAME FROM EMPLOYEES WHERE NOT (EMPLOYEE_ID = ANY(SELECT DEPT_HEAD FROM DEPARTMENTS) A) Lists the employees who head at least one department in the organi B) Lists the employees who head all the departments in the organization. C) Lists te employees who do not head more than one department in the organization. D) employees who do nat head their own department According to theory, which of the following can be considered best practices when deciding to create an index in ANSI SQL? A) Build indexes on columns of character string types. Which of the following overriding clauses that can be used in ANSI SQL INSERT statement? A) OVERRIDING SESSION VALUE B) c) & OVERRIDING INSERT VALUE OVERRIDING MEMORY VALUE OVERRIDING SELECT VALUE Examine the structure of the two tables EMPLOYEES and DEPARTMENTS below (DEPT_HEAD in DEPARTMENTS references EMPLOYEE_ID in EMPLOYEES) EMPLOYEES: EMPLOYEE _ID - NUMBER(4) FIRST_NAME - VARCHAR2(10) JOB - VARCHAR2(9} MGR_YN - VARCHAR2(2) HIRE_DATE - DATE SALARY - NUMBER COMM_PCT - NUMBER(7,2) DEPARTMENT_ID - NUMBER(2) DEPARTMENTS: DEPARTMENT_ID - NUMBER(2) DEPT_NAME - VARCHAR2(48) DEPT_HEAD - NUMBER(4) LOC_CODE - VARCHAR2(5) Which of the following statements correctly describe capabilities of referential integrity in databases? A) It ensures that a row is a unique instance of an enti 8) Itensures that altable can refer another table through a constraint pointer. C) It ensures joins between two tables through a common column. D) &)

You might also like