Oracle Basic Test! Trivia Questions Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Rajeshrbhattad
R
Rajeshrbhattad
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,087
| Attempts: 2,087
SettingsSettings
Please wait...
  • 1/10 Questions

    What does truncate do?

    • Deletes all the rows and applies autocommit.
    • Deletes rows after last commit.
    • Deletes all rows without a commit.
    • Deletes rows before last commit.
Please wait...
About This Quiz

Oracle is a relational database management system (RDBMS) officially known as Oracle Database. This software is used by many Corporate IT companies which supports in keeping track and maintaining the database. This application used for processing transaction, business intelligence, and analytics. Take this test your knowledge about the Oracle tools and functions. Let's begin the quiz. All the best!

Oracle Basic Test! Trivia Questions Quiz - Quiz

Quiz Preview

  • 2. 

    Which will delete records from the table which cant be rolled back?

    • Delete

    • Drop

    • Truncate

    • All of above

    • None of above

    Correct Answer
    A. Truncate
    Explanation
    Truncate is the correct answer because it is a DDL (Data Definition Language) command that is used to delete all the records from a table. Unlike the delete command, the truncate command cannot be rolled back, meaning that once the truncate command is executed, the data cannot be recovered. The drop command is used to delete an entire table, not just its records. Therefore, the truncate command is the only option that fits the given criteria.

    Rate this question:

  • 3. 

    Which of the following is not an aspect of logical data model?

    • Entity

    • Relation

    • Attribute

    • Object

    Correct Answer
    A. Object
    Explanation
    The correct answer is "Object". In a logical data model, an object is not considered as an aspect. Instead, the main aspects are entities, relations, and attributes. Entities represent the real-world objects or concepts, relations define the associations between entities, and attributes describe the characteristics or properties of entities. Objects, on the other hand, are typically associated with object-oriented programming and are not directly related to logical data modeling.

    Rate this question:

  • 4. 

    Triggers are fired on:

    • Cursor

    • DML statement

    • DDL statement

    • Insert, Update or Delete

    Correct Answer
    A. Insert, Update or Delete
    Explanation
    Triggers are database objects that are associated with a table and are fired automatically in response to specific events. These events include Insert, Update, or Delete operations on the table. When any of these operations are performed on the table, the trigger is triggered and its associated code is executed. Therefore, the correct answer is Insert, Update, or Delete.

    Rate this question:

  • 5. 

    Which of the following is a feature of a tablespace?

    • Logical storage unit used to group related data structures

    • Memory buffer for storage

    • Dedicated memory area for tables storage

    • Physical storage unit for data

    Correct Answer
    A. Logical storage unit used to group related data structures
    Explanation
    A tablespace is a logical storage unit used to group related data structures. It allows for the organization and management of database objects such as tables, indexes, and partitions. By grouping these objects together in a tablespace, it becomes easier to manage and allocate storage resources. Additionally, tablespaces provide the ability to assign different storage characteristics to different sets of data, allowing for more efficient storage management.

    Rate this question:

  • 6. 

    Which one of the following is not a shutdown command for a database?

    • Shutdown partial

    • Shutdown Transactional

    • Shutdown normal

    • Shutdown Immediate

    Correct Answer
    A. Shutdown partial
    Explanation
    The correct answer is "Shutdown partial" because it is not a valid shutdown command for a database. The other options, "Shutdown Transactional," "Shutdown normal," and "Shutdown Immediate," are valid commands that can be used to shut down a database. "Shutdown partial" does not exist as a valid command in most database management systems.

    Rate this question:

  • 7. 

    Which of the following are some important dynamic performance views?

    • V$Database, V$Instance, V$trigger, V$logfiles

    • V$Database, V$Instance, V$controlfiles, V$logfiles

    • V$Database, V$cursor, V$controlfiles, V$logfiles

    • None of the above

    Correct Answer
    A. V$Database, V$Instance, V$controlfiles, V$logfiles
    Explanation
    The correct answer is V$Database, V$Instance, V$controlfiles, V$logfiles. These views are important dynamic performance views in a database. V$Database provides information about the database such as its name, version, and creation time. V$Instance provides information about the current instance of the database. V$controlfiles provides information about the control files of the database, which are crucial for database operation and recovery. V$logfiles provides information about the redo log files, which are used for crash recovery and instance recovery.

    Rate this question:

  • 8. 

    System Change Number (SCN) ________________.

    • Is generated for every change in database tables

    • Is generated for every checkpoint (CKPT) occurred

    • Is generated for every change in database

    • Is generated for every change in triggers

    Correct Answer
    A. Is generated for every checkpoint (CKPT) occurred
    Explanation
    The System Change Number (SCN) is a unique identifier that is generated for every checkpoint (CKPT) that occurs in the database. A checkpoint is a process that writes all the modified data from the database buffers to the data files on disk. The SCN is used to track the order of transactions and ensure data consistency. Therefore, the correct answer is that the SCN is generated for every checkpoint occurred.

    Rate this question:

  • 9. 

    What is wrong with these statements?

    • Cursor cursor_name is

    • Select first-name into first_name1 from emp

    • Declare begin

    • Null; end;

    • None of above

    Correct Answer
    A. Select first-name into first_name1 from emp
    Explanation
    The given statements are incorrect because they contain syntax errors. In the first statement, "cursor cursor_name is" is not a valid syntax. It should be "cursor cursor_name is select...". In the second statement, "first-name" should be written as "first_name" without the hyphen. Lastly, the third statement is not needed as it is just a null statement.

    Rate this question:

  • 10. 

    Which of the following is not the feature of database view?

    • Provide additional security

    • Hide complexity

    • Add portability

    • Store complex queries

    Correct Answer
    A. Add portability
    Explanation
    The feature of adding portability is not associated with a database view. Database views are used to provide additional security by allowing users to access only specific data, hide complexity by presenting a simplified view of the data, and store complex queries for easier access. However, adding portability is not a specific feature of a database view.

    Rate this question:

Quiz Review Timeline (Updated): May 29, 2024 +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • May 29, 2024
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 03, 2008
    Quiz Created by
    Rajeshrbhattad
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.