Internet & E-Commerce Objective Set_1

OBJECTIVE QUESTIONS INTERNET & E-COMMERCE (CA-101)

1)    ………. is/are an ISP in India:         a) BSNL ❌                                b) AIRTEL  ❌                          c) RELIANCE ❌                      d) All of these✅ 2)    ………. is one of e-mail protocol:         a) HTTP❌                                 b) FTP❌                                   c) SMTP✅                               d) All of these❌ 3) What is WWW:        a) World Web Wide ❌                                                b) Web Wide World ❌                          c) World Wide Web ✅                                                 d) Web World Wide❌ 4) Which is Incorrect IP Address:         a) 192.168.1.1 ❌                                 b) 256.168.1.1  ✅                                c) 254.168.1.1 ❌                                 d) 145.168.1.1❌ 5)  What is HTTP?        a) Hyper Text Transmission Protocol❌                        b) Hyper Text Transfer Protocol ✅                   c) Hyper Tags Transfer Protocol❌                                           d) Higher Text Transmission Protocol❌ 6) What is FTP:        a) File Transfer Protocol   ✅                                       b) Format Transmission Protocol❌         c) File Transmission Protocol❌                                     d) Format Transfer Protocol❌ 7) Which is Incorrect IP Address:         a) 168.152.10.1❌                                b) 160.152.10.1❌                    c) 260.152.10.1✅                   d) 245.152.10.1❌ 8) Which is invalid class of IP Address:         a) Class A ❌                            b) Class C❌                             c) Class G✅                            d) Class E❌ 9) Which is not a Search Engine:        a) Bing❌                                               b) Ask❌                                    c) Windows7 Search✅            d) Yahoo❌  10) What is TCP:        a) Transmission Control Protocol  ✅                          b) Transfer Control Protocol❌         c) Traffic Control Protocol❌                                       d) None of these❌ 11) What is SMTP:        a) Simple Mail Transfer Protocol  ✅                           b) Simple Mail Transmission Protocol❌         c) Server Mail Transfer Protocol❌                                d) None of these❌ 12) How many Layers in OSI Model Have:         a) 4 ❌                                      b) 6  ❌                                     c) 7✅                                      d) 8❌ 13) Which is Correct IP Address:         a) 192.168.7.10  ✅                              b) 292.168.7.10   ❌                 c) 192.168.7.310  ❌                d) 192.268.7.10❌ 14) IP address are classified in how many number of classes:         a) 4  ❌                                  b) 5✅                                      c) 6   ❌                                    d) None of these❌ 15) In OSI Model which layer is at number 4:         a) Network Layer❌                  b) Session Layer❌                   c) Transport Layer ✅               d) Data link Layer❌ 16) A ________ is a collection of many separate networks         a) WAN❌                                 b) INTERNET✅         c) LAN  ❌                               d) None of these❌ 17) A _____ data communication system spanning states, countries or the whole world         a) MAN❌                                 b) LAN❌                                  c) WAN  ✅                              d) None of these❌ 18) A data communication system within a building, campus or between nearby building         a) MAN❌                                 b) LAN  ✅                               c) WAN❌                                d) None of these❌ 19)   _______ is the Protocol suite for the current internet         a) UNIX❌                                 b) TCP/IP✅                              c) ACM❌                                  d) NCP❌ 20) An Unauthorized user is a network ______ issue         a) Performance❌                                  b) Reliability❌                          c) Security✅                           d) Availability❌

 

DTP Objective Set_1

OBJECTIVE QUESTIONS DESKTOP PUBLISHING & MULTIMEDIA (CA-102)

