ADVANCED DBMS-II
ADVANCED DATABASE SYSTEM
Question [1-40] – Part A [Each 1 mark]
Question [41-60] – Part B [Each 2 marks]
Question [61-75] – Part C [Each 4 marks]
1) What are working of Hierarchical Model?
A) Like a tree structure
b) As like model
C) DATA IS ORGINZED INTO A TREE-LIKE STRUCTURE
d) None of these
2) What are working of Networked Model?
A) DATA IS ORGANIED INTO RECORD AND SETS
B) Record and field
C) None of these
3) What is relational model
A) Set of rule
B) Border gate protocol
C) A RELATION IS A TABLE WITH COLOUMNS AND ROWS
D) None of these
4) What is the Objects Database Models
a) IS TYPE OF DATABASE MODEL ITS CAN BE USED IN OBJECT TYPE
b) Is type database?
c) Object type database
D) All of these
5) What is indexing?
a) INDEXING IS TYPE OF SEQUENCE TO INCREASE THE SPEED OF RETRIVEING DATA
b) Type of database
c) Sorted by order
d) None of these
6) What is replication?
a) Its used to database
b) It is database item
c) REPLICATION OF DATABASE IS COLSELY RELATED TO TRANSACTIONS
D) All of these
7) What is the query optimizer?
A) Query processing
B) Query processing tools
c) QUERY OPTIMIZER IS THE COMPONENT OF A DATABASE MANAGEMENT STSTEM
D) All of these
8) What is query plan?
a) Its query processing
B) QUERY PLAN IS ASET OF SETPS USED TO ACCESS INFORMATION IN A SQL.
c) Both a &b
D) All of these
9) What is parallel-join?
a) Computer Process
B) SPLIT THE PAIRS TO BE TESTED OVER SEVERAL PROCESSORS.
c) Processed to system
d) None of these
10) What database Tuning?
a) Class info
b) Tunneling of the data
C) PERFORMANCE IS THE WAY A COMPUTER SYSTEM BEHAVES GIVEN A PARTICULAR WORK LOAD.
d) None of these
11) What is QSL?
A) SQL IS A FLEXIABLE HIGH-LEVEL LANGUAGE.
B) It is used by oracle
C) Low level-language
D) All of these
12) What is query processing?
A) It is database item
B) It is processing of data
C) IT IS PROCESSING AN SQL QUERY FROM THE DATABASE
d) None of these
13) What are views?
A) It is showing item
B) It manipulated the data
C) VIEW IS DATABASE OBJECT IT CAN BE CREATED BY USERS
D) All of these
.
14) What are stands of MIRS?
A) Retrieval system
B) MULTIPLE MEDIA INFORMATION RETRIEVAL SYSTEM
c) Software
d) None
15) What is Methodology?
a) THE GOAL OF DATA MODELING PROCESS IS TO CONVERT INFORMATION.
B) This is method of processing
c) Processing of data
D) None of these
16) SSM Stands for?
A) STRUCTURE SEMANTIC DATA MODEL
b) Storing system model
c) Storing management system
d) None of these
17) What is Associative?
A) RELATION CONNECT TWO OR MORE INDEPENDENT ENTITY TYPES
b) Its define of rule
C) Its a class define
D) All of these
18) What is classification?
A) SPECIFY A SPECIALIZATION/GENERALIZATION
b) Remote access classification
c) Both
d) None of these
19) What’s role of cardinality specification
A) ITS ASSIGNED FOR EACH CLASSIFICATION AND ASSOCITIVE RELATION SHIP
b) Assigned to valued
c) Fully qualified remain
D) All of these
20) What is metadata?
a) It message scheme
b) Its message scheme compression
C) THE TERM SCHEME CATLOG AND DTATA SHARING AND INFORMATION RETRIVAL ON THE WEB.
D) All of the above
21) What is Semantic Metadata?
a) The text data and multimedia
b) The data store is keywords
C) THESE DATA ARE STORED IN INDEXES, MAKING THE INDEXES.
D) All of the above
23) MPGE is stand for
a) Move picture expert graphics
b) Motion picture expert graphics
C) MOVING PICTURE EXPERT GROUP
D) None of the above
24) What is text-Document?
a) The structure of data
b) TEXT DOCUMENT CAN BE CONSIDERED SEMI-STRUCTURE OF THE PARAGRAPH
c) The application windows is used for server
D) None of the above
25) What is the feature of SQL3
a) IN DBMS THAT SUPPORTSQL3 ARE CALLED OBJECT-RELATION OR ORDBMS.
b) Data manage system
c) This is new query based
d) None of these
26) What is Query optimization?
a) Query transfer to one to other system
b) Time reform optimization
c) IN DATABASE APPROCH TO QUERY OPTIMIZATION IS TO TRANSFER THE QUERY TO AN EXECUTION TREE,
d) None of these
27) What is Synonym Management?
A) File to file connection
b) Message to message connection
c) IN CREATION OF MEDIA DATABASETHE COLLECTION MANAGER
d) None of these
28) What is type System?
A) TYPE STYEM CONSISTING OF A AGGREGATE TYPE: RELATION
b) Mail to mail transfer
c) Transfer data between two ends
d) None of these
29) Used of Encapsulation in DBMS?
A) ENCAPULASTION OF METHODS WITH THE DATA THAT THEY OPERATE ON IN OODBMS.
b) Transmission protocol
c) Control protocol
d) None of these
30) What is DB Components??
a) A DATA IS DEFINED AS A LOGICALLY COHERENT COLLECTION OF RELETED DATA.
b) Simple Database item
c) Simple component of database
a) None of these
31) How dose DB Design work
a) A NECESSARY FIRST STEP IN DESIGNNING DATABASE IS TO DATABASE IS TO INFORMATION ABOUT IN APPLICATION.
b) Data base design concept.
c) Both a &b
d) None of these
32) What’s worked on SCHEME ARCHITECTURE?
a) It is collection table
b) SCHEME CONENT A STRUCTURE OF DATABSE
c) It database collection
D) All of these
33) What is Data Warehouse?
A) Internet manage application protocol
b) DATE WAREHOUSE IS THE REPOSITRY OF HISTORICAL DATA.
c) Both a & b
d) None of these
34) Stands for OLTP?
A) ON-LINE TRANSCTION PROTOOL
B) Send to data from one networked to another
c) Send mail to another mail
d) None of these
35) Stands for OLAP?
A) ON-LINE ANALYTICLA PROCESSING
b) It is protocol
c) The tool/bar will be visible when deleted
d) None of these
36) What is Data mining?
A) ITS A SEARCHING METHOD OF DATA WARE HOUSE
b) Simple Serching method
c) Both A & b
d) None of these
37) What does worked in data dredging?
a) DATA DREDGING IS THE SCANNING OF THE DATA FOR ANY RELATIONSHIPS
b) When data stored on the system
c) When data stored on the system drive
d) None of these
38) Classification is?
A) DATA MINING REQUIRES THE USER TO DEFINE ONE OR MORE CLASS.
b) Internet group message control
c) Internet group management
d) None of these
39) Associations are?
A) ASSOCIATION OF ITEMS AND A SET OF RECORD
b) Address resource plan
c) Address reach plan
D) All of these
40) Clustering what does worked?
A) CLUSTERING IS SET OF OBJECTS GROUPED OF OBJ.
b) Dynamic host coning.
c) Dynamic control host processing
e) None of these
=========== 2 MARKS QUESTION===================
41) Segmentation is?
a) SEGMENTATION IS THE PROCESS OF CREATING PARTINION.
B) Gateway protocol
c) Both of above
d) None of these
42) Decision tree worked for?
a) DECISION TREES ARE SIMPLE KNOWLEDGE REPRESTATION.
b) Interior group protocol
c) Internet group protocol
D) All of these
43) Neural networks are?
a)NEURAL NETWORKED ARE AN APPROACH THAT STRUCTURE OF DATA
B) Serialization
c) Both a&b
d) None of these
44) What is fuzzy in database?
a) Internet protocol address
b) IT IS SET OF DATA BASE OBJECTS
C) Internet host protocol
d) Both have A & b
45) What is role SERVER?
a) User datagram protocol
b) Transmission control protocol
C) SERVER IS THE SOFTWARE MANAGING A DATABSE.
d) Check box
46) What is role of client?
A) Congestion control
b) CLIENT IS AN APPLICATION THAT REQUEST INFORMATION FROM SERVER.
c) Data transport from one to another
D) All of these
47) What are nodes?
A) Delivery host-to-host
b) Higher-level protocol
c) A NODE IS DISRIBUTED DATABASE SYSTEM CAN BE A CLIENT A SERVER, OR BOTH
D) All of these
48) What is site Autonomy?
a) SITE AUTONOMY MEANS THAT DISTRIBUTED DATABASE.
b) Its a protocol
c) Its communication protocol
D) All of these
49) What is Scheme?
a) SCHEME IS COLLECTION OF DIFF.TYPE OF OBJECT
b) Internet assembly networked assign
c) Both of these
D) All of these
50) What is database link?
a) Store of database
b) Link between two tables
c) A DATABASE LINK DEFINES A “PATH” TO A REMOTE DATABASE
D) all of these
51) What is remote Query?
A) REOMTE QUERY IS SELECTION ONE OR MORE REMOTE TABLES
b) Internet reaches task force
c) Internet research tragedy force
D) all of these
52) What is remote update?
A) REOMTE UPDATE IS ONE OR MORE REMOTE TABLES B) B) Internet engine task force
c) Both a & b
D) None of these
53) What is remote transaction?
A) REMOTE TRANSACTION IS A TRANSACTION IS ONE OR MORE STATMENTS
b) Loose resource and record route
c) Both a & b
d) None of these
54) What is distributed transaction?
A) REMOTE TRANSACTION IS A TRANSACTION IS ONE OR MORE STATEMENTS IS INDIVISUALY
b) Asia performance networked internet center
c) Asia perforce networked central
D) all of these
55) What is data replication?
A) REPLICATION IS PROCESS OF COPYING AND MAINTAIN DATABASE
b) Send a data from client to server
c) Send data from server
D) None of these
56) What is availability?
a) REPLICATION PROVIDED FAST AND LOCAL ACCESS
b) Data transfer in both directions
c) Both a & b
D) None of these
57) What is materialized view?
A) A MATERIALIZED VIEW IS A COMPLETE OR PARTIAL COPY OF TARGET TABLE
b) Send data from server
c) Send data from client
D) None of these
58) What are replication objects?
a) A RELPICTION OBJECTS IS A DATABASE EXITING ON MULTIPLE SERVERS
B) Uniform resource location
C) Uniform resource locators
d)all of these
59) What are replication group?
a) ORACLE MANAGE REPLICATION OBJECTS USING REPLICATION GROUP
b) Internet corporate networked
c) Internet corporation numbers
d) none of these
60) What is replication SITE?
A) EXTING A MULTIPLE REPLICATION SITES
b) Top-level names called names
c) Both a & b
d) None of these
============4 MARKS QUESTION==============
61) What is refresh group?
a) Specify the variable type as networked
B) Specify the networked
c) Domain name system
D) MATERIALIZED VEW IS USED THIS GROUP
62) Who can refresh group of materialized view?
A) Fast refresh
b) Complete refresh