Section 1 Oracle Acad
15 Questions
| Total Attempts: 2045
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
PL/SQL is a procedural language extension to Structured Query Language. You can take this Oracle PL/SQL quiz questions and answers and check your knowledge. The purpose of PL/SQL is to combine database language and procedural...
Questions: 30 | Attempts: 12505 | Last updated: Nov 18, 2021
-
Sample QuestionSelect incorrect variable declarations
Questions: 40 | Attempts: 3165 | Last updated: Feb 4, 2013
-
Sample QuestionYou attempt to query the data base with this command: SELECT name,salary FROM employee WHERE salary= (SELECT salary FROM employee WHERE last_name= ‘Wagner’ OR dept_no=233) Why could this statement cause an error?
Are you able to pass this Oracle PL/SQL test? This free procedural language is designed to run alongside the SQL within the same server process, bringing optimal efficiency. The Oracle PL, although not portable and doesn't...
Questions: 45 | Attempts: 3082 | Last updated: Sep 23, 2020
-
Sample QuestionSelect incorrect variable declarations
Back to top