Database Gk interview questions

In which database records are organised in a tree like structured by type

1. Flat-file
2. Relational
3. Hierarchical
4. Network

_____ option specifies the user should enter a value for that field.

1. Entry required
2. Format
3. Length
4. Default value

Which of the following is used to delete or edit the records in a table?

1. Filter
2. Form
3. Field
4. File

By pressing _____ key we can move to next column.

1. Enter
2. Tab
3. Insert
4. Shift

The common field or fields of two or more tables is called a

1. Keys
2. Row
3. Cell pointer
4. Cell

_____ are grouped by object oriented database.

1. Characteristics, attributes & graphics
2. Characteristics, attributes & quantity
3. Characteristics, attributes & procedures
4. Characteristics, color & size

Which of the following window is similar to Defaultfilter?

1. Condition window
2. Query condition window
3. Report window
4. Form window

_____ is not a field type in StarBase.

1. Menu
2. Float
3. Currency
4. Date/Time

To edit a record first

1. Select the record
2. Press the record pointer
3. Press the primary key
4. Key the record

By pressing which key, one can move to the second field?

1. Shift key
2. Tab key
3. Replace key
4. Insert key

The key combination used to save the table is

1. Ctrl + B
2. Ctrl + K
3. Ctrl + Z
4. Ctrl + S

Sorting on more than one field of a table at the same time is called

1. Multiple Sorting
2. Merging
3. Sorting in Ascending order
4. Sorting in Descending order

Browsing a selecting list of records is called

1. Filtering
2. Merging
3. Searching
4. Sorting

To uniquely identify a record in database, the key used is

1. Key
2. Primary key
3. Secondary key
4. Third level key

Database is highly effective for

1. Editing
2. Merging
3. Data manipulation
4. Copying

Sorting is a process

1. Of performing corrections.
2. Of joining data from two or more tables.
3. To select a desired specific data.
4. Of arranging the data in a table.

With the help of Structured Query Language one can

1. Delete obsolete records
2. List a subset of records
3. Search the database to locate records
4. All the above

Currency, text and decimal are examples for _____ types.

1. Name
2. Data
3. Field
4. Both

To edit the data that has been entered in a table we have to

1. Just click on that field and retype the new value
2. Retype the new value
3. Just click on the field value
4. None of these

The option used to specify the maximum characters that can be entered in a field is

1. Length
2. Type
3. Entry required
4. Default value

Which of the following is used to create a Database?

1. Edit→New→Database
2. File→New→Database
3. View→New→Database
4. File→View→Database

Which are displayed on the right pane of window→opening screen?

1. Forms
2. Queries
3. Reports
4. All the above

To change the selected record, we have to click on the

1. Record button
2. Primary key
3. Delete rows options
4. Delete columns options

Which one of the following statement is false?

1. SQL is a Special Query Language for communicating with a database
2. Merging arranges records in a table according to specific critieria
3. Editing in StarOffice Base allows to change the font type, size and height of the rows also
4. Every table in StarOffice Base have a primary key

Computerised data processing includes

1. Modifications
2. Changes
3. Correction
4. All the above