Q73 The stores table has a column START_DATE of data type DATE
...
Thẻ: ocp
Q72 Examine the description of the employees table
...
Q71 The SCOTT/TIGER user exists in two databases, BOSTON_DB and DALLAS_DB, in two different locations
...
Q70 While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system
...
Q69 You must create a tablespace of non-standard block size in a new file system and plan to use this command
...
Q68 Which three activities are recorded in the database alert log?
...
Q67 Which three statements are true about dropping and unused columns in an Oracle database?
...
Q66 You need to calculate the number of days from 1st January 2019 until today
...
Q65 Examine this command Which two statements are true?
...
Q64 Which statement is true about aggregate functions?
...
Q63 Which two statements are true about the rules of precedence for operators?
...
Q62 In the SALES database, DEFERRED_SEGMENT_CREATION is TRUE
...
Q61 Which two statements are true about the results of using the INTERSECT operator in compound queries?
...
Q60 Which two statements are true about Enterprise Manager (EM) Express?
...
Q59 Which two statements are true about Enterprise Manager Database Express?
...
Q58 The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace
...
Q57 Your database instance is started with a PFILE
...
Q56 Your database instance is started with an SPFILE
...
Q55 A script abc.sql must be executed to perform a job
...
Q54 Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY
...
Q53 Examine this description of the TRANSACTIONS table
...
Q52 Which two statements are true about the SALES tablespace?
...
Q51 Examine the description of the customers table
...
Q50 You currently have an active transaction in your session and have been granted select access to V$TRANSACTION
...
Q49 Which three statements are true about data block storage in an Oracle Database?
...
