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
Must follow PK Series for IT Officers exam here
Answers:
1) 2
2) 1
3) 2
4) 3
5) 3
6) 2
7) 3
8) 3
9) 1
10) 1
11) 2
12) 4
13) 4
14) 3
15) 4
16) 3
17) 1
18) 1
19) 4
20) 1
