Search Adaface test library by skills or roles
⌘ K

Adaface Sample Oracle SQL Questions

Here are some sample Oracle SQL questions from our premium questions library (10273 non-googleable questions).

Skills

🧐 Question

Medium

Sales Table
Solve
                                    Here's a proposal for SALES table in Oracle SQL:
                                    
 image
                                    Of the following statements about creating SALES table and storing data, which are true?
                                    
                                    A: The CUST_STATUS column would store exactly one character
            B: The SALE_VALIDITY column would have a maximum size of one character
            C: The CUST_CREDIT column would be able to store decimal values
            D: The SALE_VALIDITY column would give an error
                                    

Options:

  • A B
  • A C
  • A D
  • B C
  • B D
  • C D

Medium

Users Table
Solve
                                    Of the following CREATE ORACLE SQL queries, which all would create "users" table with columns user_id and login_id as unique and not null?
                                    
 image

Options:

  • A B
  • A C
  • A D
  • A E
  • B D
  • C D
  • B C
  • B E
  • C D
  • D E
  • C E
🧐 Question🔧 Skill

Medium

Sales Table
3 mins
Oracle SQL
Solve

Medium

Users Table
3 mins
Oracle SQL
Solve
🧐 Question🔧 Skill💪 Difficulty⌛ Time
Sales Table
Oracle SQL
Medium3 minsSolve
Users Table
Oracle SQL
Medium3 minsSolve

Adaface questions are trusted by enterprises globally

Amazon Morgan Stanley Vodafone United Nations HCL PayPal Bosch WeWork Optimum Solutions Deloitte Microsoft NCS Doubtnut Sokrati J&T Express Capegemini

We evaluated several of their competitors and found Adaface to be the most compelling. Great default library of questions that are designed to test for fit rather than memorization of algorithms.


Swayam Narain, CTO, Affable

hashtag image heart icon Swayam
Join 1200+ companies in 75+ countries.
Essayez l'outil d'évaluation des compétences le plus candidat aujourd'hui.
Ready to streamline your recruitment efforts with Adaface?
Ready to streamline your recruitment efforts with Adaface?
Discute avec nous