db2 sql interview questions

Label:1. Query questions during interviewTable has a, b two columns, using SQL statement, internship, when a column greater than Blie, select a column, otherwise select column B select id1,id2,(case when id1>id2 then id1 else id2 end) as result from t4; Similar to the problem, table T4, Id2 greater than 3 records as qualified, greater than 5 for excellent, otherwise unqualified select Id1,id2, (case when

) s#,c#, G respectively represents the student number, the selected course number, and the academic score (1) Use standard SQL nested statements to query the student number and name of the elective course named ' Tax base '? Answer: Select s#, SN from S where s# in (select s# from C,SC where C. c#=sc.c# and cn= ' tax base ') (2) Use standard SQL nested statements to query the student name and affiliation of

) s#,c#, G respectively represents the student number, the selected course number, and the academic score (1) Use standard SQL nested statements to query the student number and name of the elective course named ' Tax base '? Answer: Select s#, SN from S where s# in (select s# from C,SC where C. c#=sc.c# and cn= ' tax base ') (2) Use standard SQL nested statements to query the student name and affiliation of

Before I resigned, I gave my company a set of interview questions. What do you think is difficult ?? Oracle Database assessment: 1. Write a jdbc connection to the database and add, delete, modify, and query data code (simply write it ). Answer: PublicstaticvoidMain (String [] args ){ //TODOAuto-generated method stub Connection cn =Null; CallableStatement cstmt =Null; Try{ // Do not do this here, because th

ASP and net interview questions 1. Briefly describe the access permissions of private, protected, public, and internal modifiers.A. Private: Private Members can be accessed within the class.Protected: protects members, which can be accessed within the class and in the inheritance class.Public: A Public member. It is completely public and has no access restrictions.Internal: accessible within the same name

file.A single portal makes it easier to control permissions, allowing for security checks on HTTP requests.Cons: URLs look less beautiful, especially unfriendly to search engines.14. Print one with '. ' Linked strings, what else can be used instead of '. ' More efficient links?can be used, instead., more efficient.15. What does the hint type 200, 404, 502 mean?200 is the request succeeds, 404 is the file is not found, and 502 is the server internal error.16. Write a custom function to extract t

oracle| problem ORACLE interview Questions-Technical articles (2) 21. How to determine the time zone of the database? Answer: SELECT dbtimezone from DUAL; 22. Explain the purpose of global_names set to True Answer: Global_names indicates how the database is joined. If this argument is set to True, You must connect the remote database with the same name when you create the database link 23. How do I encry

Interview questions for php development engineers 1. get a letter combinationQuestion requirements:Make a combination of three letters, such as "abd, ade, acc, aef" and so on:Target1. all letters must be printed2. the combination of letters should be excluded, abc (three consecutive letters), CBA (three letters reverse), aaa (three letters the same)3. calculate the number of abc cases, the number of CBA c

Echo is a language structure and has no return value. The print function is basically the same as echo. The difference is that print is a function and has a return value. print_r is a recursive print, which is used to output the PHP interview questions and answer 1 of the array object. 1. use PHP to print the previous day in the format of 22:21:21 // Echo date ('Y-m-d H: I: S', time ()-60*60*24Echo date ("

) (int) 1 p0001 2007-2-8 8960 2 p0002 2007-2-8 5812 3 p0003 2007-2-8 8753 4 p0004 2007-2-8 8753 5 p0005 2007-2-8 9846 6 p0003 2007-2-9 4568 7 p0002 2007-2-9 2456 8 P0005 2007-2-9 9854Question 1, (5 points) write a newspaper with an SQL statement that averages more than 5200 sales by newspaper type?For:Question 2, (5 points) Use the SQL statement to write out the top three n

= { NewSqlParameter ("@number", SqlDbType.NVarChar),NewSqlParameter ("@moneys", SqlDbType.Int),NewSqlParameter ("@name", SqlDbType.NVarChar),}; para[0]. Value = file[0]; para[1]. Value = Convert.ToInt32 (file[1]); para[2]. Value = file[2]; //Database Operations using(SqlConnection conn =NewSqlConnection ("Data Source=.;i Nitial catalog=test; Persist Security info=true; User Id=sa; Password=123")) { usi

COSCO Java interview question zzz COSCO Java interview questions Java training materialsI. Java language1. Three basic features of object-oriented2. Concepts and differences between method overloading and method Rewriting3. Features of interfaces, internal classes, and abstract classes4. Basic file read/write classes** 5. Precautions for serialization and how to

reasonable allocation of server resources Cpu:apache MySQL in high-load environment, disk IO read and write too much, will certainly occupy a lot of resources, it is inevitable that the CPU occupies too high. Memory: Memory library, database software hard disk: file web2.0 architecture Select MongoDB+redis or mysql+Memcached is a better combination, the logic is simple to use NoSQL current main web site architecture LAMP, LNMP, LLMP now there is a lnamp architecture on the network, which is the

Huawei's Java interview questions Question No: 1 1. Public class test { Public static void changestr (string Str ){ STR = "welcome "; } Public static void main (string [] ARGs ){ String STR = "1234 "; Changestr (STR ); System. Out. println (STR ); } } Please write the output result: Question No: 2 1. Public class test { 2. Static Boolean Foo (char c ){ 3. system. Out. Print (C ); 4. Return true; 5 .} 6.

JSP enterprise interview questions (5)7-2 illustrates how JDBC works and lists common objects. (Enterprise pen exam) Establishing a connection is to establish a connection with the database, that is, to create a connection instance. The getconnection () method of the drivermanager class will establish a database connection: The statement object is used to send SQL