This Blog is very much helpful for the student who reads in BSC computer
science and engineering. This blog will give you all the tutorial of theoretical
answers of various questions of different subjects, so keep stay and get the
information + hand notes you need. This is written for you to get the notes
easily and to research with the subjects.
Please select a category of tutorial you need:
COMPUTER FUNDAMENTALS:
http://computer-fundamentals-4-student.blogspot.com
COMPUTER PROGRAMMING:
http://computer-programming-4-student.blogspot.com
PROGRAMMING IN ANSII C:
http://computer-c-programming-4-student.blogspot.com
PROGRAMMING IN C++:
http://computer-cpp-programming-4-student.blogspot.com
HTML AND WEB SITE DESIGN:
http://computer-webdesign-4-student.blogspot.com
COMPUTER ARCHITECTURE:
http://computer-architecture-4-student.blogspot.com
STATISTICS AND PROBABILITY:
http://statistics-probability-4-student.blogspot.com
DATA STRUCTURE:
http://datastructure-4-student.blogspot.com
DEFERENTIAL AND INTEGRAL CALCULUS:
http://calculus-4-student.blogspot.com
BUSINESS COMMUNICATION:
http://business-communication-4-student.blogspot.com
ELECTRONICS:
http://electronics-4-student.blogspot.com
ALGORITHM DESIGN:
http://algorithm-4-student.blogspot.com
OPERATING SYSTEM:
http://operatingsystem-4-student.blogspot.com
SYSTEM ANALYSIS AND DESIGN :
http://system-design-4-student.blogspot.com
DATA BASE MANAGEMENT SYSTEM :
http://dbms-4-student.blogspot.com
DISCRETE MATHEMATICS :
http://math-4-student.blogspot.com
E-COMMERCE :
http://e-commerce-4-student.blogspot.com
COMPILER DESIGN:
http://compilerdesign-4-student.blogspot.com
Monday, July 13, 2009
My WEB Blogs
Sunday, July 12, 2009
THE quitz
1. DBMS –
a. Direct base management system
b. Database management system
c. Dualbase management system
d. Databoth management system
2. Database means –
a. A collection of interrelated data
b. A collection of unterrelated data
c. A collection of updated data
d. A collection of any types of data
3. RDBMS –
a. Relational direct base management system
b. Relational database management system
c. Related dual base management system
d. Related database management system
4. SQL –
a. Structured query language
b. Stack query language
c. Structure query language
d. Structurebased query language
5. DCL –
a. Data control language
b. Database control language
c. Direct control language
d. Defined control language
6. An example of DCL –
a. Alter
b. Update
c. Grant
d. Insert
7. An example of DDL –
a. Alter
b. Update
c. Grant
d. Insert
8. An example of DML –
a. Alter
b. Update
c. Grant
d. Insert
9. An example of DML –
a. Alter
b. Update
c. Grant
d. Insert
10. An example of DML –
a. Alter
b. Update
c. Grant
d. Insert
11. Create table is an example of –
a. DDL
b. DML
c. DCL
d. DMA
12. Create View is an example of –
a. DDL
b. DML
c. DCL
d. DMA
13. Create user is an example of –
a. DDL
b. DML
c. DCL
d. DMA
14. Grant privilege is an example of –
a. DDl
b. DML
c. DCL
d. DMA
15. Select is an example of –
a. DDL
b. DML
c. DCL
d. DMA
16. Which of the following query will be execute properly:
a. create table class (roll number, name varchar (30));
b. creat table class (roll number, name varchar (30));
c. create class table (roll number, name varchar (30));
d. create table class (roll, name varchar(30));
17. Which of the following query will be execute properly on the table class(roll, name):
a. inset values into class (23, arif);
b. insets into class values (23, arif);
c. inset into class values (23, arif);
d. insert into class values (23, arif);
18. To show all rows and all columns of any table the query will be –
a. select * from table tablename;
b. select * from tablename;
c. select * from table tablename
d. dese tablename;
19. To show the structure of a table the query will be –
a. select * from table tablename;
b. select * from tablename;
c. Dese tablename
d. Describe tablename;
20. What will be the data type of data “c2307” –
a. Data
b. Varchar
c. Number
d. Raw
21. A SQL statements always start with:
a. adverb
b. verd
c. noun
d. adjective
22. A ___ used to seperates parameters within a clause of a SQL statement:
a. comma
b. semicolon
c. space
d. ()
23. A ___ used to terminates a SQL statement –
a. comma
b. semicolon
c. space
d. ()
24. Alter table instruction can do the following function:
a. change the name of a table
b. increase the coloumn size
c. change the coloumn name
d. decrease the coloumn size
25. ____ oldtablename to newtablename:
a. Name
b. Rename
c. Update
d. Alter
26. Using Commit statement, the change of current transaction is make permanent on database:
a. false
b. true
c. not mentioned
d. none
27. Using Rollback statement, the change during transaction is undo on database
a. false
b. true
c. not mentioned
d. none
28. A primary key must be:
a. unique & null
b. unique & not null
c. unique
d. not null
29. A multicoloumn primary key is called:
a. primary key
b. composite pimary key
c. super key
d. candidate key
30. PL /SQL:
a. Procedural language / structured query language
b. Prduced language / structured query language
c. Proccessed language / structured query language
d. Procedure language / structured query language
31. ___ is used for error trapping in PL / SQL blocks:
a. exception section
b. declare section
c. begin section
d. both b & c
32. Record cannot be ___ into detail table if corresponding records in the master table do not exist:
a. inserted
b. deleted
c. selected
d. none
33. Record cannot be ___ from the master table if corresponding records in the detail table exist:
a. inserted
b. deleted
c. selected
d. none
34. Foreign key represents ___ between table:
a. relationship
b. uniqueness
c. duality
d. none
35. What is the sequence of PL / SQL block declaration:
a. Declare, Begin, Execution, End
b. Begin, Declare, Execution, End
c. Declare, Begin, End, Execution
d. None
36. select name from student wherename like ‘ja%’;
a. sajal
b. jamal
c. suja
d. none
37. DUAL is a small –
a. oracle worktable
b. developer worktable
c. access worktable
d. VB worktable
38. Attributes presents in:
a. coloumns
b. rows
c. none
d. both
39. the following is a back end tool:
a. developer
b. visual basic
c. MS Access
d. MS Excel
40. Blocks are logical containers that have no physical representation.
a. true
b. false
c. not mentioned
d. both
41. A single block can be connected to multiple database objects like a table, view or synonym.
a. true
b. false
c. not mentioned
d. both
42. when a frame is associated with a block, the items in the block are automatically arranged within the frame.
a. true
b. false
c. not mentioned
d. both
43. scroll bar for a block can be attached to a block only at the time of block creation.
a. true
b. false
c. not mentioned
d. both
44. a window is connected to a block
a. true
b. false
c. not mentioned
d. both
45. Every forms contains at least one block, one window, one canvas and one or more items.
a. true
b. false
c. not mentioned
d. both
46. GUI stands for –
a. Graphical User Interface
b. Graphices Users Interface
c. Graph User Interface
d. Graphically Used Interface
47. The ___ item can be used only to show information that must be feathed or assigned programmatically.
a. display
b. text
c. button
d. none
48. forms builder provides the user with the ___ editor to write appropriate cade blocks.
a. SQL
b. PL / SQL
c. PL
d. None
49. The ___ at the bottom of the screen displays oracle messages to the user
a. status bar
b. scroll bar
c. tool bar
d. menu bar
50. If an item is connected to the base table column, the name of the item and the name of the base table column must be:
a. same
b. can be different
c. double
d. none
51. New_Record procedure creates a new record at runtime.
a. true
b. false
c. not mentioned
d. both
52. Execute_query retrieves row from the table and displays first record on the form.
a. true
b. false
c. not mentioned
d. both
53. Developer / VB is the tool of
a. back end
b. front end
c. middle
d. none
54. When_button_pressed is the trigger name of:
a. display item
b. text item
c. push button
a. Direct base management system
b. Database management system
c. Dualbase management system
d. Databoth management system
2. Database means –
a. A collection of interrelated data
b. A collection of unterrelated data
c. A collection of updated data
d. A collection of any types of data
3. RDBMS –
a. Relational direct base management system
b. Relational database management system
c. Related dual base management system
d. Related database management system
4. SQL –
a. Structured query language
b. Stack query language
c. Structure query language
d. Structurebased query language
5. DCL –
a. Data control language
b. Database control language
c. Direct control language
d. Defined control language
6. An example of DCL –
a. Alter
b. Update
c. Grant
d. Insert
7. An example of DDL –
a. Alter
b. Update
c. Grant
d. Insert
8. An example of DML –
a. Alter
b. Update
c. Grant
d. Insert
9. An example of DML –
a. Alter
b. Update
c. Grant
d. Insert
10. An example of DML –
a. Alter
b. Update
c. Grant
d. Insert
11. Create table is an example of –
a. DDL
b. DML
c. DCL
d. DMA
12. Create View is an example of –
a. DDL
b. DML
c. DCL
d. DMA
13. Create user is an example of –
a. DDL
b. DML
c. DCL
d. DMA
14. Grant privilege is an example of –
a. DDl
b. DML
c. DCL
d. DMA
15. Select is an example of –
a. DDL
b. DML
c. DCL
d. DMA
16. Which of the following query will be execute properly:
a. create table class (roll number, name varchar (30));
b. creat table class (roll number, name varchar (30));
c. create class table (roll number, name varchar (30));
d. create table class (roll, name varchar(30));
17. Which of the following query will be execute properly on the table class(roll, name):
a. inset values into class (23, arif);
b. insets into class values (23, arif);
c. inset into class values (23, arif);
d. insert into class values (23, arif);
18. To show all rows and all columns of any table the query will be –
a. select * from table tablename;
b. select * from tablename;
c. select * from table tablename
d. dese tablename;
19. To show the structure of a table the query will be –
a. select * from table tablename;
b. select * from tablename;
c. Dese tablename
d. Describe tablename;
20. What will be the data type of data “c2307” –
a. Data
b. Varchar
c. Number
d. Raw
21. A SQL statements always start with:
a. adverb
b. verd
c. noun
d. adjective
22. A ___ used to seperates parameters within a clause of a SQL statement:
a. comma
b. semicolon
c. space
d. ()
23. A ___ used to terminates a SQL statement –
a. comma
b. semicolon
c. space
d. ()
24. Alter table instruction can do the following function:
a. change the name of a table
b. increase the coloumn size
c. change the coloumn name
d. decrease the coloumn size
25. ____ oldtablename to newtablename:
a. Name
b. Rename
c. Update
d. Alter
26. Using Commit statement, the change of current transaction is make permanent on database:
a. false
b. true
c. not mentioned
d. none
27. Using Rollback statement, the change during transaction is undo on database
a. false
b. true
c. not mentioned
d. none
28. A primary key must be:
a. unique & null
b. unique & not null
c. unique
d. not null
29. A multicoloumn primary key is called:
a. primary key
b. composite pimary key
c. super key
d. candidate key
30. PL /SQL:
a. Procedural language / structured query language
b. Prduced language / structured query language
c. Proccessed language / structured query language
d. Procedure language / structured query language
31. ___ is used for error trapping in PL / SQL blocks:
a. exception section
b. declare section
c. begin section
d. both b & c
32. Record cannot be ___ into detail table if corresponding records in the master table do not exist:
a. inserted
b. deleted
c. selected
d. none
33. Record cannot be ___ from the master table if corresponding records in the detail table exist:
a. inserted
b. deleted
c. selected
d. none
34. Foreign key represents ___ between table:
a. relationship
b. uniqueness
c. duality
d. none
35. What is the sequence of PL / SQL block declaration:
a. Declare, Begin, Execution, End
b. Begin, Declare, Execution, End
c. Declare, Begin, End, Execution
d. None
36. select name from student wherename like ‘ja%’;
a. sajal
b. jamal
c. suja
d. none
37. DUAL is a small –
a. oracle worktable
b. developer worktable
c. access worktable
d. VB worktable
38. Attributes presents in:
a. coloumns
b. rows
c. none
d. both
39. the following is a back end tool:
a. developer
b. visual basic
c. MS Access
d. MS Excel
40. Blocks are logical containers that have no physical representation.
a. true
b. false
c. not mentioned
d. both
41. A single block can be connected to multiple database objects like a table, view or synonym.
a. true
b. false
c. not mentioned
d. both
42. when a frame is associated with a block, the items in the block are automatically arranged within the frame.
a. true
b. false
c. not mentioned
d. both
43. scroll bar for a block can be attached to a block only at the time of block creation.
a. true
b. false
c. not mentioned
d. both
44. a window is connected to a block
a. true
b. false
c. not mentioned
d. both
45. Every forms contains at least one block, one window, one canvas and one or more items.
a. true
b. false
c. not mentioned
d. both
46. GUI stands for –
a. Graphical User Interface
b. Graphices Users Interface
c. Graph User Interface
d. Graphically Used Interface
47. The ___ item can be used only to show information that must be feathed or assigned programmatically.
a. display
b. text
c. button
d. none
48. forms builder provides the user with the ___ editor to write appropriate cade blocks.
a. SQL
b. PL / SQL
c. PL
d. None
49. The ___ at the bottom of the screen displays oracle messages to the user
a. status bar
b. scroll bar
c. tool bar
d. menu bar
50. If an item is connected to the base table column, the name of the item and the name of the base table column must be:
a. same
b. can be different
c. double
d. none
51. New_Record procedure creates a new record at runtime.
a. true
b. false
c. not mentioned
d. both
52. Execute_query retrieves row from the table and displays first record on the form.
a. true
b. false
c. not mentioned
d. both
53. Developer / VB is the tool of
a. back end
b. front end
c. middle
d. none
54. When_button_pressed is the trigger name of:
a. display item
b. text item
c. push button
Saturday, July 11, 2009
program for web
/*Write a C program to create a tree. */
#include
#include
#include
typedef struct TREE
{
struct TREE *left_child;
int element;
struct TREE *right_child;
} TREE;
TREE *CreateTree (int element, TREE *tree_ptr)
{
/* if tree is null, the following code create the parent node.*/
if (! tree _ptr)
{
tree_ptr= (TREE *) malloc (sizeof (TREE));
tree_ptr->element=element;
tree_ptr->left_child=NULL;
tree_ptr->right_child=NULL;
return (tree_ptr);
}
/* if tree is not null. */
if (elementelement) //left child.
tree_ptr->left_child=CreateTree (element, tree_ptr->left_child);
else
if (element>tree_ptr->element) //right child.
tree_ptr->right_child=CreateTree (element, tree_ptr->right_child);
return (tree_ptr);
}
void Display_Tree (int height, TREE *tree)
{
int i;
if (tree)
{
Display_Tree (height+1, tree->right_child);
printf ("\n");
for (i=0; i
printf (" ");
printf ("%d", tree->element);
Display_Tree (height+1, tree->left_child);
}
}
void main ()
{
int x;
TREE *tree=NULL;
clrscr ();
while (1)
{
printf ("\n Enter new element (1000 for exist) :");
scanf ("%d", &x);
if (x = = 1000)
break;
tree = CreateTree(x, tree);
printf ("\n\n The tree is: \n");
Display_Tree (1, tree);
}
}
#include
#include
#include
typedef struct TREE
{
struct TREE *left_child;
int element;
struct TREE *right_child;
} TREE;
TREE *CreateTree (int element, TREE *tree_ptr)
{
/* if tree is null, the following code create the parent node.*/
if (! tree _ptr)
{
tree_ptr= (TREE *) malloc (sizeof (TREE));
tree_ptr->element=element;
tree_ptr->left_child=NULL;
tree_ptr->right_child=NULL;
return (tree_ptr);
}
/* if tree is not null. */
if (elementelement) //left child.
tree_ptr->left_child=CreateTree (element, tree_ptr->left_child);
else
if (element>tree_ptr->element) //right child.
tree_ptr->right_child=CreateTree (element, tree_ptr->right_child);
return (tree_ptr);
}
void Display_Tree (int height, TREE *tree)
{
int i;
if (tree)
{
Display_Tree (height+1, tree->right_child);
printf ("\n");
for (i=0; i
printf (" ");
printf ("%d", tree->element);
Display_Tree (height+1, tree->left_child);
}
}
void main ()
{
int x;
TREE *tree=NULL;
clrscr ();
while (1)
{
printf ("\n Enter new element (1000 for exist) :");
scanf ("%d", &x);
if (x = = 1000)
break;
tree = CreateTree(x, tree);
printf ("\n\n The tree is: \n");
Display_Tree (1, tree);
}
}
Friday, July 10, 2009
Subscribe to:
Comments (Atom)
