0:00	foreign
0:06	welcome back in this presentation we are
0:10	going to see solved questions in
0:12	introduction to dbms let's step into
0:15	question number one the question is
0:17	which of the following is true about
0:20	dbms and the options are option A dbms
0:24	is a collection of interrelated data
0:26	option b it is a set of programs to
0:30	access those data option C it is a
0:34	software to create and manage databases
0:36	and option D all of the above I request
0:40	you to pause this video for a while and
0:43	think about the right answer
0:46	I hope you are done and the right answer
0:49	for this question is option D all of the
0:52	above because a dbms is a set of
0:54	interrelated data and it is a set of
0:57	programs to access those data basically
0:59	dbms is a software to create and manage
1:02	databases and hence option D is the
1:05	right answer we are now done with
1:08	question number one let's now move on to
1:10	question number two the question is
1:13	which of the following statement is or
1:16	are false options are option A both file
1:19	system and database management system
1:22	are preferred for storing and retrieving
1:24	the data option B file systems can
1:28	handle redundancy well
1:30	option C database systems are more
1:33	responsive data retrieval system than
1:35	file systems and option D concurrent
1:38	access may lead to inconsistency
1:41	I request you to pause this video for a
1:43	while and think about the right answer
1:47	I hope you are done in this question we
1:50	are required to find out the false
1:52	statements at first we'll focus on the
1:55	first option both file system and
1:57	database management system are preferred
1:59	for storing and retrieving the data this
2:02	is true because both file system and
2:04	DPMS are for storing and retrieving the
2:05	data only but the difference is file
2:08	system is not efficient in terms of
2:10	effective storing and retrieval of data
2:13	whereas dbms is sufficient but anyway
2:16	both file system and database systems
2:18	are for storing and retrieving the data
2:20	so this is not the right answer so a is
2:23	not the right answer coming to be file
2:25	systems can handle redundancy well and
2:28	this is false and this is one of the
2:30	drawbacks that we have in file systems
2:33	and that is why we are preferring TPMS
2:35	so option b is false so we can confirm
2:38	that one of the right answers here is
2:41	file systems can handle redundancy well
2:43	which is actually not true let's see is
2:46	there any other correct answer database
2:48	systems are more responsive data
2:50	retrieval system than file systems and
2:52	this is also true and coming to option D
2:55	concurrent access may lead to
2:57	inconsistency this is also true but
3:00	concurrence access in databases are
3:02	handled well but anyway in general
3:04	concurrent access may lead to
3:06	inconsistency if it is not properly
3:08	handled so from this we can confirm that
3:11	the right answer is option b that is
3:14	file systems can handle redundancy well
3:17
which is false
3:19
we are done with question number two
3:21
let's now move on to question number
3:23
three which is in a three-tier
3:25
architecture which of the following tier
3:27
deals with the business logic and
3:30
business rules and the options are given
3:32
option a presentation tier option b
3:35
application tier option C data tier and
3:39
option D none of the above I request you
3:41
to pause this video for a while and
3:43
think about the right answer
3:46
I hope you are done let's analyze what's
3:49
the question in a three-tier
3:51
architecture we are required to find the
3:54
following tier that deals with the
3:56
business logic and business rules
3:58
presentation tier is the front end so
4:00
this is not dealing with the business
4:01
logic and business rules its intention
4:04
is to provide interface to the user to
4:06
access the database
4:08
an application tier yes this is the tier
4:11
that deals with the business logic and
4:13
business rules and coming to the data
4:15
tier we have databases here which does
4:17
not deal with the business logic or
4:19
business rules and hence option b is the
4:22
right answer here
4:24
we are done with question number three
4:26
let's now move on to question number
4:28
four the question is hiding the
4:30
complexity from the application
4:32
programmers and users is referred to as
4:34
Dash and the options are option a data
4:38
encapsulation option b data redundancy
4:41
option C data abstraction and option D
4:44
data analytics I'll request you to pause
4:46
this video for a while and think about
4:48
the right answer
4:51
it's easy to answer this question that
4:53
data abstraction is the right answer
4:55
because data abstraction is the concept
4:57
that hides the complexity from the
4:59
application programmers and also from
5:01
the users accessing the database systems
5:03
so we want Simplicity we don't want any
5:07
complex details to be shown so we are
5:09
hiding the complexity through data
5:11
abstraction
5:12
we are done with question number four
5:14
let's now move on to question number
5:16
five which is the overall design of the
5:19
database is called as Dash and the
5:22
options are option a schema option b
5:25
instance option C structure and option D
5:28
model and we can confirm that the right
5:31
answer for this question is option b
5:33
schema because schema is referred to as
5:36
the overall design of the database and
5:39
we have three levels of schema the
5:40
physical schema The Logical schema and
5:42
the sub schema we are done with question
5:45
number five let's now move on to
5:47
question number six the question is
5:49
which of the following type of users are
5:52
unsophisticated and who interact with
5:55
the system by invoking one of the
5:57
application programs that have been
5:59
written previously and the options are
6:02
option A and IV users option b
6:05
application programmers option C
6:07
database administrators and option D
6:10
system analyst I request you to pause
6:12
this video for a while and think about
6:14
the right answer
6:16
I hope you are done and the right answer
6:19
for this question is option a knife
6:21
users because naive users are the
6:24
unsophisticated users who interact with
6:26
the database system by invoking the
6:28
application programs that were written
6:30
by the application programmers and also
6:33
coming to the database administrators
6:34
they have the overall control over the
6:37
system and they are not unsophisticated
6:39
users coming to the system analyst or
6:42
database analyst he is also not an
6:44
unsophisticated users so the
6:46
unsophisticated here who invokes the
6:49
application program is the nive users
6:52
tellers in the bank even end users who
6:55
access the database system through some
6:56
web interfaces are referred as live
6:58
users
7:00
we are done with question number six
7:02
let's now move on to question number
7:03
seven and the question is which of the
7:06
following is or are incorrect about DBA
7:09
the database administrator the options
7:12
are DBA is responsible for granting
7:15
authorization for data access option b
7:18
DPA periodically backup the database
7:20
option C DBA defines the schema storage
7:24
structure and the access method and
7:27
option D none of the above I request you
7:30
to pause this video for a while and
7:32
think about the right answer
7:34
and the right answer here is option D
7:37
none of the above because all these jobs
7:40
mentioned here option A B and C all are
7:43
the responsibilities of the database
7:45
administrator and hence option D is the
7:48
correct answer here so DBA the database
7:51
administrator grants the authorization
7:53
for data access periodically back up the
7:55
database and he is the one who defines
7:58
the schema storage structure and the
8:00
access method I hope you are able to
8:02
answer all these seven questions if not
8:04
no worries when the course progresses we
8:07
will be able to gain more knowledge
8:09
about databases before we sign out let's
8:11	see the homework question the question
8:13	is if you are a database administrator
8:16	list some major steps that you would
8:19	take in setting up a database for a
8:21	particular Enterprise so I request you
8:24	to take some time work on this homework
8:26	question and post your answers in the
8:28	comment section I know you are not going
8:30	to just mention the option as the right
8:32	answer here because here I have asked
8:34	you to contemplate you as a database
8:36	administrator and then you are required
8:39	to identify some major steps that you
8:41	would take in setting up a database for
8:44	your organization or for a particular
8:45	Enterprise this is a generic question
8:48	because I have not mentioned any
8:49	particular organization or an Enterprise
8:51	here so as a database administrator what
8:54	are all the things that you will do in
8:56	order to set up a database for an
8:58	Enterprise and that's it guys I hope you
9:01	guys enjoyed this presentation we are
9:03	done with chapter number one as well
9:04	I'll see you in the next chapter and
9:07	thank you for watching
9:09	[Music]
9:09	[Applause]
9:11	[Music]
9:18	thank you