Latest Answer: Select query can be made faster by using indexes. ...
Latest Answer: There are 6 types of joins:1. Inner Join: This will display the matching rows from the tables after comparing values present in a common column.2.
Outer Join: When you want all rows from a table and matching rows from the another table then we use this ...
Latest Answer: 1.Subquery is nothing but a query inside a query which appears only after the WHERE clause of a select statement.2.Two types of subquery is there:a) Co-Related subqueryb) Non-Co-related subquery.3. Use of subquery is to run or execute your subquery accoring ...
Latest Answer: View: A view is a list of columns or a series of records retrieved from one or more existing tables, or as a combination of one or more views and one or more tables.Types of Views: a)
DataBase View b) Help View c) Projection View d) Maintenance ...
Latest Answer: These answers are probably all correct---if it's SQLServer or Sybase. I don't think the DBMS was identified and for sure the data dictionary/relational catalog/system tables are not standard in naming or contents.For instance in DB2 it's SYSIBM.SYSINDEXES ...
Latest Answer: For Indexes you can use :DBA_INDEXESALL_INDEXESUSER_INDEXESFor Constraint you can use :DBA_CONSTRAINTSALL_CONSTRAINTSUSER_CONSTRAINTSFor index upon which table and which column you can query on:DBA_CONS_COLUMNSALL_CONS_COLUMNSUSER_CONS_COLUMNS ...
What checklist questions could one come up with for the establishment of a DBMS for an organisation with 90PCs?
Latest Answer: Normalization is based on the functional dependency and primary key.1NF- Attribute should be atomic value and there must be no composite attribute, no multivalued attribute and no relation with in relation. By default what ever relation we are creating ...
Latest Answer: Drop user username cascade ...
Latest Answer: Two tier architecture having three components at two layers. It was intended due to the limitation in the file sharing software engineering as in the file sharing system more than 12 users can not work together. ...
View page << Previous 3 4 5 6 [7]
Go Top
