Which of the following is an unary operation?


Options: a. Selection operation b. Generalized selection c. Primitive operation d. Projection operation

Ans:– b ,






More Database Systems Related questions:


. Which of the following is NOT true about background images?
Options: a. They are similar to watermarks in Word. b. They are displayed behind the controls in a form. c. They do not print when a form or a report is printed. d. They can be inserted on a form or a report.

Ans:8 – c ,8 – c


. Which of the following is not a database application?
Options: a. dBase b. Flash c. FoxPro d. Access

Ans:– b,– b


The 0 and 1 in the binary numbering system are called binary digits or _____
Options: bytes,    kilobytes,    decimal bytes,    bits

Ans:D ,D


What Oracle backup and recover file contains user and system data?
Options: Control file,    Datafile,    OnLine ReDo file,    Offline ReDo file

Ans:B ,B


To autofit the width of column
Options:  A) Double click the right border of column, B) Double click the left border of column, C) Double click the column header, D) All of above,

Ans:-A,-A


The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but hte data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a lienear array does not d. All of above  

Ans:d,d


Which SQL-92 standard SQL command can be used to change a table name?
Options: RENAME TABLE,    CHANGE TABLE,    ALTER TABLE,    None of the above is correct.

Ans:D ,D


A subtype discriminator is which of the following?
Options: An attribute of the supertype whose values determine the subtype,    An attribute of the subtype whose values determine the supertype,    An attribute of the supertype whose values determine the supertype,    An attribute of the subtype whose values determine the subtype

Ans:A ,A


You need the IP address of the devices with which the router has established an adjacency. Also, the retransmit interval and the queue counts for the adjacent routers need to be checked. What command will display the required information?
Options: show ip eigrp adjacency,    show ip eigrp topology,    show ip eigrp interfaces,    show ip eigrp neighbors

Ans:D ,D


What component would most likely cause a "parity error"?
Options: bad hard disk,    bad controller,    bad RAM,    bad software

Ans:C ,C


How many broadcast domains are created when you segment a network with a 12-port switch?
Options: 1,    2,    5,    12

Ans:A ,A


In virtual memory systems, Dynamic address translation
Options: is the hardware necessary to implement paging,    stores pages at a specific location on disk,    is useless when swapping is used,    is part of the operating system paging algorithm

Ans:A ,A


Which of the following is the address of the router?
Options: The IP address,    The TCP address,    The subnet mask,    The default gateway

Ans:D ,D


In SQL, which command is used to remove a stored function from the database?
Options: REMOVE FUNCTION,    DELETE FUNCTION,    DROP FUNCTION,    ERASE FUNCTION

Ans:C ,C


EBCDIC can code up to how many different characters?
Options: 8,    16,    32,    64

Ans:E ,E


Third generation computers
Options: were the first to use built-in error detecting devices,    used transistors instead of vacuum tubes,    were the first to use neural network,    All of the above

Ans:E ,E


The IEEE 802 project of the 1980s involved further defining the lower two layers of the OSI model. A number of standards were agreed upon during that time. Which of the following is the standard for Ethernet?
Options: 802.2,    802.3,    802.4,    802.5

Ans:B ,B


The integration of the computer with manufacturing is called CIM or _____
Options: CAM,    CAD,    Computer Integrated manu¬facturing,    All of the above

Ans:C ,C


If, in a computer, 16 bits are used to specify addresses in a RAM, the number of addresses will be
Options: 216,    65,536,    64K,    Any of the above

Ans:D ,D


The master list of an indexed file
Options: is sorted in ascending order,    contains only a list of keys and record numbers,    has a number assigned to each record,    both (b) and (c)

Ans:C ,C


The difference between CAD and CAM is that CAD software is directed at product design while CAM software is:
Options: concerned with production and control of tool design,    concerned with management programs,    designed for communications,    specifically for PC-board design

Ans:A ,A


Which of the following is used to insure the high quality of computer output?
Options: computer output microfilm,    output controls,    voice output systems,    liquid crystal display

Ans:B ,B


. The Basic Input Output System (BIOS) resides in
Options: a. RAM b. ROM c. The CPU d. Memory Cache

Ans: b, b


Who invented the microprocessor?
Options: Marcian E Hoff,    Herman H Goldstein,    Joseph Jacquard,    All of the above

Ans:A ,A


What is the purpose of the PSH flag in the TCP header?
Options: Typically used to indicate end of message B. Typically used to indicate beginning of message C. Typically used to push the message D. Typically used to indicate stop the message

Ans:– A ,


    Who invented Analytical engine?
Options: Blaise Pascal B. George Bool C. Charles Babbage D. Dr. Herman Hollerith

Ans:– C ,


What is the standard code the computer industry created to represent characters?
Options: DASI,    ASSH,    ASCII,    BASCII

Ans:C ,C


