|
|
| |
|
SQL View and Synonyms Questions for Certification Part 1
Question Posted on 22 Nov 2017
Home >> DataBase >> SQL Certification >> SQL View and Synonyms Questions for Certification Part 1 |
Below are the some latest topics and the question which helps you to clear your Certification in Sql. Answer are alos given below the questions
(1)Select different types of Views from below?
(a)Simple views
(b)Complex views
(c)Both A and B
(d)None of the above
(2)Select true value from below given for complex views
(a)DML statements not used against complex views
(b)Contain multiple base tables
(c)Aggregations not be performed
(d)All of the above
(3)How View is stored in data dictionary?
(a)As a WHERE clause
(b)As a CREATE statement
(c)As a SELECT statement
(d)As an UPDATE statement
(4)Which view contain single row functions?
(a)Complex Views
(b)Simple Views
(c)Composite Views
(d)Inline Views
(5)Which View contain group of data?
(a)Complex View
(b)Composite View
(c)Simple View
(d)None of the above
(6)Which object provides a layer of abstraction between users and data?
(a)Views
(b)Synonyms
(c)Table
(d)Rows
(7)Data base objects which generate serial numbers?
(a)Synonyms
(b)Tables
(c)Sequences
(d)Views
(8)Why are views usefull?
(a)Because they have shorter names than tables
(b)To prevent users from accessing the columns of tables
(c)To simplify user SQL
(d)All of the above
(9)From where view can get data?
(a)Tables from the same schema
(b)Tables from different schema
(c)Both A and B
(d)None of the above
(10)Get true about synonyms
(a)PUBLIC and PRIVATE synonyms may have same name for the same table
(b)DROP SYNONYM may remove a synonym
(c)DROP PUBLIC SYNONYM may be executed only by a SYSDBA
(d)None of the above
(11)Is below query to delete complex view is correct or not
DELETE FROM dept_sum_vu;
(a)Will delete the view
(b)Will remove all the rows from view and structure of view will remain the same
(c)will throw an ORA error
(d)None of the above
(12)How can row from view be removed?
(a)Deletion of rows through a view is not possible
(b)It should be a simple view
(c)It should be a complex view
(d)None of the above
Answer are Given Below
(1)Answer is c Simple and Complex both are views. Simple views are refer only to one table and it should have subquery. But not include group function expressions etc. On the other Side complex Views are based on subquery have data from more then one table and have function and group data.
(2)Answer is d as complex views can take data from one or more tables and can contain functions and grouped data.
(3)Answer is c
(4)Answer is b and d
(5)Answer is a
(6)Answer is a and b Views and Synonyms not store data . Data is stored in temporary or virtual table.
(7)Answer is c Squence is created to do a series of integers. Sequence is created with Create Sequence command.
(8)Answer B and c View is temporary or vortual table used to retrieve data stored in database tables.
(9)Answer is c
(10)Answer is a and c Only SYSDBA or a user with DBA privileges can create a public synonym.
(11)Answer is c as complex view can not be deleted becasue DML statement not run on complex view.
(12)Answer is B DML operation can be possible on simple views. | |
|
|
|
|
|
|
|
|
|
|