1) Which of the following is done through DTP:        a) Advertisement Design❌           b) Flex Design❌                 c) Banner Design❌                           d) All of these✅ 2) How many types of Computer Graphics :        a) 2 ✅                        b) 3 ❌                        c) 4 ❌                      d) 5 ❌ 3) Desktop Publishing Abbreviated:        a) dtps ❌                               b) dtpk ❌                               c) dtp✅                      d) dtpv ❌  4) Which of the following printers printing is fastest:        a) Laser✅               b) Inkjet ❌                 c) Drum Printer❌                 d) Dot matrix❌ 5) Which of these is published under DTP:        a) News Letters❌                b) Brochures❌                     c) The Books ❌                              d) All of these✅ 6) Which of the following is done through DTP:         a) Flex Design ❌                             b) Banner Design❌          c) Poster Design❌            d) All of these✅ 7) Which type of graphic size increases, there is no defect in quality?         a) Print Graphic ❌               b) Vector Graphic            c) Raster Graphic ❌            d) None of These❌ 8) Which of these is published under DTP?         a) News Letters❌                b) Brochures ❌                                c) The Books ❌                              d) All of these 9) What type of printer is Dot-Matrix printer?        a) Impact Printers✅           b) Non-Impact Printers ❌               c) Both ❌                d) None of these❌ 10) What type of printer is laser printers:        a) Impact Printers❌           b) Non-Impact Printers✅                c) Both ❌                d) None of these❌ 11) Which of the following is done through DTP:        a) Poster Design ❌                  b) Banner Design ❌           c) Flex Design❌                              d) All of these✅ 12) What is the full form of DTP:        a) Data Publishing❌           b) Desktop Publishing✅        c) Desktop Printing❌                 d) Data Printing❌ 13) In which type of printing ribbon is used:        a) Impact printer✅              b) Non-impact printer❌          c) Drum Printer ❌            d) None of these❌ 14) Which of these is published under DTP:        a) News Letters ❌               b) Brochures ❌                    c) The Books ❌                  d) All of these✅ 15) What type of printer is laser printers:        a) Impact Printers ❌            b) Non-Impact Printers✅                c) Both ❌                d) None of these.❌ 16) Adobe Photoshop is a _____________ Graphics editor.        a) Vector❌                 b) bitmap❌                c) bmp ❌                   d) Raster✅ 17) Passport size photo size( in centimeters)__________        a) 3.5x4.5✅              b) 6.4x1.5❌                c) 5.6x4.5 ❌              d) 6.2x2❌ 18) What is the default extension of Photoshop file____        a) .psd✅                   b) .bmp❌                    c) .cdr❌                                  d) .pmd❌ 19) What is the shortcut key of Ruler?        a) Ctrl + I❌               b) Ctrl + R✅             c) alt + R❌                 d) Ctrl + J❌ 20) Photoshop is product of _______        a) Microsoft❌            b) Apple❌                  c) Adobe✅               d) Mac❌

RDBMS Objective Set_1

OBJECTIVE QUESTIONS RELATIONAL DATABASE MANAGEMENT SYSTEM-(RDBMS) (CA-202)

1) Which of the following is a database management tool developed by Microsoft: a) Dbase❌                b) Access✅                 c) Oracle❌            d) Physical view❌ 2) A field used to access a specific record is called: a) Key✅                     b) Attribute❌           c) Domain❌          d) None of these❌ 3) Which are DML statements: a) Create & Drop❌  b) Update, Insert & Delete✅  c) Commit❌  d) Alter Session❌ 4) In SQL, which command is used to add new row to a table: a) Alter table❌               b) add row❌                   c) Insert✅            d) Append❌ 5) What is SQL? a) Summarized Query Language❌                 b) Stored Query Language❌              c) Systematic Query Language ❌                   d) Structured Query Language✅ 6) What is DDL: a) Data Definition Language✅                       b) Drawing Definition Language❌ c) Distributed Definition Language❌              d) Defined Definition Language❌ 7) In RDBMS, tuple is also called: a) Column❌               b) Row✅              c) Attribute❌               d) None of These❌ 8) CREATE command is: a) DDL Command✅              b) DML Command❌                c) DCL Command❌ d) TCL Command❌ 9) In RDBMS, Attribute is also called: a) Column✅                  b) Row❌                    c) Cell❌                   d) Record❌ 10) Which command is used to delete a table: a) DELETE❌              b) DROP✅         c) DESTROY❌        d) None of these❌ 11) Which are DDL statement: a) CREATE✅               b) INSERT❌            c) COMMIT❌       d) None of these❌ 12) What is DCL: a) Data Currency Language❌                         b) Data Control Language✅               c) Data Concurrent Language❌                      d) Data Customized Language❌ 13) The view of Total Database is: a) Conceptual view✅   b) Internal view❌    c) External view❌  d) Physical view❌ 14) In SQL, which command is used to edit record in a table? a) Manipulate❌              b) Edit❌               c) Update✅            d) None of these❌ 15) What is TCL statement: a) savepoint❌                b) rollback❌         c) commit❌              d) All of these.✅ 16) Related fields in a database are grouped to form a_______ a) File❌                     b) Record✅                   c) Menu❌                    d) Bank❌ 17) In the Architecture of DBMS System external level is the_______ a) Physical❌             b) Logical❌                c) Conceptual❌               d) View✅ 18) In case of Entity Integrity, the primary key may be_______       a) Not Null✅                   b) Null❌                          c) both a and b❌                 d) any value❌ 19) The database Schema is written in________       a) TCL❌                       b) DML ❌                             c) DDL✅                              d) DCL❌ 20) In a relational model, relations are termed as______             a) Tuples❌                        b) Attributes❌                            c) Tables✅                                d) Rows❌

 

