Sawaal

 Database Questions

Popular Latest Rated
Q:

 In the relational model, relationships between relations or tables are created by using:

A) composite keys. B) determinants.
C) candidate keys. D) foreign keys.
 
Answer & Explanation Answer: D) foreign keys.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5079
Q:

Which of the following indicates the maximum number of entities that can be involved in a relationship?

A) Minimum cardinality B) Maximum cardinality
C) ERD D) Greater Entity Count (GEC)
 
Answer & Explanation Answer: B) Maximum cardinality

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

1 5038
Q:

SQL Server program code that is executed instead of an SQL command that needs to be processed is called

A) INSTEAD OF trigger. B) BEFORE trigger.
C) AFTER trigger. D) BEGIN trigger.
 
Answer & Explanation Answer: A) INSTEAD OF trigger.

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

0 5024
Q:

 If a table has been normalized so that all determinants are candidate keys, then that table is in:

A) 1NF B) 2NF
C) 3NF D) BCNF
 
Answer & Explanation Answer: D) BCNF

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 4915
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 4908
Q:

 Legacy data is which of the following?

A) Data contained in a newly-installed system B) Data rejected during the installation of a new system
C) Data contained in a file system D) Data contained by a system used prior to the installation of a new system
 
Answer & Explanation Answer: D) Data contained by a system used prior to the installation of a new system

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

2 4897
Q:

 A proxy server is used for which of the following?

A) To provide security against unauthorized users B) To process client requests for Web pages
C) To process client requests for database access D) To provide TCP/IP
 
Answer & Explanation Answer: A) To provide security against unauthorized users

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database

5 4865
Q:

A collection of interrelated records is called a

A) Datasheet B) Spreadsheet
C) Database D) Utility File
 
Answer & Explanation Answer: C) Database

Explanation:
Report Error

View Answer Report Error Discuss

Filed Under: Database
Exam Prep: AIEEE , Bank Exams
Job Role: Analyst , Bank PO , Database Administration , IT Trainer , Network Engineer , Project Manager , Software Architect

5 4828