Q.1

Of the three ways to create an Oracle database, which one is the easiest and most recommended?

  • Using the Oracle Database Configuration Assistant.
  • Using the Oracle-supplied database creation procedures.
  • Using the SQL CREATE DATABASE command.
  • None of the above is correct.
Q.2

 Which of the following occurs when a transaction rereads data it has previously read and finds modification or deletions caused by a committed transaction?

  • Nonrepeatable read
  • Phantom read
  • Dirty read
  • Consistent read
Q.3

To eliminate definition duplication, XML Schemas define:

  • an intersection table.
  • global elements.
  • a normalized definition table.
  • None of the above is correct.
Q.4

Which of the following is not true about cloud computing?

which_of_the_following_is_not_true_about_cloud_computing1539240737.jpg image

  • Cloud-based management platforms cannot support internally hosted server platforms
  • Cloud-based management platforms can support multiple cloud-virtual server vendors
  • Cloud-based management platforms can support multiple cloud-virtual server operating systems
  • Cloud-based management platforms can support change management methodologies
Q.5

We Can still delete a row from primary table if there are related rows in secondary table once a refferential integrity is enforced

  • TRUE
  • FALSE
Q.6

Physical data models describe the details of how data is stored in the computers

  • TRUE
  • FALSE
Q.7

Cloud computing is not suited for situations

  • where complex legacy systems have to be ported
  • characterized by limited-time tasks
  • involving offloading of expensive computing tasks
  • with no existing regulatory compliance issues
Q.8

The no of entities participating in a relation is called

  • Relation
  • Degree of relationship
  • Recursive relationship
  • None of the above
Q.9

Which among the following is the disadvantage of circular list?

  • An info field that contains the information stored in the node
  • Can’t traverse the list backward
  • A pointer to the node is given we cannot delete the node
  • Both 2 and 3
Q.10

 In enterprise data modeling, which is incorrect?

  • You review current systems.
  • You implement the new database.
  • You describe the data needed at a very high level of abstraction.
  • You plan one or more database development projects.
Q.11

Which among the following is the relationship constraints

  • Cardinality ratio
  • Participation constraints
  • Both A and B
  • None of the above
Q.12

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?

  • Supertype entity
  • Subtype entity
  • Archetype entity
  • Instance entity
Q.13

 A reason for using an SQL view to hide columns is:

  • to simplify a result only.
  • to prevent the display of sensitive data only.
  • to accomplish both of the above.
  • None of the above are reasons for using an SQL view.
Q.14

Which of the following indicates the maximum number of entities that can be involved in a relationship?

  • Minimum cardinality
  • Maximum cardinality
  • ERD
  • Greater Entity Count (GEC)
Q.15

 A transitive dependency is which of the following?

  • A functional dependency between two or more key attributes.
  • A functional dependency between two or more nonkey attributes.
  • A relation that is in first normal form.
  • A relation that is in second normal form.
Q.16

A ternary relationship involves how many entities?

  • 3 or less
  • 3
  • More than 3
  • 3 or more
Q.17

The capacity to change the conceptual schema without having to change external schemas or application programs is called

  • Physical Data Independence
  • Logical Data Independence
  • Both A and B
  • None
Q.18

The benefits of object-oriented modeling are which of the following?

  • The ability to tackle more challenging problems
  • Reusability of analysis, design, and programming results
  • Improved communication between users, analysts, etc.
  • All of the above.
Q.19

The ODBC core API consists of which of the following functions?

  • Commit or rollback transactions only
  • Connect to data sources only
  • Connect to data sources with driver-specific information only
  • Both 1 and 2 above are in the OBDC core API.
Q.20

The command to eliminate a table from a database is

  • REMOVE TABLE CUSTOMER;
  • UPDATE TABLE CUSTOMER;
  • DELETE TABLE CUSTOMER;
  • DROP TABLE CUSTOMER;
0 h : 0 m : 1 s