| Cursors are used to handle single row selections at a time. They are data structure which hold all the results of a query. State whether true or false? |
| Explain in detail the pad boss and its functionalities? |
| Explain what a plan? |
| How and when does the Db2 actualize the novel key? |
| How can the duplicate values be eliminated from DB2 SELECT? |
| How to find the number of rows in a DB2 table? |
| How to retrieve rows from a DB2 table in Embedded SQL? |
| How you will count the number of rows from a table TAB? |
| Is cement speedier than IsNull? |
| Is it possible to change a table – for example including a fragment when another customer is getting to or invigorating a couple of portions? |
| Is it possible using MAX on a CHAR column? |
| Is there any restriction on the use of UNION in Embedded SQL? |
| Once You Create A View, Where Would Information About The View Be Stored? |
| What are UNION and UNION ALL? |
| What could be the reason that the MySQL statement ‘SELECT AVG (SALARY) FROM EMP’ generates an inaccurate output? |
| What is -206? |
| What is -209? |
| What Is A Buffer Pool? |
| What Is A Db2 Catalog? |
| What Is a Declaration Generator(dclgen)? |
| What Is A Predicate? |
| What is Aggregate? |
| What is an access path? |
| What is an alias? |
| What is COPY PENDING status? |
| What is DB2 ( IBM Database 2 )? |
| What is meant by AUTO COMMIT |
| What is meant by the attachment facility? |
| What Is Pagespace? |
| What is the -207? |
| What is the -209 error message? |
| What is the explanation behind the floor work? |
| What Is The Function Of Buffer Manager? |
| What is the physical storage length of DATE data type? |
| What will the COMMIT accomplish? |
| What Will The Commit Accomplish? |
| When a table is dropped all the alias get dropped automatically. State whether true or false? |
| When you will face SQLCODE -818? |
| When you will face SQLCODE -922? |
| Which component checks DB2 deadlocks? |
| Which component is responsible for execution of SQL statements? |
| Why SELECT is not preferred in Embedded SQL programs? |
| Explain DB2. |
| How can the duplicate values be eliminated from DB2 SELECT? |
| How to find the maximum value in a column in the DB2 database? |
| How to find the number of rows in DB2 tables? |
| List down the data types in the DB2 database. |
| List down the types of Triggers in the DB2 database? |
| What are the benefits of using the DB2 database? |
| What are the different types of Base tables? |
| What are the two types of Logging in the DB2 database? Explain them. |
| What is a trigger in the DB2 database? |
| What is buffer pool in the DB2 database? |
| What is DBRM in DB2 database? |
| What is the Clustering Index in the DB2 database? |
| What is the function of Logging in the DB2 database? |
| What is the meaning concurrency in the DB2 database? |
| What is the physical storage length of the Data Types: date, Time, Timestamp in the DB2 database? |
| What is the role of Data Manager in the DB2 database? |
| What is the role of Schema in the DB2 database? |
| What is the role of the cursor in DB2? |
| What is the role of the Data page in the DB2 database? |
| What is the role of UNION ALL and UNION |
| What is the syntax for creating a table in the DB2 database? |
| What is the syntax for seeing the columns and data types of a table in the DB2 database? |
| What is the use of DB2 optimizer? |
| What types of tables are there in the DB2 database? |
16 April 2021
#DB2
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment