Which of the following is not a database object in MS Access?
Reports
Relationships
Tables
Queries
Q.2.
A DBMS that combines a DBMS and an application generator is ________ .
Microsoft's SQL Server
Microsoft's Access
IBM's DB2
Oracle Corporation's Oracle
Q.3.
________ is an open source DBMS product that runs on UNIX, Linux and Windows.
MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS
Q.4.
If no multivalued attributes exist and no partial dependencies exist in a relation, then the relation is in what normal form?
First normal form
Second normal form
Third normal form
Fourth normal form
Q.5.
Which of the following is not true about cloud computing?
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.6.
A composite attribute is which of the following?
An attribute that can be broken into components
An attribute that cannot be broken into components
Multiple attributes
An identifier
Q.7.
What are the notations used in Evaluation of Arithmetic Expressions using prefix and postfix forms?
Polish
Reverse Polish
Both A and B
None of the above
Q.8.
When mapping a supertype/subtype relationship which of the following is true?
The supertype primary key is assigned to each subtype.
The subtype primary key is assigned to each supertype.
There is no link between the supertype/subtype entities.
There is no primary key/foreign key relationship between a supertype/subtype.
Q.9.
With this type of SQL Server cursor concurrency no lock is obtained until the user updates the data.
READ_ONLY
SCROLL_LOCK
OPTIMISTIC
PESSIMISTIC
Q.10.
The different classes of relations created by the technique for preventing modification anomalies are called:
normal forms.
functional dependencies.
referential integrity constraints.
None of the above is correct.
Q.11.
The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T ;
Equi-join
Natural join
Outer join
Cartesian join
Q.12.
It is necessary to sort a file before searching a particular item
True
False
May or may not be true
None of the above
Q.13.
When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):
LIKE only.
IN only.
NOT IN only.
Both IN and NOT IN.
Q.14.
Which of the following products implemented the CODASYL DBTG model?
IDMS
DB2
dBase-II
R:base
Q.15.
When assessing the table structure of an acquired set of tables with data, accessing the validity of possible referential integrity constraints on foreign keys is (part of) the:
first step.
second step.
third step.
fourth step.
Q.16.
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.17.
A data dictionary is a special file that contains
The width of all fields in all files
The data type of all fields in all file
The name of all fields in all files
All of the above
Q.18.
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.19.
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 (GE
Q.20.
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.
Support mcqgeeks.com by disabling your adblocker.
Please disable the adBlock and continue. Thank you.