What is a cluster Key ?
Answers were Sorted based on User's Feedback
Answer / sawant
The related columns of the tables are called the cluster
key. The cluster key is indexed using a cluster index and
its value is stored only once for multiple tables in the
cluster.
| Is This Answer Correct ? | 16 Yes | 7 No |
Answer / nihar
the related columns of the tables in a cluster is called
cluster key
| Is This Answer Correct ? | 7 Yes | 1 No |
What is not equal to in oracle?
How to use "while" statements in oracle?
What is the quickest way to export a table to a flat file?
SQL> CREATE TABLE to_table 2 (col1 NUMBER); Table created. SQL> CREATE OR REPLACE TRIGGER statement_trigger 2 AFTER INSERT ON to_table 3 BEGIN 4 DBMS_OUTPUT.PUT_LINE('After Insert Statement Level'); 5 END; 6 / Trigger created. SQL> CREATE OR REPLACE TRIGGER row_trigger 2 AFTER INSERT ON to_table 3 FOR EACH ROW 4 BEGIN 5 DBMS_OUTPUT.PUT_LINE('After Insert Row Level'); 6 END; 7 / Trigger created. SQL> INSERT INTO TO_TABLE VALUES(1); After Insert Row Level After Insert Statement Level 1 row created. SQL> BEGIN 2 INSERT INTO TO_TABLE VALUES(2); 3 INSERT INTO TO_TABLE VALUES(3); 4 INSERT INTO TO_TABLE VALUES(4); 5 INSERT INTO TO_TABLE VALUES(5); 6 INSERT INTO TO_TABLE VALUES(6); 7 INSERT INTO TO_TABLE VALUES(7); 8 INSERT INTO TO_TABLE VALUES(8); 9 INSERT INTO TO_TABLE VALUES(9); 10 INSERT INTO TO_TABLE VALUES(0); 11 END; 12 / WAT LL BE THE O/P??? XPLAIN IT>>>>
7. Repeat query (7) but also display all clients who have never ordered anything.
How to define a specific record type?
How to establish administrator authentication to the server?
How to export your connection information to a file?
What is columnar storage what is the advantage?
What is a select query statement in oracle?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
write a query that displays every Friday in a year with date?