কম্পিউটার ডাটাবেজ বহুনির্বাচনী প্রশ্ন ও উত্তর – পর্ব ০২

কম্পিউটার ডাটাবেজ

যেকোনো প্রস্তুতিমূলক পরীক্ষার জন্য কম্পিউটার ডাটাবেজ বহুনির্বাচনী প্রশ্ন ও উত্তর

Computer Database Multiple Choice Questions (MCQ) and Answers – Part 02

This Set of questions will help you to enrich IT Skills for competitive examinations.

 

  1. The relational model is based on the concept that data is organized and stored in two-dimensional tables called ……………………….

Ans: Relations

  1. ……………….. contains information that defines valid values that are stored in a column or data type.

Ans: Index

  1. Which of the syntax is correct for insert statement?
    i) insert into <table_name> values <list of values>
    ii) insert into <table_name> (column list) values <list of values>

Ans: Both of them (i & ii)

  1. ………………. First proposed the process of normalization.

Ans: Edgar F. Codd

  1. For using a specific database …………… command is used.

Ans: use database

  1. Which of the following is not comparison operator?

Ans: =<

  1. An outstanding functionality of SQL is its support for automatic ………… to the target data.

Ans: navigation

  1. ………………… is a special type of integrity constraint that relates two relations & maintains consistency across the relations.

Ans: Referential Integrity Constraints

  1. ……………..specifies a search condition for a group or an aggregate.

Ans: HAVING Clause

  1. Drop Table cannot be used to drop a table referenced by a …………… constraint.

Ans: Foreign Key

  1. Processed data is called ………………..

Ans: Information

  1. …………….. is a utility to capture a continuous record of server activity and provide auditing capability.

Ans: SQL server service manager

  1. Data items grouped together for storage purposes are called a

Ans: record

  1. …………. contains data assisting day to day activities of the organization.

Ans: Operational database

  1. ………………… approach reduces time and effort required for design and lesser risk in database management.

Ans: Multiple databases

  1. HSAM stands for ……….

Ans: Hierarchic Sequential Access Method

  1. SQL server stores index information in the ………… system table

Ans: sys indexes

  1. The one guideline to be followed while designing the database is

Ans: It should avoid/reduce the redundancy.

  1. Which of the following is not a logical database structure?

Ans: Chain

  1. ……………. is a preferred method for enforcing data integrity

Ans: Constraints

মন্তব্য করুন (Comments)

comments

Related posts

error: Content is protected !!