logo

CuriousTab

CuriousTab

Discussion

Home ‣ Database ‣ Managing Databases with Oracle See What Others Are Saying!
  • Question

  • What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles?


  • Options
  • A. Full backup
  • B. Consistent backup
  • C. Inconsistent backup
  • D. Differential backup

  • Correct Answer
  • Consistent backup 

    • More questions

    • 1. What is Hypertext Transfer Protocol (HTTP)?

    • Options
    • A. The protocol to copy files between computers
    • B. The transfer protocol to transfer Web pages to a browser
    • C. The database access protocol for SQL statements
    • D. The hardware/software protocol that limits access to company data
      • Discuss
    • 2. A UNION query is which of the following?

    • Options
    • A. Combines the output from no more than two queries and must include the same number of columns.
    • B. Combines the output from no more than two queries and does not include the same number of columns.
    • C. Combines the output from multiple queries and must include the same number of columns.
    • D. Combines the output from multiple queries and does not include the same number of columns.
      • Discuss
    • 3. Data scrubbing can help upgrade data quality; it is not a long-term solution to the data quality problem.

    • Options
    • A. True
    • B. False
      • Discuss
    • 4. Which of the following column properties specifies whether or not cells in a column must contain a data value?

    • Options
    • A. Null status
    • B. Data type
    • C. Default value
    • D. Data constraints
      • Discuss
    • 5. Cascading updates refers to child rows being automatically deleted when a parent row is deleted.

    • Options
    • A. True
    • B. False
      • Discuss
    • 6. With which type of SQL Server recovery model are all database changes logged except those that cause large log entries?

    • Options
    • A. Differential recovery
    • B. Full recovery
    • C. Simple recovery
    • D. Bulk-logged recovery
      • Discuss
    • 7. Oracle maintains a System Change Number (SCN) which is a database-wide value that is incremented by Oracle whenever database changes are made.

    • Options
    • A. True
    • B. False
      • Discuss
    • 8. The SQL-92 command to change a table name is RENAME TABLE.

    • Options
    • A. True
    • B. False
      • Discuss
    • 9. Which of the following statements is true concerning subqueries?

    • Options
    • A. Involves the use of an inner and outer query.
    • B. Cannot return the same result as a query that is not a subquery.
    • C. Does not start with the word SELECT.
    • D. All of the above.
      • Discuss
    • 10. When transforming an entity-relationship model into a relational database design, each entity is represented as a table.

    • Options
    • A. True
    • B. False
      • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.