Tag: databases

Questions Related to databases

The table employee contains 20 records. What is the output of the query " Select 8 from Employee"?
technology databases

  1. No Rows retrieved

  2. 8 is displayed 20 times

  3. 8 is displayed 1 time

  4. error message

Show answer
Correct Option: B

The columns with unique constraint allows more than one null values to be inserted.

technology databases

  1. True

  2. False

Show answer
Correct Option: B

What is the use of reuse storage clause when used with truncate table statement?
technology databases

  1. specifies that the empty space created by deleting the records must be retained for this table and should not be used by other tables

  2. specifies that the empty space created by deleting the records, can be used by other tables.

  3. specifies that this transaction can be rolled back later

  4. This clause cannot be used with truncate statement

Show answer
Correct Option: A

Which of the following are valid pseudocolumns in oracle?
technology databases

  1. rowid

  2. row_num

  3. sl_no

  4. rownum

  5. sid

Show answer
Correct Option: A,D

For which of these constraints, an unique index is automatically created while creating constraints?
technology databases

  1. Primary Key

  2. Check

  3. Unique

  4. Not Null

  5. Foreign Key

Show answer
Correct Option: A,C

1.Which statements about JDBC are true? (2 answers)

technology databases

  1. JDBC is an API to connect to relational-, object- and XML data sources

  2. JDBC stands for Java DataBase Connectivity

  3. JDBC is an API to access relational databases, spreadsheets and flat files

  4. JDBC is an API to bridge the object-relational mismatch between OO programs and relational

Show answer
Correct Option: B,C
  1. Which packages contain the JDBC classes?
technology databases

  1. java.jdbc and javax.jdbc

  2. java.jdbc and java.jdbc.sql

  3. java.sql and javax.sql

  4. java.rdb and javax.rdb

Show answer
Correct Option: C
  1. Which type of driver provides JDBC access via one or more ODBC drivers?
technology databases

  1. Type 1 driver

  2. Type 2 driver

  3. Type 3 driver

  4. Type 4 driver

Show answer
Correct Option: A

4.Which type of driver converts JDBC calls into the network protocol used by the database management system directly?
technology databases

  1. Type 1 driver

  2. Type 2 driver

  3. Type 3 driver

  4. Type 4 driver

Show answer
Correct Option: D

5.Which type of Statements can execute parameterized queries?
technology databases

  1. PreparedStatement

  2. ParameterizedStatement

  3. ParameterizedStatement and CallableStatement

  4. All kinds of Statements (i.e. which implement a sub interface of Statement)

Show answer
Correct Option: A