Specialist IT Officer Professional Knowledge Questions For IBPS SO (Day-23)

Specialist IT Officer Professional Knowledge Questions For IBPS SO 2018

Dear Readers, Important IT Officer Professional Knowledge Questions for IBPS SO Exam was given here with answers. Aspirants those who are preparing for the examination can use this.

[WpProQuiz 1071]

Click “Start Quiz” to attend these Questions and view Solutions

1). A scheme describes

1. Data elements
2. Records and files
3. Record relationship
4. All of the above
5. None of the above

 

2). In SQL, the ____________ command is used to recompile a view.

1. COMPILE VIEW
2. DEFINE VIEW
3. CREATE VIEW
4. ALTER VIEW
5. None of the above

3). In SQL, which of the following is not a data definition language command?

1. RENAME
2. REVOKE
3. GRANT
4. All of the above
5. None of the above

4). A relational database management (RDBM) Package manages data in more than one file at once. How does it organize these file? As

1. tables
2. relations
3. both (a) and (b)
4. either (a) or (b)
5. None of the above

5). Which of the following is true?

1. Duplicate values are allowed in a primary key
2. Primary keys generally can be changed
3. Foreign keys are based on data values and are purely logical, not physical, pointers
4. You can define foreign keys without existing primary key
5. None of these

6). Which of the following is not an advantage of the database approach?

1. Elimination of the data redundancy
2. Ability to associate related data
3. Increase security
4. Program / data independence
5. All of the above are advantages

7). Which command is used to remove a table from the database in SQL?

1. DELETE TABLE
2. DROP TABLE
3. ERASE TABLE
4. UNATTACH TABLE
5. None of the above

8). In SQL, which command is used to changes data in a table?

1. UPDATE
2. INSERT
3. BROWSE
4. APPEND
5. None  of the above

9). The distinguishable parts of a record are called

1. files
2. data
3. fields
4. database
5. None of the above

10). The _________ contains information on the date stored in the database and is consulted by the DBMS before any data manipulation operation.

1. Data dictionary
2. Date table
3. View
4. Network catalog
5. None of these

Click Here for More Specialist IT Officer Professional Knowledge Questions