Teradata has been called a __________ architecture.
Anything Goes
Shared Nothing
Shared Everything
Dual Redundant
A column of a table is declared as NUMBER(10,2).For which of the following values oracle returns an error
5392845.324
871039453.1
97234512.123
1234567.12
Sub query cannot have which clause defined for it
where
having
order by
none of the above
Select length(-1) from dual What is the output of the above sql stmt
2
1
0
error
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?
14
>14
<14
You can declare this only by using table contraint syntax
Composite primarykey
Not null
unique
check
An interval literal specifies
a period of time
a numerical difference
a descriptive number
a floating point number
You use comments in a SQL statement to pass hints to the Oracle optimizer.
False
This is hard to determine
True
None of the choices
For each DATE value in an Oracle database, which of the following information is stored (choose all that apply):
second
century
hour
year
date
month