Oracle Database MCQ Quiz Model Test

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 Leonfrnnd
L
Leonfrnnd
Community Contributor
Quizzes Created: 1 | Total Attempts: 2,078
| Attempts: 2,078
SettingsSettings
Please wait...
  • 1/17 Questions

    A CALL statement inside the trigger body enables you to call  a stored procedure

    • True
    • False
Please wait...
About This Quiz



Hey, do you have a good understanding of Oracle? If yes, then you must check out this awesome 'Oracle Database MCQ Quiz' that we've created below. As you would know, Oracle is a multi-model relational database management system, that is primarily designed for enterprise grid computing and data warehousing. Try answering the questions of this quiz and you'll get to know how much knowledge you have about this database system.

Oracle Database MCQ Quiz Model Test - Quiz

Quiz Preview

  • 2. 

    Constants , a programmed constructs can be grouped witihn the packages

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement is true because constants, which are fixed values that do not change during program execution, can be organized and grouped within packages. Packages provide a way to organize related classes and interfaces, and constants can be declared within these classes or interfaces. By grouping constants within packages, it becomes easier to manage and access them within the program. Therefore, the correct answer is true.

    Rate this question:

  • 3. 

    Contents of the packages can be shared by many applications

    • True

    • False

    Correct Answer
    A. True
    Explanation
    The statement "Contents of the packages can be shared by many applications" is true. In software development, packages are used to organize and group related classes, interfaces, and other components. These packages can be accessed and used by multiple applications, allowing for code reusability and modularity. This promotes efficient development and maintenance of software systems by enabling the sharing and collaboration of resources among different applications.

    Rate this question:

  • 4. 

    YOU can acheive information hiding by making package constructs private.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Information hiding is a principle in software engineering that aims to restrict access to certain parts of a program, allowing only necessary information to be exposed. By making package constructs private, we can control the visibility of these constructs within the package, preventing external access and achieving information hiding. This ensures that the implementation details of the package are hidden from other parts of the program, promoting encapsulation and reducing dependencies. Therefore, the statement "YOU can achieve information hiding by making package constructs private" is true.

    Rate this question:

  • 5. 

     In SQL, Null values are displayed last in the ascending sequences.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In SQL, when sorting data in ascending order, Null values are displayed last. This means that if there are Null values in a column being sorted, they will appear at the bottom of the result set. This behavior is consistent across most SQL database systems and can be useful for identifying missing or incomplete data.

    Rate this question:

  • 6. 

    State true or false- The user do not explicitly open, fetch or close a cursor within a cursor for loop.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    In a cursor for loop, the user does not need to explicitly open, fetch, or close a cursor. The cursor for loop automatically performs these actions internally. This loop is designed to simplify the process of iterating through the result set of a query by handling the cursor operations behind the scenes. Therefore, the statement "The user do not explicitly open, fetch or close a cursor within a cursor for loop" is true.

    Rate this question:

  • 7. 

    Which privilege concerns with system level security?

    • Drop any table.

    • DELETE

    • ALTER

    • INDEX

    • UPDATE

    Correct Answer
    A. Drop any table.
    Explanation
    The privilege that concerns with system level security is the DROP privilege. This privilege allows a user to delete or drop any table in the database. It is a powerful privilege that should only be granted to trusted users, as it can potentially cause data loss or disruption to the system. The other options, DELETE, ALTER, INDEX, and UPDATE, are privileges that are related to manipulating data or modifying database objects, but they do not have the same level of impact on system security as the DROP privilege.

    Rate this question:

  • 8. 

    Which table name is valid?

    • #_667.

    • Number.

    • Catch_#22.

    • 1996_invoices

    • Invoices-1996.

    Correct Answer
    A. Catch_#22.
    Explanation
    The table name "Catch_#22" is valid because it follows the rules for naming tables in a database. Table names can contain letters, numbers, and underscores, but cannot start with a number or contain special characters like "#" or "-". Therefore, "Catch_#22" is the only option that meets these criteria.

    Rate this question:

  • 9. 

    It is not possible to sort query results by a column that is not included in the SELECT list. State true or false. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    False. It is possible to sort query results by a column that is not included in the SELECT list. The SELECT list determines the columns that will be returned in the result set, but it does not restrict the ability to sort by other columns in the table.

    Rate this question:

  • 10. 

    The SQL results are sorted by the first column in the SELECT list if the ORDER BY a clause is not provided.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    If the ORDER BY clause is not provided in an SQL query, the results are not necessarily sorted by the first column in the SELECT list. The order in which the results are returned is not guaranteed and can vary depending on the database system or other factors.

    Rate this question:

  • 11. 

    State true or false. The user can go into SQL* PLUS and query the USER_TRIGGERS data dictionary view to see the compilation error that occur during the compilation of a trigger. 

    • True

    • False

    Correct Answer
    A. False
    Explanation
    The user cannot go into SQL* PLUS and query the USER_TRIGGERS data dictionary view to see the compilation error that occurs during the compilation of a trigger. The USER_TRIGGERS view provides information about triggers in the user's schema, but it does not include details about compilation errors. To see compilation errors, the user can check the error logs or error messages generated during the compilation process.

    Rate this question:

  • 12. 

    The employee table contains these columns: ID NUMBER(9) LAST_NAME VARCHAR2(25) FIRST_NAME VARCHAR2(25) COMMISSION NUMBER(7,2) You need to display the current commission for all employees.   Desired results are: 1. Display the commission multiplied by 1.5 48 2. Exclude employees with zero commission. 3. Display a zero for employees with null commission value.   Evaluate this SQL statement. SELECT id, last_name, first_name, commission*1. 5 FROM employee WHERE commission <>0; Which of the desired results does the statement provide?

    • All the desired results.

    • Two of the desired results.

    • One of the desired results

    • A syntax error.

    Correct Answer
    A. Two of the desired results.
    Explanation
    The given SQL statement SELECT id, last_name, first_name, commission*1.5 FROM employee WHERE commission 0; provides two of the desired results. It displays the commission multiplied by 1.5, as requested in the first desired result. It also excludes employees with zero commission by using the WHERE clause with the condition commission 0, as stated in the second desired result. However, it does not display a zero for employees with a null commission value, which is the third desired result.

    Rate this question:

  • 13. 

    Pick the three SQL arithmetic expressions that return date. 

    • ‘08-jul-96’ + 7

    • ‘01-jul-96’ – 12

    • ‘03-jul-96’ + (12/24)

    • (‘03-jul-96’ – ‘04-jul-97’) /7

    Correct Answer(s)
    A. ‘08-jul-96’ + 7
    A. ‘01-jul-96’ – 12
    A. ‘03-jul-96’ + (12/24)
    Explanation
    The three SQL arithmetic expressions that return a date are '08-jul-96' + 7, '01-jul-96' - 12, and '03-jul-96' + (12/24). These expressions perform addition and subtraction operations on the given dates, resulting in a new date value. The first expression adds 7 days to the date '08-jul-96', the second expression subtracts 12 days from the date '01-jul-96', and the third expression adds 12 hours (12/24) to the date '03-jul-96'.

    Rate this question:

  • 14. 

    Pick the three DATETIME data types that can be used when specifying column definitions. 

    • TIMESTAMP

    • INTERVAL MONTH TO DAY

    •  INTERVAL DAY TO SECOND

    • INTERVAL YEAR TO MONTH

    Correct Answer(s)
    A. TIMESTAMP
    A.  INTERVAL DAY TO SECOND
    A. INTERVAL YEAR TO MONTH
    Explanation
    TIMESTAMP, INTERVAL DAY TO SECOND, and INTERVAL YEAR TO MONTH are the three DATETIME data types that can be used when specifying column definitions. The TIMESTAMP data type is used to store date and time values, while INTERVAL DAY TO SECOND is used to store intervals of time in days, hours, minutes, and seconds. INTERVAL YEAR TO MONTH is used to store intervals of time in years and months. These data types provide flexibility in storing and manipulating date and time data in a database.

    Rate this question:

  • 15. 

    Examine the table instance chart for the patient table. Column name Id_number Last_name first_name birth_date doctor_id Key type PK Nulls/Unique NN, UU FK table NN NN FK column Data type Length DOCTOR ID_NUMBER NUM 10 25 25 VARCHAR2 VARCHAR2 DATE NUM 10 You created the patient_vu view based on the id_number and last_name columns from the patient table. What is the best way to modify the view to contain only those patients born in 1997?

    • Replace the view adding a WHERE clause.

    • Use the ALTER command to add WHERE clause to verify the time.

    • Drop the patient_vu then create a new view with a WHERE clause.

    • Drop the patient_vu then create a new view with a HAVING clause

    Correct Answer
    A. Replace the view adding a WHERE clause.
    Explanation
    The best way to modify the view to contain only those patients born in 1997 is by replacing the view and adding a WHERE clause. This allows us to filter the data and include only the patients who were born in 1997.

    Rate this question:

  • 16. 

    The 'Where' clause is used for which of these three tasks? 

    • Compare two values

    • Designate a table location.

    • Only display data greater than a specified value.

    • Restrict the rows displayed.

    • Restrict the output of the group function.

    Correct Answer(s)
    A. Compare two values
    A. Only display data greater than a specified value.
    A. Restrict the rows displayed.
    Explanation
    The 'Where' clause is used to compare two values by specifying a condition that needs to be met for the rows to be included in the result set. It is also used to restrict the rows displayed by specifying certain criteria that the rows must satisfy. Additionally, it can be used to only display data greater than a specified value by using comparison operators such as '>', '=', or '

    Rate this question:

  • 17. 

    Which three SELECT statements display 2000 in the format "$2,000.00"? 

    • SELECT TO CNAR(2000, '$#,###.##') FROM dual;

    • SELECT TO CNAR(2000, '$0,000.00') FROM dual;

    • SELECT TO CNAR(2000, '$9,999.00') FROM dual;

    • SELECT TO CNAR(2000, '$9,999.99') FROM dual;

    • SELECT TO CNAR(2000, '$2,000.00') FROM dual;

    Correct Answer(s)
    A. SELECT TO CNAR(2000, '$0,000.00') FROM dual;
    A. SELECT TO CNAR(2000, '$9,999.00') FROM dual;
    A. SELECT TO CNAR(2000, '$9,999.99') FROM dual;
    Explanation
    The correct answer is SELECT TO CNAR(2000, '$0,000.00') FROM dual;, SELECT TO CNAR(2000, '$9,999.00') FROM dual;, SELECT TO CNAR(2000, '$9,999.99') FROM dual; These three SELECT statements will display 2000 in the format "$2,000.00" because the TO_CHAR function is used to convert the number 2000 into a character string with the specified format. The format '$0,000.00' specifies that the number should be displayed with a dollar sign, comma as a thousands separator, and two decimal places.

    Rate this question:

Quiz Review Timeline (Updated): Mar 29, 2023 +

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

  • Current Version
  • Mar 29, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 24, 2011
    Quiz Created by
    Leonfrnnd
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.