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();
True
False
Which constraint can be defined only at the column level?
UNIQUE
NOT NULL
CHECK
PRIMARY KEY
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?
17000.00
17000*****
**17000.00
An error statement
SELECT TO_CHAR(1000000, '$99,999.00') SALARY FROM dual What Is the Output?
NNNNNNN
########
1000000
1000000.00
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
2017
1917
1900
2000
The outer and inner queries can get data from different tables?
Which statement describes the ROWID data type?
binary data up to 4 gigabytes
character data up to 4 gigabytes
a hexadecimal string representing the unique address of a row in its table
raw binary data of variable length up to 2 gigabytes
What will be the output of following Select 8 from Emp ? Emp table has 10 rows
No Rows returned
10 rows of Emp table
Error
8 is displayed 10 times
Can we abbreviate keywords across lines?e.g. DESCRIBE