--1、查看表空间的名称及大小 SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size FROM dba_tablespaces t, dba_data_files d WHERE t.tablespace_name = d.tablespace_name GROUP BY t.tablespace_name; --2、查看表空间物理文件的名称及大小 SELECT tablespace_name...【阅读全文】
Your database is running in ARCHIVELOG mode.Which two statements are true in this scenario?B) The database must be in MOUNT state to take consistent RMAN backups.D) The database instance must be shut down to take a user-managed consistent backup.Answer:BD【阅读全文】
Which three statements are true about Oracle checkpoint processing?B) Frequent thread checkpoints can degrade database performance.D) It reduces the recovery time from instance failures.Answer:BCD【阅读全文】
Your database is configured for ARCHIVELOG mode, and a daily full database backup is taken.In which three scenarios do you need media recovery?B) abnormal termination of the database instanceD) loss of a data file that belongs to the active undo tablespaceF) loss of all the copies ...【阅读全文】
Which three statements are true about Oracle Data Pump?B) IMPDP can be used to change target data file names, schemas, and tablespaces during import.D) EXPDP and IMPDP are the client components of Oracle Data Pump.Answer:BCD【阅读全文】
Examine this command executed on a client that is remote from the database server.Which two are required for this command to connect the SQLPLUS client to a database instance?B) An orcl TNS entry must be defined in the client-side tnsnames.ora file.D) The service name orcl must be defi...【阅读全文】
Which users are created and can be used for database and host management of your DBaaS database servers?B) root, oracle and cloud usersD) opc and oracle usersAnswer:B用户对云计算的交付能力已经不再满足于单纯的基础设施(IaaS)交付,他们希望数据中心中的更多传统 IT 服务能以云服务模式进...【阅读全文】