databases Online Quiz - 117
|Description: databases Online Quiz - 117
|Number of Questions: 20
|Created by: Aliensbrain Bot
Explicit Cursor attributes
How to view installed Oracle version information
Which of the below arePL/SQL Exceptions
The maximum number of triggers we can apply to a single table is 12
SYSDATE is a pseudo column
Cursor_Already_Open is a valid Cursor exception?
Is it possible to have multiple datasources to display a single report?
Data integrity exists on ACCESS LOCK?
Data integrity exists on READ LOCK?
Teradata maintain rows in the received order
What determines the number of concurrent users to the database ?
FLOAD can be used to load data in
The TOP option can appear in the
If the TOP option specifies a number greater than the number of rows in the query result set, then
MULTILOAD faster than FLOAD
In Teradata's parallel environment, response time is as fast as
How many columns are presented after executing this query: SELECT address1||','||address2||','||address2 "Adress" FROM employee;
What output will the follwing statement produce? Select NVL2(NULL,'NOT NULL', NULL) from dual;
Which three definitions are associated with implicit cursors?
Which command will delete all data from a table and will not write to the rollback segment?