Academic Quiz On Section 1 Database Design Oracle

15 Questions | By G.iirina | Updated: Jul 26, 2022 | Attempts: 4126

Questions

Settings

Academic Quiz On Section 1 Database Design Oracle - Quiz

Do you know what the basic steps for designing a database are? Check out this academic quiz based on section 1 of database design Oracle. Here, we will ask a few questions in the true and false format about the oracle database to test your knowledge of this database software. Oracle is a multi-model database management system that stores and retrieves related information. Oracle is produced and marketed by Oracle Corporation. Play the quiz to review your understanding of it.

Questions and Answers

1.

A row is called a record.
- A.
  
  True
- B.
  
  False
2.

A table is a collection of records.
- A.
  
  True
- B.
  
  False
3.

By defining primary and foreign key, you can ensure that the integrity of the data in a table is maintained.
- A.
  
  True
- B.
  
  False
4.

It is important to identify and document business rules when designing a database.
- A.
  
  True
- B.
  
  False
5.

All Business Rules can be modeled.
- A.
  
  True
- B.
  
  False
6.

A database is a centralized and structured set of data stored on a computer system and provides facilities for retrieving, adding, modifying and deleting the data when required.
- A.
  
  True
- B.
  
  False
7.

Information can be defined as facts from which you can deduce new facts.
- A.
  
  True
- B.
  
  False
8.

In the relational database model, each table name must be unique. The column names in the table must be unique too. You can have two different tables that have column names that are similar.
- A.
  
  True
- B.
  
  False
9.

A relational model describes a database in terms of tables, columns, and joins between tables.
- A.
  
  True
- B.
  
  False
10.

A flat file may contain many fields, often, with duplicate data that are prone to data corruption.
- A.
  
  True
- B.
  
  False
11.

The market for IT professionals is still increasing and will continue to do so in the future as the world gets ever more dependent on computer systems.
- A.
  
  True
- B.
  
  False
12.

Once you have learned how to write programs and build systems, you no longer need any input or involvement from any users as you are perfectly capable of delivering the systems that businesses need and want.
- A.
  
  False. Business requirements can and will change. For instance new legal requirements may arise.
- B.
  
  True. Users never know what they want anyway, so building systems is best left to the professionals.
13.

A segment is a set of extents which have been allocated for a specific type of data structure, and all are stored in the same tablespace.
- A.
  
  True
- B.
  
  False
14.

Every instance of an Oracle Database has an associated redo log to protect the database in case of an instance failure.
- A.
  
  True
- B.
  
  False
15.

Each database has one unique control file, although it may maintain identical copies of it.
- A.
  
  True
- B.
  
  False