BLUE PARADISE BLUE PARADISE
Para los fans de la Animación, Música, VG y Arte
 
 chatChat   BuscarBuscar   MiembrosMiembros   Grupos de UsuariosGrupos de Usuarios   RegistrarseRegistrarse 
 PerfilPerfil   Entre para ver sus mensajes privadosEntre para ver sus mensajes privados   LoginLogin 




SSD7 Quizzes

 
Publicar nuevo tema   Responder al tema Foros de discusión -> ICARNEGIE
Ver tema anterior :: Ver tema siguiente  
Autor Mensaje
aoikokoro
Blue God & Genius Magician
Blue God & Genius Magician


Registrado: 31 Dic 2006
Mensajes: 185
Ubicación: México, Querétaro.



MensajePublicado: Vie May 22, 2009 12:18 am    Asunto: SSD7 Quizzes Responder citando

QUIZZ DE OPCION MULTIPLE 1

1. An E-Commerce database contains data about customers, products, orders, system response times, etc. Which of the following can be specified as integrity constraints in an E-Commerce database system?

1. No two products can have the same product ID.
2. The DBMS response time for all Web requests should be at most 2 seconds.
3. A customer order cannot have more than one shipping address.


(d) I and III only


2. In a database system, whose responsibility is it to provide data consistency?

(a) the DBMS's

3. An E-Commerce system consists of the following components. Which of these same components must be included in a database?

1. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
2. A database must include a collection of programs that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains.
3. A database must include a collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc.


(b) I only



4. An E-Commerce system consists of the following components. Which of these same components will constitute a database system?

1. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
2. A collection of programs that control the data, such as programs to create, maintain, and manipulate the data constitutes a database system. These programs can be easily used to create, maintain, and manipulate data in other domains such as in a library information system.
3. A collection of programs that operate on the data, but are specific to the E-commerce system, constitutes a database system. These programs enable users to browse through the store-items, place orders, track shipping, etc.



(b) I, II, and III


5. An E-Commerce system consists of the following components. Which of the same components must be included in a database management system?

1. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
2. A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains, such as in a library information system.
3. A collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc.

(d) II only

6. A database is needed for which of the following application scenarios?

1. A video store that needs to keep track of data about members, about videos carried by the store, about videos rented by members, as well as data concerning borrow-date, return-date, and payment information.
2. In the human resources department of a company, information about employees, their titles, their salaries and sick days, and about vacation days taken by each employee.
3. A computer-simulated video game which needs to calculate and display, the physical (x, y) location of each actor in the game, the speed with which they are moving at the current instant, the direction in which they are moving, the action they are performing, the angle at which the game-player is viewing the scene.

(d) I and II only


7. The physical storage structure will be _____ to the application programmer in a database approach, and will be _____ to the application programmer in a file system approach.

(d) hidden, visible


An E-Commerce system consists of the following components. Which of the same components must be included in a database management system?

1. The data, such as information about the goods available for sale, customers, orders placed, shipping information, etc.
2. A collection of programs must be included that control the data, such as programs to create, maintain, and manipulate the data. These programs can be easily used to create, maintain, and manipulate data in other domains, such as in a library information system.
3. A collection of programs that operate on the data, but are specific to the E-commerce system. These programs enable users to browse through the store-items, place orders, track shipping, etc.


(d) II only

QUIZZ DE OPCION MULTIPLE 2


1. The foreign key in a table T1 _____ the same _____ as the corresponding primary key in table T2.

1. must have, name
2. need not have, name
3. must have, domain

(b) II and III

2. The cardinality of a table is the number of _____ in the table.

(d) rows

3. What information is necessary when specifying the structure of a table?

(c) the name of the table, the names of the table's attributes, the data types of attributes, and the formats of attributes

4.The degree of a table is the number of _____ in the table.

(c) columns

5.The SQL clause to perform a set difference operation is

(d) EXCEPT

6. What can be specified in the selection condition of a SELECT statement?