Fundamental of Computer Objective Set_1

OBJECTIVE QUESTIONS FUNDAMENTAL OF COMPUTER & P.C. SOFTWARE (CA-101)

1) The brain of any computer System is:         a) ALU❌                          b) Memory❌         c) CPU✅                  d) Control Unit❌ 2) The output quality of printer is measured by:         a) Dot per sq. inch❌           b) Dot per inch✅           c) Dots print per sec❌           d) All of these❌ 3) Mnemonic a memory trick is used in which of the following language?        a) Machine❌                         b) Assembly✅        c) High Level❌                 d) None of these❌ 4) In word processing, changing the appearance of a document is called:        a) Editing ❌          b) Writing ❌              c) Formatting ✅        d) All of these❌ 5) A nibble consists of:        a) bits❌        b) 4 bits✅            c)  6 bits❌        d) 16 bits❌ 6) The smallest unit of data in a computer is called:        a) Nibble❌        b) Byte❌                    c) Bit✅                 d) Cell❌ 7)  A Giga Byte (GB) is equal to the:        a) 1024 Byte❌        b) 1024 MB✅        c) 1024 KB❌        d) 1024 TB❌ 8)  A computer program that converts assembly language to machine language is:        a) Compiler❌            b)  Interpreter❌        c)  Assembler✅        d)  Converter❌ 9) Which device is used for translate data from a computer into pictorial form on paper?        a) Mouse❌        b) Plotter ✅        c) Touch Panel❌              d) Card Punch❌ 10) An optical input device that interprets pencil marks on paper media is:        a) O.M.R.✅           b) Punch Card Reader❌         c) Optical Scanners❌         d) Magnetic Tape❌  11) The symbols used in an assembly language are:        a) Code❌        b) Mnemonics✅        c)   Assembly❌        d) None of these❌ 12) Codes consisting of light and dark marks which may be optically read is known as:        a) Mnemonics❌              b) Binary❌        c)   Bar Code✅        d) Decoder❌ 13) Binary Language is also known as:       a) Machine❌             b) Assembly❌       c)  Low Level❌                 d) Both a and c✅ 14) The device that can both feed data into and accept data from a computer is:       a) CPU❌                   b) ALU❌           c)  Memory❌            d) Input & Output Device✅ 15) A pen shaped device can sense light, and is used to point at spots on a video screen:       a) Mouse❌       b) Light Pen✅       c)   Joystick❌       d) Plotter❌ 16) Which of the following is non-volatile storage?       a) Primary❌       b) Cache❌       c) Secondary✅       d) None of these❌ 17) Which unit is responsible for converting the data received from the user into a       computer understandable format?       a) Input Unit✅             b) Output Unit❌       c) Control Unit❌           d) None of these❌ 18) The only language which the computer understands is:       a) Assembly❌       b) Binary✅       c) BASIC❌       d) C Language❌ 19) Whenever the data is found in the cache memory it is called as:       a) MISS❌       b) FOUND❌       c) FLAG❌       d) HIT✅ 20) The transfer between CPU and Cache is:       a) Block Transfer❌         b) Word Transfer✅         c) Bit Transfer❌               d) None❌

 

BCA RDBMS PRACTICAL NUMBER_1

PRACTICAL NUMBER_1 

➤Create tables named employee, department, Salary, Implement all DDL commands on it.

DDL (Data Definition Language) Commands are-

1. Create,
2. Alter table (to Add Column, to Modify Column and to DROP Column)
3. Rename
4. Truncate
5. Drop

1. Create table Command-->

SQL> connect ⤶

Enter user-name: system⤶

Enter password : password⤶

connected

SQL>Create table Employee ( Emp_Id int primary key, Name varchar(20) , age int, city varchar(30));⤶

Table Created.

SQL> Create table Department( DeptId int primary key, Dept_Name varchar(20));⤶

Table Created.

