Q1. Which of the following are two most important network architecture or reference model?
i) Layered reference model
ii) OSI reference model
iii) DSL reference model
iv) TCP/IP reference model
(a) i and ii
(b) ii and iii
(c) iii and iv
(d) ii and iv
(e) only iii
Q2. CREATE TABLE Employee(Emp_id NUMERIC NOT NULL, Name VARCHAR(20) , dept_name VARCHAR(20), Salary NUMERIC UNIQUE(Emp_id,Name));
INSERT INTO Employee VALUES(1002, Ross, CSE, 10000)
INSERT INTO Employee VALUES(1006,Ted,Finance, );
INSERT INTO Employee VALUES(1002,Rita,Sales,20000);
Consider the given SQL statements in the description. What will be the result of the query?
(a) All statements executed
(b) Error in create statement
(c) Error in insert into Employee values(1006,Ted,Finance, );
(d) Error in insert into Employee values(1008,Ross,Sales,20000);
(e) Error in Create Table;
Q3. A variable X is called pointer if:
(a) X contains the address of an element in data
(b) X points to the address of first element in data
(c) X can store only memory addresses
(d) X contain the data and the address of data
(e) X cannot store a value more than 1 bit.
Q4. Which among the following operation cannot be performed on a queue?
(a) Traversal
(b) Insertion
(c) Deletion
(d) Retrieval
(e) All of the above operations are performed on a queue