(d) a Boolean operation

7. Which of the following SQL statements can be used to remove a row from a table?

(b) DELETE

8. DML is used to

(c) add/modify/delete data in the database.

9. Which of the following SQL statements can be used to create a relational table?

(a) CREATE

10. With Query By Example, a user enters a query by

(d) filling in skeleton tables of the database with examples of what is to be retrieved


For two tables to be union compatible, the tables should be the same with respect to which of the following?

(c) degree


Which of the following SQL statements can be used to add a row to a table?

(b) INSERT

9. The SQL clause to perform a set UNION operation is

(c) UNION

The term query by example refers to

(c) a visual query language developed by IBM

A difference operation can be applied to tables that

(c) are union compatible

A join operation joins _____ tables into _____.

(c) two, one

The arity of a table is the number of _____ in the table.

(d) columns


Which of the following SQL statements can be used to modify just one row (out of many rows) in a table?

(a) UPDATE

QUIZZ DE OPCION MULTIPLE 3


In SQL, a database can be created by which of the following?

(d) the command CREATE SCHEMA

2. In SQL, when destroying a database, the RESTRICT option removes

(a) the schema if the database has no data (empty tables)

3. When a string whose length is strictly less than n is entered as the value of a field whose SQL data type is VARCHAR(n), the system responds by

(a) storing the string as is.

4. In SQL, a database can be destroyed by which of the following?

(a) the command DROP SCHEMA

5. In SQL, when destroying a database, the CASCADE option removes

(c) everything in the specified database: the data, schema, etc.

6. In SQL, one function of the AS operator is to

(d) customize the names of columns in a query’s result

7. In SQL, which of the following operators can be used to express searches that test for a range in a selection condition?

(a) BETWEEN

8. When specifying a selection criterion in SQL, attributes can be renamed with which of the following operators?

(d) AS

9. In SQL, which of the following clauses can be used to sort results in ascending or descending order of attribute values?

(b) ORDER BY


10. In a FROM clause of a SELECT statement in SQL, a table can be aliased with which of the following operators?

(c) AS


When removing a table from the schema, using the RESTRICT option would

(c) remove the table if there are no references to it

QUIZZ DE OPCION MULTIPLE 4

Which of the following is true about updateability of views?

(a) A view is updateable if it involves one table and contains a key.

2. Which of the following is true about views being up to date?

(c) Views are always up to date.

3. A horizontal view allows users access to

(d) only specific rows of the defining tables

4. Consider two tables, Employee(EmpNo, Name, DeptNo) and Department(DeptNo, Name, Manager) with primary keys being EmpNo and DeptNo respectively. The DeptNo attribute of the Employee table has a NOT NULL constraint and is a foreign key that references the DeptNo attribute of the Department table. The Manager attribute of the Department table has a NOT NULL constraint and is a foreign key that references the EmpNo attribute of the Employee table. When the tables are empty, the only way to insert rows into the two tables is

(b) to use a transaction in DEFERRABLE mode

5.Which of the following referentially triggered actions are supported in SQL when a referential integrity constraint is violated?

SET NULL
REJECT
CASCADE
SET DEFAULT

(b) I, III, and IV only

6. Which of the following commands can be used to give access permissions to a table?

(c) GRANT

7. Which of the following commands can be used to remove access privileges associated with a table?

(b) REVOKE

8. Who can always give access permissions to a table?

(d) the owner of the table

9. When is embedded SQL referred to as dynamic SQL?

(b) when the embedded SQL is translated into DBMS calls at run-time

10. When is embedded SQL referred to as static SQL?

(c) when the embedded SQL is translated into DBMS calls at compile-time


The SQL keyword _____ makes the modifications of the transaction permanent, while the SQL keyword _____ discards the modifications of the transaction.

COMMIT, ROLLBACK

QUIZZ DE OPCION MULTIPLE 5


In the Entity-Relationship model, the degree of a relationship specifies which of the following?

