Questions
wwwworldandknowledge.blogspot.in
__________provide concepts that are close to the way many users perceive data
Select one:
a. None of the above
b. Physical Data Models
c. Conceptual data models
d. Objective Data models
Feedback
The correct answer is: Conceptual data models
Question 2
Question text
. A dependency exist between two columns when
Select one:
a. The table is in 3NF
b. Together they constitute a foreign key
c. Knowing the value in one column determines the value stored in another column
d. Together they constitute a composite key for the table
Feedback
The correct answer is: Together they constitute a composite key for the table
Question 3
Question text
Several contiguous blocks are called as ---------------
Select one:
a. None of the given choices
b. Buffer
c. Cluster
d. Group
Feedback
The correct answer is: Cluster
Question 4
Question text
Select one:
a. i and iii
b. ii and iii
c. i and ii
d. iii and iv
Feedback
The correct answer is: i and iii
Question 5
Question text
Relationships are identified from the word statement of a problem by
Select one:
a. picking words which are nouns
b. picking words which are pronouns
c. picking words which are verbs
d. picking words which are adjectives
Feedback
The correct answer is: picking words which are verbs
Question 6
Question text
Which of the following is top down approach
Select one:
a. Generalization
b. None of the given choices
c. Specialization
d. Categorization
Feedback
The correct answer is: Specialization
Question 7
Question text
__________are the people whose jobs require access to the database for querying, updating, and generating reports
Select one:
a. Casual Users
b. End users
c. Scientific users
d. Parametric Users
Feedback
The correct answer is: End users
Question 8
Question text
Consider the relation given below and ind the maximum normal form applicable to them. 1. R(A, B) with productions { A --> B }; 2. R(A, B) with productions { B --> A }; 3. R(A, B) with productions {A —> B, B --> A }; 4. R(A, B, C) with productions {A -->B, B --> A, AB --> C }
Select one:
a. 1 and 2 are in BCNF and 3 and 4 are in 3NF
b. All are in 3NF
c. All are in BCNF
d. 1, 2 and 3 are in 3NF and 4 is in BCNF
Feedback
The correct answer is: All are in BCNF
Question 9
Question text
The database schema is written in
Select one:
a. DDL
b. DCL
c. DML
d. HLL
Feedback
The correct answer is: DDL
Question 10
Question text
What is the benefit of using a query language rather than a nature language to get information out of a database?
Select one:
a. Query languages allow the user to pose unstructured, open ended queries
b. Query languages are more flexible than natural language
c. Query languages are more precise so there is less room for misinterpretation
d. There is no benefit of query languages over natural languages for getting information out of a database.
Question 11
Question text
A table has fields F1, F2 , F3 , F4, F5 with the following functional dependencies F1--> F3, F2 —> F4, (FI,F2) —> F5 In terms of normalization, this table is in
Select one:
a. 3 NF
b. BCNF
c. 2 NF
d. 1 NF
Feedback
The correct answer is: 1 NF
Question 12
Question text
What is the usual block size range ?
Select one:
a. 5120 bytes to 40960 bytes
b. None of the given choices
c. 512 KB to 4096 KB
d. 512 bytes to 4096 bytes
Feedback
The correct answer is: 512 bytes to 4096 bytes
Question 13
Question text
What is the expansion of ISAM ?
Select one:
a. Index access method
b. Internal storage access method
c. Integrated storage & management
d. None of the given choices
Feedback
The correct answer is: Index access method
Question 14
Question text
Which of the following is a collision resolution method ?
Select one:
a. All of the given choices
b. Chaining
c. Multiple hashing
d. Open addressing
Feedback
The correct answer is: All of the given choices
Question 15
Correct
Question text
Which below is specified by the DataSource Property?
Select one:
a. connection object
b. DataAdapter object
c. Dataset object
d. Database table
e. Database field
Feedback
The correct answer is: Dataset object
Question 16
Question text
The relational algebra operations enable a user to specify basic _______ requests.
Select one:
a. entry
b. construct
c. modification
d. retrieval
Feedback
The correct answer is: retrieval
Question 17
Question text
The ______ operator is used to compare a value to a list of literals values that have been
Select one:
a. IN
b. ALL
c. ANY
d. BETWEEN
Feedback
The correct answer is: BETWEEN
Question 18
Question text
The data dictionary/repository contains:
Select one:
a. all of the given choices.
b. help files for working with databases
c. all the data contained in the database
d. definitions of all the tables, columns, data domains and assumptions used in the database
Feedback
The correct answer is: definitions of all the tables, columns, data domains and assumptions used
in the database
Question 19
Question text
Pick entities from the following: i:vendor ii:student iii:attends iv: km/hour
Select one:
a. iii and iv
b. i, ii, iii
c. i and ii
d. i, ii, iv
Feedback
The correct answer is: i and ii
Question 20
Question text
Consider the relation Emps(empID, ssNo, name, mgrID) giving for a set of employees their employee ID (assumed unique), their social-security number (also unique), the name of the employee (not necessarily unique, and the employee ID of the manager of the employee. Assume that the president is his/her own manager, so every employee has a unique manager. You may assume there are no duplicate tuples in this relation. Here are two possible ways to declare the relation Emps. I. CREATE TABLE Emps (empID INT,ssNo INT,name CHAR(50), mgrID INT, UNIQUE (empID), PRIMARY KEY (ssNo), FOREIGN KEY mgrID REFERENECES Emps (empID)); II. CREATE TABLE Emps ( empID INT PRIMARY KEY, ssNo INT UNIQUE, name CHAR(50), mgrID INT REFERENECES Emps (empID)); Which, if any, of the two declarations above will correctly (in SQL2) declare the relation Emps?
Select one:
a. II only
b. I only
c. Both I and II
d. Neither I nor II
Feedback
The correct answer is: II only
Question 21
Question text
A relationship is
Select one:
a. a meaningful dependency between entities
b. a collection of related entities
c. an item in an application
d. related data
Feedback
The correct answer is: a meaningful dependency between entities
Question 22
Question text
Which is a bottom-up approach to database design that design by examining the relationship between attributes:
Select one:
a. Functional dependency
b. Decomposition
c. Normalization
d. Database modeling
Feedback
The correct answer is: Normalization
Question 23
Question text
Consider the following relational schemes for a library for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) Which ofthe following functional dependecies: I. Title Author —› Catalog no. II. Catalog_no ---> Title Author Publisher Year III. Publisher Title Year --> Price. Assume {Author, Title) is the key for both schemes: which ofthe following statements is true?
Select one:
a. Both Book and collection are in 3NF only
b. Book is in 2NF and Collection is in 3NF
c. Both Book and collection are in BCNF
d. Both Book and Collection are in 2NF only
Feedback
The correct answer is: Book is in 2NF and Collection is in 3NF
Question 24
Question text
Another name for hash function is -----
Select one:
a. Randomising
b. Arithmetic
c. None of the given choices
d. Exponential
Feedback
The correct answer is: Randomising
Question 25
Question text
The language used in application programs to request data from the DBMS is referred to as the
Select one:
a. DML
b. VDL
c. SDL
d. DDL
Feedback
The correct answer is: DML
No comments:
Post a Comment