Which SQL Query is use to remove a table and all its data from the database? a. Create Table b. Alter Table c. Drop Table d. None of these


Options: Every primary-key value must match a primary-key value in an associated table B. Every primary-key value must match a foreign-key value in an associated table C. Every foreign-key value must match a primary-key value in an associated table D. Every foreign-key value must match a foreign-key value in an associated table

Ans:– c ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 9263






More Database Systems Related questions:


Poor data administration can lead to which of the following?
Options: A single definition of the same data entity,    Familiarity with existing data,    Missing data elements,    All of the above.

Ans:C ,C


The integrated circuit was invented by Jack Kilby of:
Options: MIT,    Texas Instruments,    Xerox,    All of the above

Ans:B ,B


ASK, PSK, FSK, and QAM are examples of _____ encoding.
Options: digital-to-digital,    digital-to-analog,    analog-to-analog,    analog-to-digital

Ans:B ,B


What will be the output of the program? #include<stdio.h> int main() { struct s1 { char *z; int i; struct s1 *p; }; static struct s1 a[] = {{"Nagpur", 1, a+1} , {"Chennai", 2, a+2} , {"Bangalore", 3, a} }; struct s1 *ptr = a; printf("%s,", ++(ptr->z)); printf(" %s,", a[(++ptr)->i].z); printf(" %s", a[--(ptr->p->i)].z); return 0; }
Options: Nagpur, Chennai, Bangalore,    agpur, hennai, angalore,    agpur, Chennai, angalore,    agpur, Bangalore, Bangalore

Ans:D ,D


Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Options: Nonrepeatable read,    Phantom read,    Dirty read,    Consistent read

Ans:C ,C


. How can you optimize performance of your computer?
Options: a. Delete unused files b. Defrag disk c. Scan for virus d. All of above

Ans:8 – d ,8 – d


. The virtual memory is
Options: a. An extremely large main memory b. An extremely large secondary memory c. An illusion of extremely large main memory d. A type of memory used in super computer

Ans:5 – c ,5 – c


Which of the following digits are known as the sub-address digits (for use by the user) of the Network User Address (NUA)?
Options: 5-7,    1-4,    8-12,    13-14

Ans:D ,D


A record management system
Options: a. can handle many files of information at a time b. can be used to extract information stored in a computer file c. always uses a list as its model d. both a and b 

Ans:.b,.b


. Which of the following statements does NOT hold true for the Top Values property?
Options: a. The Top Values property displays only the highest values from the query. b. The Top Values property requires the fields to have a defined sort order. c. The Top Values property finds a specified number of records. d. The Top Values property finds a specified percentage of records.

Ans:1 – a ,1 – a


You see the message "invalid media device" after installing a new hard drive. What do you do next?
Options: Format,    Fdisk,    Partition,    Add the OS

Ans:A ,A


What is the i/o address for com2?
Options: 2vb,    2f8,    8f8,    330

Ans:B ,B


Indicate which is a pre-emptive scheduling algorithm
Options: Round-robin,    Shortest-job-next,    Priority-based,    All of the above

Ans:A ,A


The extract process is which of the following?
Options: Capturing all of the data contained in various operational systems,    Capturing a subset of the data contained in various operational systems,    Capturing all of the data contained in various decision support systems,    Capturing a subset of the data contained in various decision support systems

Ans:B ,B


Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Options: Using the Oracle Database Configuration Assistant.,    Using the Oracle-supplied database creation procedures.,    Using the SQL CREATE DATABASE command.,    None of the above is correct.

Ans:A ,A


. Which criteria do not return the position “Officer” as a match?
Options: a. position = “*ff*” b. position = “O??icer” c. position = ” ?ff*” d. position = “O#r”

Ans:– d,– d


Programming languages currently available for robots:
Options: may be point-to-point languages,    require training,    may allow primitive motion,    All of the above

Ans:D ,D


. How do you print your slides in a handout that includes lines for notes?
Options: a. In the print dialog box, select handout and set the number of slides per page to 3 b. In the print dialog box, select handout and set the number of slides per page, then select the include comment page option c. In the print dialog box select note page instead of handout d. All of above

Ans:3 – A ,3 – A


A thermistor:
Options: is a pressure sensing device,    has a voltage output,    measures temperature,    All of the above

Ans:C ,C


Getting data from a cell located in a different sheet is called …
Options: a. Accessing b. Referencing c. Updating d. Functioning

Ans:#8211; b,#8211; b


The short statements that represent the steps the computer needs to follow to solve a problem are called
Options: Flowcharts,    Flow diagrams,    IPO charts,    Pseudocharts

Ans:E ,E


    Which of the following extensions suggest that the file is a backup copy
Options: a.    Bak b.    Bas c.    Com d.    Txt

Ans:.a,Correct Answer: a. Bak


