logo

CuriousTab

Oracle Certification (Certification) Question and Answers-Page 4

Oracle Certification problems


Share: 
  • 1. Foreign key in DBMS is

  • Tags: Analyst, Database Administrator, IT Trainer, Project Manager

  •           Discuss     

  • 2. Difference between Union and Union all?

  • Tags: Analyst, Database Administrator, IT Trainer, Software Architect

  •           Discuss     

  • 3. Candidate Key in DBMS?

  • Tags: Analyst, Database Administrator, IT Trainer, Software Architect

  •           Discuss     

  • 4. The SQL keyword(s) ________ is used with wildcards.

  • Options
  • A. LIKE only
  • B. IN only
  • C. NOT IN only
  • D. IN and NOT IN

  • Tags: Database Administrator, IT Trainer

  •           Discuss     

  • 5. Which of the following is a comparison operator in SQL?

  • Options
  • A. LIKE
  • B. BETWEEN
  • C. =
  • D. All of the above

  • Tags: AIEEE, Bank Exams, Analyst, Bank Clerk

  •           Discuss     

  • 6. Go command is a signal to execute the entire batch of SQL statements after previous Go

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Database Administrator

  •           Discuss     

  • 7. Copying the logs on the standby/backup server is an operation of Log Shipping

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Database Administrator

  •           Discuss     

  • 8. Multiple users can share a local temporary table

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Database Administrator

  •           Discuss     

  • 9. STUFF and REPLACE are used to replace characters in a string

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Database Administrator

  •           Discuss     

  • 10. Breaking of relationships is allowed once referential integrity on a database is enforced

  • Options
  • A. TRUE
  • B. FALSE

  • Tags: Database Administrator

  •           Discuss     


First 2 3 4 5