SQL> Create table Salary ( Emp_Id int, Salary numeric(10,2));⤶

Table Created.

DDL Commands-Create Table

2. (a) Alter Table Command to Add Column--> we use this command to add Mobile Column in Employee Table.

SQL> Alter table Employee ADD Mobile number(10);⤶

Table altered.

2. (b) Alter table Command to Modify Column--> we use this command to modify Name Column with Not Null Constraint.

SQL> Alter table Employee MODIFY Name varchar(20) not null;⤶

Table altered.

2. (c) Alter table Command to DROP Column--> we use this command to drop or destroy Name Column.

SQL> Alter table Employee DROP COLUMN Name;⤶

Table altered.

DDL Commands-Alter Table(Add Column, Modify Column or Drop Column)

3. Rename Command--> this command is used to Rename object and here we will rename Employee table name to Employee_Record.

SQL>rename Employee to Employee_Record;⤶

Table renamed.

4. TRUNCATE Command--> this command is used to delete data permanently. 

SQL>TRUNCATE Table Employee_Record;⤶

Table truncated.

5. DROP Command--> this command is used to drop table, view, user, sequence, synonym etc.

SQL>drop table Employee_Record;⤶

Table dropped.  

DDL Commands- Rename, Truncate, Drop

Relational Database Management System Syllabus For BCA

Unit-I

Introduction, Evolution of DB and DBMS, Need for Data Management, Introduction & Application of DBMS, File System V/S Database System, Concepts of DBMS: Data, Information, Database, Components of DBMS, Architecture of Database System-Physical, Conceptual & User Level, Data Independence: Logical & Physical, DBMS Terminology, Data Dictionary, Concepts of Multitier, Architecture in Databases, Brief Idea about, Distributed Databases, Parallel Databases, Mobile Databases, Temporal Databases, Spatial Databases, Geographical Databases, Data Warehousing,  Data Mining, Data Visualization, OODB and XML Databases, Multimedia and Web Databases.

Unit-II

Database Models: Networks, Hierarchical and Relational Models, Features and Comparison of the three models, RDBMS: Introduction to Relational database, Structure of Relational Database, Relational Model terminology– domain, Attributes, Tuples, Relations, Relational DB Schema, E-R Model, ER- Diagram, ER- Concepts and types of relationships, Codd’s 12 rule, Normalization: Functional Dependency, definition, Trivial and Non-Trivial, Functional Dependencies, Steps involved in normalization, 1NF, 2NF, 3NF, Decomposition using Functional Dependency preservation, BCNF, Multi- valued Dependency, 4NF Join Dependency, 5NF.

Unit-III

Idea about Generalization, Aggregation, Specialization, Indexing & Hashing: Basic Concepts, Indexing: b+ tree & B- tree index files, Hashing static & dynamic hashing, Elementary Concepts of Database Security: System failure, Backup and Recovery Techniques, Authorization and Authentication, Relational Algebra: Formal Definition, Fundamental Operations: select, project, union, set difference, Cartesian product & rename, additional operational operations, extended operations.

Unit-IV

Concept of SQL sublanguages- DDL, DML, DCL, TCL, Embedded SQL, Interactive SQL: Oracle data types, table creation, modifying the structure of tables, dropping and renaming tables, DML commands: Insertion, updating, deletion operations, many faces of select command, data constraints, logical operations, range searching, pattern matching, oracle functions, use of Alias, Grouping data from tables, manipulating dates in SQL.

Unit-V

Joins Equi Join, Self join. Cross Join, Sub queries, Indexes, Views, Sequences, Roles, Synonyms, TCL Commands: use of save point, rollback, commit commands. DCL Commands: creating user accounts, granting permissions, revoking permissions. Concept of importing and exporting database files.

Practical Solution

1) Create tables named employee, department, Salary, Implement all DDL commands on it. 2) On the Employee table use the many faces of Select Command. 3) On a table perform WHERE clause HAVING, GROUP BY, ORDER BY, IN, NOT IN, BETWEEN. 4) Create a database implementing Primary and Foreign Key. 5) Implement I/O constraints and Business rule constraints on the database created as in 4 above. 6) Perform nested queries on table STUDENT. 7) Perform different types of JOINS on any two tables. 8) Create VIEWS, SEQUENCES and SYNONYMS on a table. 9) Use of SAVEPOINT, ROLL BACK and COMMIT commands.

Objective Questions

1. RDBMS Objective Set_1.