DBW Final

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

ACCT 1010 Proctored Exam Two Ch 5-10

View Set

PLAGIARISM: Appropriate Quotation (MLA 2016 Style)

View Set

Human resource management chaps 5, 6 ,7 ,8

View Set

Transformers Level II Lesson 4: Understanding Transformer Overcurrent Protection (22 Questions; Third Year)

View Set

Ch 18 Cognitive Behavior Therapy

View Set

Moral Distress vs. Ethical Dilemma vs. Locus of Authority

View Set