(b) The number of entities that participate in the relationship

2. Which of the following is true about storage for derived attributes?

(d) Derived attributes are usually not stored because they can be computed.

3. In the Entity-Relationship model, properties that characterize entities and relationships are modeled as

(c) attributes

4. In the Entity-Relationship model, a derived attribute is one

(b) whose value can be computed from the values of other attributes

5. In an ER model, which of the following is true about a component attribute?

(d) A component attribute can be a composite attribute.

6. What is an identifying owner in an ER model?

(d) The entity upon which a weak entity's existence depends

7. In an ER model, what is a recursive relationship type?

(c) The type of relationship between entities of one entity type

8. In EER modeling, generalization is the process of generating
I
(d) superclasses out of subclasses

9. When mapping from an ER model to a relational model, a strong entity is mapped into a

(c) table

10. Which of the following is true about attributes in a relational model?

Attributes can be multi-valued.
Attributes can be composite.

(d) Neither I nor II

A weak entity type implies a

(d) relationship with total participation constraint

QUIZZ DE OPCION MULTIPLE 6

Consider the following functional dependency.

{A, B} -> {C}

Regarding this dependency, which of the following statements is (are) true?

1. The values of C are uniquely determined by the values of A.
2. The values of A are uniquely determined by the values of C.

(d) None

2. Which of the following is a property (are properties) exhibited by good relational schemas?

1. The use of null values in tuples
2. The grouping of as many attributes as possible into one main table
3. The elimination of data redundancy to avoid update anomalies

(c) III only

3. Which of the following problems can be caused by data redundancy in a relational schema?

1. Inefficient use of space
2. Update anomalies and possible loss of data
3. Inefficient use of processing time

(b) I, II, and III

4. Through normalization, data redundancy

(d) can be eliminated

5. Through normalization, update anomalies

(c) can be eliminated

6. The FD X -> Y is a full dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.

(a) no, removed from

7. For a relation to be in 3NF, it should not contain _____ attribute that is transitively dependent on _____.

(b) a non-primary key, the primary key

8. For a relation to be in 2NF, _____ attribute must be fully functionally dependent on _____.

(a) every non-primary-key, the primary key

9. Consider a table with atomic attributes A, B, and C and the following functional dependencies.

A -> B
B -> C

If the primary key of this table is attribute A, then this relation satisfies which of the following normal forms?

First
Second
Third

(d) I and II only

10. The FD X -> Y is a partial dependency in a relation R, if there is _____ attribute A that can be _____ X and the dependency still holds.

(b) at least one, removed from

Which of the following statements concerning normal forms is true?

(a) A relation that is in second normal form is also in first normal form.

QUIZZ DE OPCION MULTIPLE 7

Is it possible for a valid transaction to see the modified, yet uncommitted data of another valid transaction when the isolation level is set to SERIALIZABLE?

(b) It is not possible for a transaction to see the modified, yet uncommitted, data of another transaction, even if both transactions are working on the same data, and even if both transactions are concurrent.

2. All changes made by a committed transaction can be recovered

(a) irrespective of whether there have been hardware or software failures

3. A livelock occurs when

(d) a transaction is aborted and restarted repeatedly

4. The strict two-phase locking protocol is _____ to implement.

(c) the easiest two-phase locking protocol

5. In a two-phase locking protocol, what happens during the shrinking phase?

(c) The transaction cannot acquire locks, but can release its locks.

6. An exclusive lock on a data item represents permission to perform which of the operations, read and write, on the data item?

(c) Both read and write

7. In a two-phase locking protocol, what happens during the growing phase?

(d) The transaction can acquire locks, but cannot release its locks.

8. During recovery, in which of the following ways are the before and after images used by the undo and redo actions?

undo action uses the before image
undo action uses the after image
redo action uses the after image
redo action uses the before image

(d) I and III only

9. Immediate update policy _____ undo actions, and deferred update policy _____ undo actions.

