Monday, 21 December 2015

IBPS IT Officer Computer Knowledge Database Capsule Quiz 112

Dear mm expert. Here we are Presenting to you some questions and answers on IBPS IT Officer Professional Knowledge for the IBPS Specialist Officer Exam. These Questions and Answers also known as our computer knowledge capsule for ibps bank po, ibps clerk, ibps so, ibps rrb, ibps rbi officer, SBI po and clerk exam series. Practice start now.!!!

IBPS IT Officer Professional Knowledge Computer Database - Quiz Part - 2

21. The overall description of a database is called :
a. Data definition
b. Data manipulation
c. Data integrity
d. Database schema


22. Which is proper subset designed to support ‘views’ belonging to different classes of users in order to hid
or protect information:
a. Schema
b. Subschema
c. Non-schema
d. None-subschema

23. A data dictionary is a repository that manages :
a. Database
b. Memory
c. Metadata
d. All of these

24. Which languages are used to define and query a database:
a. Database
b. Memory
c. Metadata
d. All of
these

25.DDL stand for:
a. Data definition language
b. Data description languages
c. Data design languages
d. Database dictionary languages

26. Which are the not most frequently used DDL statements:
a. CREATE
b. DROP
c. ALTER
d. None of these

27.VDL stand for:
a. View data languages
b. View design languages
c. View definition languages
d. View done languages

28.SDL stands for
a. Stand definition languages
b. Storage definition languages
c. Select definition languages
d. system definition languages

29.The DDL is used to specify the :
a. Conceptual schemas
b. Internal schemas
c. Both
d. None

30. The SDL is used to specify the :
a. Conceptual schemas
b. Internal schemas
c. Both
d. None

31.DML stands for:
a. Data description languages
b. Data design languages
c. Database dictionary languages
d. Data manipulation languages

32. Which is used for data retrieval from the database:
a. DDL
b. DML
c. SDL
d. VDL

33. Which is used to specify the user views and their mappings to the conceptual schema:
a. DDL
b. DML
c. SDL
d. VDL

34. How many types of DML:
a. 1
b. 2
c. 3
d. 4

35. What are the types of DML:
a. Low level
b. High level
c. Procedural DML
d. All of these

36. Which is requires a user to specify what data is needed and how to get it:
a. Low level
b. Procedural DML
c. Both
d. None

37. Data is manipulated by procedure calls to subroutines provided by a :
a. Data
b. DBMS
c. Register
d. All of these

38. The programming languages is called:
a. Sublanguages
b. Host languages
c. VDL
d. DDL

39. The DML is called:
a. Sublanguages
b. Host languages
c. VDL
d. DDL

40. Which command are included in a general purpose programming languages:
a. DDL
b. DML
c. SDL
d. VDL
 
Read : IBPS IT Officer Professional Knowledge Computer Database - Quiz Part - 1

No comments:

Post a Comment

Advertisement