1. Which two are true about an Oracle gold image-based installation in Oracle 18c and later releases? (Choose two.)
A. It can be used for both Oracle Database and Oracle Grid Infrastructure installation.
B. It can only install and configure Oracle Database software. The database has to be created separately.
C. It does not require the setup wizard.
D. It uses a single RPM that automatically extracts and installs the Oracle Database software.
E. It can be used to install and upgrade Oracle Database for single-instance and cluster configurations.
Answer: A E
2. Which two are true about the automatic execution of operating system scripts when performing silent mode installation starting from Oracle Database 19c?
(Choose two.)
A. The response file can specify the root or sudo password. B. The installer will prompt for the root or sudo password. C. Silent install always runs operating scripts automatically. D. The response file must contain the root or sudo password. E. The response file can specify the path of the sudo program.
Answer: B E
3. Which two are true about poorly performing SQL statements and their tuning in Oracle database instances? (Choose two.)
A. SQL statements performing many physical I/Os can always have their performance improved by creating indexes.
B. SQL statements doing only logical reads never require tuning because they do no physical
I/O.
C. The solution that best optimizes one SQL statement can degrade the performance of others.
D. SQL statements doing joins always do more physical I/O than single table queries.
E. Poorly performing SQL statements can be tuned automatically by the Oracle server. Answer: C E
4. Which two are true about Rapid Home Provisioning of Oracle software? (Choose two.)
A. It can be used for applications and middleware.
B. It can be used only for Oracle Grid Infrastructure, excluding Oracle Restart.
C. It can be used only for Oracle Grid Infrastructure, including Oracle Restart.
D. It can be used for both Oracle Database and Oracle Grid Infrastructure, including Oracle
Restart.
E. It can be used for both Oracle Database and Oracle Grid Infrastructure, excluding Oracle
Restart. Answer: A D
5. Your database is in ARCHIVELOG mode and you plan to use Flashback Database. Which two features or parameters manage space availability in the fast recovery area? (Choose two.)
A. the archived log deletion policy B. the backup optimization policy C. the backup retention policy
D. using guaranteed UNDO retention
E. the DB_CREATE_ONLINE_LOG_DEST_n parameter setting
F. the DB_RECOVERY_FILE_DEST parameter setting
Anwer: A C
6. Which two are true about Oracle Database Configuration Assistant (DBCA)? (Choose two.)
A. It can be launched from both the command line and the Universal Installer (OUI)
interfaces.
B. It can be used to change the character set of an existing database.
C. It can be used to convert a non-container database to a container database.
D. It can be used to create container databases and non-container databases.
E. It can only be launched from the command line interface. Ans: A D
7. Which three are performed by Oracle Automatic Storage Management (ASM) instances? (Choose three.)
A. mounting disk groups
B. managing Allocation Units (AUs) for disk group content
C. managing extent allocation for Oracle database segments
D. acting as an I/O server to write data file blocks to ASM disks on behalf of Database Writer processes (DBWn)
E. managing space allocation for Oracle ASM files
F. acting as an I/O server to read data file blocks from ASM disks on behalf of database server processes
Ans: A B E
8. Which two are prerequisites for using FLASHBACK TABLE? (Choose two.) A. A table's constraints must be disabled before issuing the flashback.
B. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the user performing the flashback.
C. A table's indexes must be set to unusable before issuing the flashback. D. Row Movement must be enabled on the table being flashed back.
E. The FLASHBACK ANY TABLE system privilege or the FLASHBACK object privilege must be granted to the table owner.
Ans: B D
9. RMAN has just been connected to a target database and the recovery catalog database.
In which two cases would an automatic full resynchronization occur between this target database's control file and the RMAN recovery catalog? (Choose two.)
A. when control file metadata for archive log backups or image copies has been overwritten
in the target database's control file due to being older than
CONTROL_FILE_RECORD_KEEP_TIME
B. when control file metadata for data file backups or image copies has been overwritten in the target database's control file due to being older than CONTROL_FILE_RECORD_KEEP_TIME
C. when a new tablespace is added to a registered target database
D. when a backup of the current control file is created
E. when the target is first registered
Ans: C E
10. Which three are true about SGA memory management in a multitenant database? (Choose three.)
A. Setting DB_CACHE_SIZE for a PDB guarantees a minimum amount of Database Buffer
Cache memory for that PDB.
B. The SHARED_POOL_SIZE setting for a PDB can be up to 80% of the
SHARED_POOL_SIZE setting of the root container.
C. Setting SHARED_POOL_SIZE for a PDB guarantees a minimum amount of Shared Pool memory for that PDB.
D. The SGA_TARGET setting for a PDB cannot exceed 50% of the SGA_TARGET value of the root container.
E. Setting SGA_TARGET for a PDB guarantees a minimum amount of SGA memory for that
PDB.
F. SGA_MIN_SIZE cannot be set for a PDB. Ans: A B C (B may false)
11. Which three are true about creating container databases (CDBs) and pluggable databases
(PDBs) in Oracle 19c and later releases? (Choose three.)
A. A PDB snapshot can be a sparse copy of a source PDB.
B. A PDB snapshot depends on an existing storage snapshot of the source PDB.
C. A CDB can be duplicated using Recovery Manager (RMAN) with no configuration required before starting the duplication.
D. A CDB can be duplicated using the Database Configuration Assistant (DBCA) in silent mode with no configuration required before starting the duplication.
E. A PDB snapshot can be a full copy of a source PDB.
F. A snapshot copy PDB can be a full copy of a source PDB.
G. A snapshot copy PDB does not depend on an existing storage snapshot of the source PDB. Ans: A D E
12. Which two are true about an RPM-based Oracle Database installation? (Choose two.)
A. It uses a service configuration script to create a single-instance database as part of the installation.
B. From Oracle Database 18c, a single RPM can be used to install only Oracle Database
Server for a single instance.
C. It performs a software-only Oracle Database installation. D. It includes the Oracle Preinstallation RPM.
E. It requires an Unbreakable Linux Network (ULN) subscription. Ans: B C
13. In performance management, which two factors might reduce the ability of an application
to scale to a large number of users? (Choose two.)
@tunganh46 10-08-2023
A. poorly written SQL
B. the number of tablespaces containing tables updated by a transaction
C. poorly trained users who do not commit transactions
D. the number of data files containing extents belonging to tables updated by a transaction
E. issuing multiple savepoints during a transaction
Ans: A C
14. Examine this configuration:
1. CDB1 is a container database.
2. APP_ROOT is an application root in CDB1.
3. APP_PDB1 is an application PDB in APP_ROOT.
4. FLASHBACK DATABASE is ON. You execute these commands:
Which table or set of tables will exist after the Flashback operation has completed?
A. CDB1_TAB, APP_ROOT_TAB, and APP_PDB1_TAB B. CDB1_TAB and APP_PDB1_TAB
C. none of the tables, because all three tables will be dropped
D. CDB1_TAB only
E. CDB1_TAB and APP_ROOT_TAB Ans: B
15. Which two are true about the Program Global Area (PGA) and its management in an
Oracle database instance? (Choose two.)
A. The private SQL area (UGA) is located in the System Global Area (SGA) when using dedicated servers.
B. PGA_AGGREGATE_LIMIT is a hard limit on the PGA size for any one session.
C. The entire PGA is located in the System Global Area (SGA) when using shared servers.
D. Sorts and Hash Joins use PGA memory.
E. The private SQL area (UGA) is located in the System Global Area (SGA) when using shared servers.
Ans: D E
16. Which two are true about creating RMAN backups for an Oracle container database? (Choose two.)
A. Online Redo Log backups can be created while connected to the root container.
B. Control file backups can be created while connected to the root container.
C. The BACKUP TABLESPACE command can back up a PDB tablespace even if RMAN is connected to CDB$ROOT.
D. Archived Redo Log backups can be created while connected to an application root CDB.
E. Control file backups can be created while connected to a nonroot container. Ans: B C E
17. Which are three of the steps taken by Database Configuration Assistant (DBCA) to clone
a remote pluggable database (PBD) starting from Oracle 19c? (Choose three.)
A. creating a database link from CDB$ROOT in the local database to the PDB in the remote system that is to be cloned
B. creating a database link from CDB$ROOT in the local database to CDB$ROOT in the remote system that is to be cloned
C. creating a new empty PDB in the local database from PDB$SEED
D. creating a database link from CDB$ROOT in the remote database to be cloned to
CDB$ROOT in the local database
E. automatically dropping the database link to the remote database if it already exists
F. creating a database link from CDB$ROOT in the remote database to the PDB in the local database
G. opening the cloned PDB Ans: B E G
18. Which three are true about backing up the control file? (Choose three.)
A. It gets backed up automatically by RMAN when the BACKUP SPFILE command is used
B. It can get backed up automatically as a binary copy
C. It can be backed up manually as a binary copy
D. It can be backed up manually as a trace file containing SQL statements for control file re- creation
E. It gets backed up automatically by RMAN as a trace file containing SQL statements for control file re-creation when a database backup occurs
F. It cannot be backed up manually as a binary copy
Ans: B C D
19. You want to install Oracle Grid Infrastructure for a Standalone Server using Oracle
Universal Installer (OUI).
There is no existing Oracle installation on the server. Which two are prerequisites? (Choose two.)
A. a group called dba
B. the Oracle Inventory group oinstall
C. an operating system user to own this installation
D. an operating system account called grid
E. the installation of Oracle ASMLIB Ans: B C
20. Which two are true about RMAN virtual private catalogs (VPCs)? (Choose two.)
A. RMAN uses Oracle Virtual Private Database (VPD) to implement VPCs
B. Each VPC is owned by the recovery catalog schema owner
C. VPC functionality is enabled by default
D. The RMAN catalog owner can grant access for an already registered database to a new virtual catalog owner
E. Only one target database can be registered in a VPC Ans: A D
21. Which two are true about backup encryption? (Choose two.)
A. Keystore-based encryption is the default mode for RMAN backup encryption
B. Vendor-specific media management software can be used for making encrypted RMAN
backups to media
C. Image copies can be encrypted
D. Backup encryption can be enabled selectively for specific tablespaces
E. The BACKUP BACKUPSET command can encrypt and decrypt backup sets
F. The Transparent Data Encryption (TDE) keystore is backed up using RMAN Ans: A D
22. Which three are true about Data Pump in an Oracle multitenant environment? (Choose three.)
A. It can be used to clone a CDB.
B. It can be used to transport data from a PDB to a non-CDB. C. It can be used to transport data between PDBs.
D. It can be used to create a new PDB.
E. It can be used to transport data from a non-CDB to a PDB. Ans: B C E
23. Which two are true about Lockdown profiles in a container database (CDB) and its pluggable databases (PDBs)? (Choose two.)
A. A Lockdown profile created from a base Lockdown profile is always automatically modified if the profile on which it is based is modified.
B. A PDB Lockdown profile can be created in an application root.
C. A Lockdown profile created from a base Lockdown profile is never automatically modified
if the profile on which it is based is modified.
D. A PDB Lockdown profile can be created in CDB$ROOT. E. A PDB Lockdown profile can be created in a regular PDB.
Ans: B D
24. Which two are true about a read-only Oracle home? (Choose two.)
A. Its configuration data and log files reside in subdirectories under the Oracle home.
B. It is enabled by performing an Oracle Database installation with database creation and then running the roohctl -enable script.
C. It requires the Rapid Home Provisioning service.
D. It contains an image that can be distributed across multiple servers.
E. It is enabled by performing a software-only Oracle Database installation and then running the roohctl -enable script.
Ans: D E
25. Some archived log backups have been accidentally deleted from storage.
Which two commands should be used to update the status of backups in the recovery catalog
to display only the missing backups? (Choose two.)
A. RESYNC CATALOG B. REPORT OBSOLETE
C. LIST ARCHIVELOG ALL
D. CROSSCHECK BACKUP OF ARCHIVELOG ALL E. LIST ARCHIVELOG
F. LIST EXPIRED Ans: D F
26. Which three are true about post-upgrade activities when upgrading an Oracle database using Database Upgrade Assistant? (Choose three.)
A. The Oracle Application Express configuration should be updated after upgrading Oracle
Database.
B. Time zone files must be upgraded manually using the DBMS_DST PL/SQL package.
C. Any Recovery Manager (RMAN) recovery catalog must be upgraded manually.
D. The new extended data type capability must be enabled by running the utlrp.sql script.
E. After a manual upgrade, TNSNAMES.ORA entries must be updated to reflect the new
ORACLE_HOME. Ans: A C E
27. Which two restrictions apply when the RMAN BACKUP AS COPY command is used to create a backup? (Choose two.)
A. Backups can be written only if checksums are stored for each block. B. Binary compression cannot be applied to the backup.
C. Backups can be written only to disk.
D. Backups can be written only to media.
E. Backups can be taken only if a fast recovery area is configured.
F. Backups can be taken only for data files. Ans: B C
28. Examine this configuration:
1. CDB1 is a container database.
2. APP1_ROOT is an application container contained in CDB1.
3. APP1_ROOT$SEED is the application seed contained in APP1_ROOT and synchronized with APP1_ROOT.
4. APP1_PDB1 and APP1_PDB2 are application PDBs contained in APP1_ROOT.
5. APP1_USER_APP is an application installed in APP1_ROOT at version 1.0.
6. USER1 is a common user in APP1_ROOT and all its application PDBs, created when version 1.0 of APP1_USER_APP was installed.
You execute these commands:
$ sqlplus sys/oracle@localhost:1521/cdb1 as sysdba
SQL> ALTER SESSION SET CONTAINER=app1_root; Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app BEGIN UPGRADE '1.0' TO '2.0';
Pluggable database altered.
SQL> GRANT CREATE SESSION TO USER1; Grant succeeded.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_user1_app END UPGRADE TO '2.0';
Pluggable database altered.
SQL> ALTER SESSION SET CONTAINER=app1_pdb1; Session altered.
SQL> ALTER PLUGGABLE DATABASE APPLICATION app1_userl_app SYNC; Pluggable database altered.
Which two are true? (Choose two.)
A. USER1 can connect to APP1_ROOT and APP1_PDB1.
B. USER1 can connect only to APP1_ROOT.
C. USER1 can connect to APP1_ROOT, APP1_ROOT$SEED, and APP1_PDB1.
D. USER1 can connect only to APP1_PDB1. E. USER1 can connect to CDB1.
F. USER1 is defined in APP1_PDB2. Ans: A F
29. A container database, CDB1, contains a pluggable database PDB1. Another container database is called CDB2.
You want to relocate PDB1 from CDB1 to CDB2 with near-zero down time. Which three are required? (Choose three.)
A. CDB2 must be in archivelog mode.
B. CDB1 and CDB2 must both be in local UNDO mode. C. CDB2 must be in shared UNDO mode only.
D. CDB1 must be in shared UNDO mode only. E. CDB1 must be in archivelog mode.
F. CDB1 and CDB2 must be in shared UNDO mode. Ans: A B E
30. Examine this configuration:
1. CDB1 is a container database.
2. DEFAULT_SHARING is METADATA.
3. APP_ROOT is an application root contained in CDB1.
4. APP_PDB1 is an application PDB contained in APP_ROOT.
5. COMPANYAPP is an application contained in APP_ROOT.
6. EMP is a common table created in APP_ROOT and all its application PDBs, created when version 1.0 of COMPANYAPP was installed.
You execute these commands:
What will be the outcome and why?
A. It will return an error because EMP is not empty in APP_ROOT
B. It will return an error because the SYNC operation is not allowed when constraints are added to common objects
C. SAL will be added to APP_PDB1.EMP, with NULLs in columns of existing rows
D. SAL will be added to APP_PDB1.EMP, with 0 in columns of existing rows
E. It will return an error because EMP.SAL is empty in APP_ROOT Ans: A
31. Give:
What is the result?
A. 1525
B. 13
C. Compilation fails
D. An exception is thrown at runtime
E. The program fails to execute due to runtime error
Ans: D
Website không chứa bất kỳ quảng cáo nào, mọi đóng góp để duy trì phát triển cho website (donation) xin vui lòng gửi về STK 90.2142.8888 - Ngân hàng Vietcombank Thăng Long - TRAN VAN BINH
=============================
Nếu bạn không muốn bị AI thay thế và tiết kiệm 3-5 NĂM trên con đường trở thành DBA chuyên nghiệp hay làm chủ Database thì hãy đăng ký ngay KHOÁ HỌC ORACLE DATABASE A-Z ENTERPRISE, được Coaching trực tiếp từ tôi với toàn bộ bí kíp thực chiến, thủ tục, quy trình của gần 20 năm kinh nghiệm (mà bạn sẽ KHÔNG THỂ tìm kiếm trên Internet/Google) từ đó giúp bạn dễ dàng quản trị mọi hệ thống Core tại Việt Nam và trên thế giới, đỗ OCP.
- CÁCH ĐĂNG KÝ: Gõ (.) hoặc để lại số điện thoại hoặc inbox https://m.me/tranvanbinh.vn hoặc Hotline/Zalo 090.29.12.888
- Chi tiết tham khảo:
https://bit.ly/oaz_w
=============================
2 khóa học online qua video giúp bạn nhanh chóng có những kiến thức nền tảng về Linux, Oracle, học mọi nơi, chỉ cần có Internet/4G:
- Oracle cơ bản: https://bit.ly/admin_1200
- Linux: https://bit.ly/linux_1200
=============================
KẾT NỐI VỚI CHUYÊN GIA TRẦN VĂN BÌNH:
📧 Mail: binhoracle@gmail.com
☎️ Mobile/Zalo: 0902912888
👨 Facebook: https://www.facebook.com/BinhOracleMaster
👨 Inbox Messenger: https://m.me/101036604657441 (profile)
👨 Fanpage: https://www.facebook.com/tranvanbinh.vn
👨 Inbox Fanpage: https://m.me/tranvanbinh.vn
👨👩 Group FB: https://www.facebook.com/groups/DBAVietNam
👨 Website: https://www.tranvanbinh.vn
👨 Blogger: https://tranvanbinhmaster.blogspot.com
🎬 Youtube: https://www.youtube.com/@binhguru
👨 Tiktok: https://www.tiktok.com/@binhguru
👨 Linkin: https://www.linkedin.com/in/binhoracle
👨 Twitter: https://twitter.com/binhguru
👨 Podcast: https://www.podbean.com/pu/pbblog-eskre-5f82d6
👨 Địa chỉ: Tòa nhà Sun Square - 21 Lê Đức Thọ - Phường Mỹ Đình 1 - Quận Nam Từ Liêm - TP.Hà Nội
=============================
cơ sở dữ liệu, cơ sở dữ liệu quốc gia, database, AI, trí tuệ nhân tạo, artificial intelligence, machine learning, deep learning, LLM, ChatGPT, DeepSeek, Grok, oracle tutorial, học oracle database, Tự học Oracle, Tài liệu Oracle 12c tiếng Việt, Hướng dẫn sử dụng Oracle Database, Oracle SQL cơ bản, Oracle SQL là gì, Khóa học Oracle Hà Nội, Học chứng chỉ Oracle ở đầu, Khóa học Oracle online,sql tutorial, khóa học pl/sql tutorial, học dba, học dba ở việt nam, khóa học dba, khóa học dba sql, tài liệu học dba oracle, Khóa học Oracle online, học oracle sql, học oracle ở đâu tphcm, học oracle bắt đầu từ đâu, học oracle ở hà nội, oracle database tutorial, oracle database 12c, oracle database là gì, oracle database 11g, oracle download, oracle database 19c/21c/23c/23ai, oracle dba tutorial, oracle tunning, sql tunning , oracle 12c, oracle multitenant, Container Databases (CDB), Pluggable Databases (PDB), oracle cloud, oracle security, oracle fga, audit_trail,oracle RAC, ASM, oracle dataguard, oracle goldengate, mview, oracle exadata, oracle oca, oracle ocp, oracle ocm , oracle weblogic, postgresql tutorial, mysql tutorial, mariadb tutorial, ms sql server tutorial, nosql, mongodb tutorial, oci, cloud, middleware tutorial, docker, k8s, micro service, hoc solaris tutorial, hoc linux tutorial, hoc aix tutorial, unix tutorial, securecrt, xshell, mobaxterm, putty
