Computer interview questions – page 11

SQL data definition commands make up a(n)

1. HTML
2. DML
3. DDL
4. XML

In the _____ normal form, a composite attribute is converted to individual attributes.

1. 1st
2. 2nd
3. 3rd
4. 4th

You can add a row using SQL in a database with which of the following?

1. INSERT
2. CREATE
3. ADD
4. MAKE

Which normal form is considered adequate for relational database design?

1. 1 NF
2. 2 NF
3. 3 NF
4. 4 NF

The result of a SQL SELECT statement is a(n)

1. File
2. Report
3. Form
4. Table

The primary key is selected from the

1. Determinants
2. Candidate keys
3. Composite keys
4. Foreign keys

A relation is in this form if it is in BCNF and has no multivalued dependencies.

1. Second normal form
2. Third normal form
3. Fourth normal form
4. Domain/key normal form

SQL can be used to

1. Create database structures only
2. Query database data only
3. Modify database data only
4. All of the above can be done by SQL

SQL query and modification commands make up a(n)

1. DDL
2. HTML
3. XML
4. DML

Which command creates a new shell?

1. ah
2. oh
3. ch
4. sh

The <b>cd</b> command stands for

1. complete directory
2. created directory
3. change directory
4. current directory

This command formats a floppy _____

1. mkfs
2. mkf
3. mks
4. man

Which key should be pressed to save a file in line editing mode?

1. x
2. s
3. n
4. w

Hard disk partition is prefixed by

1. hd
2. hda
3. hda2
4. dha

Which command is used to evaluate arithmetic expression?

1. cat
2. expre
3. expr
4. lets

<b>Is</b> command with the <b>-a</b> option will display

1. sorted files
2. all files including hidden fields
3. all files
4. sub directories

Which symbol allows you to search the pattern, backward in the text?

1. plus (+)
2. question mark (?)
3. astrisk (*)
4. slash (/)

Which keys are substituted for the cut facility?

1. nyy
2. nkk
3. ndd
4. nhh

Which Directory is assigned to the user when he/she enters into the system for the first time, by the System Administrator (SA)?

1. user
2. home
3. bin
4. usr

Second normal form should meet all the rules for

1. 1 NF
2. 3 NF
3. 4 NF
4. 5 NF

The SQL statement that queries or reads data from a table is

1. READ
2. SELECT
3. ORDER
4. QUERY

The command to eliminate a table from a database is

1. DELETE TABLE CUSTOMER
2. UPDATE TABLE CUSTOMER
3. DROP TABLE CUSTOMER
4. REMOVE TABLE CUSTOMER

Which of the following memory is capable of operating at electronics speed?

1. Magnetic tapes
2. Magnetic drums
3. Magnetic disks
4. Semiconductor memory

Average access time in the magnetic disks is of the order of

1. 50 millisecond
2. 50 microsecond
3. 50 second
4. All of the above

Which of the following is a displayed listing of program option that users can select?

1. File
2. Data item
3. Block
4. Menu

Which of the following is responsible for coordinating various operations using timing signals?

1. Memory unit
2. Control unit
3. Arithmetic Logic Unit
4. Input/Output Unit

Which memory time delay required between the initiation of two successive memory operations is known as

1. Transmission time
2. Waiting time
3. Memory access time
4. Memory cycle time

The blinking on and off of characters on a VDU screen is

1. Flicker
2. Flag
3. Flashing
4. Flat bed plotter

Which of the following is not an alternative name for primary memory?

1. Main memory
2. Primary storage
3. Mass storage
4. Internal storage

Primary storage is _____ as compared to secondary storage.

1. Fast and expensive
2. Fast and inexpensive
3. Slow and expensive
4. Slow and inexpensive