1Z0-060 Practice Questions

Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

Examine the types and examples of relationships that follow: 1. One-to-one

You need to create a table for a banking application. One of the columns in the table has the following requirements: 1) You want a column in the table to store the duration of the...

Which three tasks can be performed using SQL functions built into Oracle Database?

Which two statements are true regarding the count function?

Which two statements are true regarding single row functions?

You issue the following command to alter the country column in the departments table: Which statement is true?

Which two statements are true regarding constraints?

Examine the structure of the customers table: CUSTNO is the primary key in the table. You want to find out if any customers' details have been entered more than once using differen...

Which statement is true regarding the default behavior of the order by clause?

Which three SQL statements would display the value 1890.55 as $1, 890.55?

In your Oracle 12c database, you create two roles: and AUDIT_ADMIN. You then AUDITOR execute the following commands: To create a privilege analysis policy for the AUDIT_ADMIN role,...

You want to upgrade your pre-12c database to an Oracle 12c database. You set up the test environment and replay the captured workload from the production database on the test machi...

Which two statements are true about Enterprise Manager (EM) express in Oracle Database 12c? (Choose two.)

You must configure Oracle Data Redaction for the EMP table to satisfy the following requirements: - RANDOM redaction on the SAL and COMM columns - PARTIAL redaction on the HIREDATE...

You enabled an audit policy by issuing the following statements: SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SCOTT; SQL> AUDIT POLICY ORA_DATABASE_PARAMETER BY SYS, SYSTEM; For whi...

On your Oracle 12c database, you issue the following commands to create indexes: SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id) INVISIBLE; SQL> CRE...

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in UNIX?

You find this query being used in your Oracle 12c database: Which method a used by the optimizer to limit the rows being returned?

You are administering a database stored in Automatic Storage Management (ASM). You use RMAN to back up the database and the MD_BACKUP command to back up the ASM metadata regularly....

Which two are direct benefits of the multiprocess, multithreaded architecture of Oracle Database 12c when it is enabled? (Choose two.)

Which two statements are true when row-archival management is enabled? (Choose two.)

To complete the online redefinition procedure, you execute the following command; EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE(`SH', `SALES', `INT_SALES', 600); What is the signifi...

You notice a performance change in your production Oracle 12c database and you want to know what change caused this performance difference. You generate the compare period Automati...

Which five actions are prerequisites for using extended data types for VARCHAR2, NVARCHAR2, and RAW columns in Oracle Database 12c?

You plan to recover the SCOTT.EMP table to a specific point in time by using RMAN: RMAN> RECOVER TABLE SCOTT.EMP UNTILL SYSDATE-2 USING AUXILIARY LOCATION `+RECO'; Which five steps...

Identify the prerequisite for configuring and accessing Enterprise Manager (EM) express for an Oracle 12c database.

Your multitenant container database (CDB) containing two pluggable databases, PDB2_1 and PDB2_2, is running in ARCHIEVELOG mode. An RMAN backup exists for the databases. You issue...

In your database, the TBS PERCENT USED parameter is set to 60 and the TBS PERCENT FREE parameter is set to 20. Which two storage-tiering actions might be automated when using infor...

Which two are true concerning a multitenant container database with three pluggable databases?

Oracle Data Redaction is active on the table. SCOTT.EMP You queried the table twice. SQL> SELECT ENAME, SAL, COMM, MGR, HIREDATE FROM EMP WHERE DEPTNO=30; SQL> SELECT ENAME, SAL, C...

Which three statements are true about tablespaces in a multitenant container database (CDB)?

On your Oracle 12c database, you issue the following commands to create indexes: SQL> CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customer_id, sales_rep_id); SQL> CREATE BITMAP...

What are three purposes of the RMAN "FROM SERVICE" clause?

You connect to the root container of a multitenant container database (CDB) with SYSDBA privileges by using SQL*Plus. The CDB has several pluggable databases (PDBs) open in read/wr...

Which two statements are true concerning Information Lifecycle Management (ILM) policies?

Which three are amongst the categories into which column definitions are classifies by the Database Migration Assistant for Unicode (DMU)?

You plan to drop the column of a table that has Flashback Archiving enabled. You want to ensure minimal service disruption. How would you do this in your Oracle 12c Database?

Your multitenant container database (CDB) contains some pluggable databases (PDBs), you execute the following commands to create a common user and grant connect privileges: Which s...

Which three statements are true about adaptive SQL plan management?

You are the DBA for an Oracle Database 11g Release 1 data warehouse database running on Oracle Linux with little endianness. You want to plug in a transportable tablespace with a 1...

Which two statements are true about Oracle Direct Network File System (NFS)?

Which three statements are true about RMAN compressed backups?

You notice that the elapsed time for an important database scheduler job is unacceptably long. The job belongs to a scheduler job class and runs in a scheduler window. Which two ac...

Which two statements are true about Oracle Data Pump export and import operations?

You configure your database Instance to support shared server connections. Which two memory areas that are part of PGA are stored in SGA instead, for shared server connections?

Your database uses Automatic Memory Management, and has the large pool configured. You issue the following command: SQL> ALTER SYSTEM SET SHARED_SERVERS = 5; Which statement is tru...

You issue the following commands: The directories '/u0l/app/oracle/oradata/orcl' and '/u0l/app/oracle/mydata' exist. Which statement describes the outcome?

Examine the memory-related parameters of an Oracle database instance: Which statement is true?

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)