If a column is an image value type, how you can compare column values? How can you use this column in join clause?
590You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
590You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
547The count() function always returns a int value type what should you do if you need to count rows from a query which you know will return a value that is too large for an int value type?
576What are the three basic rules which are to be followed for the relational model of the database?
562Post New DB Development Questions
What is dbms and its application?
Who are end users in dbms?
You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?
Explain the process of the user request and data generating?
Explain about relational database management systems?
Explain what a database is?
You have a table with three columns: amount1, amount2, and amount3 in a single row only one of these three columns will have a value and the other two will be null. Write a sql query to retrieve the values from these columns?
Pgm A calls Pgm B and pgm B uses cursor, when pgm B is called second time, the program is abending saying the cursor is opened? Why?
What is dbms explain in brief?
What are the three basic rules which are to be followed for the relational model of the database?
Write the fastest query to find out how many rows exist in a table?
Any sample or model question of punjab national bank for deputy manger IT or any sample of PNB.any1 plz do send on
How can you fix a poorly performing query?
How to customize error conditions.
What is the maximum length of an extended property?
