Your database is running in ARCHIVEVLOG mode.You want to take a consistent whole database backup.Which two statements are true in this scenario? A. RMAN backups contain only data files. B. The database instance must be shut down to take a user-managed consistent backup. C. Consistent RMAN backups can be taken while the database is open. […]
Which statement is true regarding the DEFAULT profile? A. The values assigned to the resource limits and password parameters in the default profile can be altered. B. A different DEFAULT profile can be created before each user in a database. C. It can be dropped and recreated. D. it must be explicitly assigned to the […]
Your database has archive logging enabled and RMAN backups are taken at regular intervals. A data file in theUSERS tablespace is damaged.Which command must you execute before starting the recovery of this tablespace? A. ALTER TABELSPACE users OFFLINE B. STARTUP FORCE NOMOUNT C. STARTUP FORCE D. SWITCH DATAFILE ALL Show Answer
Examine the details of the uncompressed, non-partitioned heap table CITIES. Examine the command:SQL> ALTER TABLE cities SHRINK SPACE COMPACT;What must you do before executing it? A. Ensure free space that is approximately equal to the space used by the table should be available. B. Ensure there are no pending transactions on the table. C. Enable […]
Examine the command to perform a data pump export operation on a source database:$> expdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_deptOn the target database, you execute the data pump import command:$> impdp hr/hr DIRECTORY=dumpdir DUMPFILE=emp1.dmp VIEWS_AS_TABLE=emp_deptWhich three statements are true? (Choose three.) A. The expdp operation exports data that satisfies the condition of the defining query used […]
In your database, archive logging and control file autobackup are enabled.The data files and redo log files are intact but control files are impacted due to media failure.In which two recovery scenarios must you use the RESETLOGS option? (Choose two.) A. One control file copy is intact so the spfile is changed to refer to […]
Which three statements are true about Oracle Data Pump? (Choose three.) A. Oracle Data Pump export and import operations can be performed to move data across different database releases. B. DBMS_DATAPUMP PL/SQL packages can be used independent of Data Pump clients. C. A directory object must exist and a user performing an EXPDP or IMPDP […]
Which users are created and can be used for database and host management of your DBaaS database servers?
Which users are created and can be used for database and host management of your DBaaS databaseservers? A. opc and oracle users B. root, oracle and cloud users C. root and oracle users D. root, opc and oracle users E. cloud and oracle users Show Answer
Examine the command:SQL> CONNECT hr/hr@orclWhich two configurations allow this command to execute successfully? (Choose two.) A. In the tnsnames.ora file, the SERVICE_NAME value of CONNECT_DATA should be explicitly suffixed with the domain name. B. The SERVICE_NAMES initialization parameter should contain the name orcl in the database host. C. The orcl TNS alias should be defined […]
What must be done to ensure only the HR user in the BOSTON database can access the HR schema in the DENVER database?
The HR schema exists in two databases, BOSTON and DENVER, and has the same password, HR.You have the CREATE DATABASE LINK and CREATE SESSION privileges on both the database.BOSTON is defined as a service name in the tnsnames.ora of both the databases.You plan to use the command:CREATE DATABASE LINK hr_link CONNECT to hr IDENTIFIED BY […]