. You can not link Excel worksheet data to a Word document
Options: a. With the right drag method b. With a hyperlink c. With the copy and paste special commands d. With the copy and paste buttons on the standard toolbar

Ans:– d,– d


Pressure sensors:
Options: use the piezoresistive effect in strain gauge sensors,    use an aneroid chamber with a variable resistance output,    use capacitive variations to sense pressure,    All of the above

Ans:D ,D


The network layer, in reference to the OSI model, provide
Options: data link procedures that provide for the exchange of data via frames that can be sent and received,    the interface between the X.25 network and packet mode device,    the virtual circuit interface to packet-switched service,    All of the above

Ans:C ,C


Which of the following is intended to be used in all applications runs on mainframe computers.
Options: LOGO,    APL,    PL/1,    OCCAM

Ans:C,(Canswer


If the displayed system time and dateis wrong, you can reset it using
Options: a. Write b. Calendar c. Write file d. Control panel

Ans:d,d


Duplicate copies of the data base are stored at all locations under:
Options: partitioning,    polling,    replication,    data sharing

Ans:C ,C


An AND gate
Options: implements logic addition,    is equivalent to a series switching circuit,    is an any or all gate,    is equivalent to a parallel switching circuit

Ans:B ,B


The register which keeps track of the execution of a program and which contains the memory address of the instruction currently being executed is known as
Options: Index register,    Memory address register,    Program counter,    Instruction register

Ans:C ,C


Which of the following systems software does the job of merging the records from two flies into one?
Options: Documentation system,    Utility program,    Networking software,    Security software

Ans:B ,B


Bandlimited signal is
Options: transmission of signals without modulation,    a signal all of whose energy is contained within a finite frequency range,    simultaneous transmission of data to a number of stations,    All of the above

Ans:B ,B


Any device that performs signal conversion is
Options: Modulator,    Modem,    Keyboard,    Plotter

Ans:A ,A


14. What is the name of the latest server operating system developed by Microsoft?
Options: a. Windows NT b. Windows 2000 c. Windows XP d. Windows 2003

Ans:Correct Answer: d,Correct Answer: d


One method of programming a computer to exhibit human intelligence is called modeling or:
Options: simulation,    cognitization,    duplication,    psychic amelioration

Ans:A ,A


. Which of the following computer implemented binary numbers, perform calculations using electronics and implemented separate computation and memory for the first time?
Options: A) Mark I B) ABC C) Z3 D) None of above

Ans:B,B


In an Entity-Relationship Diagram “Diamonds” represents
Options: Attributes B. Multi-valued attributes C. Weak entity set D. Relationship sets

Ans:– D ,


In creating a procedure, you may get a message if you have compile errors. Which of the following is true?
Options: The line numbers reported match the line numbers you see in your text editor.,    SQL*Plus will automatically show the errors to you.,    To see the errors, enter SHOW ERRORS in SQL*Plus.,    If there are no syntax errors, you will receive the message "NO ERRORS."

Ans:C ,C


. Which of the following devices can be sued to directly image printed text?

Options: A) OCR B) OMR C) MICR D) All of above

Ans:A,A


55. A feature of MS Word that saves the document automatically after certain interval is available on
Options: a. Save tab on Options dialog box b. Save As dialog box c. Both of above d. None of above

Ans:– A ,– A


Which command will display all the EIGRP feasible successor routes known to a router?
Options: show ip routes *,    show ip eigrp summary,    show ip eigrp topology,    show ip eigrp adjacencies

Ans:C ,C


29. What is a Document Outline View?
Options: a. A preview in a full screen b. A preview with margins c. A View with a margins and gutter d. A view with a structure of heading at various levels

Ans:–  D ,–  D


Expand EDVAC
Options:

Ans:Electronic Discrete Variable Automatic Computer,


H.P. Luhn and Stephen E. Forth developed an application for the computer named
Options: selective dissemination of information,    management information system,    information retrieval,    document retrieval

Ans:C ,C


Convert the BRNE h#01E6, i assembly language instructions into hexadecimal machine language:
Options: 0111EF,    9001E6,    DA000F,    40

Ans:B ,B


Which command is used to establish a link between a source document and a destination document?
Options: Tools, Link, Documents B. Tools, Link C. Edit, Link D. Edit, Paste Special

Ans:– D ,


A directly accessible appointment calendar is a feature of a _____ resident package.
Options: CPU,    Memory,    Buffer,    ALU

Ans:B,B


. Which of following are not PowerPoint views?
Options: a. Page View b. Print View c. Normal View d. Outline View

Ans:2 – A ,2 – A


Information concerning the probability distribution of a profit rate can be generated by using:
Options: electronic spreadsheet,    artificial intelligence,    time-series analysis,    management science techniques

Ans:D ,D


Which command displays RIP routing updates?
Options: show ip route,    debug ip rip,    show protocols,    debug ip route

Ans:B ,B

www.000webhost.com