Tag: databases

Questions Related to databases

6.What is, in terms of JDBC, a DataSource?
technology databases

  1. A DataSource is the basic service for managing a set of JDBC drivers

  2. A DataSource is the Java representation of a physical data source

  3. A DataSource is a registry point for JNDI-services

  4. A DataSource is a factory of connections to a physical data source

Show answer
Correct Option: D

To ensure proper data conversion between databases with different character sets, you must ensure that
technology databases

  1. ASCII characters are capitalized

  2. INT data consists of non-negative numbers

  3. CHAR data consists of well-formed strings.

  4. CHAR data consists of at least a nil string

  5. None of the choices.

Show answer
Correct Option: C

Which of the following correctly describe the LONG columns (choose all that apply):
technology databases

  1. You can use them to store long text strings

  2. They have many of the characteristics of VARCHAR2 columns

  3. They store variable-length character strings containing up to 2 gigabytes

  4. None of the choices.

Show answer
Correct Option: A,B,C

Which of the following are the valid datetime datatypes in Oracle (choose all that apply):
technology databases

  1. TIMESTAMP WITH LOCAL TIME ZONE

  2. TIMESTAMP

  3. TIMESTAMP WITH TIME ZONE

  4. DATE

Show answer
Correct Option: A,B,C,D

Which of the following are the restrictions of creating bitmap indexes (choose all that apply):

technology databases

  1. You cannot specify BITMAP for a domain index

  2. You cannot specify both UNIQUE and BITMAP

  3. You cannot specify BITMAP when creating a local index.

  4. You cannot specify BITMAP when creating a global partitioned index

Show answer
Correct Option: A,B,D

Text literals have properties of which of the following datatypes (choose all that apply):

technology databases

  1. CHAR

  2. CLOB

  3. VARCHAR2

  4. Float

Show answer
Correct Option: A,C

A sequence generates values that are often used for (choose all that apply):
technology databases

  1. primary keys

  2. sales figures

  3. foreign keys

  4. unique keys

Show answer
Correct Option: A,D

What's command to start DBCONSOLE service on database installed on Linux?
technology databases

  1. emctl start dbconsole

  2. start dbconsole

  3. dbconsole start

  4. emctl dbconsole start

Show answer
Correct Option: A

In Oracle, the result of comparison conditions can be (choose all that apply):
technology databases

  1. TRUE

  2. UNKNOWN

  3. ERROR

  4. NULL

  5. FALSE

Show answer
Correct Option: A,B,E

What is default location for portlist.ini file?

technology databases

  1. $ORACLE_HOME/sysman/install

  2. $ORACLE_HOME/install

  3. $ORACLE_HOME/rdbms/admin/install

  4. $ORACLE_HOME/dbs/install

Show answer
Correct Option: B