Tag: technology

Is SQL injection possible in the below code? String username = request.getParameter(“username”); String password = request.getParameter(“password”); conn = pool.getConnection( ); PreparedStatement pstmt = conn.prepareStatement(“select * from user where username=”+username+” and password=”+password); pstmt.execute(); rs = pstmt.getResultSet();

Which constraint can be defined only at the column level?

Evaluate the SQL statement: SELECT LPAD(salary,10,*) FROM EMP WHERE EMP_ID = 1001; If the employee with the EMP_ID 1001 has a salary of 17000, what is displayed?

SELECT TO_CHAR(1000000, '$99,999.00') SALARY FROM dual What Is the Output?

There are also multiple-column subqueries: Queries that return more than one column from the inner SELECT statement.(T/F)

What is the output in RR format for following dates Date Specified :27-Oct-1995

The outer and inner queries can get data from different tables?

Which statement describes the ROWID data type?

What will be the output of following Select 8 from Emp ? Emp table has 10 rows

Can we abbreviate keywords across lines?e.g. DESCRIBE