databases Online Quiz - 206
|Description: databases Online Quiz - 206|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
What is syntax to unlock the table statastics?
A Tablespace can hold objects from different Schemes.
You can use ____________ in a SQL expression to override operator precedence
A Datafile can be part of multiple tablespaces.
Which of the following can be partitioned (choose all that apply):
What type of joins extends the result of a simple join
To write a query that performs an outer join of tables A and B and returns all rows from B, you need a:
You may use the CREATE INDEX statement to create an index on (choose all that apply):
An inner join is always a:
The UNION ALL operator does not eliminate duplicate selected rows from the result set
The ALTER SEQUENCE statement can affect only the future sequence numbers
If you use the CREATE DATABASE statement on an existing database, all data in the datafiles will be lost
which datatype store pointer to binary file on disk
For Which datatype Maximum size is 4GB
A) Long raw - Variable length binary strings B) LONG - Character data of variable length
32-bit floating point number datatype is?