262 views

1 Answer

0 votes
0 votes

I think views should be the answer.

Actually the phrase "to provide security by restricting data access" tells us that we want to give restricted access to some set of users by only giving them partial DB not the entire DB access. 

Indexes are ways of speeding up searches and achieving certain kind of efficiency in query running time.

Sequence is just a feature of DBMS to give unique incrementing numbers.

Eg:

CREATE SEQUENCE sequence_name
  MINVALUE value
  MAXVALUE value
  START WITH value
  INCREMENT BY value
  CACHE value;

Related questions

0 votes
0 votes
1 answer
1
Hradesh patel asked Nov 17, 2016
286 views
Q. Bus is used in computer for-:A. connect different component on the motherboard of a PC unit.B. connect RAM to motherboard.C.run the CMOS.D. speed up the processing spe...
0 votes
0 votes
1 answer
2
Hradesh patel asked Nov 17, 2016
444 views
Q. Which of the following process of an operating system is shown in this figure?A.Fundamental state transitionB.Scheduling of kernel level threadsC.Event handling action...
0 votes
0 votes
1 answer
3
Hradesh patel asked Nov 17, 2016
244 views
Q. The expressions are evaluated ____________ according to the precedence of set operators.A. from left to rightB.from right to leftC.as per user defined specificationD.f...
0 votes
0 votes
1 answer
4