Category: Interview Questions

03/20/10

Define candidate key, alternate key, composite key.

Issue time12:56:42 pm, by admin_sippsin Email 515 views
Categories: Interview Questions
A candidate key is one that can identify each row of a table uniquely. Generally a candidate key becomes the primary key of the table. If thetable has more than one candidate key, one of them will become the primary key, and the rest are called alternate… more »
Leave a comment
01/02/10

Finding grants on the object

Issue time05:19:48 am, by moderator_damian Email 332 views
Categories: Oracle FAQs, Oracle General, Interview Questions
Finding grants on the object Fire the below query on user_tab_privs table to find the grants and their details. SELECT * FROM user_tab_privs; more »
Tags: grants of an object, user_tab_privs
Leave a comment

Tag cloud

«all_source table»,«alter data type of column having data»,«ascii for newline and tab»,«b-tree indexes»,«bitmap indexes»,«bulk collect»,cardinality,«column constraints»,«constraints on a table»,«control files»,cube,«ddl commands inside pl/sql proc»,«debugging a procedure»,«delete duplicates»,«describing a package body in sql plus»,«duplicate records»,«dynamic table creation in stored procedure»,«export saved database connections in toad»,«grants of an object»,«mutliline data in oracle»,«number of columns in a table»,«oracle aggregate functions»,«oracle data loader»,«oracle product version»,«oracle version»,«pragma autonomous_transaction»,rollup,«source code of a package»,«special characters in varchar2 column»,sql*loader,«toad database connections file»,user_tab_columns,user_tab_privs

Search

OraclePassport Network







About OraclePassport
Contact OraclePassport

OraclePassport Members

Categories

XML Feeds

What is RSS?

Hit Counter

Powered by b2evolution