(b) requires, does not require

10. Force propagation policy _____ redo actions, and no-force propagation policy _____ redo actions.

(d) does not require, requires

QUIZZ DE OPCION MULTIPLE 8

Collisions occur in hashing when

(a) a new record hashes to a location already occupied by an existing record

2. Hashing exhibits the best performance for

(d) equality searches involving the key, provided the key is used for hashing

3. Which of the following are properties of a good hash function?

It should be computed efficiently.
It should minimize the number of collisions by spreading keys as evenly and uniformly as possible.
It should always use the Modulo (MOD) function.

(b) I and II only

4.A sparse index contains entries for

(d) some records of a table

5. A secondary index is an index defined on a(n) _____ field.

(d) non-ordering

6. A primary ISAM is a _____ index, and a secondary ISAM is a _____ index.

(d) sparse, dense

7. A cylinder of a multi-platter hard disk consists of

(c) tracks with the same diameter

8. The term blocking factor refers to the number of

(b) database records that can be stored on a disk block

9. To improve the performance of a database,

(b) minimize the amount of data transferred between secondary storage and main memory

10. Which of the following can be used to measure hard disk drive performance?

Seek time
Rotational latency
Block transfer time

(b) I, II, and III


The term block transfer time refers to the amount of time it takes to

(c) read data from a disk

Each index entry in an index file contains

an indexing value
a pointer to the page where the record with the value appears
an indexing function

(c) I and II only

How does chained overflow solve the problem of collisions in hashing?

(c) The first available slot in a linked list of overflow buckets that is connected to the hashed bucket is used.

A primary index _____ defined on a key field, and a secondary index _____ defined on a key field.

(a) should be, need not be

Where do heap files add new records?

(d) at the end of the heap file

QUIZZ DE OPCION MULTIPLE 9

In SQL3, inheritance is specified using which of the following keywords?

(d) UNDER

2. Which of the following is an ordered collection?

1. SET
2. LIST
3. MULTISET

(d) II only

3. Which of the following is true about the support for inheritance in Object-Relational models?

(b) Both single inheritance and multiple inheritance are supported.

4. In an Object-Relational model, which of the following data types are supported?

1. user-defined data types
2. ROW types
3. time-series data types

(a) I and II only

5. Spatial data is _____-dimensional data.

(a) multi

6. Which of the following are valid operations performed on spatial data?

1. object overlap
2. object containment
3. object visibility

(d) I and II only

7. Which of the following data models currently have the predominant market share?

(c) relational

8. What is a drill-down operation in a data warehouse application?

(a) Deriving a fine-grained view, i.e., a disaggregated view along a particular dimension

9.A star schema in a data warehouse context refers to which of the following?

(b) A central fact table and a number of dimension tables

10. Which of the following is the predominant data type that is encountered in OLAP databases?

(d) multi-dimensional

_________________

"Everyone is... Well, you know what, for Bridget... Also for Genis and Gaara, jeje"
Play-Asia.com - Your One-Stop-Shop for Asian Entertainment
AOIPLANET
Volver arriba
Ver perfil de usuario Enviar mensaje privado Enviar email Visitar sitio web del autor Yahoo Messenger MSN Messenger
Mostrar mensajes de anteriores:   
Publicar nuevo tema   Responder al tema    Foros de discusión -> ICARNEGIE Todas las horas son GMT
Todas las horas son GMT
Página 1 de 1


Cambiar a:  
Puede publicar nuevos temas en este foro
No puede responder a temas en este foro
No puede editar sus mensajes en este foro
No puede borrar sus mensajes en este foro
No puede votar en encuestas en este foro



Mapa del sitio - Powered by phpBB © 2001, 2007 phpBB Group

Crear foro gratis | foros de Colecciones | Hosting gratis | soporte foros | Contactar | Denunciar un abuso | FAQ | Foro ejemplo

Para hosting especialidado en foros phpbb ssd en Desafiohosting.com