Tag: technology

Questions Related to 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();

technology security

  1. True

  2. False

Show answer
Correct Option: A

Which constraint can be defined only at the column level?
technology databases

  1. UNIQUE

  2. NOT NULL

  3. CHECK

  4. PRIMARY KEY

Show answer
Correct Option: C

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?
technology databases

  1. 17000.00

  2. 17000*****

  3. **17000.00

  4. An error statement

Show answer
Correct Option: D

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

  1. NNNNNNN

  2. ########

  3. 1000000

  4. 1000000.00

Show answer
Correct Option: B

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

  1. True

  2. False

Show answer
Correct Option: A

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

  1. 2017

  2. 1917

  3. 1900

  4. 2000

Show answer
Correct Option: B

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

technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which statement describes the ROWID data type?
technology databases

  1. binary data up to 4 gigabytes

  2. character data up to 4 gigabytes

  3. a hexadecimal string representing the unique address of a row in its table

  4. raw binary data of variable length up to 2 gigabytes

Show answer
Correct Option: C

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

  1. No Rows returned

  2. 10 rows of Emp table

  3. Error

  4. 8 is displayed 10 times

Show answer
Correct Option: D

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

  1. True

  2. False

Show answer
Correct Option: B