Recent questions tagged Oracle-sql-interview-questions-answers

0 votes
    Which privillega from the following is used to create a private sybonym in another user's schema? a. CREATE SYNONYM b. ... SYNONYM c. CREATE ANY SYNONYM d. None of the above...
asked Feb 19, 2023 in Technology by JackTerrance
0 votes
    Rownum numbers the records in a result set. a. False b. True...
asked Feb 19, 2023 in Technology by JackTerrance
0 votes
    IN and NOT IN operations decreases the performance of an SQL query compared to AND/OR operations. it it True or False? a. True b. False...
asked Feb 19, 2023 in Technology by JackTerrance
0 votes
    How to concatenate multiple rows into a single string in sql a. COALESCE b. STRING_AGG C. Option 1 & 2 d. None of the above...
asked Feb 19, 2023 in Technology by JackTerrance
0 votes
    Views are created on top of Materialized views a. False b. True...
asked Feb 19, 2023 in Technology by JackTerrance
To see more, click for the full list of questions or popular tags.
...