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
"Did you Know? In this pack you will get All new content we launch in the next 1 months"
This is the most recommended and NRA-CET ready Pack!
Use Code 'DREAM' to avail at the best price today
This package Includes IBPS PO Study Material - Subscribe Now
About Bank Mahapack
If you are preparing for more than 1 Banking & Insurance exams then this is the pack we recommend you buy.
It is most cost-effective and you get access to 100% digital content for Bank & Insurance exams on Adda247.
Banking & Insurance Exams Covered in this Pack
Additionally, you can crack any private bank job exam with content in this pack.
Bank & Insurance Mahapack Highlights
- Structured course content
- Recorded classes available if you miss any live class
- Previous Years’ Papers of all upcoming exams.
- Full Length Mocks based on the latest pattern with detailed solutions (video solutions for certain topics)
- Topic level knowledge tests
- Strategy sessions, time management & Preparation tips from the experts
Validity: 1 Month
- Unlimited Live Classes & Recorded Video Courses
- Unlimited Tests and eBooks
- 1 Lakh+ Selections
- 15 Months
- 9 Months
- 3 Months
- 27 Months
- 1 Month
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?
(e) All of the above operations are performed on a queue
Q5. Which of the following is used to get back all the transactions back after rollback?
Q6. Which among the following is an example of a network database?
(e)Both (a) and (b)
Q7. Which of the following is IaaS service provider?
(e) Both (a) and (b)
Q8. Which statement is true regarding synonyms?
(a) Synonyms can be created for tables but not views
(b) Synonyms are used to reference only those tables that are owned by another user
(c) A public synonym and a private synonym can exist with the same name for the same table
(d) The DROP SYNONYM statement removes the synonym, and the status of the table on which the synonym has been created becomes invalid
(e) All of the given statements are true
Q9. A binary search tree whose left subtree and right subtree in differ in height by at most 1 unit is called _______.
(a) Lemma Tree
(b) Redblack Tree
(c) AVL Tree
(d) Both (a) and (c)
(e) None of the above
Q10. What does Rollback do after commit?
(a) Undo the transactions before commit
(b) Clears all transactions
(c) Redo the transactions before commit
(d) No action
(e) Redo (one) previous transaction