Which catalog tables contain authorization information ?
The SYSIBM table that contain authorization information are SYSCOLAUTH, SYSDBAUTH, SYSPLANAUTH, SYSTABAUTH and SYSUSERAUTH. Read more »
‘Database Interview Questions’ - KyaPoocha.com
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database ?
The catalog tables to use are the SYSIBM.SYSTABLES and the SYSIBM.SYSCOLUMNS. Read more »
What is read-only cursor ?
A read-only cursor is one in which the result table was created by a query containing one of the following : • a DISTINCT keyword • a UNION operator •... Read more »
When is the results table for the query in a DECLARE CURSOR statement created ?
The results table for a query specified in a DECLARE CURSOR statement of a cursor is created during the execution of the OPEN CURSOR statement. Read more »
What is the syntax required for the creation of a cursor ?
EXEC SQL DECLARE cur_name CURSOR for SELECT col1,col2 FROM table1 WHERE col1 = search_condition END-EXEC. Read more »
What is a cursor ?
A cursor is a named control structure used to make a set of rows available to a program. Read more »
What is a result table ?
A result table is the product of a query against one or more tables or views ( i.e. it is the place that holds the results of a query). Read more »
How does the processing of a correlated subquery differ from a non correlated subquery ?
The subquery in a correlated subquery is reevaluated for every row of the table or view named in the outer query, while the subquery of a non correlated subquery... Read more »
What is correlated subquery ?
A correlated subquery is one that has a correlation name as a table or view designator in the FROM clause of the outer query and the same correlation name as a qualifier... Read more »
What is subquery ?
A subquery is a query that is written as part of another query’s WHERE clause. For example : SELECT col_name1,col_name2 FROM table_A WHERE ... Read more »
How do you define a correlated name?
A correlated name can be defined in the FROM clause of a query and in the first clause of an UPDATE or DELETE statement. Read more »
What is correlation names ?
IT is a special type of column designator that connects specific column in the various levels of a multilevel SQL query. Read more »
What are column-name qualifiers used ?
Column-name qualifier are used as table designator to avoid ambiguity when the column names referenced exist in more than one table used in the SQL statement. Column-name... Read more »
What is the syntax of SELECT statement when embedded in a COBOL program ?
Exec SQL SELECT col_name1,col_name2,col_name3 INTO hos:_var1,hos_var2,hos_var3 FROM owner.tablename WHERE ... Read more »
What is a SELECT statement?
A select statement is an SQL statement that retrieves data from a table or view. Read more »