A33a

1. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ………………………. A) Fields B) Records C) Relations D) Keys 2. ……………….. contains information that defines valid values that are stored in a column or data type. A) View B) Rule C) Index D) Default 3. Which of the syntax is correct for insert statement? i) insert into <table_name> values <list of values> ii) insert into <table_name> (column list) values <list of values> A) i-only B) ii-only C) Both of them D) None of them 4. ………………. First proposed the process of normalization. A) Edgar. W B) Edgar F. Codd C) Edward Stephen D) Edward Codd 5. For using a specific database …………… command is used. A) use database B) database name use C) Both A &B D) None of them 6. Which of the following is not comparison operator? A) <> B) < C) =< D) >= 7. An outstanding functionality of SQL is its support for automatic ………… to the target data. A) programming...

1. Which of the following is not the layer of TCP/IP protocol? A) Application Layer B) Session Layer C) Transport Layer D) Internetwork layer  2. ................... address use 7 bits for the <network> and 24 bits for the <host> portion of the IP address. A) Class A B) Class B C) Class C D) Class D 3. ............. addresses are reserved for multicasting. A) Class B B) Class C C) Class D D) Class E 4. State the following statement is true or false. i) In class B addresses a total of more than 1 billion addresses can be formed. ii) Class E addresses are reserved for future or experimental use. A) True, False B) True, True C) False, True D) False, False 5. Which of the following statement is true? i) An address with all bits 1 is interpreted as all networks or all hosts. ii) The class A network 128.0.0.0 is defined as the loopback network. A) i only B) ii only C) Both A and B D) None of the above 6. Which is not the Regional Internet Registers (RIR) of the following? A) ...

1. In mesh topology, relationship between one device and another is .............. A) Primary to peer B) Peer to primary C) Primary to secondary D) Peer to Peer 2. The performance of data communications network depends on .............. A) Number of users B) The hardware and software C) The transmission D) All of the above 3. Find out the OSI layer, which performs token management. A) Network Layer B) Transport Layer C) Session Layer D) Presentation Layer 4. The name of the protocol which provides virtual terminal in TCP/IP model is. A) Telnet B) SMTP C) HTTP 5. The layer one of the OSI model is A) Physical layer B) Link layer C) Router layer D) Broadcast layer 6. What is the name of the network topology in which there are bi-directional links between each possible node? A) Ring B) Star C) Tree D) Mesh 7. What is the commonly used unit for measuring the speed of data transmission? A) Bytes per second B) Baud C) Bits per second D) Both B and C 8. Which of the communication modes support...

1. A network that needs human beings to manually route signals is called.... A) Fiber Optic Network         B) Bus Network C) T-switched network           D) Ring network 2. TCP/IP ................. layer corresponds to the OSI models to three layers. A) Application          B) Presentation C) Session                 D) Transport 3. Which of the transport layer protocols is connectionless? A) UDP                      B) TCP C) FTP                ...

1.  The computer network is A) Network computer with cable B) Network computer without cable C) Both of the above D) None of the above 2. FDDI used which type of physical topology? A) Bus B) Ring C) Star D) Tree 3. FTP stands for A) File transfer protocol B) File transmission protocol C) Form transfer protocol D) Form transmission protocol 4. Ethernet system uses which of the following technology. A) Bus B) Ring C) Star D) Tree 5. Which of the following are the network services? A) File service B) Print service C) Database service D) All of the above 6. If all devices are connected to a central hub, then topology is called A) Bus Topology B) Ring Topology C) Star Topology D) Tree Topology 7. FDDI stands for A) Fiber Distributed Data Interface B) Fiber Data Distributed Interface C) Fiber Dual Distributed Interface D) Fiber Distributed Data Interface 8. Which of the following is an application layer service? A) Network virtual terminal B) File transfer, access and management C) Mail ...

1. In SQL, which command is used to issue multiple CREATE TABLE , CREATE VIEW and GRANT statements in a single transaction? A) CREATE PACKAGE B) CREATE SCHEMA C) CREATE CLUSTER A) All of the above 2. In SQL, the CREATE TABLESPACE is used A) to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace. B) to create a database trigger . C) to add/rename data files, to change storage D) All of the above 3. Which character function can be used to return a specified portion of a character string ? A) INSTR B) SUBSTRING C) SUBSTR D) POS 4. Which of the following is TRUE for the System Variable $date$? A) Can be assigned to a global variable. B) Can be assigned to any field only during design time. C) Can be assigned to any variable or field during run time. D) Can be assigned to a local variable. 5. What are the different events in Triggers? A) Define, Create B) Drop, Comment C) Insert, Update, Delete D) Select, Comm...

1. The first batch operating system was developed in the ................. by General Motors for use on an IBM 701. A) mid 1940's B) mid 1950's C) mid 1960's D) mid  1970's 2. Process is ........................ A) A program in execution B) An instance of a program running on a computer. C) The entity that can be assigned to and executed D) All of the above. 3. ................... is a facility that allows programmers to address memory from a logical point of view, without regard to the main memory, physically available. A) Visual memory B) Real memory C) Virtual memory D) Secondary memory 4. ............ is a large kernel, including scheduling file system, networking, device drivers, memory management and more. A) Monolithic kernel B) Micro kernel C) Macro kernel D) Mini kernel 5. A .................... architecture assigns only a few essential functions to the kernel,  including address spaces, Inter process communication(IPC) and basic scheduling. A) Monolithic kerne...