Basics Of Data Types And Database Objects

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 Kalloorkar_bvk
K
Kalloorkar_bvk
Community Contributor
Quizzes Created: 2 | Total Attempts: 1,083
| Attempts: 347
SettingsSettings
Please wait...
  • 1/5 Questions

    Which of the following is not supported by Oracle as an internal datatype? (Choose the best answer.)

    • CHAR
    • FLOAT
    • INTEGER
    • STRING
Please wait...
About This Quiz

The quiz checks if trainee has understood basic concepts of table creation and database objects

Database Design Quizzes & Trivia

Quiz Preview

  • 2. 

    Several object types share the same namespace and therefore cannot have the same name in the same schema. Which of the following object types is not in the same namespace as the others? (Choose the best answer.)

    • Index

    • PL/SQL stored procedure

    • Synonym

    • Table

    • View

    Correct Answer
    A. Index
    Explanation
    Indexes, PL/SQL stored procedures, synonyms, tables, and views are all object types that exist within a schema. However, indexes are not in the same namespace as the others. Indexes are used to improve the performance of database queries by allowing for faster data retrieval. They are not directly related to the structure or definition of the data itself, unlike tables, views, and synonyms. Therefore, indexes have a separate namespace from the other object types mentioned.

    Rate this question:

  • 3. 

    Which of these statements will fail because the table name is not legal? (Choose two answers.)

    • Create table "SELECT" (col1 date);

    • Create table "lower case" (col1 date);

    • Create table number1 (col1 date);

    • Create table update(col1 date);

    • Create table 1number(col1 date);

    Correct Answer(s)
    A. Create table update(col1 date);
    A. Create table 1number(col1 date);
    Explanation
    The table name "update" will fail because it is a reserved SQL keyword and cannot be used as a table name. The table name "1number" will also fail because it starts with a number, which is not allowed in SQL table names.

    Rate this question:

  • 4. 

    You need to record date/time values, with a precision of one second. What would be a suitable datatype for a single column to store this information? (Choose One that is most appropriate)

    • DATE

    • TIMESTAMP

    • DATE or TIMESTAMP

    • User Defined Data Type

    Correct Answer
    A. DATE or TIMESTAMP
    Explanation
    A suitable datatype for recording date/time values with a precision of one second would be TIMESTAMP. The TIMESTAMP datatype allows for storing both date and time information, including seconds. DATE datatype only stores the date information without the time component. Therefore, TIMESTAMP is the most appropriate choice for this requirement.

    Rate this question:

  • 5. 

    Which of the following constraints require an index? (Choose Two)

    • NOT NULL

    • PRIMARY KEY

    • CHECK

    • UNIQUE

    Correct Answer(s)
    A. PRIMARY KEY
    A. UNIQUE
    Explanation
    The PRIMARY KEY constraint requires an index because it ensures that each value in the specified column(s) is unique and also serves as a unique identifier for each row in the table. An index is needed to efficiently enforce this constraint and allow for fast lookup and retrieval of data based on the primary key. Similarly, the UNIQUE constraint also requires an index to enforce the uniqueness of values in the specified column(s), allowing for efficient data retrieval and preventing duplicate entries.

    Rate this question:

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

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

  • Current Version
  • Mar 21, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jan 26, 2012
    Quiz Created by
    Kalloorkar_bvk
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.