Sawaal

 Database Questions

Popular Latest Rated
Q:

A data dictionary is a special file that contains

A) The width of all fields in all files B) The data type of all fields in all file
C) The name of all fields in all files D) All of the above
 
Answer & Explanation Answer: D) All of the above

Explanation:

A data dictionary is a special file that contains a set of information describing the contents, format, and structure of a database and the relationship between its elements, used to control access to and manipulation of the database.

Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: Bank Exams
Job Role: Analyst , Bank Clerk , Database Administration , IT Trainer

7 6137
Q:

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

A) to simplify a result only. B) to prevent the display of sensitive data only.
C) to accomplish both of the above. D) None of the above are reasons for using an SQL view.
 
Answer & Explanation Answer: C) to accomplish both of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 6106
Q:

 A transitive dependency is which of the following?

A) A functional dependency between two or more key attributes. B) A functional dependency between two or more nonkey attributes.
C) A relation that is in first normal form. D) A relation that is in second normal form.
 
Answer & Explanation Answer: B) A functional dependency between two or more nonkey attributes.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

4 5836
Q:

 What SQL command will allow you to change the table STUDENT to add the constraint named GradeCheck that states that the values of the Grade column must be greater than 0?

A) ALTER TABLE STUDENT ALTER CONSTRAINT GradeCheck (Grade > 0); B) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck (Grade > 0);
C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0); D) None of the above is correct.
 
Answer & Explanation Answer: C) ALTER TABLE STUDENT ADD CONSTRAINT GradeCheck CHECK (Grade > 0);

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5679
Q:

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

A) The ability to tackle more challenging problems B) Reusability of analysis, design, and programming results
C) Improved communication between users, analysts, etc. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

5 5654
Q:

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

A) Commit or rollback transactions only B) Connect to data sources only
C) Connect to data sources with driver-specific information only D) Both 1 and 2 above are in the OBDC core API.
 
Answer & Explanation Answer: D) Both 1 and 2 above are in the OBDC core API.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5635
Q:

For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?

A) Two B) Three
C) Four D) Six
 
Answer & Explanation Answer: D) Six

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 5611
Q:

A shared database should:

A) be accurate and available. B) provide for backup and recovery.
C) be secure. D) All of the above.
 
Answer & Explanation Answer: D) All of the above.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

3 5486