Question 1

Sub query cannot have which clause defined for it

technology databases

where
having
order by
none of the above

Answer

Correct Option: C

Question 2

Select length(-1) from dual What is the output of the above sql stmt

technology databases

2
1
0
error

Answer

Correct Option: A

Question 3

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table: select count(mgr) from emp; What is the count?

technology databases

14
>14
error
<14

Answer

Correct Option: D

Question 4

You can declare this only by using table contraint syntax

technology databases

Composite primarykey
Not null
unique
check

Answer

Correct Option: A

Question 5

An interval literal specifies

technology databases

a period of time
a numerical difference
a descriptive number
a floating point number

Answer

Correct Option: A

Question 6

You use comments in a SQL statement to pass hints to the Oracle optimizer.

technology databases

False
This is hard to determine
True
None of the choices

Answer

Correct Option: C

Question 7

For each DATE value in an Oracle database, which of the following information is stored (choose all that apply):

technology databases

second
century
hour
year
date
month

Answer

Correct Option: A,B,C,D,E,F

Question 8

Sub query cannot have which clause defined for it

technology databases

where
having
order by
none of the above

Answer

Correct Option: C

Question 9

Select length(-1) from dual What is the output of the above sql stmt

technology databases

2
1
0
error

Answer

Correct Option: A

Question 10

The standard EMP table contains 14 records corresponding to the employess of the corporation.One of those records has a NULL value stored in the MGR column.If Issue the following command on the table: select count(mgr) from emp; What is the count?

technology databases

14
>14
error
<14

Answer

Correct Option: D

Question 11

You can declare this only by using table contraint syntax

technology databases

Composite primarykey
Not null
unique
check

Answer

Correct Option: A

Question 12

An interval literal specifies

technology databases

a period of time
a numerical difference
a descriptive number
a floating point number

Answer

Correct Option: A

Question 13

You use comments in a SQL statement to pass hints to the Oracle optimizer.

technology databases

False
This is hard to determine
True
None of the choices

Answer

Correct Option: C

Question 14

For each DATE value in an Oracle database, which of the following information is stored (choose all that apply):

technology databases

second
century
hour
year
date
month

Answer

Correct Option: A,B,C,D,E,F

Question 15

Which of the following are the correct value for the column whose data type is declared as number(3,4)

technology databases

123.21
0.001
0.01
123.01

Answer

Correct Option: C

Question 16

Which of the following describes the difference between varchar and varchar2 data types

technology databases

varchar is used to store fixed length character data, varchar2 is for variable length character data
varchar data type is not supported in oracle
varchar data type is applicable only to PL/SQL
maximum length for varchar is 2000 bytes and for varchar2 is 4000 bytes

Answer

Correct Option: D

Question 17

What is true in case of deferred constraints in Oracle?

technology databases

The Constraint condition is never checked
The Constraint condition is checked only at the time of commiting the transaction
The Constraint condition is checked only for newly inserted rows and will not be checked for already existing rows in the table
The constraint condition is checked after a predefined time interval

Answer

Correct Option: B

Question 18

Which of the following clause enables to drop the foreign key constraints of the child table while dropping the parent table?

technology databases

drop foreign keys
cascade constraints
this is not possible in oracle
clear references

Answer

Correct Option: B

Question 19

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

technology databases

No Rows retrieved
8 is displayed 20 times
8 is displayed 1 time
error message

Answer

Correct Option: B

Question 20

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

technology databases

True
False

Answer

Correct Option: B

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

databases Online Quiz - 208

Find more quizzes from top tags