DBW Final
Which statement is not correct to derive relations from superclass/subclass relationship?
... optimal and disjoint: Many relations will be created, one relation ....
Choose the correct statement about distributed database concept
A logically interrelated collection of shared data, physically distributed over a network
Hash collisions need
A mechanism to find the keys/ records with the same hash value (like chaining)
Why does consistent hashing *using a hash ring like [0...2^128-1] support availability?
A new node may be easily inserted because of the large spectrum [0...2^128-1] of addresses
If the isolation level is Repeatable Read
A phantom record may occur (e.g. after insertion)
Choose the incorrect statement
A relation that contains one or more repeating groups is in 1NF
Choose the most correct statement
A relation that contains one or more repeating groups is in UNF
QN=113 Hashing algorithm converts a primary key value into a record address.
Aa. False
QN=122 Adding null columns to a table is straightforward.
Aa. Tru |
QN=183 The semijoin approach saves network traffic.
Aa. True
QN=248 A candidate key must uniquely identify each row.
Aa. True
Which one is not overhead involved in maintenance and use of secondary indexes
Adding an index record to every ...
Which one is not overhead involved in maintenance and use of secondary indexes?
Adding an index record to every secondary index whenever tuple is retrieved
Which one is not a problem associated with data redundancy
Alter anomalies
Which on is not basic concept of the Entity Relationship (ER) model
Attribute type
Which one is not basic concept of the Entity Relationship (ER) model?
Attribute type
Which of the following is not a component of the warehouse in a data warehouse system?
Backup manager
The requirement of the data warehouse DBMS are all of the following, excepts
Basic query function
QN=114 The data model produced from the reverse engineering process does not include intersection table data.
Bb. Fals
QN=146 Joining is the process of partitioning data according to predefined criteria.
Bb. False
QN=240 A primary key may be null.
Bb. False
QN=98 The NOT EXISTS keyword will be true if:
Bb. all rows in the subquery fail the condition
Which statement is not correct
Cardinality detemines whether all or only some entity occurences participate in a relationship
QN=17 If attributes A and B determine attribute C, then it is also true that:
Cc. (A,B) is a composite determinant
QN=62 Which of the following is NOT a type of SQL constraint?
Cc. ALTERNATE KE
QN=187 A semijoin is which of the following?
Cc. Only the joining attributes are sent from one site to another and then only the required rows are returned
QN=199 SQL is:
Cc. a data sublanguage
which one is a problem of the ER models
Chasm trap
Which one is not a step in conceptual database design phase
Check model to add controlled redundancy
Which statement is incorrect regards to the transaction
Commited transaction can be aborted
Which statement is incorrect regards to the transaction?
Committed transaction can be aborted
Q14 Which one is not a transformation rule for relation algebra operations to construct the query tree when doing query processing
Commutativity of projection and intersection
Which one is not a transformation rule for relation algebra operations to construct the query tree when doing query processing?
Commutativity of projection and intersection
What is not requirement of the data warehouse DBMS?
Concurrency control
Which one is not benefit of the database replication
Connected computing
What does lazy replication mean?
Copies are updated at some time in the future
What are bitmap indexes are often used for?
Counting
Which one is not a problem associated with data redundancy
Create anomalies
What is not main problem of data warehouse?
Data heterogenization
The neutral clustering technique can be use for which of the following data mining operations
Data segmentation
QN=97 Using SQL Server 2000, which of the following symbols is used to indicate parameters in stored procedures?
Dd.
QN=165 A heterogeneous distributed database is which of the following?
Dd. A different DBMS is used at each location and data are distributed across all nodes
QN=102 Which of the three possible types of triggers does SQL Server support?
Dd. INSTEAD OF and AFTER onl
QN=67 What is not an advantage of stored procedures?
Dd. Increased network traffi
Which one is not an additional semantic modelling concept in Enhanced Entity-Relationship (EER) model?
Decomposition
Which one is not a step in logical database design phase?
Derive relationships for logical data model
Which one is a type of fragmentation?
Derived Horizontal
Q6 Which one is not a type of fragmentation
Derived Vertical
Which constraints used in specialization and generalization, choose two answers?
Disjoint + Participation
Q2 Which one is not benefit of storing methods in database in an object-oriented database system
Easy to implement
Which one is not benefit of storing methods in database in an object-oriented database system?
Easy to implement
Database logs
Ensure recovery after failure
Which one is not basic concept of the Entity Relationship (ER) model?
Entity
Which of the following is one phase in Cross Industry Standard Process for Data Mining (CRISP-DM) Model
Evaluation
Q8 Which one is not a characteristic of the information extracting from database by using data mining tools
Expected
The followings are characteristics of the information extracting from database by using data mining tools, excepts
Explicitly presented
The followings are characteristics of the information extracting from database by using data mining tools, excepts
Explicity presented
Q23 Which one is not an alternative strategy for developing an OODBMS
Extending a relational DBMS with object-oriented capabilities
Which one is not an alternative strategy for developing an OODBMS?
Extending an existing object-oriented programming language with database capabilities
WHich one is a problem of the ER models
Fan trap
The advantage of hashing is
Fast computation of hash values from a key
Which one is not a DBMS transaction subsystem?
File manager
A secondary index may be used
For evaluation of a foreign key relationship
Which one is advantage of ORDBMSs compare to OODBMSs?
Gives rise to increased productivity both for developer and end-user
Which of the following is not a characteristic of the data warehouse system compares to OLTP system?
Hold the summarised data
What is the main difference between ISAM and B+-tree indexes?
ISAM has a fixed number of index levels
Which statement is incorrect regards to the two-phase locking (2PL)?
If every transaction in a schedule follows 2PL, schedule is serializable
Which statement is correct regards to the ordering of read/writes in the serializability of the transactions?
If on transaction writes a data item and another reads or writes same data item, order of execution is important
Which statement is not correct regards to the ordering of read/writes in the serializability of the transactions?
If one transaction reads a data item and another reads or writes same data item, order of execution is not important
Which statement is incorrect regards to serializability of the transactions?
If precedence graph contains cycle then schedule is conflict serializable
Which statement is incorrect regards to the serializabity of the transactions?
If precedence graph contains cycle then...
Which statement is not correct to derive relations from superclass/subclass relationship?
If the participation and disjoint constraints are optimal and disjoint: Many relations will be created, one relation for each combined superclass/subclass
Which one is not basic rule of locking?
If transaction has shared lock on item, can both read and update item
Which one is not a basic rule of locking?
If transaction has shared lock on item, can...
Which one is not a transformation rule for relation algebra operations to construct the query tree when doing query processing?
In a sequence of projection operations, only the middle in the sequence is required
Database replication typically
Increases availability
In the interaction between a database and a program a result set
Is fetched record by record from the DBS
Which constraint does not exist in specialization and generalization?
Joint
Q7 Which of the following is not main operation of the data mining
Link segmentation
Which of the following is not main operation of the data mining?
Link segmentation
Suppose locking is used for synchronization of transactions. A lost update may occur if
Locks are set before accessing/ updating an object and released immediately after.
Which one is an important property of the decomposition?
Lossless-join property
The primary Copy (Master copy) server for replication
May be be substituted by a copy in case of a crash by a voting protocol
Which DBMS does not exist in Stonebraker's View
Mobile DBMS
The advantage of the distributed DBMS is?
Modular growth
All of the followings are most common mechanisms for conflict detection and resolution, excepts
Most frequently update
All of the followings are type of attribute excepts
Multi attribute
All of the followings are type of relationship excepts
Multi-sides
All of the followings are type of relationships, excepts
Multi-sides
Which one is not collection type in SQL 2003
Multiarray
Choose the incorrect statement about User-Defined Routines (UDRs)
Must be defined as part of a UDT
Choose the incorrect statement about User-Defined Routines (UDRs)?
Must be defined as part of a UDT
What does the "WAL" mean?
Never write into the database before a log record has been written
Q15 Which of the following is not a property of the data in a data warehouse
Non-summarized
All of the followings are query processing phases, excepts
Normalization
Q9 All of the followings are query processing phases, excepts
Normalization
Which one is not key issue in distributed database design?
Normalization
Which one is not typical stage of the query decomposition phase when doing query processing?
Normalization analysis
Suppose in a relational schema for a library we have a table "Books" and the row of a book contains attributes of the student who lend the book, (E.G. Books(bNo, title, ..., studentNo, studentName, Tel, ...) What is wrong with the design?
Not in 3rd normal form
Which statement is incorrect
One relation can have both clustering index and primary index
Which statement is incorrect?
One relation can have both clustering index and primary index
A deadlock my be solved
Only if the DBS aborts one of the involved transactions
Which one is not category of constraints of specialization and generalization?
Optional and joint
Which statement is not correct to derive relations from 1:1 binary relationship
Optional participation on both sides of a 1:1 relationship: Must decide the parent and child entities
which statement is not correct to derive relations from 1:1 binary relationship
Optional participation on both sides of a 1:1 relationship: Must decide the parent and child entities
Which is the correct sequence of query processing steps
Parsing - query rewrite - optimization - code generation - execution
Which statement is not correct
Participation describes maximum number of possible relationship occurences for an entity participating in a given relationship type
Which statement is not correct?
Participation describes maximum number of possible relationship occurrences for an entity participating in a given relationship type
Which one is not problem of the ER models?
Pathway trap
Which one is a main databae design phase
Physical design
Which one is not a phase of optimistic concurrency control techniques?
Prevention
Q12 The advantage of the distributed DBMS is
Reflects organizational structure
Which one is not a type of transaction in IBM's Distributed Relational Database Architecture (DRDA)
Remote all of work
Which one is not a type of transaction in IBM's Distributed Relational Database Architecture (DRDA)?
Remote all of work
Q4 Which one is advantage of ORDBMSs
Reuse and sharing
Which one is not a kind of key in a relation?
Secondary key
As OODMBS Manifesto which one of the followings is not be supported?
Security
What can a correctly defined trigger not be used for?
Sending an email after a deletion of a row of some table occurred
All of the following are rules to construct the query tree when doing query processing, excepts
Sequence is directed from root to leaves
Which one is disadvantage of ORDBMSs?
Simplicity of SQL
Which of the following is NOT part of the disk access time?
Surface torsion time
Stored procedures have the advantage
That they can use iterative statements
Which statement is correct
The RD is more complex than the ERD causes of the RD contains some foreign keys that associate some relations
Which statement is correct?
The RD is more complex than the ERD causes of the RD contains some foreign keys that associate some relations
Which statement is incorrect regards to the transaction
The consistency must not be violated during transaction
Which statement is incorrect regards to the transaction?
The consistency must not be violated during transaction
Which parameter is not relevant for calculating the height of a B+-tree index?
The data type of the attributes of the records which are not keys
The following are reasons for creating a data mart, expects
The future users of a data mart are hardly defined and targeted to botain support for a data mart than an enterprise-wide data warehouse project
Which statement is not correct to derive relations from 1:1 binary relationship?
The participation constraints are used to decide whether it is best to represent the relationship by combining the entities involved into one relation or by creating two relations
The coordinator of a distrubuted transaction crashes after sending the decision (commit/abort) to the resource managers and after having received one of the acknowledgements from the resource managers (more than one). What will happen?
The resource managers which did not get the decision are blocked
Which of the following is a property of the data in a data warehouse?
Time-variant
Which one is not a technique for handling deadlock?
Timestamping
Which statement is correct with regard to transactions?
Transaction is a logical unit of work on the database
Which statement is incorrect regards to the database recovery?
Transaction manager responsible for atomicity and durability
Which one is not a kind of functional dependency (FD)?
Trivial FD
Which statement is correct regards to the deadlock
Two-phase locking (2PL) eliminates the deadlock
Which statement is correct regards to the deadlock?
Two-phase locking (2PL) eliminates the deadlock
Which statement is incorrect with regards to the deadlock?
Two-phase locking (2PL) eliminates the deadlock
Which of the following is not a characteristic of the OLTP system compares to data warehouse system?
Unpredictable reporting
Which one is not main type of data ownership in database replication?
Update-anywhere
Which one is not an element of a database ER model
Verification
Choose the correct statement?
Vertical fragmentation defined using projection operation of relational algebra
Which statement is incorrect regards to the serializability of the transactions
View serializable shedule may contain one or more blind writes
Q24 As OODBMS Manifesto which one of the followings is not be supported
Views
Which of the following is not a property of the data in a data warehouse?
Volatile
When does a transaction T using snapshot isolation (MVCC) read a version which was committed after the begin but before the end of T?
When no other transaction has written x and committed during the lifetime of T
..... table contains the values we want to analyze. a. Dimension b. Fact c. Aggregate d. Center
a
........ focus is on how managers view the business. a. Data warehouse b. OLTP c. Business system d. OLAP
a
......... reveals business trends. a. Data warehouse b. OLTP c. Business system d. OLAP
a
........... acts as the glue that connects all parts of the data warehouse. a. Metadata b. ETL c. Operational Metadata d. Extraction and Transformation Metadata
a
SSAS (SQL Server Analysis Services) is Microsoft BI Tool for creating Online Analytical Processing and data mining functionality. a. True b. False
a
Which is the traditional data warehouse project life cycle? a. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment 6)Growth and maintenance b. 1)Requirements definition 2)Project plan 3)Design 4)Construction 5)Deployment 6)Growth and maintenance c. 1)Project plan 2)Requirements definition 3)Design 4)Construction 5)Deployment d. None of the others
a
Which of the following is NOT a life-cycle methods of an Activity? Select one: a. onInit b. onCreate c. onRestart d. onResume
a
choose the most correct statement
a relation that contains one or more repeating group is in UNF
QN=55 The normal form that is not necessarily dependency preserving is
aa. 2NF
QN=79 What will be the number of columns and rows respectively obtained for the operation, A - B, if A B are Base union compatible and all the rows of a are common to B? Assume A has 4 columns and 10 rows; and B has 4 columns and 15 rows
aa. 4,0
QN=86 If ??? holds then so does
aa. ????
choose the incorrect statement about distributed database concept
all DBMS together participates in at least one global application
Which one is not an additional sementic modeling concept in Enhanced Entity-Relationship (EER) model
application
Which one is not a transformation rule for relation algebra operations to construct the query tree when doing query processing
associativity of union and set difference
which one is not basic concept of the entity relationship (ER) model
attribute type
............. indicator of high-quality data ensures the data value of an attribute falls in the range of allowable, defined values. a. Accuracy b. Domain Integrity c. Data Type d. Consistency
b
............. indicator of high-quality data ensures the value stored in the system for a data element is the right value for that occurrence of the data element. a. Domain Integrity b. Accuracy c. Data Type d. Consistency
b
...............represents the level of detail in the fact table. a. Aggregation b. Data granularity c. Data level d. Data size
b
............systems focus on individual events. a. Data warehouse b. OLTP c. Business system d. OLAP
b
A fact is a measure taken at the .............of all the dimensions. a. union b. intersection c. combination d. cross
b
ACCESSIBLE characteristic of strategic information means: a.Every business factor must have one and only one value. b.Easily accessible with intuitive access paths, and responsive for analysis. c.Information must be accurate and must conform to business rules. d.Must have a single, enterprise-wide view.
b
Activity results handled by the onActivityResult() method are differentiated from one another using which parameter? Select one: a. Data b. Result Code c. Both result code and request code d. Request Code
b
Although most people's first thought when they think of Android is Google, Android is not actually owned by Google. Who owns the Android platform? Select one: a. Dalvik b. Open Handset Alliance c. The above statement is incorrect and Android is owned by Google d. Oracle Technology
b
QN=2 Which of the following is not a property of transactions?
bb. Concurrence
QN=15 What are the desirable properties of a decomposition?
bb. Dependency preservation
QN=95 Which is the best file organization when data is frequently added or deleted from a file?
bb. Direct
QN=53 In multiple granularity of locks SIX lock is compatible with
bb. IS
QN=73 Which of the following addressing modes permits relocation without any change over in the code?
bb. Indexed addressing
A table may contain some ............. indexes. Select one answer only. a. bitmap b. clustered c. non-clustered, bitmap d. non-clustered
c
QN=78 If both the functional dependencies : X?Y and Y?X hold for two attributes X and Y then the relationship between X and Y is
cc. 1:1
Which statement is incorrect regards to the transaction
commited transaction cannot be aborted
Which one is not a transformation rule for relation algebra operations to constrcut the query tree when doing query processing
commutavity of union and set difference
all of the followings are query processing phases, excepts
compilation
Which one is strong point of RDBMS compares to OODBMS
computational completeness
QN=11 According to the levels of abstraction, the schema at the intermediate level is called
conceptual schema
When is the onStop() method invoked? Select one: a. When an activity process is killed or completed terminated b. When an activity is at foreground c. When an activity is at the background and still visible d. When an activity is no longer visible to the user
d
Which are the optimization strategies in data warehouse system? (choose ONE answer only) a. Use Index b. Aggregate Table c. Query Optimization d. All the other choices
d
QN=108 Which of the following are integrity controls that a DBMS may support?
dd. All of the above
QN=23 As per equivalence rules for query transformation, selection operation distributes over
dd. All of the above
QN=46 Which of the following is a reason to model data?
dd. All of the above
Source data in data warehouse may come from: (choose one answer only) a. Production Data b. Internal Data c. Archived Data d. External Data e. All the others
e
Which is NOT a characteristic of a data warehouse? a. Separate b. Integrated c. Time stamped d. Subject oriented e. Volatile
e
Which is NOT a key issue while planning for your data warehouse? a. setting proper expectations b. assessing risks c. deciding between top-down or bottom-up approaches d. Choosing from vendor solutions. e. requirement changes
e
Which one is not benefit of storing methods in database in an object-oriented database system
easy to implement
which one is not weakness of RDBMS compares to OODBMS
experience and standards
Which of the following tolls is not one used to access data warehouse
extracting tool
The operational system is an information system that: a. Provides an integrated and total view of the enterprise. b. Makes the enterprise's current and historical information easily available for strategic decision making. c. Makes decision-support transactions possible without hindering operational systems. d. Renders the organization's information consistent. e. Presents a flexible and interactive source of strategic information. f. Support the basic business processes of the company.
f
All of the followings are most common mechanisms for conflict detection and resolution, excepts
hold for manual resolution
Choose the correct statement
horizontal fragmentation defined using projection operation of relational algebra
Which one is not an issue of the recovery from deadlock detection?
how to build Wait-For-Graph (WFG)
which statement is correct regards to the ordering of read/writes in the serializability of the transactions
if one transaction writes a data item and another reads or writes same data item, order of execution is important
Which statement is note correct to derive relation form superclass/subclass relationship
if the participation and disjoint constraints are optimal and disjoint: Many relations will be created, one relation for superclass and one for each subclass
Which one is not property of the transaction
insolation
Which constraints do not exist in specialization and generalization, choose two answers?
joint+unparticipation
which statement is correct regards to the two-phase locking (2PL)
leaving the release of all locks until end of transaction can prevent some problems
which one is not purpose of the normalization
minimal number of the relations access times
All of the followings are type of attribute excepts
multi attribute
Choose the incorrect statement about functionality of a DDBMS compares to a conveniontal DBMS
needs the least functionality of a conventional dbms only
May transactions using optimistic concurrency control (BOCC) be involved in a deadlock?
never
All of the followings are query processing phases, excepts
normalization
Which one is not category of constraints of specialization and generalization
optional and joint
which one is not category of constraints of specialization and generalization
optional and joint
Which one is not a phase of optimistic concurrency control techniques
prevetion
Which one is not typical stage of the query decomposition phase when doing query processing
query constructing
Which one is not implementation issue of database replication
query execution
which one is not implementation issue of databse replication
query execution
which one is not transparency in a DDBMS
query processing transparency
Suppose strict 2PL is used for the sequence of operations received by the scheduler r1(x) r2(x) r2(y) w2(x) r1(y) w1(y). What is the effective sequence of operations executed?
r1(x) r2(x) r2(y) r1(y) - deadlock
Which one is not a basic rules of locking
reads can conflict,...
Which of the following is not main operation of the data mining
repeat detection
Which one is not an example of potential problems caused by concurrency
repeatable read
All of the following are rules to construct the query tree when doing query processing, excepts
sequence is directed from root to leaves
What is not main architecture of parallel DBMS
share processor
Which one is not a step in logical database design phase
split logical data models into global model
Choose the incorrect statement about heterogeneous distributed DBMS
the intergration of the sites must be considered first
Which of the following is a property of the data in a data warehouse
time-variant
Which one is not main type of data ownership in database replication
update-anytime
What is the minimal number of tables used to represent a specialization of an entity set E with two specializations S1 and S2
1
Distributed processing is
A centralized database that can be accessed over a computer network
Q19 Choose the correct statement about distributed database concept
A logically interrelated collection of shared data, physically distributed over a network
QN=60 The SQL statement to create a view is:
Aa. CREATE VIEW
QN=174 SQL data definition commands make up a(n) ________ .
Aa. DDL |
QN=80 Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?
Aa. Nonrepeatable rea
QN=116 A secondary key is which of the following?
Aa. Nonunique key
QN=152 All primary keys are required.
Aa. Tru |
QN=130 An extent is a contiguous section of disk storage space.
Aa. True
QN=137 Successful data warehousing requires that a formal program in total quality management (TQM) be implemented.
Aa. True
QN=16 All instances of an entity class have the same attributes.
Aa. True
QN=33 Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.
Aa. True
QN=70 The SQL ALTER statement can be used to:
Aa. change the table structure
Row is synonymous with the term:
Aa. record
QN=35 A homogenous distributed database is which of the following?
Bb. The same DBMS is used at each location and data are distributed across all nodes
QN=133 Which of the following columns is(are) are required in a table?
Cc. A primary ke |
QN=101 What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?
Cc. ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0)
QN=87 What SQL command can be used to delete columns from a table?
Cc. ALTER TABLE TableName DROP COLUMN ColumnName
QN=224 A foreign key is which of the following?
Cc. An attribute that serves as the primary key of another relation
QN=41 A semijoin is which of the following?
Cc. Only the joining attributes are sent from one site to another and then only the required rows are returned
QN=135 A data warehouse is which of the following?
Cc. Organized around important subject areas
QN=195 The keyword "inverse" is used in which of the following?
Cc. Relationship
Which one is not main benefit of the database replication?
Connected computing
Which one is a problem of the ER model?
Connection trap
QN=16 A relation in this form is free of all modification anomalies.
Dd. Domain/key normal for
Which one is not a step in conceptual database design phase?
Identify entity domains (types).
Q13 Which one is not typical stage of the query decomposition phase when doing query processing
Query constructing
The following histtory is executed in this order (without synchronization). r2(x) r1(y) w2(x) r1(x) c1 a2 (a2 means abort of TA2) This results in a
Read uncommitted
Why is traversal of a non-clustered (B+-tree) index - leaf pages contain pointers to heap storage - expensive?
Records may be distrubuted over the persistent storage, needs block access for each key
Which dimension does a data warehouse usually have? a. Time b. Category c. User d. Invoice
a
Data warehouse architecture is just an overall guideline. It is not a blueprint for the data warehouse. a. True b. False
b
QN=39 Which of the following aggregate functions does not ignore nulls in its results?.
bb. COUNT (*)
QN=9 The clause in SQL that specifies that the query result should be sorted in ascending or descending order based on the values of one or more columns is
bb. Order b
Where will you declare your activity so the system can access it? Select one: a. In the style xml file b. In the layout xml file c. In the manifest xml file d. In the string xml file
c
Which operation involves summarizing the data along a dimension? a. Dice b. Slice c. Roll-up d. Drill Down
c
QN=37 In an E-R, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect
cc. Operationally, if X is deleted, so is Y
............ may answer questions on overall process. a. OLTP b. OLAP c. Business Intelligence d. Data warehouse
d
What is NOT a Benefit of Improved Data Quality? a. Improved Productivity b. Reduced Costs and Risks c. Reliable Strategic Decision Making d. None of these.
d
QN=42 Maximum height of a B+ tree of order m with n key values is
dd. None of these
QN=107 Which of the following improves a query's processing time?
dd. Use compatible data types
QN=90 The clause alter table in SQL can be used to
dd. all of the above
QN=88 Wait-for graph is used for
dd. deadlock detection
Choose the incorrect statement?
OODBMSs (Object-Oriented DBMSs) are suited to advanced database applications
Choose the incorrect statement?
OODBMSs (Object-Oriented DBMSs) are suited to advanced database applications.
Choose the correct statement
ORDBMSs (Object Relational DBMSs) are RDBMSs with some OO features being added
Q5 Choose the correct statement
ORDBMSs (Object Relational DBMSs) are RDBMSs with some OO features being added
Which statement is incorrect regards to timestamping?
Older transactions, transactions with bigger timestamps, get priority in the event of conflict
Choose the correct statement regards database replication?
One site can be both the master site and slave site for same replication group
Q17 Choose the incorrect statement regards database replication
One site cannot be both master site for one replication group and slave site for different replication group
Choose the correct statement regards database replication
One site cannot be both the master site and slave site for same replication group
Which kind of relationship between entities does not necessarily need a separate table when represented in the relational model?
One-to-one
Q22 Which one is not a good heuristic rule that could be applied during query processing
Perform Selection operations as lately as possible
Which one is not a good heuristic rule that could be applied during query processing
Perform Selection operations as lately as possible
Which one is not an example of potential problems caused by concurrency?
Phantom read
The classification technique can be use for which of the following data mining operations?
Predictive modeling
Which of the following is main operation of the data mining?
Predictive modeling
Q25 Which of the following is not a reason for creating a data mart
Provide data in a form that matches the whole view of the data by many business application areas
Which one is not an alternative strategy for developing an OODBMS
Provide extensible object-oriented DBMS libraries to an existing object-oriented programming language
Which one is not transparency in a DDBMS?
Query Processing Transparency
Why are B+trees used in database systems instead of e. g. hash maps?
Records may be traversed in key sequence
Which one is not purpose of the normalization?
Records with a close logical relationship are found in the same relation
Which one is not basic concept of the Entity Relationship(ER) model
Relationship type
Q18 Choose the incorrect statement about homogeneous distributed DBMS
Requires the translations
Q3 What is main architecture of parallel DBMS
Shared nothing
What is not main architecture of parallel DBMS?
Shared processor
Which of the following statements about a bitmap index for attributes of some table R is wrong?
Should only be used if s has a large number of values
All of the followings are type of attribute, excepts
Single Attribute
Which one is not a kind of key in a relation
Single key
Which one is not a kind of key in a relation?
Single key
Concurrent execution of 2 transactions with isolation level "read uncommitted" will
Sometimes results in an inconsistent DB state
Which one is not a transaction state of the transaction?
Success
QN=180 The purpose of timestamping is to avoid the use of locks.
Aa. True
QN=190 Which of the following is not one of the stages in the evolution of distributed DBMS?
Aa. Unit of work
QN=29 Which of the following is NOT an Oracle-supported trigger?
Bb. DURING
QN=150 Periodic data are data that are physically altered once added to the store
Bb. False
QN=245 The primary key in a relation does not need to be underlined.
Bb. False
QN=183 The SQL -92 wildcards are ____ and ____ .
Bb. percent sign (%); underscore (_ |
QN=188
Cc. Each site must have the same storage capacity
QN=191 Which one of the following sorts rows in SQL?
Cc. ORDER B |
QN=139 Which is not true about surrogate keys?
Cc. They have meaning to the user |
QN=14 A key:
Cc. identifies a row
Which one is not benefit of the database replication?
Connected computing
Choose the incorrect statement about distributed database concept
Data at all sites is under control of a DBMS
QN=10 Which of the following are integrity controls that a DBMS may support?
Dd. All of the above
QN=132 The @active data warehouse architecture includes which of the following?
Dd. All of the above
QN=141 A snowflake schema is which of the following types of tables?
Dd. All of the above
QN=160 A multifield transformation does which of the following?
Dd. All of the above
QN=163 A transaction manager is which of the following?
Dd. All of the above
QN=164 Location transparency allows for which of the following?
Dd. All of the above
QN=189 A distributed database can use which of the following strategies?
Dd. All of the above
QN=194 Using ODL, you can define which of the following?
Dd. All of the above
QN=196 The object definition language (ODL) is which of the following?
Dd. All of the above
QN=197 An atomic literal is which of the following?
Dd. All of the above
QN=204 Using OQL, you may do which of the following?
Dd. All of the above
QN=69 Which of the following is an SQL trigger supported by Oracle?
Dd. All of the above
QN=169 Which of the following is the original purpose of SQL?
Dd. All of the above |
QN=186 Which of the following do you need to consider when you make a table in SQL?
Dd. All of the above |
QN=64 For what purposes are views used?
Dd. All of the above are uses for SQL views
QN=194 SQL can be used to:
Dd. All of the above can be done by SQL |
QN=91 Before any changes to database structure are attempted one should first:
Dd. All of the above should be done
QN=131 Which of the following situation requires the use of ID-dependent entities?
Dd. All of the above use ID dependent entitie |
QN=203 A relationship should be specified how in the ODL?
Dd. Both direction
QN=94 What is the overall responsibility of the DBA?
Dd. Both the first and third answers above are correct
QN=96 With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?
Dd. Bulk-logged recover
QN=35 Which of the following is not considered to be a basic element of an enterprise-class database system?
Dd. COBOL program
QN=18 The SQL command to create a table is:
Dd. CREATE TABLE
QN=56 The SQL command to create a table is:
Dd. CREATE TABLE
QN=145 Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
Dd. Data constraint |
QN=3 A relation in this form is free of all modification anomalies
Dd. Domain/key normal form
QN=83 Which of the following refers to a cursor type where changes of any type and from any source are visible?
Dd. Dynami
QN=232 When mapping a ternary relationship with an associative entity into a relation which of the following is true?
Dd. Four relations are created
QN=23 What is not an advantage of stored procedures?
Dd. Increased network traffic
QN=28 Which of the following is not true about indexes?
Dd. Indexes are created with the ALTER TABLE command
QN=40 Which type of entity represents an actual occurrence of an associated generalized entity?
Dd. Instance entit
QN=161 A distributed database has which of the following advantages over a centralized database?
Dd. Modular growth
QN=53 Entities can be associated with one another in which of the following?
Dd. Relationship
QN=190 Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';
Dd. SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA') |
QN=98 What mode of authentication does SQL Server NOT provide?
Dd. SQL Server only securit
Which one is not a step to translate logical data model for target DBMS?
Design indexes
Which statement is not correct about query processing?
Disk access tends not to be dominant cost in query processing for centralized DBMS
Q10 Which DBMS does not exist in Stonebraker's View
Distributed DBMS
Which one of the following sentences is correct when choosing an index?
Do not add secondary index to any attribute or relation that is frequently updated
Which one is not a good heuristic rule that could be applied during query processing?
Perform Selection operations as lately as possible
How will you pass data to sub-activities? Select one: a. Use Bundles b. Use Packages c. Use Blocks d. Use Messages
a
QN=57 The normalization was first proposed by
bb. Codd
Which is NOT a data warehouse building block? a. source data b. data staging c. data schema d. information delivery e. metadata f. management and control.
c
QN=48 The common column is eliminated in
cc. natural join
Which is NOT popular data warehouse architecture? a. Real b. Virtual c. Remote d. Distributed
d
As OODBMS Manifesto which one of the followings is not be supported
recovery
QN=7 Precedence graphs help to find a
Aa. Serializable schedule
QN=150 In a 1:1 relationship, the primary key placement is arbitrary.
Aa. Tru |
QN=220 In ODL, you specify an operation using parentheses after its name
Aa. True
QN=168 A homogenous distributed database is which of the following?
Bb. The same DBMS is used at each location and data are distributed across all nodes
The R.java file is where you edit the resources for your project Select one: a. False b. True
a
QN=94 Dependency preservation is not guaranteed in
aa. BCNF
Data Mining means we want to mining the data? a. YES b. NO
b
Q20 Which of the following is not a characteristic of the OLTP system compares to data warehouse system
. Unpredictable reporting
Suppose Staff entity has generalization/specialization relationship with three entities Manager, SalePersonnel and Secretary. The constraints on this generalization/specialization relationship is {Mandatory, And}. How many relation should be derived from this ERD, choose the most correct answer?
1
What is the estimated cardinality of the following operations on tables T(a,b), S(a,c). T has 100000 rows, 10000 different values in column a, 5000 in column b, table S has 2000 rows, 100 different values in a, 20 in column c: sel (a=10)(T)
10
What is the estimated cardinality of the following operations on tables T(a,b), S(a,c). T has 100000 rows, 10000 different values in column a, 5000 in column b, table S has 2000 rows, 100 different values in a, 20 in column c: (sel (c=1)(T join S)
1000
How many hash collisions occur if the key set {110, 15, 98, 22, 18, 9} is mapped onto a table of length k using the hash function h(k) = k modulo 7 (or h(k) = k%7)
2
Suppose Staff entity has generalization/specialization relationship with three entities Manager, SalePersonnel and Secretary. The constraints on this generalization/specialization relationship is {Optional,And}. How many relation should be derived form this ERD, choose the most correct answer
2
What is the estimated cardinality of the following operations on tables T(a,b), S(a,c). T has 100000 rows, 10000 different values in column a, 5000 in column b, table S has 2000 rows, 100 different values in a, 20 in column c: UNIQUE(proj (c) (S))
20
What is the estimated cardinality of the following operations on tables T(a,b), S(a,c). T has 100000 rows, 10000 different values in column a, 5000 in column b, table S has 2000 rows, 100 different values in a, 20 in column c: S join T
20,000
Given tables R(a,b), S(a,c). What is the estimated cardinality of the following operation assumed table R has 100000 rows, 100000 different values in column a primary keys, 500 in column b, table S has 2000 rows, 500 different values in a, 1000 in column c. proj c (R join S) /* "join" is always natural join, value preservation.
2000
Suppose Staff entity has generalization/specialization relationship with three entities Manager, SalePersonnel and Secretary. The constraints on this generalization/specialization relationship is should be derived from this ERD, choose the most correct answer
3
Suppose Staff entity has generalization/specialization relationship with three entities Manager, SalePersonnel and Secretary. The constraints on this generalization/specialization relationship is {Optional, OR}. how many relation should be derived from this ERD, choose the most correct answer
3
Let R be a table with B(R) blocks on disk. B(R) <= M*(M-1), where M is the number of blocks of main memory which can be used for sorting, aggregation, join operations etc. What is the cost estimated cost of a merge sort in terms of block accesses
3*B(R)
Given tables R(a,b), S(a,c). What is the estimated cardinality of the following operation assumed table R has 100000 rows, 100000 different values in column a primary keys, 500 in column b, table S has 2000 rows, 500 different values in a, 1000 in column c. sel(b=3)(R join S)
4
How many bits are used for a bitmap index of attribute b of a table with 100000 rows, if b has 5 values? The index is uncompressed.
500,000
How many bushy query trees (not deep right or left) are possible for the expression? R join S join T
6
Choose the correct statement
A relation in which the intersection of each row and column contains one and only one value is in 1NF
Choose the correct statement?
A relation in which the intersection of each row and column contains one and only one value is in 1NF
Choose the most correct statement
A relation in which the intersection of each row and column contains one and only one value is in 1NF
QN=1 The DBMS acts as an interface between what two components of an enterprise-class database system?
Aa.
QN=19 If attribute A determines both attributes B and C, then it is also true that:
Aa. A ? B
QN=21 Every time attribute A appears, it is matched with the same value of attribute B, but not the same value of attribute C. Therefore, it is true that:
Aa. A ? B
QN=126 Which of the following data constraints would be used to specify that the value of cells in a column must be one of a specific set of possible values?
Aa. A domain constrain |
QN=144 Data transformation includes which of the following?
Aa. A process to change data from a detailed level to a summary level
QN=37 A distributed database is which of the following?
Aa. A single logical database that is spread to multiple locations and is interconnected by a networ
QN=186 A distributed database is which of the following?
Aa. A single logical database that is spread to multiple locations and is interconnected by a network
QN=171 A view is which of the following?
Aa. A virtual table that can be accessed via SQL command |
QN=193 Identify the class name for the following code: ABC123 course();
Aa. ABC123
QN=182 The HAVING clause does which of the following?
Aa. Acts like a WHERE clause but is used for groups rather than rows |
QN=101 If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
Aa. All fields are stored in one relation
QN=6 If a denormalization situation exists with a one-to-one binary relationship, which of the following is true?
Aa. All fields are stored in one relation
QN=180 Which of the following are the five built-in functions provided by SQL?
Aa. COUNT, SUM, AVG, MAX, MIN |
QN=175 Which of the following is valid SQL for an Index?
Aa. CREATE INDEX ID; |
QN=92 Which of the following modifications may not succeed?
Aa. Changing a column data type from char to dat
QN=170 Storing a separate copy of the database at multiple locations is which of the following?
Aa. Data Replication
QN=159 Transient data is which of the following?
Aa. Data in which changes to existing records cause the previous version of the records to be eliminated
QN=120 A multidimensional database model is used most often in which of the following models?
Aa. Data warehouse
QN=43 Which of the following refers to something that can be identified in the users' work environment, something that the users want to track?
Aa. Entit
QN=115 A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Aa. False
QN=227 If no multivalued attributes exist in a relation, then the relation is in what normal form?
Aa. First normal form
QN=31 Which of the following products implemented the CODASYL DBTG model?
Aa. IDM
QN=100 SQL Server program code that is executed instead of an SQL command that needs to be processed is called a(n):
Aa. INSTEAD OF trigger
QN=6 Which of the following is a group of one or more attributes that uniquely identifies a row?
Aa. Key
QN=176 The SQL keyword(s) ________ is used with wildcards.
Aa. LIKE only |
QN=141 Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Aa. MUST COVE |
QN=42 Which of the following indicates the minimum number of entities that must be involved in a relationship?
Aa. Minimum cardinalit
QN=12 Which of the following indicates the minimum number of entities that must be involved in a relationship?
Aa. Minimum cardinality
QN=128 Which of the following column properties specifies whether or not cells in a column must contain a data value?
Aa. Null statu |
QN=52 In which of the following is a single-entity instance of one type of related to a single-entity instance of another type?
Aa. One-to-One Relationshi
QN=117 The fastest read/write time and most efficient data storage of any disk array type is:
Aa. RAID-0
QN=79 In this instance, dirty reads are disallowed, while nonrepeatable reads and phantom reads are allowed.
Aa. Read committe
QN=185 The benefits of a standard relational language include which of the following?
Aa. Reduced training cost |
QN=195 The SQL statement that queries or reads data from a table is ________ .
Aa. SELEC |
QN=177 Which of the following is the correct order of keywords for SQL SELECT statements?
Aa. SELECT, FROM, WHER |
QN=205 The Object Query Language is which of the following"?
Aa. Similar to SQL and uses a select-from-where structure
QN=27 SQL stands for ________ .
Aa. Structured Query Languag
QN=46 Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Aa. Supertype entit
QN=13 Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Aa. Supertype entity
QN=72 Which is NOT one of the most common types of SQL CHECK constraints?
Aa. System dat
QN=162 An autonomous homogenous environment is which of the following?
Aa. The same DBMS is at each node and each DBMS works independently
QN=42 An autonomous homogenous environment is which of the following?
Aa. The same DBMS is at each node and each DBMS works independently
QN=234 When mapping a supertype/subtype relationship which of the following is true?
Aa. The supertype primary key is assigned to each subtype
QN=198 Which of the following is true concerning an ODBMS?
Aa. They have the ability to store complex data types on the Web
QN=199 The reserved word enum is used for which of the following?
Aa. To define a range for an attribute
QN=133 A goal of data mining includes which of the following?
Aa. To explain some observed event or condition
QN=106 A correlated subquery is processed as a nested subquery.
Aa. Tru
QN=107 A regular subquery is processed from the bottom up.
Aa. Tru
QN=110 Some organizations take the stand that no application should ever employ the true name of a table.
Aa. Tru
QN=111 The use of the double NOT EXISTS can be used to find rows that do not match some specified condition.
Aa. Tru
QN=117 Reverse engineering is the process of reading a database schema and producing a data model from that schema.
Aa. Tru
QN=119 It is not easy to build a database correctly the first time.
Aa. Tru
QN=246 The primary key of the new relation in a many-to-many relationship is a composite key comprised of the primary keys of each of the binary entities.
Aa. Tru
QN=124 Dependency graphs are diagrams that consist of nodes and arcs that show the dependencies of a database.
Aa. Tru |
QN=125 The EXISTS keyword will be true if any row in the subquery meets the condition.
Aa. Tru |
QN=146 A foreign key is used to implement relationships between tables.
Aa. Tru |
QN=147 The terms alternate key and candidate key mean the same thing.
Aa. Tru |
QN=149 When the parent entity is required, cascading updates and cascading deletions should be allowed or the associated actions on the parent should be prohibited.
Aa. Tru |
QN=153 Intersection tables are ID-dependent on both their parent tables.
Aa. Tru |
QN=155 An intersection table is required to represent M:N relationships.
Aa. Tru |
QN=158 When transforming an entity-relationship model into a relational database design, each entity is represented as a table.
Aa. Tru |
QN=160 When the child entity is required, we are restricted from creating a new parent row without also creating a corresponding child row at the same time.
Aa. Tru |
QN=162 When the parent entity is required and the parent has a surrogate key, update actions can be ignored.
Aa. Tru |
QN=163 When the parent entity is required, a new parent row can always be inserted.
Aa. Tru |
QN=164 For every relationship, there are six possible referential integrity actions.
Aa. Tru |
QN=165 An ideal primary key is short, numeric and seldom changing.
Aa. Tru |
QN=111 Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Aa. True
QN=121 Information systems and organizations do not just influence each other; they create each other.
Aa. True
QN=121 When storage space is scarce and physical records cannot span pages, creating multiple physical records from one logical relation will minimize wasted storage space.
Aa. True
QN=122 A field represents each component of a composite attribute.
Aa. True
QN=123 Some advantages of partitioning include: efficiency, security, and load balancing.
Aa. True
QN=136 A data mart is designed to optimize the performance for well-defined and predicable uses.
Aa. True
QN=138 Data in operational systems are typically fragmented and inconsistent.
Aa. True
QN=139 Most operational systems are based on the use of transient data.
Aa. True
QN=140 Independent data marts are often created because an organization focuses on a series of short-term business objectives.
Aa. True
QN=148 Data in the data warehouse are loaded and refreshed from operational systems.
Aa. True
QN=151 Both status data and event data can be stored in a database.
Aa. True
QN=153 Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.
Aa. True
QN=154 Every key used to join the fact table with a dimensional table should be a surrogate key
Aa. True
QN=17 An entity is something that can be identified in the user's work environment; something that the users want to track.
Aa. True
QN=171 With failure transparency, all of the actions of a transaction are committed or none of them are committed
Aa. True
QN=172 Each site (or node) in a distributed system is subject to the same types of failure as in a centralized system.
Aa. True
QN=173 Replication may use either synchronous or asynchronous distributed database technologies, although asynchronous technologies are more typical in a replicated environment.
Aa. True
QN=174 Synchronization for pull replication is less disruptive and occurs only when needed by each site, not when a central master site thinks it is best to update.
Aa. True
QN=177 An increasingly popular option for data distribution as well as for fault tolerance of any database is to store a separate copy of the database at each of two or more sites.
Aa. True
QN=179 A distributed unit of work allows various statements within a unit of work to refer to multiple remote DBMS locations.
Aa. True
QN=181 Data replication is favored where most process requests are read-only and where the data are relatively static
Aa. True
QN=182 The cost to perform a snapshot refresh may depend on whether the snapshot is simple or complex
Aa. True
QN=184 In a semijoin, only the joining attribute is sent from one site to another, and then only the required rows are returned.
Aa. True
QN=185 The problem of concurrency control is more complex in a distributed database.
Aa. True
QN=207 The ODMG Object Model requires that a relationship be specified in both directions
Aa. True
QN=208 Before specifying a key for a class, you must specify its extent.
Aa. True
QN=210 The ODMG Object Model supports only unary and binary relationships
Aa. True
QN=211 Literals do not have identifiers, and, therefore, cannot be individually referenced like objects.
Aa. True
QN=212 An attribute's value is always literal
Aa. True
QN=213 An attribute's value is either a literal or an object identifier
Aa. True
QN=218 Specifying a key ensures that no two objects belonging to a class have the same value for the key attribute(s).
Aa. True
QN=219 If you know all the possible values that an attribute can have, you can enumerate those values in ODL.
Aa. True
QN=236 A composite attribute does not get mapped into a relation.
Aa. True
QN=237 A relation is a two-dimensional table
Aa. True
QN=241 Normalization is a formal process for deciding which attributes should be grouped together in a relation.
Aa. True
QN=242 In a 1:M relationship, the primary key on the one side migrates to the many side to become the foreign key on the many side.
Aa. True
QN=243 A synonym is two or more attributes that have different names but the same meaning
Aa. True
QN=244 A null value is assigned when no other value applies.
Aa. True
QN=247 A foreign key may be null and still adhere to the referential integrity constraint.
Aa. True
QN=25 Common types of SQL CHECK constraints include range checks and limiting columns values.
Aa. True
QN=26 If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
Aa. True
QN=38 With failure transparency, all of the actions of a transaction are committed or none of them are committed
Aa. True
QN=40 The purpose of timestamping is to avoid the use of locks.
Aa. True
QN=8 Two basic constructs to link one piece of data with another piece of data: sequential storage and pointers.
Aa. True
QN=30 Of the three ways to create an Oracle database, which one is the easiest and most recommended?
Aa. Using the Oracle Database Configuration Assistant
QN=103 What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?
Aa. VARCHAR2
QN=119 Sequential retrieval on a primary key for sequential file storage has which of the following features?
Aa. Very fast
QN=38 Which type of entity cannot exist in the database unless another type of entity also exists in the database, but does not require that the identifier of that other entity be included as part of its own identifier?
Aa. Weak entit
QN=132 A foreign key is:
Aa. a column containing the primary key of another table |
QN=97 Changing cardinalities in a database is:
Aa. a common database design task
QN=181 In an SQL SELECT statement querying a single table, according to the SQL-92 standard the asterisk (*) means that:
Aa. all columns of the table are to be returned |
QN=96 The EXISTS keyword will be true if:
Aa. any row in the subquery meets the condition only
QN=87 A transaction in which either all of the database actions occur or none of them do is called:
Aa. atomic
QN=15 An attribute is a(n):
Aa. column of a table
QN=29 The following are functions of a DBMS except ________ .
Aa. creating and processing form
QN=229 The relational model consists of:
Aa. data in the form of tables
QN=30 Helping people keep track of things is the purpose of a(n) ________ .
Aa. databas
QN=103 A tool that can help designers understand the dependencies of database structures is a:
Aa. dependency graph
QN=134 In a 1:1 relationship, the foreign key is placed in:
Aa. either table without specifying parent and child tables |
QN=196 The SQL keyword BETWEEN is used:
Aa. for ranges |
QN=88 A cursor type in which the application can only move forward through the recordset is called:
Aa. forward only
QN=95 Locks placed by the DBMS are called ________ .
Aa. implicit lock
QN=41 A recursive relationship is a relationship between an entity and ________ .
Aa. itsel
QN=221 The entity integrity rule states that:
Aa. no primary key attribute may be null
QN=22 The different classes of relations created by the technique for preventing modification anomalies are called:
Aa. normal forms
QN=39 In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Aa. paren
QN=11 In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity
Aa. parent
QN=24 An application where only one user accesses the database at a given time is an example of a(n) ________ .
Aa. single-user database applicatio
QN=20 One solution to the multivalued dependency constraint problem is to:
Aa. split the relation into two relations, each with a single theme
QN=81 The advantage of optimistic locking is that:
Aa. the lock is obtained only after the transaction has processed
QN=144 If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Aa. the primary ke |
QN=235 Relations are:
Aa. two-dimensional tables
QN=193 To define what columns should be displayed in an SQL SELECT statement:
Aa. use FROM to name the source table(s) and list the columns to be shown after SELECT |
What is the difference between the minimum and the maximum number of records a table having a B+-tree index with 3 index levels (root and two more) and a leaf level (rough estimate). Leafs contain the rows. An entry (key, record) has 100 Bytes. The number of successors of index nodes is 50 <=k <= 100. The net page size (header not taken into account) of leafs and internal nodes is 8000 Bytes.
About 75,000,000
Which one should not use when choosing an index
Add secondary index to an attribute if the query will retrieve a significant propotion of the relation
Which one should not use when choosing an index?
Add secondary index to any attribute or relation that is frequently updated
Which one is not a property of the transaction?
Automaticity
Which one is not a database design phase?
Basical
QN=225 A transitive dependency is which of the following?
Bb. A functional dependency between two or more nonkey attributes
QN=156 The load and index is which of the following?
Bb. A process to load the data in the data warehouse and to create the necessary indexes
QN=134 An operational system is which of the following?
Bb. A system that is used to run the business in real time and is based on current data
QN=65 What is an SQL virtual table that is constructed from other tables?
Bb. A vie
QN=22 What is an SQL virtual table that is constructed from other tables?
Bb. A view
QN=104 If a denormalization situation exists with a many-to-many or associative binary relationship, which of the following is true?
Bb. All fields are stored in two relations
QN=228 A primary key is which of the following?
Bb. An attribute that uniquely identifies each roý
QN=170 The wildcard in a WHERE clause is useful when?
Bb. An exact match is not possible in a SELECT statement |
QN=200 Which of the following is an unordered collection of elements that may contain duplicates?
Bb. Bag
QN=110 What is the best data type definition for Oracle when a field is alphanumeric and has a fixed length?
Bb. CHAR
QN=157 The extract process is which of the following?
Bb. Capturing a subset of the data contained in various operational system
QN=145 Reconciled data is which of the following?
Bb. Current data intended to be the single source for all decision support system
QN=2 Which of the following products was an early implementation of the relational model developed by E.F. Codd of IBM?
Bb. DB
QN=187 SQL query and modification commands make up a(n) ________ .
Bb. DM |
QN=172 The command to eliminate a table from a database is:
Bb. DROP TABLE CUSTOMER |
QN=173 ON UPDATE CASCADE ensures which of the following?
Bb. Data Integrity |
QN=142 The generic two-level data warehouse architecture includes which of the following?
Bb. Data that can extracted from numerous internal and external source
QN=130 Which of the following column properties would be used to specify that cells in a column must contain a monetary value?
Bb. Data typ |
QN=93 How can you find rows that do not match some specified condition?
Bb. Double use of NOT EXIST
QN=108 Correlated subqueries are similar to a regular subquery.
Bb. Fals
QN=109 Database redesign is especially difficult if the database has no data.
Bb. Fals
QN=112 Although creating test databases is a critical and necessary job, there are few career opportunities in this area.
Bb. Fals
QN=113 Because of the need for extensive knowledge of SQL, many database developers choose to automate the redesign process.
Bb. Fals
QN=115 If a database is built correctly the first time, it will not have to be redesigned.
Bb. Fals
QN=116 The SQL-92 command to change a table name is RENAME TABLE.
Bb. Fals
QN=118 The data model produced from the reverse engineering process is a true logical model.
Bb. Fals
QN=120 Typically, there should be at least two different copies of the database schema used in the redesign process.
Bb. Fals
QN=123 The NOT EXISTS keyword will be true if any row in the subquery meets the condition.
Bb. Fals |
QN=148 In 1:N relationships, which entity becomes the parent entity is arbitrary.
Bb. Fals |
QN=151 When the parent entity is required, a new child row can always be inserted.
Bb. Fals |
QN=154 For every relationship, there are six possible sets of minimum cardinalities.
Bb. Fals |
QN=156 The DBMS allows surrogate keys to be changed.
Bb. Fals |
QN=157 Cascading updates refers to child rows being automatically deleted when a parent row is deleted.
Bb. Fals |
QN=159 Surrogate keys have much meaning for users.
Bb. Fals |
QN=161 (STREET ADDRESS, CITY, STATE, ZIP) is an ideal primary key.
Bb. Fals |
QN=124 A pointer is a detailed coding scheme recognized by system software for representing organizational data.
Bb. False
QN=125 Distributing the columns of a table into several separate physical records is known as horizontal partitioning.
Bb. False
QN=126 It is usually not very important to design the physical database to minimize the time required by users to interact with the information systems.
Bb. False
QN=127 In general, larger block sizes are used for online transaction processing applications and smaller block sizes are used for databases with a decision support or data warehousing system.
Bb. False
QN=128 Data-volume and frequency-of-use statistics are not critical inputs to the physical database design process
Bb. False
QN=129 The three newest database architectures in use today are relational, multidimensional and hierarchical.
Bb. False
QN=147 The role of the ETL process is to identify erroneous data and to fix them.
Bb. False
QN=149 Star schema is suited to online transaction processing, and therefore is generally used in operational systems, operational data stores, or an EDW.
Bb. False
QN=15 An ID-dependent entity is an entity whose identifier is a composite identifier where no portion of the composite identifier is an identifier of another entity.
Bb. False
QN=152 Static extract is used for ongoing warehouse maintenance
Bb. False
QN=155 Every key used to join the fact table with a dimensional table should be a surrogate key
Bb. False
QN=175 With asynchronous technology, if any copy of a data item is updated anywhere on the network, the same update is immediately applied to all other copies or it is aborted.
Bb. False
QN=176 Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.
Bb. False
QN=178 Asynchronous technology can result in unsatisfactorily slow response time because the distributed DBMS is spending considerable time checking that an update is accurately and completely propagated across the network.
Bb. False
QN=206 ODL supports the abstract keyword for classes and operations.
Bb. False
QN=209 The Object Model supports different literal types, but does not support atomic literals, collection literals, and structured literals.
Bb. False
QN=214 Database objects are almost always transient.
Bb. False
QN=215 A collection of literals or object types is called a bag.
Bb. False
QN=216 An ordered collection of elements of the same type are called sets.
Bb. False
QN=217 You may specify an object identifier with only one unique tag name.
Bb. False
QN=238 An enterprise key is a primary key whose value is unique for a given relation.
Bb. False
QN=239 Weak entities do not get mapped into a relation.
Bb. False
QN=24 Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Bb. False
QN=249 Well-structured relations encourage anomalies of data.
Bb. False
QN=250 If a relation is in third normal form, it does not need to be in second normal form.
Bb. False
QN=32 Money is defined in Oracle with the Currency data type
Bb. False
QN=39 Databases that are stored on computers at multiple locations and are not interconnected by a network are known as distributed databases.
Bb. False
QN=9 A bitmap index is an index on columns from two or more tables that come from the same domain of values.
Bb. False
QN=223 If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
Bb. First normal form
QN=27 What type of failure occurs when Oracle fails due to an operating system or computer hardware failure?
Bb. Instance Failure
QN=201 Which of the following is true concerning the following statement: class Manager extends Employee
Bb. Manager is a concrete class and a subclass
QN=37 Which of the following indicates the maximum number of entities that can be involved in a relationship?
Bb. Maximum cardinalit
QN=33 A DBMS that combines a DBMS and an application generator is ________ .
Bb. Microsoft's Acces
QN=129 A primary key should be defined as:
Bb. NOT NULL |
QN=31 Which SQL phrase is not supported by Oracle?
Bb. ON UPDATE CASCAD
QN=44 In which of the following is a single-entity instance of one type related to many entity instances of another type?
Bb. One-to-Many Relationshi
QN=77 Which of the following occurs when a transaction rereads data and finds new rows that were inserted by a command transaction since the prior read?
Bb. Phantom rea
QN=90 Which of the following allows dirty reads, nonrepeatable reads and phantom reads to occur?
Bb. Read uncommitte
QN=99 The strictest transaction isolation level provided by SQL Server is called:
Bb. SERIALIZABLE
QN=198 ________ was adopted as a national standard by ANSI in 1992.
Bb. SQ |
QN=54 Which type of entity has its relationship to another entity determined by an attribute in that other entity called a discriminator?
Bb. Subtype entit
QN=71 What SQL structure is used to limit column values of a table?
Bb. The CHECK constrain
QN=109 Which of the following is not a factor to consider when switching from small to large block size?
Bb. The number of columns
QN=167 Which of the following is true concerning a global transaction?
Bb. The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary
QN=112 Denormalization and clustering can work well to minimize data access time for small records.
Bb. True
QN=114 The primary goal of physical database design is data processing efficiency.
Bb. True
QN=222 When mapping a many-to-many unary relationship into a relation which of the following is true?
Bb. Two relations are created
QN=226 When mapping a multivalued attribute into a relation which of the following is true?
Bb. Two relations are created
QN=191 ODL supports which of the following types of association relationships?
Bb. Unary and Binary
QN=48 Properties that describe the characteristics of entities are called:
Bb. attributes
QN=105 SQL Server 2000 stored procedures can:
Bb. be kept within the database and invoked by application programs
QN=58 The DROP TABLE statement:
Bb. deletes the table structure along with the table data
QN=50 Entities of a given type are grouped into a(n):
Bb. entity class
QN=75 Locks placed by command are called ________ .
Bb. explicit lock
QN=94 A regular subquery can be processed:
Bb. from the bottom up
QN=168 The SQL WHERE clause:
Bb. limits the row data are returned |
You have run an SQL statement that asked the DBMS to display data in a table named USER_TABLES. The results include columns of data labeled "TableName," "NumberOfColumns" and "PrimaryKey." You are looking at ________ .
Bb. metadata
QN=13 For some relations, changing the data can have undesirable consequences called:
Bb. modification anomalies
QN=32 An Enterprise Resource Planning application is an example of a(n) ________ .
Bb. multiuser database applicatio
QN=105 Because of the importance of making data model changes correctly, many professionals are ________ about using an automated process for database redesign.
Bb. skeptica
QN=93 A cursor type in which the application sees the data as they were at the time the cursor was opened is called:
Bb. static
QN=63 A ________ is a program that performs some common action on database data and that is stored in the database.
Bb. stored procedur
QN=21 A ________ is a program that performs some common action on database data and that is stored in the database.
Bb. stored procedure
QN=142 Each entity is represented as a(n):
Bb. table |
QN=106 The blocking factor is:
Bb. the number of physical records per page
Which of the following is not a phase in Cross Industry Standard Process for Data Mining (CRISP-DM) model?
Business preparation
QN=137 Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
Cc. An intrarelation constrain |
QN=55 Which type of entity represents a logical generalization whose actual occurrence is represented by a second, associated entity?
Cc. Archetype entit
QN=86 Which of the following SQL statements are helpful in database redesign?
Cc. Both of the above are helpful
QN=103 Which of the following is a way to create and modify tables using SQL Server?
Cc. Both of the two methods above will work
QN=143 Fact tables are which of the following?
Cc. Completely normalize
QN=24 The metadata is created by the
Cc. DDL interpreter
QN=167 The command to remove rows from a table 'CUSTOMER' is:
Cc. DELETE FROM CUSTOMER WHERE .. |
QN=184 To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included.
Cc. DISTINCT |
QN=135 Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Cc. Default valu |
QN=89 Which of the following occurs when one transaction reads a changed record that has not been committed to the database?
Cc. Dirty rea
QN=231 A relation has which of the following properties?
Cc. Each relation has a unique name
QN=91 Which of the following locks the item from access of any type?
Cc. Exclusive loc
QN=143 For every relationship, how many possible sets of minimum cardinalities are there?
Cc. Fou |
QN=4 A relation is in this form if it is in BCNF and has no multivalued dependencies:
Cc. Fourth normal form
QN=45 Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Cc. ID-dependent entit
QN=166 You can add a row using SQL in a database with which of the following?
Cc. INSERT |
QN=102 Selecting a data type involves which of the following?
Cc. Improve data integrity
QN=82 Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
Cc. Keyse
QN=202 Which of the following is an ordered collection of elements of the same type?
Cc. List
QN=49 In which of the following can many entity instances of one type be related to many entity instances of another type?
Cc. Many-to-Many Relationshi
QN=74 Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Cc. ORDER BY
QN=192 To sort the results of a query use:
Cc. ORDER BY |
QN=158 A star schema has what type of relationship between a dimension and fact table?
Cc. One-to-many
QN=5 When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Cc. Referential integrity constraint
QN=84 Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Cc. Repeatable rea
QN=169 Replication should be used when which of the following exist?
Cc. The application's data can be somewhat out-of-date
QN=36 Replication should be used when which of the following exist?
Cc. The application's data can be somewhat out-of-date
QN=12 Which of the following is not a restriction for a table to be a relation?
Cc. The columns must be ordered
QN=192 An extent is which of the following?
Cc. The set of all instances of a class within a database
QN=104 How many copies of the database schema are typically used in the redesign process?
Cc. Thre
QN=233 When mapping a regular entity into a relation which of the following is true?
Cc. Three relations are create
QN=230 When mapping a binary many-to-many relationship into a relation which of the following is true?
Cc. Three relations are created
QN=73 What is an advantage of placing computations in SQL views?
Cc. To accomplish both of the above
QN=166 Some of the columns of a relation are at different sites is which of the following?
Cc. Vertical Partitioning
QN=20 To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Cc. a particular row in a particular underlying table
QN=61 To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Cc. a particular row in a particular underlying table
QN=19 SQL views can be used to hide:
Cc. both of the above can be hidden by an SQL view
QN=59 SQL views can be used to hide:
Cc. both of the above can be hidden by an SQL view
QN=5 The primary key is selected from the:
Cc. candidate keys
QN=88 Database redesign is not terribly difficult if the:
Cc. database has no data
QN=100 To drop a column that is used as a foreign key, first:
Cc. drop the foreign key constraint
QN=25 An on-line commercial site such as Amazon.com is an example of a(n) ________ .
Cc. e-commerce database applicatio
QN=23 A relation is in this form if it is in BCNF and has no multivalued dependencies:
Cc. fourth normal form
QN=197 A subquery in an SQL SELECT statement:
Cc. has a distinct form that cannot be duplicated by a join |
QN=47 An attribute that names or identifies entity instances is a(n):
Cc. identifier
QN=92 The size of a lock is called:
Cc. lock granularity
QN=178 A subquery in an SQL SELECT statement is enclosed in:
Cc. parenthesis -- (...) |
QN=136 The identifier of an entity will become the ________ of the new table.
Cc. primary ke |
QN=7 When the values in one or more attributes being used as a foreign key must exist in another set of one or more attributes in another table, we have created a(n):
Cc. referential integrity constraint
QN=3 The following are components of a database except ________ .
Cc. report
QN=90 The process of reading a database schema and producing a data model from that schema is known as:
Cc. reverse engineering
QN=18 A tuple is a(n):
Cc. row of a table
QN=28 Because it contains a description of its own structure, a database is considered to be ________ .
Cc. self-describin
QN=127 In a 1:N relationship, the foreign key is placed in:
Cc. the child table |
QN=68 A reason for using an SQL view to hide columns is:
Cc. to accomplish both of the above
QN=57 A ________ is a stored program that is attached to a table or a view.
Cc. trigge
QN=8 A relation is considered a:
Cc. two-dimensional table
Q16 Which one is not basic client-server architecture of an object-oriented database system
Class Server
All of the followings are query processing phases, excepts
Compilation
Which one is not weakness of RDBMS compares to OODBMS?
Data Structure
Q21 Which statement is incorrect regards to database replication
Database vendor always provides either distributed DBMS or database replication
QN=131 Data scrubbing is which of the following?
Dd. A process to upgrade the quality of data before it is moved into a data warehouse
QN=95 What SQL command can be used to add columns to a table?
Dd. ALTER TABLE TableName ADD ColumnNam
QN=118 A rule of thumb for choosing indexes for a relational database includes which of the following?
Dd. Be careful indexing attributes that have null values
QN=188 When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
Dd. Both IN and NOT IN |
QN=34 A distributed database has which of the following advantages over a centralized database?
Dd. Modular growth
QN=99 The data model that is produced from reverse engineering is:
Dd. None of the above is correct
QN=89 Which SQL-92 standard SQL command can be used to change a table name?
Dd. None of the above is correct.
QN=36 The DBMS that is most difficult to use is ________ .
Dd. Oracle Corporation's Oracl
QN=14 Which of the following is NOT a basic element of all versions of the E-R model?
Dd. Primary key
QN=51 Which of the following is NOT a basic element of all versions of the E-R model?
Dd. Primary key
QN=26 Which of the following products was the first to implement true relational algebra in a PC DBMS?
Dd. R:bas
QN=101 Which type of SQL Server cursor concurrency places an update lock on a row when the row is read?
Dd. READCOMMITTE
QN=7 Which of the following is an advantage of partitioning?
Dd. Security
QN=85 Dirty read, nonrepeatable, and phantom reads are not possible in this instance.
Dd. Serializabl
QN=76 Which of the following locks the item from change but not from read?
Dd. Shared loc
QN=140 For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Dd. Si |
QN=104 With which type of SQL Server recovery model, is no logging done?
Dd. Simple recover
QN=102 Which is not true of a correlated subquery?
Dd. They are very similar to a regular subquery
QN=86 The clause alter table in SQL can be used to
Dd. all of the abov
QN=10 A functional dependency is a relationship between or among:
Dd. attributes
QN=11 Table is synonymous with the term:
Dd. attributes
QN=78 A transaction for which all committed changes are permanent is called:
Dd. durable
QN=9 In the relational model, relationships between relations or tables are created by using:
Dd. foreign keys
QN=189 The Microsoft Access wildcards are ____ and ____ .
Dd. question mark (?); asterisk (* |
QN=66 When using the SQL INSERT statement:
Dd. rows can either be inserted into a table one at a time or in groups
QN=138 A unique, DBMS-supplied identifier used as the primary key of a relation is called a(n):
Dd. surrogate key |
QN=179 The result of a SQL SELECT statement is a(n) ________ .
Dd. table |
All of the followings are data mining technique, excepts
Different time sequence discovery
Which statement is incorrect about dynamic and/or static query optimization
Disadvantages of static query optimization are that performance of query is affected, time may limit finding optimum strategy
Why is dynamic block assignment (indirect mapping) of the DBS page address space to disk blocks is to prefer a static assignment
Flexibility of disk block assignment
Which statement is not correct to derive relations for logical data model?
For each strong entity in the data model, create a relation that includes all the simple attributes of that entity. Composite attributes will be ignored.
Which statement is not correct to derive relations for logical model?
For each strong entity in the data model, create a relation that includes all the simple attributes of that entity. Composite attributes will be ignored.
As OODBMS Manifesto which one of the followings is not be supported
Integrity
What is disadvantage of the fragmentation in a DDBMS?
Integrity
When are all records of a table stored on disk in increasing key order?
Key-sequenced B+-tree index (Oracle: index organized table)
Which one is not collection type in SQL:2003?
MULTILIST
Which one is not category of constraints of specialization and generalization?
Mandatory and joint
Q1 Which statement is not correct about query processing?
Memory access tends to be dominant cost in query processing for centralized DBMS
Choose the incorrect statement about User-Defined Routines (URDs)?
Must be defined as part of a UDT
Q11 Choose the incorrect statement about User-Defined Routines (UDRs)
Must be defined as part of a UDT
Which statement is incorrect regards to the Concurrency Control Techniques
Timestamping is a conservative method
Which statement is incorrect regards to the Concurrency Control Techniques?
Timestamping is a optimistic method
Which statement is correct?
Timestamping schedule is view serializable
Which statement is correct
Timestamping shedule is view serializable
............ systems capture details of events or transactions. a. OLTP b. Data warehouse c. OLAP d. Business Intelligence
a
............... signifies that the data warehouse stores the information around a particular subject such as product, customer, sales etc. a. Subject oriented b. Integrated c. Time-Variant d. Nonvolatile
a
................. means populating all the data warehouse tables for the very first time. a. Initial load b. Incremental load c. Load all d. Load
a
...........means applying ongoing changes as necessary in a periodic manner. a. Incremental load b. Updating load c. Full refresh d. Immediate load
a
A Web-enabled data warehouse adapts the Web for information delivery and collaboration among the users. Is this true? a. YES b. NO
a
Accurate requirements definition in a data warehouse project is many times more important than in other types of projects. a. True b. False
a
Activities can be closed, or terminated anytime the user wishes. on the other hand, services are designed to run behind the scenes, and and act independently. Select one: a. True b. False
a
Android doesn't make any assumptions about a device's screen size, resolution, or chipset Select one: a. True b. False
a
BIDS (Business Intelligence Development Studio) provides environment for developing your OLAP Cube and Deploy on SQL Server. a. True b. False
a
Benefits from a data warehouse accrue only after the users put it to full use. a. True b. False
a
Benefits from a data warehouse accrue only after the users put it to full use. a.True b.False
a
Bitmapped indexes are ideally suitable for .................data. a. low-cardinality b. high-cardinality c. numerical d. textual
a
Building a data warehouse is very different from building an operational system. a. True b. False
a
CREDIBLE characteristic of strategic information means: a. Every business factor must have one and only one value. b. Easily accessible with intuitive access paths, and responsive for analysis. c. Information must be accurate and must conform to business rules. d. Must have a single, enterprise-wide view.
a
Can you deploy executable JARs on Android? Select one: a. False b. True
a
Data granularity in a data warehouse refers to the level of detail. a. True b. False
a
Data on salary may be represented as monthly salary, weekly salary, and bimonthly salary in different source payroll systems. What do you call the above problem in ETL? a. Inconsistency b. Consistency c. Diverse d. Multiple-form
a
Degenerated dimensions ............ a. contain many attributes b. contain no attribute c. contain only one attribute d. contain a primary key and a fact value
a
Dimension tables contain the ...... of analysis. a. criterions b. measurements c. facts d. values
a
Entity-Relationship Modeling is suitable for............ a. OLTP systems b. Data warehouse systems c. OLTP and Data warehouse systems d. OLAP
a
Fact tables generally occupy the most of the storage capacity. a. True b. False
a
How do you programmatically determine whether a RadioButton is checked? Select one: a. You should check the isChecked() method b. You should check the isSelected() method c. You should check the isTicked() method d. You should check the isFilled() method
a
In Bottom-Up Approach of designing a data warehouse, data marts are created first to provide analytical and reporting capabilities for specific business subjects based on the dimensional data model. a. True b. False
a
In an operational system, data is usually kept at the lowest level of detail. a. True b. False
a
In any analytical system, time is a critical dimension. a. True b. False
a
In data warehouse, Data Extraction function has to deal with numerous data sources. You have to employ the appropriate technique for each data source. a. True b. False
a
In designing a data warehouse, Top-Down Approach will create a data warehouse as a centralized repository for the entire enterprise. a. True b. False
a
Intents do not name a target and the field for the component name is left blank Select one: a. Implicit Intents b. Explicit Intents c. Open Intents d. Close Intents
a
Is it possible to run java source code directly on Android? Select one: a. False b. True
a
Is that true, if one says that OLAP report on the past while Data Mining predicts the future? a. YES b. NO
a
Let business requirements drive your data warehouse, not technology a. True b. False
a
MOLAP refers to ............OLAP. a. Multidimensional b. Multiple c. Many-to-Many d. Mix
a
Metadata in a data warehouse is similar to the .............or the data catalog in a database management system. a. data dictionary b. data structure c. data tables d. data constraints
a
OLAP systems provide ............. and roll-up capabilities. a. drill-down b. drop-down c. top-down d. up-down
a
OLTP is stand for Online Transaction Processing. a. True b. False
a
One says that: ER modeling will have logical and physical model but Dimensional modeling will have only Physical model. ER Modeling is used for normalizing the OLTP database design whereas Dimensional Modeling is used for de-normalizing the ROLAP and MOLAP design. IS THIS TRUE? a. YES b. NO
a
Operational systems are online transaction processing (OLTP) systems. a. TRUE b. False
a
Operational systems are the systems that are used to run the day-to-day core business of the company. a. TRUE b. FALSE
a
ROLAP refers to ............OLAP. a. Relational b. Rapid c. Running d. Roll
a
Regarding OLAP, which statement is true? a. An OLAP cube is a technology that stores data in an optimized way to provide a quick response to various types of complex queries by using dimensions and measures. b. Most cubes store dimensional values with its special storage structure to provide quick response to queries. c. An OLAP cube is a technology that stores data in data warehouse. d. None of the others
a
Regarding to Star schema, which statement is NOT true? a. In star schema some dimension tables are normalized. b. In star schema each dimension is represented with only one dimension table. c. There is a fact table at the centre. This fact table contains the keys to each of dimension. d. None of the others.
a
Select the most correct definition of the data warehouse concept. a. Take all the data you already have in the organization, clean and transform it, and then provide useful strategic information. b. Take all the data you already have in the organization, store it, and then provide useful strategic information. c. Take all the data you already have in the organization and also in the related business domains, clean and transform it, and then provide useful strategic information. d. None of the others
a
The data warehouse is an informational environment that: a. Makes the enterprise's current and historical information easily available for strategic decision making. b. Makes the enterprise's current information easily available for strategic decision making. c. Makes the enterprise's historical information easily available for strategic decision making. d. None of the others
a
The data warehouse is an informational environment that: a. Provides an integrated and total view of the enterprise. b. Store all the business data c. Data is often updated and inserted d. All company's staff access it everyday.
a
The detailed plan results in the definition of the transformation/conversion rules. a. True b. False
a
The initial load (in Data Loading) moves large volumes of data using up substantial amounts of time. a. True b. False
a
The online transaction processing applications support the day-to-day operations of an enterprise. a. True b. False
a
Using parallel processing technologies (e.g. multithreading), the performance of ETL can be improved. Is it true? a. Yes b. No
a
What are the three major areas in the data warehouse? a. Data Acquisition, Data storage, Information delivery b. Data Collection, Data storage, Information delivery c. Data Acquisition, Database, Reporting System d. Data Acquisition, Data storage, Business Intelligence
a
What does the .apk extension stand for? Select one: a. Android Package b. Application Program Kit c. Android Proprietary Kit d. Application Package
a
What is AAPT tool? Select one: a. This tool provides developers with the ability to deal with zip-compatible archives, which includes creating, extracting as well as viewing its contents b. This tool provides developers to manipulate with sqlite database c. This tool provides developers to view all resources of mobile d. This tool provides developers to create and run an emulator
a
What is Business intelligence? a. The systems and technologies for gathering, cleansing, consolidating, and storing corporate data. The tools, techniques, and applications for analyzing the stored data. b. The tools for decision makers to get the strategic information. c. The tools for data warehouse developer to manipulate and monitor the data warehouse database. d. The most common Operation System for a data warehouse.
a
What is a key difference with the distribution of apps for Android based devices than other mobile device platform applications? Select one: a. Applications are distributed by multiple vendors with different policies on applications b. Applications are distributed by multiple vendors with the exact same policies on applications c. Applications are distributed by Apple App Store only d. Applications are distributed by the Android Market only
a
What should we do before executing ETL? a. Remove indexes in data warehouse database b. Create some non-clustered indexes in data warehouse database c. Do nothing d. None of the others
a
When a user queries the data warehouse for analysis, he or she usually starts by looking at very details of data. a. True b. False
a
Where will you declare your activity so the system can access it? Select one: a. In the manifest xml file b. In the layout xml file c. In the string xml file d. In the style xml file
a
Which is the act of picking a rectangular subset of a cube by choosing a single value for one of its dimensions, creating a new cube with one fewer dimension? a. Slice c. Dice b. Roll-up c. Drill Down/Up
a
Which is the challenge of ETL? a. Source systems are very diverse and disparate. b. Source systems are usually in one platform. c. Specify all the source systems. d. None of the others
a
Which is the challenge of ETL? a. Source system structures keep changing over time because of new business conditions. b. Source system structures are very different. c. Source systems are hosted in very low performance systems. d. None of the others
a
Which is the question that may NOT answered by Data Mining? a. Who are our top 100 best customers for the last three years? b. Which 100 customers offer the best profit potential? c. For the next two years, which stores are likely to have best performance? d. What is the expected return for next year's promotions?
a
Which of the following should be used to save the unsaved data and release resources being used by an Android application? Select one: a. Activity.onDestroy() b. Activity.onFreeze() c. Activity.onPause() d. Activity.onStop()
a
Which operation allows an analyst to rotate the cube in space to see its various faces? a. Pivot b. Dice c. Roll-up d. Slice
a
Which operation allows the user to navigate among levels of data ranging from the most summarized to the most detailed? a. Drill Down b. Dice c. Roll-up d. Slice
a
Which statement is TRUE? a. In SQL Server, primary key is clustered index as default. This makes it a very fast index when accessing data, though it may slow down writes if your primary key is not a sequential number. b. Clustered index uses a huge amount of storage to store indexing data. c. Clustered index can increase both read and write operations. d. None of the others.
a
Which statement is correct? a. We have to choose OLAP Cube when performance is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your huge database. b. We have to choose OLAP Cube when storage is a key factor, the key decision makers of the company can ask for statistics from the data anytime from your small database. c. We have to choose OLAP Cube when we do not want to implement ETL. d. None of the others.
a
Which statement is correct? a. With OLAP cube, we are able to create data mining structure on this data which can be helpful in forecasting, prediction. b. OLAP cube help us reduce the cost (time, CPU usage) of updating the data warehouse database. c. OLAP is an optimized way to design the data warehouse system. d. None of the others.
a
Which statement is the most correct definition of data warehouse system? a. Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support management's decision making process. b. Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support daily management process. c. Data warehouse is Subject Oriented, Integrated, Time-Variant and Nonvolatile collection of data that support auditing process. d. None of the others.
a
Who are the users that need information from the data warehouse? a. Decision makers b. Customers e. Staff f. Database Administrators
a
QN=82 Which of the following is true for relational calculus?
aa. ?x?P?x????????x???P?x?
QN=84 Relationships among relationships can be represented in an-E-R model using
aa. Aggregation
QN=20 Immediate database modification technique uses
aa. Both undo and redo
QN=66 Manager salary details are hidden from the employee .This is
aa. Conceptual level data hiding
QN=62 The FD A ? B , DB ? C implies
aa. DA ? C
QN=97 An advantage of views is
aa. Data securitt
QN=89 The expression ??1?E1 ?2E2? is the same as
aa. E1 ?1^ ?2E2
QN=65 Relations produced from an E-R model will always be
aa. First normal form
QN=67 Which of the following is true for network structure?
aa. It is a physical representation of the data
QN=10 What is a disjoint less constraint?
aa. It requires that an entity belongs to no more than one level entity set
QN=17 The operation which is not considered a basic operation of relational algebra is
aa. Join
QN=100 operator is used to compare a value to a list of literals values that have been specified
aa. Like
QN=4 Checkpoints are a part of
aa. Recovery measures
QN=8 The rule that a value of a foreign key must appear as a value of some specific table is called a
aa. Referential constrain
QN=16 In an E-R diagram double lines indicate
aa. Total participation
QN=77 Which of the following ensures the atomicity of the transaction?
aa. Transaction management component of DBMS
QN=43 Which one is true statement?
aa. With finer degree of granularity of locking a high degree of concurrency is possible
QN=61 In E-R Diagram total participation is represented by
aa. double line
QN=27 In SQL the word ?natural? can be used with
aa. inner join
QN=30 Shadow paging has
aa. no redo
QN=70 In b-tree the number of keys in each node is than the number of its children
aa. one less
QN=31 If the closure of an attribute set is the entire relation then the attribute set is a
aa. superkey
QN=26 When R ? S ? ? , then the cost of computing R S is
aa. the same as R x S
QN=56 A functional dependency of the form x ? y is trivial if
aa. y ? x
What items are important in every Android project? (3 selected) Select one or more: a. AndroidManifest.xml b. res/ c. gradle/ d. src/ e. libs/
abd
which one should use when choosing an index
add secondary index to any attribute or relation that is frequently updated
which one is not overheat involved in maintenance and use of secondary indexes
adding and index record to every secondary index whenever tuple is retrieved
Android archtecture is made up of 4 key components: Linux kernel, Libraries, Android Frameworks and ______________ Select one: a. Android Applications b. Services c. Android Tools d. Camera e. Activity
b
Android is based on which language? Select one: a. Java b. C c. Objective C d. C++
b
Data Cleansing is a. Large collection of data mostly stored in a computer system b. The removal of noise errors and incorrect input from a database c. The systematic description of the syntactic structure of a specific database. It describes the structure of the attributes the tables and foreign key relationships. d. None of these.
b
Dimensional Modeling is suitable for............ a. OLTP systems b. Data warehouse systems c. OLTP and Data warehouse systems d. OLAP
b
Does Android support AWT and Swing? Select one: a. Yes b. No
b
How to set data for a Spinner control? Select one: a. Define in XML file b. Use method setAdapter() c. Use function addView() d. Use method setData()
b
In SQL (Structured Query Language), Which statement(s) is (are) TRUE regarding to the term cardinality? 1) Low-cardinality refers to columns with few unique values. 2) The lower the cardinality, the less duplicated elements in a column. 3) SQL databases use cardinality to help determine the optimal query plan for a given query. a. 1 and 2 b. 1 and 3 c. 2 and 3 d. There isn't statement.
b
In a table, there is only one ............. index. a. bitmap b. clustered c. non-clustered d. tree
b
In the data warehouse architecture, ................ sits on top of all the other components. It coordinates the services and activities within the data warehouse. a. Metadata Component b. Management and Control Component c. Data source Component d. Data Storage Component
b
In the dimensional model, the attributes of the data warehouse are divided into ..........and dimension tables a. center b. fact c. summary d. aggregate
b
Intents designate the target component by its name and they are typically used for application-internal messages. Select one: a. Close Intents b. Explicit Intents c. Open Intents d. Implicit Intents
b
Justification the benefits of a data warehouse through stiff ROI (Return on investment) calculations is always easy. a. True b. False
b
On android, a layout can contain other layout? Select one: a. False b. True
b
The traditional methods of collecting requirements that work well for operational systems can be directly applied to data warehouses. a. True b. False
b
What is the android:versionCode attribute in the AndroidManifest.xml file? Select one: a. The android:versionCode attribute is used mainly for displaying to the user b. The android:versionCode attribute is used to programmatically check if an application can be upgrade c. The android:versionCode attribute is a version name of application d. The android:versionCode attribute is a name of the cake
b
Which of the following are UI elements that you can not use in a window in an Android application? Select one: a. SeekBar b. SliderBar c. Button d. RadioButton
b
Which of the following are UI elements that you can use in a window in an Android application? Select one: a. TextElement b. TextView c. TextField d. TextBox
b
Which of the following is layout that you can use in a window in an Android application? Select one: a. BorderLayout b. FrameLayout c. FlowLayout d. CardLayout
b
Which of the following used to detect when a user clicks or taps on a button? Select one: a. OnClickDetector b. OnClickListener c. OnPressListener d. OnClickButton
b
Which operation produces a subcube by allowing the analyst to pick specific values of multiple dimensions? a. Slice b. Dice c. Roll-up d. Drill Down/Up
b
Which statement(s) is (are) correct? 1) Maintaining metadata in a modern data warehouse is just for documentation. 2) Metadata is needed by IT for data warehouse administration. a. Only statement 1 b. Only statement 2 c. Both statement 1 and 2 d. None of the others
b
Who needs strategic information in an enterprise? (choose the most correct) a. Staff b. Decision Markers c. Managers d. Accountants e. Directors
b
QN=13 A relation is in _________ if an attribute of a composite key is dependent on an attribute of other composite key.
bb. 3NF
QN=14 What is data integrity?
bb. It is the data contained in database that is accurate and consistent
QN=92 Whenever two independent one-to-many relationships are mixed in the same relation, a arises
bb. Multi-valued dependency
QN=6 The language that requires a user to specify the data to be retrieved without specifying exactly how to get it is
bb. Non-Procedural DM
QN=51 The cost of reading and writing temporary files while evaluating a query can be reduced by
bb. Pipelining
QN=21 In SQL the statement select * from R, S is equivalent to
bb. Select * from R cross join S
QN=59 Which of the following is not a characteristic of a relational database model?
bb. Tree like structure
QN=22 Which of the following is not a consequence of concurrent operations?
bb. Update anomaly
QN=47 If an entity can belong to only one lower level entity then the constraint is
bb. partial
QN=25 When an E-R diagram is mapped to tables, the representation is redundant for
bb. weak relationship sets
............. indicator of high-quality data ensures value for a data attribute is actually stored as the data type defined for that attribute. a. Accuracy b. Domain Integrity c. Data Type d. Consistency
c
A goal of data mining includes which of the following? a. To explain some obsserved event or condition b. To confirm that data exists c. To analyze data for expected relationships d. To create a new data warehouse
c
Android: What is value on component's attribute "layout_width" and "layout_height" to display the component big enough to enclose its content only? Select one: a. match_parent b. full_content c. wrap_content d. fill_parent
c
DATA INTEGRITY characteristic of strategic information means: a.Every business factor must have one and only one value. b.Easily accessible with intuitive access paths, and responsive for analysis. c.Information must be accurate and must conform to business rules. d.Must have a single, enterprise-wide view.
c
For writing Android code using C/C++, you need to use__________ Select one: a. JDK b. MDK c. NDK d. SDK
c
How will you launch an Activity within your application? Select one: a. launchActivity(intent); b. beginActivity(intent); c. startActivity(intent); d. runActivity(intent);
c
In which case, indexes can improve the performance? a. Insert data b. Update data c. Read data d. None of the others
c
Indexing in data warehouse database reduces performance of ........ a. Information delivery b. ETL c. Loading data into data warehouse d. OLAP
c
Select the correct comment on the two statements bellow. 1) When you perform the logical design of the database, your goal is to produce a conceptual model that reflects the information content of the real-world situation. 2) In physical design, you are getting closer to the operating systems, the database software, the hardware, and the computing platform. a. Only statement 1 is correct b. Only statement 2 is correct c. Both statements are correct d. Both statements are incorrect
c
The Intent object is passed to this method to deliver the message to all interested broadcast receivers Select one: a. Context.beginBroadcast() b. Context.startBroadcast() c. Context.sendBroadcast() d. Context.openBroadcast()
c
The intents can communicate messages among any of the three core components of an application: Select one: a. activities, broadcast receivers, content providers b. services, broadcast receivers, content providers c. activities, services, broadcast receivers d. activities, services, content providers
c
What are the benefits of partitioning? a. Easy management and Better performance b. Availability and Easier backup and recovery c. Both of A and B d. None of A and B
c
What is ANR? Select one: a. This is basic function is to allow and control communication towards and from the emulator port b. This is actually a dialog that appears to the user whenever an application have been unresponsive for a long period of time c. This is actually a dialog that appears to the user whenever an application have been unresponsive for a short period of time d. This is short for Android Network Resources.
c
What is adb? Select one: a. It allows developers the power to connect to internet b. It allows developers the power to access to sqlite database c. It allows developers the power to execute remote shell commands. d. It allows developers the power to call camera of mobile phone e. It allows developers the power to start a service
c
What is contained within the Layout xml file? Select one: a. The permissions required by the application b. The code which is compiled to run the application c. Orientations and layouts that specify what the display looks like d. The strings used in the application
c
Which of the following is the parent class for the main application class in an Android application that has a user interface? Select one: a. AppLet b. Application c. Activity d. AndroidApp
c
Which of the following is/are appropriate for saving the state of an Android application? Select one: a. Activity.onDestroy() b. Activity.onFreeze() c. Activity.onPause() d. Activity.onStop()
c
QN=12 It is an abstraction through which relationships are treated as higher level entities
cc. Aggregation
QN=3 Relational Algebra does not have
cc. Aggregation operators
QN=64 Union operator is a :
cc. Binary Operator
QN=52 A transaction is in state after the final statement has been executed.
cc. Committed
QN=99 Isolation of the transactions is ensured by
cc. Concurrency control
QN=32 DROP is a statement in SQL
cc. DDL
QN=68 Which two files are used during operation of the DBMS?
cc. Data dictionary and transaction log
QN=75 The values of the attribute describes a particular
cc. Entity instance
QN=5 Tree structures are used to store data in
cc. Hierarchical model
QN=60 Assume transaction A holds a shared lock R. If transaction B also requests for a shared lock on R
cc. It will immediately be granted
QN=18 Fifth Normal form is concerned with
cc. Join dependency
QN=35 In 2NF
cc. No partial FDs exist
QN=38 Relational Algebra is
cc. Procedural query Language
QN=63 The graphical representation of a query is
cc. Query Tree
QN=96 Which of the following constitutes a basic set of operations for manipulating relational data?
cc. Relational algebra
QN=98 Which of the following is not a recovery technique?
cc. Two-phase commit
QN=34 The keyword to eliminate duplicate rows from the query result in SQL is
cc. UNIQUE
QN=50 Use of UNIQUE while defining an attribute of a table in SQL means that the attribute values are
cc. both (A) & (B)
QN=29 If a transaction T has obtained an exclusive lock on item Q, then T can
cc. both read and write Q
QN=80 For correct behaviour during recovery, undo and redo operation must be
cc. idempotent
QN=41 Consider the join of relation R with a relation S. If R has m tuples and S has n tuples, then the maximum and minimum size of the join respectively are
cc. mn and 0
QN=69 A list consists of last names, first names, addresses and pin codes. If all people in the list have the same last name and same pin code a useful key would be
cc. the compound key first name and last name
QN=83 The part of a database management system which ensures that the data remains in a consistent state is
cc. transaction manager
DBMS should provide following facilities to assist with recovery, excepts
checkpoint facility, which enables updates to databse in progress to be made permanent
Which one is not a step to design file organizations and indexes
choose security mechanisms
which one is not a step to design file organizations and indexes
choose security mechanisms
............. indicator of high-quality data ensures the form and content of a data field is the same across multiple source systems. a. Accuracy b. Domain Integrity c. Data Type d. Consistency
d
............................. are designed to overcome any limitations placed on the warehouse by the nature of the relational data model. a. Operational database b. Relational database c. Multidimensional database d. Data repository
d
Android is based on Linux for the following reason Select one: a. Security b. Portability c. Networking d. All of these
d
Android: Which attribute will be used in XML if the Java code needs a reference to View? Select one: a. android: index b. android: gravity c. android: text d. android:id
d
Fact tables are which of the following? a. Completely denoralized b. Partially denoralized c. Completely normalized d. Partially normalized
d
INTEGRATED characteristic of strategic information means: a. Every business factor must have one and only one value. b. Easily accessible with intuitive access paths, and responsive for analysis. c. Information must be accurate and must conform to business rules. d. Must have a single, enterprise-wide view.
d
In ETL, .............tables are loaded first. a. Small b. Fact c. Dimension and Fact d. Dimension
d
In a fact table, there are 3 kinds of attributes: (choose one answer only) a. Dimension foreign keys b. Degenerated dimensions c. Facts d. All the others
d
In auto-generated code of an Android app, what is R class? Select one: a. Contains code for authentication and authorization the app b. Contains graphical user interface of the project c. It is the main controller of the app d. Contains IDs of the project resources
d
In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) a. Input Errors b. Incomplete Information at Data Entry c. Internationalization/Localization d. All the others
d
In data quality, which is (are) the Sources of Data Pollution? (choose one answer only) a. System Conversions b. Poor Database Design c. Heterogeneous System Integration d. All the others
d
Regarding to Online Analytical Processing (OLAP), which statement is INCORRECT? a. Designed to hold historical data for analyses and forecast business needs b. Data stored in denormalized format c. Used by users who are associated with the decision making process, e.g., Managers, CEO. d. Holds daily Latest Transactional Data related to your application
d
Regarding to data warehouse. Which statement is true? a. All indexes are always specified at the design time. b. All indexes are NOT always specified at the design time. c. All indexes are always specified at the maintenance time. d. Some indexes are specified at the design time, and some others are added at maintenance time.
d
The biggest drawback of the level indicator in the classic star schema is that is limits ............ a. ability b. quantify c. qualify d. flexibility
d
What are some aspects of Data Mining? a. Association Rules b. Outlier Analysis c. Predictive Analytics d. All of them
d
What are the different states wherein a process is based? Select one: a. foreground, visible, background activity and empty process b. active, pause, close and destroy c. foreground, background, stop and destroy d. active, pause, stop and destroy
d
What exactly do we mean by strategic information? a. Strategic information is important for the continued health and survival of the corporation. b. Strategic information is for the day-to-day operations of the business. c. It is intended to produce an invoice, make a shipment, settle a claim, or post a withdrawal from a bank account. d. The types of information needed to make decisions in the formulation and execution of business strategies and objectives are broad based and encompass the entire organization.
d
What is an Activity? Select one: a. A multiple screen in an application, with supporting Java code b. A single screen in an application, with supporting C++ code c. A multiple screen in an application, with supporting C++ code d. A single screen in an application, with supporting Java code
d
What is an intent object? Select one: a. An Intent object is an activity b. An Intent object is a service c. An Intent object is a broadcast d. An Intent object is a bundle of information
d
What is contained within the Layout xml file? Select one: a. The code which is compiled to run the app b. The permissions required by the app c. The strings used in the app d. Orientations and layouts that specify what the display looks like
d
What is contained within the manifest xml file? Select one: a. The list of images used in the application b. The source code c. The list of strings used in the application d. The permissions the application requires
d
What kind of datamining techniques help to find the natural group of objects? a. Classification b. Regression c. Association Rules d. Clustering
d
What part of the Android platform is open source? Select one: a. low-level Linux modules b. application frame work c. native libraries d. all of them
d
What was Google's main business motivation for supporting Android? Select one: a. To directly compete with the iPhone b. To corner the mobile device application market for licensing purposes c. To level the playing field for mobile devices d. To allow them to advertise more
d
Which dialog box can you use in you Android application? Select one: a. ConfirmDialog b. WarningDialog c. PromptDialog d. AlertDialog
d
Which is (are) related to the time-variant nature of the data in a data warehouse? (choose one answer only) a. Allows for analysis of the past b. Relates information to the present c. Enables forecasts for the future d. All the others
d
Which of the following are true about Intent.CALL_ACTION? Select one: a. Intent.action == Intent.CALL_ACTION is true when a phone call is received on the device b. Used when a phone number is to be dialled without showing a UI on the device c. Used when a phone number is to be dialled without the user having to explicitly initiate the call. d. Used to dial a phone number on the device
d
Which statement is correct regarding to dimensional model? a. A fact value CANNOT be calculated from other attributes. b. Usually, the primary key of the fact table is an auto generated key. c. Dimension tables occupy of the storage capacity. d. Every fact table has at least one Foreign Key.
d
Which statement(s) is (are) related to Dimensional Modeling? a. Captures critical measures b. Views along dimensions c. Intuitive to business users d. All the others
d
Which statement(s) is (are) related to Entity-Relationship Modeling? (choose one answer only) a. Removes data redundancy b. Ensures data consistency c. Expresses microscopic relationships d. All the others
d
Which value(s) is(are) typically Low-cardinality column values?(choose ONE answer only) a. status flags b. Boolean c. major classifications such as gender d. status flags, Boolean values, or major classifications such as gender
d
Which of the following is not a characteristic of the OLTP system
data is not detail but lightly summarised
WHich of the following is not a characteristic of the data warehouse system compares to OLTP system
data latency is always real time
Which of the following is main operation of the data mining
database segmentation
QN=36 Which one is correct statement? Logical data independence provides following without changing application programs: (i) Changes in access methods. (ii) Adding new entities in database (iii) Splitting an existing record into two or more records (iv) Changing storage medium
dd. (ii) and (iii)
QN=72 Which normal form is considered adequate for normal relational database design?
dd. 3NF
QN=19 Block-interleaved distributed parity is RAID level
dd. 5
QN=85 In tuple relational calculus P1 AND P2 is equivalent to
dd. ???P1OR ?P2?
QN=40 R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition
dd. A?BCD
QN=71 The drawback of shadow paging technique are
dd. All of these
QN=49 In SQL, testing whether a subquery is empty is done using
dd. EXISTS
QN=1 Which of the following relational algebra operations do not require the participating tables to be union-compatible?
dd. Joi
QN=91 The data models defined by ANSI/SPARC architecture are
dd. Logical, physical and vieý
QN=81 Which of the following is not a consequence of non-normalized database?
dd. Lost update problem
QN=45 Which of the following concurrency control schemes is not based on the serializability property?
dd. None of these
QN=93 A table can have only one
dd. Primary key
QN=105 Which of the following is an advantage of partitioning?
dd. Security
QN=76 Which of the following relational algebraic operations is not from set theory?
dd. Select
QN=28 The default level of consistency in SQL is
dd. Serializable
QN=44 Which of the following statement on the view concept in SQL is invalid?
dd. The definition of a view should not have GROUP BY clause in it
QN=54 The statement that is executed automatically by the system as a side effect of the modification of the database is
dd. Trigger
QN=33 If two relations R and S are joined, then the non matching tuples of both R and S are ignored in
dd. inner join
QN=58 The division operator divides a dividend A of degree m+n by a divisor relation B of degree n and produces a result of degree
dd. m
QN=74 In a multi-user database, if two users wish to update the same record at the same time, they are prevented from doing so by
dd. record lock
QN=87 Cascading rollback is avoided in all protocol except
dd. validation based protocol
which one is not an additional sematic modelling concept in Enhanced Entity-Relationship (EER) model
decomposition
Which one is not strategy of the data allocation in a DDBMS
defragmentation
which one is an important property of the decomposition
dependency preservation property
which one is not a step in logical database design phase
derive relationships for logical data model
Which one is not a step to translate logical data model for target DBMS
design indexes
Which of the following is the property of the data in a data warehouse
detailed, lightly-summarized and highly-summarized data
Which of the following is not a phase in Cross Industry Standard Process for Data Mining (CRISP-DM) Model
development
Which constraints used in specialization and generalization, choose two answers
disjoint+participation
Which are NOT the desired characteristics of strategic information? a. INTEGRATED b. DATA INTEGRITY c. ACCESSIBLE e. CREDIBLE f. TIMELY g. None of the others
g
which statement is not correct to derive relations from superclass/subclass relationship
if the participation and disjoint constraints are optional and nondisjoint. Two relations will be created, one for superclass and one for all subclasses
the definition and allocation of fragments carried out strategically to not achieve
maximum communication costs
which one is not typical stage of the query decomposition phase when doing query processing
normalization analysis
Which statement is incorrect regards to timestamping
older transactions, transactions with bigger timestamps, get priority in the event of conflict
Choose the correct statement regards database replication
one site cannot be both the master site and slave site ....
which one is basic client-server architecture of an object-oriented database system
page server
Which one is not a transition state of the transaction
partially aborted
which one is not a transition state of the transaction
partially arborted
which constraints used in specialization and generalization, choose two answers
participation - disjoint
Which of the following algebraic query transformations is correct in all cases? Tables are R(a,b), S(a,b)
proj b (R join S) j = proj b (R join proj b (S), proj b = project on attribute b
Which one is a DBMS transaction subsystem
recovery manager
Which one is advantage of ORDBMSs
reuses and sharing
which statement is correct
secondary indexes can be created as many as necessary
all of the following are main problems of data warehouse, excepts
short duration projects
What is not advantage of the distributed DBMS
simplicity
which one is disadvantages of ORDBMSs
simplicity of SQL
All of the followings are type of attribute, excepts
single attribute
Which one should not use when choosing an index
that consist of long character strings
The followings are characteristics of the information extracting from database by using data mining tools, excepts
unxepected
