Question 1

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

technology databases

specifies that the empty space created by deleting the records must be retained for this table and should not be used by other tables
specifies that the empty space created by deleting the records, can be used by other tables.
specifies that this transaction can be rolled back later
This clause cannot be used with truncate statement

Answer

Correct Option: A

Question 2

Which of the following are valid pseudocolumns in oracle?

technology databases

rowid
row_num
sl_no
rownum
sid

Answer

Correct Option: A,D

Question 3

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

technology databases

Primary Key
Check
Unique
Not Null
Foreign Key

Answer

Correct Option: A,C

Question 4

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

technology databases

JDBC is an API to connect to relational-, object- and XML data sources
JDBC stands for Java DataBase Connectivity
JDBC is an API to access relational databases, spreadsheets and flat files
JDBC is an API to bridge the object-relational mismatch between OO programs and relational

Answer

Correct Option: B,C

Question 5

Which packages contain the JDBC classes?

technology databases

java.jdbc and javax.jdbc
java.jdbc and java.jdbc.sql
java.sql and javax.sql
java.rdb and javax.rdb

Answer

Correct Option: C

Question 6

Which type of driver provides JDBC access via one or more ODBC drivers?

technology databases

Type 1 driver
Type 2 driver
Type 3 driver
Type 4 driver

Answer

Correct Option: A

Question 7

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

technology databases

Type 1 driver
Type 2 driver
Type 3 driver
Type 4 driver

Answer

Correct Option: D

Question 8

5.Which type of Statements can execute parameterized queries?

technology databases

PreparedStatement
ParameterizedStatement
ParameterizedStatement and CallableStatement
All kinds of Statements (i.e. which implement a sub interface of Statement)

Answer

Correct Option: A

Question 9

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

technology databases

A DataSource is the basic service for managing a set of JDBC drivers
A DataSource is the Java representation of a physical data source
A DataSource is a registry point for JNDI-services
A DataSource is a factory of connections to a physical data source

Answer

Correct Option: D

Question 10

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

technology databases

ASCII characters are capitalized
INT data consists of non-negative numbers
CHAR data consists of well-formed strings.
CHAR data consists of at least a nil string
None of the choices.

Answer

Correct Option: C

Question 11

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

technology databases

You can use them to store long text strings
They have many of the characteristics of VARCHAR2 columns
They store variable-length character strings containing up to 2 gigabytes
None of the choices.

Answer

Correct Option: A,B,C

Question 12

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

technology databases

TIMESTAMP WITH LOCAL TIME ZONE
TIMESTAMP
TIMESTAMP WITH TIME ZONE
DATE

Answer

Correct Option: A,B,C,D

Question 13

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

technology databases

You cannot specify BITMAP for a domain index
You cannot specify both UNIQUE and BITMAP
You cannot specify BITMAP when creating a local index.
You cannot specify BITMAP when creating a global partitioned index

Answer

Correct Option: A,B,D

Question 14

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

technology databases

CHAR
CLOB
VARCHAR2
Float

Answer

Correct Option: A,C

Question 15

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

technology databases

primary keys
sales figures
foreign keys
unique keys

Answer

Correct Option: A,D

Question 16

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

technology databases

emctl start dbconsole
start dbconsole
dbconsole start
emctl dbconsole start

Answer

Correct Option: A

Question 17

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

technology databases

TRUE
UNKNOWN
ERROR
NULL
FALSE

Answer

Correct Option: A,B,E

Question 18

What is default location for portlist.ini file?

technology databases

$ORACLE_HOME/sysman/install
$ORACLE_HOME/install
$ORACLE_HOME/rdbms/admin/install
$ORACLE_HOME/dbs/install

Answer

Correct Option: B

Question 19

What command is used to reclaim unused space for table TABLE1?

technology databases

ALTER TABLE TABLE1 SHRINK;
ALTER TABLE TABLE1 SHRINK SPACE;
ALTER TABLE TABLE1 SHRINK UNUSED;
ALTER TABLE TABLE1 SHRINK ROWs;

Answer

Correct Option: B

Question 20

Single-row functions can appear in which of the following (choose all that apply):

technology databases

WHERE clauses
START WITH and CONNECT BY clauses
select lists
HAVING clauses

Answer

Correct Option: A,B,C,D

Description: databases Online Quiz - 207
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

databases Online Quiz - 207

Find more quizzes from top tags