Data Representation & Number System-SQL (Bank-PO Computer-Basics): Questions 1 - 4 of 4

Get 1 year subscription: Access detailed explanations (illustrated with images and videos) to 395 questions. Access all new questions we will add tracking exam-pattern and syllabus changes. View Sample Explanation or View Features.

Rs. 250.00 or

Question number: 1

» Data Representation & Number System » SQL

MCQ▾

Question

ER model is most relevant to the ________ steps.

Choices

Choice (4) Response
a.

Requirement analysis

b.

Conceptual database design

c.

Logical database design

d. All a. , b. and c. are correct

Question number: 2

» Data Representation & Number System » SQL

MCQ▾

Question

Three SQL, DDL, CREATE commands are ________ respectively.

Choices

Choice (4) Response
a.

Base, Table and Schema

b.

Schema, Base and Table

c.

Key, Base and Table

d.

Schema, Table and View

Question number: 3

» Data Representation & Number System » SQL

MCQ▾

Question

Which of the following is the best definition of a relational database management system?

Choices

Choice (4) Response
a.

It is a system in which data is stored in multiple formats so that it can be an accessed easily by a variety of programs

b.

It contains a single compilation of data, such as a list of addresses or a list of books.

c.

It is a database system in which transactions are collected and then processed in batch at the end of a time- period.

d.

It contains many tables of information that can be a joined for calculations and reports by their common fields.

Question number: 4

» Data Representation & Number System » SQL

MCQ▾

Question

UNION is used in -

Choices

Choice (4) Response
a.

Language keyword

b.

Word processing function

c.

Database operator

d. None of the above

Sign In