iStudyCS

  Login in Oracle 10g software:  Open oracle 10g software:     press window button      type "go to " and click on oracle software.  User ID: system Password: oracle10g To create User:  Syntax:        create user <username> identified by <password>; Example:      create user Ram identified by ram12345 ; To display all the tables in oracle:      select * from tab; To display the content of the table:      select * from student; To see the schema (columnName, datatype, size of a table)     desc student; To create a table in oracle:    Syntax:     create table <tableName>     (          attribute1 datatype(size),          attribute2 datatype(size)     ); Example:     create table student     (          rollno var...

 Syllabus:  Database Management System   Subject Code - BCA-202 Max Marks :  80                                                                                          Min Marks : 27 Note :   The Question Paper setter is advised to prepare unit-wise question with the provision of internal choice. Only Simple calculators allowed not scientific calculator.   UNIT - I: Overview of Database Management Data, Information and knowledge, Increasing use of data as a corporate resource, data processing verses data management, file oriented approach verses database oriented approach to data management; data independence, database administration roles, DBMS architecture, different kinds of DBMS users...