Question Answer
Wwwworldandknowledge.blogspot.com
The database lifecycle consists of
Select one:
a. the states of the database before and after each database application has been executed on the database
b. all stages starting from requirements analysis, design, implementation and maintenance of an operating database
c. all different states of the database, corresponding to the operations performed on it
d. requirements analysis, conceptual, logical and physical design of the database
Feedback
The correct answer is: all stages starting from requirements analysis, design, implementation and maintenance of an operating database
Question 2
Question text
Suppose that two relations R(A, B) and S(A, B) have exactly the same schema. Consider the following equalities in relational algebra? I. R ∩ S = R - (R - S) II. R ∩ S = S - (S - R) III. R ∩ S = R NATURAL-JOIN S IV. R ∩ S = R x S Which of the equalities hold in relational algebra?
Select one:
a. I, II, III and IV
b. I and II only
c. I, II and III
d. I only
Feedback
The correct answer is: I, II and III
Question 3
Question text
:_____________determine the requirements of end users, especially naive and parametric end users, and develop specifications for standard canned transactions that meet these requirements.
Select one:
a. System Analysts
b. Business Analysts
c. None of the above
d. Data Analysts
Feedback
The correct answer is: System Analysts
Question 4
Question text
The database model that utilizes multiple tables interconnected through common attributes to store and manage information is called a:
Select one:
a. Network Database
b. Matrix Database
c. class Database
d. Relational Database
Feedback
The correct answer is: Relational Database
Question 5
Question text
. The relationship types where the same entity types participates more than once in different roles are called as
Select one:
a. Binary relationships
b. Simple relationships
c. Recursive relationships
d. Ternary relationships
Feedback
The correct answer is: Recursive relationships
Question 6
Question text
:Which of the following is said to be non procedural DMLs?
Select one:
a. DDL
b. DCL
c. TCL
d. Declarative DMLS
Feedback
The correct answer is: Declarative DMLS
Question 7
Question text
What does DML stand for?
Select one:
a. Data Model Language
b. Data Manipulation language
c. Data Mode Lane
d. Different Mode Level
Feedback
The correct answer is: Data Manipulation language
Question 8
Question text
:Assume you are creating a database to handle the data associated with instruction at a university. What is the most appropriate special association to model that a student's schedule consists of multiple classes?
Select one:
a. reflexive association
b. generalization association
c. n-ary association
d. aggregation association
Feedback
The correct answer is: aggregation association
Question 9
Question text
The ability to modify the data structure and not have to change the programs using that data is called:
Select one:
a. data dictionary
b. data independence
c. referential integrity
d. data integrity
Feedback
The correct answer is: data independence
Question 10
Question text
What is the purpose of the SQL operator IN?
Select one:
a. Specifies that the sort order should be increasing
b. Used to test if one value appears in a set of values
c. Indicates which table each field can be found
d. Used in the GROUP BY statement to indicate sub-groups
Feedback
The correct answer is: Used to test if one value appears in a set of values
Question 11
Question text
Why is it a good idea to use special associations when drawing class diagrams?
Select one:
a. They convey more information about the underlying structure of the database, making them easier to understand
b. Specialized tools are available to create these special associations
c. It is necessary. It is impossible to draw some diagrams without using these special structures
d. They hide the detail concerning the database structure, making them easier to understand
Question 12
Question text
In an E-R diagram double lines indicate
Select one:
a. Cardinality N.
b. Multiple participation.
c. None of the above
d. Total participation.
Feedback
The correct answer is: Total participation.
Question 13
Question text
During the ______ design phase of database design, the properties of data is given importance, rather than its storage details.
Select one:
a. actual
b. conceptual
c. logical
d. physical
Feedback
The correct answer is: conceptual
Question 14
Question text
_______ operation can be visualized as a horizontal partition of the relation into two set of tuples.
Select one:
a. PROJECT
b. JOIN
c. SELECT
d. PARTITION
Feedback
The correct answer is: SELECT
Question 15
Correct
Question text
Which of the following products was the first to implement true relational algebra in a PC DBMS?
Select one:
a. dBase – II
b. R:base
c. IDMS
d. DB2
Feedback
The correct answer is: R:base
Question 16
Question text
A relation is
Select one:
a. members of an entity set or a relationship set
b. members of a relationship set
c. a relationship
d. an entity
Feedback
The correct answer is: members of an entity set or a relationship set
Question 17
Question text
The NULL SQL keyword is used to ...
Select one:
a. represent a missing or unknown value. NULL in SQL represents nothing
b. represent positive infinity
c. represent negative infinity
d. represent 0 value
Feedback
The correct answer is: represent a missing or unknown value. NULL in SQL represents nothing
Question 18
Question text
What is the purpose of the SQL clause BETWEEN?
Select one:
a. To modify the JOIN command
b. To establish the sequence of columns for a query
c. Impose a query constraint covering a range of values
d. Indicate that two tables have an association
Feedback
The correct answer is: Impose a query constraint covering a range of values
Question 19
Question text
__________ are responsible for identifying the data to be stored in the database and for choosing appropriate structures to represent and store this data.
Select one:
a. Database Designers
b. DBA
c. Casual Users
d. Database programmers
Feedback
The correct answer is: Database Designers
Question 20
Question text
__________applications that store information such as economic data at regular points in time, such as daily sales and monthly gross national product figures
Select one:
a. DBMS
b. Time series
c. Database
d. Data
Feedback
The correct answer is: Time series
Question 21
Question text
Which DataAdapter Query Type can be used with the Access database?
Select one:
a. All of the given choices.
b. create new stored procedure.
c. two of the given choices.
d. Use existing stored procedure.
e. Use SQL statements.
Feedback
The correct answer is: Use SQL statements.
Question 22
Question text
A database in which data is stored on several computers is called a
Select one:
a. multidatabase
b. client-server database
c. network database
d. distributed database
Feedback
The correct answer is: distributed database
Question 23
Question text
If there is a relationship between two tables, this indicates that:
Select one:
a. the structure of the one table is inherited from the other table
b. the data contained in the two tables are related to each other in some way
c. the data from one table is inherited from the other table
d. information from both tables is always used together
Feedback
The correct answer is: the data contained in the two tables are related to each other in some way
Question 24
Question text
A timetable database is required for a University Department. Each taught event is part of a module, each event will have exactly one member of staff associated and several individual students. Each event takes place in a single weekly time slot. Each time slot has a day of the week and a time of day associated. Which of the following is the best approach to implementing the attends relation using a relational database system?
Select one:
a. A table attends contains an event/student pair for every instance of a student attending an event
b. A repeating field attends is included as part of the student table
c. None of the Given Choices
d. A secondary attends key is added to the event table
e. A repeating field attends is included as part of the event table
Feedback
The correct answer is: A table attends contains an event/student pair for every instance of a student attending an event
Question 25
Question text
Degree of a relation is
Select one:
a. All of the given choices
b. Number of columns in the relation
c. Number of rows in the relation
d. Number of tables in the database
Feedback
The correct answer is: Number of rows in the relation
No comments:
Post a Comment