What are reasons for creating OSPF in a hierarchical design? To decrease routing overhead To speed up convergence To confine network instability to single areas of the network To make configuring OSPF easier
Options: 1, 2 and 3,    3 only,    3 and 4,    2, 3 nd 4

Ans:A ,A


Which option on the custom animation task pane allows you to apply a preset or custom motion path?
Options: a. Add effect b. Emphasis c. Animate now d. All of the above

Ans: – A , – A


A class 2 materials transaction (movement from one production department to another) does not require updating of the
Options: cost center file,    inventory file,    work order file,    All of the above

Ans:B ,B


. A data map is helpful
Options: a. When you have too much data to chart b. To show a geographic distribution of data c. To compare data points d. To show changes in data over time

Ans:– b,– b


You are working with a network that is 172.16.0.0 and would like to support 600 hosts per subnet. What subnet mask should you use?
Options: 255.255.192.0,    255.255.224.0,    255.255.240.0,    255.255.248.0

Ans:E ,E


Which of the following storage and retrieval methods would be well suited to your processing requirements if you only need to retrieve records one at a time and there is no fixed pattern to the requests for data and records?
Options: indexed sectors,    sequential,    direct,    indexed direct

Ans:D ,D


You need to configure a router for a Frame Relay connection to a non-Cisco router. Which of the following commands will prepare the WAN interface of the router for this connection?
Options: Router(config-if)#encapsulation frame-relay q933a,    Router(config-if)#encapsulation frame-relay ansi,    Router(config-if)#encapsulation frame-relay ietf,    Router(config-if)#encapsulation frame-relay cisco

Ans:C ,C


. Can you set 0.5 inch left indentation for a cell in Excel?
Options: a. Excel does not have indentation feature b. You can specify indentation only if you turn the rulers on c. Indentation can be set from Format Cells dialog box d. The indentation can be specified only when printing

Ans:– c,– c


A translator is best described as
Options: an application software,    a system software,    a hardware component,    all of the above

Ans:B ,B


You have a Cisco mesh network. What protocol allows multiple APs to connect with many redundant connections between nodes?
Options: LWAPP,    AWPP,    STP,    IEEE

Ans:B ,B


When a host knows its physical address but not its IP address, it can use _____.
Options: RARP,    ARP,    IGMP,    ICMP

Ans:A ,A


Which of the following series of commands will restrict Telnet access to the router?
Options: Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line con 0 Lab_A(config-line)#ip access-group 10 in,    Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line vty 0 4 Lab_A(config-line)#access-class 10 out,    Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line vty 0 4 Lab_A(config-line)#access-class 10 in,    Lab_A(config)#access-list 10 permit 172.16.1.1 Lab_A(config)#line vty 0 4 Lab_A(config-line)#ip access-group 10 in

Ans:C ,C


The keystrokes Ctrl + I is used to
Options:  A) Increase font size, B) Inserts a line break, C) Indicate the text should be bold, D) Applies italic format to selected text,

Ans:-D,-D


How do you magnify your document?
Options: A. View, Zoom B. Format, Font C. Tools, Options D. Tools, Customize

Ans:– A ,View, Zoom


A database management system
Options: allows simultaneous access to multiple files,    can do more than a record management system,    is a collection of programs for managing data in a single file,    both (a) and (b)

Ans:D ,D


. Which command is used to display the contents of the text file of DOS?
Options: a. Copy con b. Copy c. Type d. Dir

Ans: c, c


. What is the maximum zoom percentage in Microsoft PowerPoint?
Options: a. 100 b. 200 c. 300 d. 400

Ans:7 – D ,7 – D


What will be the output of the program? #include<stdio.h> #include<stdlib.h> union employee { char name[15]; int age; float salary; }; const union employee e1; int main() { strcpy(e1.name, "K"); printf("%s %d %f", e1.name, e1.age, e1.salary); return 0; }
Options: Error: RValue required,    Error: cannot convert from 'const int *' to 'int *const',    Error: LValue required in strcpy,    No error

Ans:D ,D


The proper definition of a modern digital computer is
Options: an electronic automated machine that can solve problems involving words and numbers,    a more sophisticated and modified electronic pocket calculator,    any machine that can perform mathematical operations ',    a machine that works on binary code

Ans:A ,A


The reservation system of Indian railways is an example of
Options: transaction processing system,    Interactive decision support system,    management controls system,    expert system

Ans:A ,A


What is the problem with an interface if you type show interface serial 0 and receive the following message? "Serial0 is administratively down, line protocol is down."
Options: The keepalives are different times.,    The administrator has the interface shut down.,    The administrator is pinging from the interface.,    No cable is attached.

Ans:B ,B


. Worksheet can be renamed by
Options: Adding ? symbol at the end of filename while saving workbook B. Click on Worksheet tab by Holding CTRL Key and type new name C. Double Click on the Worksheet tab and type new name D. Worksheet cannot renamed

Ans:– C ,


The primary method that people use to sense their environment is:
Options: reading,    writing,    speaking,    seeing

Ans:D ,D

www.000webhost.com