Section 1 Oracle Acad
15 Questions
| Total Attempts: 1035
Settings
.
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.
- C.
True. The only requirement for creating a perfect system is a perfect programmer.
- D.
True. Users delay the delivery of a system by changing their minds and adding new requirements.
- 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
Back to top