Professional Knowledge Quiz for IT Officers Exam Part - 5

1. Which are two ways in Which entities can participate in a relationship?
1) Passive and active
2) Total and partial
3) Simple and complex
4) All of the above
5) None of these

2. Which among these is incorrect for relations?
(i) Degree-number of tuples
(ii) Relation-table
(iii) Tuple-row
(iv) Attribute-column

1) Only (i)
2) (i) and (ii)
3) (i) and (iii)
4) (iii) and (iv)
5) None of these

3. Which of the following is used to define the structure of a relation, deleting relations and relating schemas?
1) DML(Data Manipulation Language)
2) DDL( Data Definition Language)
3) Query
4) Relational schema
5) None of these

4. Which of the following in not true?
1) External view: highest level of abstraction as seen by a user
2) Conceptual view: sum total of Data base management system user’s views
3) Internal level: middle level of abstraction
4) Internal level: how the data are physically stored.
5) None of these.

5. Which of the following is true about WHERE clause?
1) Does not include a comparison predicate
2) No restriction on the number of rows
3) Eliminates all rows from the result set where the comparison predicate does not evaluate to True
4) The WHERE clause is applied after the group by clause.
5) None of these

6. What protocol is used to find the hardware address of a local device?
1) RARP
2) ARP
3) IP
4) ICMP
5) BOOTP

7. Establishing a virtual connection is functionally equivalent to?
1) Connection as virtual memory
2) Physically connecting a DTE and DCE
3) Placing a telephone call prior to a conversation
4) Placing a modem prior to a conversation
5) None of above

8. Which of the following is a variation of frequency division multiplexing (FDM)?
1) Time division multiplexing (TDM)
2) Pulse code multiplexing (PCM)
3) Wavelength division multiplexing (WDM)
4) None of above’
5) All of these

9. The binary equivalent of the gray code 11100 is _________?
1) 10111
2) 00111
3) 01011
4) 10101
5) None of these

10. Star topology is based on a central device that can be?
1) HUB
2) Switch
3) Only (1)
4) Both (1) and (2)
5) None of these

11. Any program is C has access to three standard files?
1) Standard input file, standard output file, standard error file
2) Stdin, stdout, stderr
3) All of above
4) Key words, screen, stderr
5) All of above

12. The index register in a digital computer is used for?
1) Pointing to the stack address
2) Indirect addressing
3) Keeping track of number of times a loop is executed
4) Address modification
5) None of these

13. The HAVING clause:
1) Includes a comparison predicate used to eliminate rows after the GROUP BY clause is applied to the result set
2) It acts on the results of the GROUP BY clause
3) Aggregate functions can be used in the HAVING clause predicate
4) All of the above
5) None of these

14. What are the functions of DCL?
1) Handling the authorization aspects of data.
2) Permitting the user to control who has access to see or manipulate data within the database.
3) Both (1) and (2)
4) (1) only
5) None of these

15. Which of these are the activities done by RDBMS?
(1) Take note of authorizations
(2) Take note of constraints
(3) Update variables according to authorizations and constraints
(4) All of above
(5) None of these

16. Which of the following are the prosperities of entities?
1) Groups
2) Tables
3) Attributes
4) Switch boards
5) None of these

17. __________ is preferred method for encoding data integrity.
1) Constraints
2) Stored procedure
3) Triggers
4) Cursors
5) None of these

18. ___________data type can store unstructured data.
1) RAW
2) CHAR
3) NUMERIC
4) VARCHAR
5) None of these

19. A DBMS responds to commands given by
1) General purpose application programs
2) Custom developed application programs
3) Users
4) All of the above
5) None of these

20. Which one of the following provides the ability to query information from the database and to insert tuples into, delete tuples from, and modify tuples in the database?
1) DML(data manipulation language)
2) DDL (data definition language)
3) Query
4) Relational schema
5) None of these