Which of the following is not true about cloud computing
Cloud-based management platforms can support multiple cloud-virtual server vendors
Cloud-based management platforms can support change management methodologies
Cloud-based management platforms cannot support internally hosted server platforms
Cloud-based management platforms can support multiple cloud-virtual server operating systems
Which of the following describes a relational database
It retrieves data related to its queries
It provides a relationship between integers
It consists of separate tables or related data
It provides a relationship between floats
The command to eliminate a table from a database is
UPDATE TABLE CUSTOMER;
DELETE TABLE CUSTOMER;
REMOVE TABLE CUSTOMER;
DROP TABLE CUSTOMER;
Which of the following is not a database object in MS Access
A collection of interrelated records is called a
The benefits of object-oriented modeling are which of the following
The ability to tackle more challenging problems
Improved communication between users, analysts, etc.
All of the above.
Reusability of analysis, design, and programming results
A proxy server is used for which of the following
To process client requests for database access
To provide TCP/IP
To process client requests for Web pages
To provide security against unauthorized users
The following SQL is which type of join: SELECTCUSTOMER_T.
CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
When mapping a supertype/subtype relationship which of the following is true
There is no link between the supertype/subtype entities.
The subtype primary key is assigned to each supertype.
There is no primary key/foreign key relationship between a supertype/subtype.
The supertype primary key is assigned to each subtype.
A transitive dependency is which of the following
A relation that is in second normal form.
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.
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form
Second normal form
Third normal form
First normal form
Fourth normal form
A ternary relationship involves how many entities
More than 3
3 or less
3 or more
A composite attribute is which of the following
An attribute that cannot be broken into components
An attribute that can be broken into components
A shared database should
All of the above.
provide for backup and recovery.
be accurate and available.
Legacy data is which of the following
Data contained in a file system
Data contained by a system used prior to the installation of a new system
Data rejected during the installation of a new system
Data contained in a newly-installed system
________ is an open source DBMS product that runs on UNIX, Linux and Windows
Which JDBC driver Type(s) is
(are) the JDBC-ODBC bridge
Which of the following are goals of OLE DB
All of the above as goals of OLE DB.
Object interface over any type of data only.
Create object interfaces for DBMS functionality pieces only.
Increase flexibility only.
The ODBC Level 1 API contains which of the following functions
Both 1 and 3 above are in the OBDC Level 1 API.
Process a scrollable cursor only
Browse possible connections and data sources only
Connect to data sources with driver-specific information only
________ is a simple object model that is easier to understand and use than OLE DB, and is frequently used for database applications
take a quick Quiz
Practice mcqs on Database
pick difficulty level
Relational Database Management SystemRDB
Relational Database Management System
MySQL Database Select Statement
MySQL Database Tables and Datatypes
MySQL Database Nulls and Conditions
MySQL Database Query Clauses
Oracle Database 11g Architecture Options
Oracle Database SQL Basics
Oracle Database Planning Oracle Applications
we serve best when javscript is enabled