OCA Oracle Database 12c 1Z0-061 Free Demo

Passcert 1Z0-061 offer a specific OCA Oracle Database 12c 1Z0-061 Free Demo for many examinees participating in IT certification exams. Our OCA Oracle Database 12c 1Z0-061 Free Demo includes simulation test before the formal examination, specific training course and the current exam which has 95% similarity with the real exam. Please add Passcert to you shopping 1Z0-061 quickly.Now there are many IT professionals in the world and the competition of IT industry is very fierce.
Share some Oracle Database 1Z0-061 exam questions and answers below.
You issued the following command: 
SQL> DROP TABLE employees; 
Which three statements are true? 
A. All uncommitted transactions are committed. 
B. All indexes and constraints defined on the table being dropped are also dropped. 
C. Sequences used in the employees table become invalid. 
D. The space used by the employees table is reclaimed immediately. 
E. The employees table can be recovered using the rollback command. 
F. The employees table is moved to the recycle bin. 
Answer: A,B,F 


Examine the data in the CUST_NAME column of the customers table. 



You need to display customers' second names where the second name starts with "Mc" or "MC." 
Which query gives the required output? 



A. Option A 
B. Option B 
C. Option C 
D. Option D 
Answer: B

Which two statements are true regarding subqueries? 
A. A subquery can retrieve zero or more rows. 
B. Only two subqueries can be placed at one level. 
C. A subquery can be used only in SQL query statements. 
D. A subquery can appear on either side of a comparison operator. 
E. There is no limit on the number of subquery levels in the WHERE clause of a SELECT statement. 
Answer: A,D 


View the Exhibit and examine the structure of the product, component, and PDT_COMP tables. 
In product table, PDTNO is the primary key. 
In component table, COMPNO is the primary key. 
In PDT_COMP table, You want to generate a report listing the product names and their corresponding component names, if the component names and product names exist.
Evaluate the following query:
SQL>SELECT pdtno, pdtname, compno, compname
FROM product _____________ pdt_comp
USING (pdtno) ____________ component USING (compno)
WHERE compname IS NOT NULL;
Which combination of joins used in the blanks in the above query gives the correct output?



A. JOIN; JOIN
B. FULL OUTER JOIN; FULL OUTER JOIN
C. RIGHT OUTER JOIN; LEFT OUTER JOIN
D. LEFT OUTER JOIN; RIGHT OUTER JOIN
Answer: C

Examine the structure of the products table:



You want to display the names of the products that have the highest total value for UNIT_PRICE * QTY_IN_HAND.
Which SQL statement gives the required output?



A. Option A
B. Option B
C. Option C
D. Option D
Answer: A

Which create table statement is valid?



A. Option A
B. Option B
C. Option C
D. Option D
Answer: D


Examine the types and examples of relationships that follow:
One-to-one a) Teacher to students
One-to-many b) Employees to Manager
Many-to-one c) Person to SSN
Many-to-many d) Customers to products
Which option indicates the correctly matched relationships?
A. 1-a, 2-b, 3-c, and 4-d
B. 1-c, 2-d, 3-a, and 4-b
C. 1-c, 2-a, 3-b, and 4-d
D. 1-d, 2-b, 3-a, and 4-c
Answer: C

You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?



A. Option A
B. Option B
C. Option C
D. Option D
Answer: D


Evaluate the following query:



What would be the outcome of the above query?
A. It produces an error because flower braces have been used.
B. It produces an error because the data types are not matching.
C. It executes successfully and introduces an 's at the end of each PROMO_NAME in the output.
D. It executes successfully and displays the literal "{'s start date was \} * for each row in the output.
Answer: C


Examine the structure and data of the CUST_TRANS table:
Dates are stored in the default date format dd-mon-rr in the CUST_TRANS table.
Which three SQL statements would execute successfully?



A. SELECT transdate + '10' FROM cust_trans;
B. SELECT * FROM cust_trans WHERE transdate = '01-01-07';
C. SELECT transamt FROM cust_trans WHERE custno > '11';
D. SELECT * FROM cust_trans WHERE transdate='01-JANUARY-07';
E. SELECT custno + 'A' FROM cust_trans WHERE transamt > 2000;
Answer: A,C,D

Examine the structure of the transactions table:



You want to display the date, time, and transaction amount of transactions that where done before 12 noon. The value zero should be displayed for transactions where the transaction amount has not been entered.
Which query gives the required result?



A. Option A
B. Option B
C. Option C
D. Option D
Answer: B

Examine the structure proposed for the transactions table:



Which two statements are true regarding the creation and storage of data in the above table structure?
A. The CUST_STATUS column would give an error.
B. The TRANS_VALIDITY column would give an error.
C. The CUST_STATUS column would store exactly one character.
D. The CUST_CREDIT_LIMIT column would not be able to store decimal values.
E. The TRANS_VALIDITY column would have a maximum size of one character.
F. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds
Answer: B,C


View the Exhibit and examine the data in the costs table.



You need to generate a report that displays the IDs of all products in the costs table whose unit price is at least 25% more than the unit cost. The details should be displayed in the descending order of 25% of the unit cost.
You issue the following query:



Which statement is true regarding the above query?
A. It executes and produces the required result.
B. It produces an error because an expression cannot be used in the order by clause.
C. It produces an error because the DESC option cannot be used with an expression in the order by clause.
D. It produces an error because the expression in the ORDER by clause should also be specified in the SELECT clause.
Answer: A

View the Exhibit and examine the structures of the employees and departments tables.



You want to update the employees table as follows:
- Update only those employees who work in Boston or Seattle (locations 2900 and 2700).
- Set department_id for these employees to the department_id corresponding to London
(location_id 2100).
- Set the employees' salary in iocation_id 2100 to 1.1 times the average salary of their department.
- Set the employees' commission in iocation_id 2100 to 1.5 times the average commission of their department.
You issue the following command:



What is the outcome?
A. It executes successfully and gives the correct result.
B. It executes successfully but does not give the correct result.
C. It generates an error because a subquery cannot have a join condition in an update statement.
D. It generates an error because multiple columns (SALARY, COMMISSION) cannot be specified together in an update statement.
Answer: B


View the Exhibit and examine the structure of the customers table.



NEW_CUSTOMERS is a new table with the columns CUST_ID, CUST_NAME and CUST_CITY that have the same data types and size as the corresponding columns in the customers table.
Evaluate the following insert statement:



The insert statement fails when executed.
What could be the reason?
A. The values clause cannot be used in an INSERT with a subquery.
B. Column names in the NEW_CUSTOMERS and CUSTOMERS tables do not match.
C. The where clause cannot be used in a subquery embedded in an INSERT statement.
D. The total number of columns in the NEW_CUSTOMERS table does not match the total number of columns in the CUSTOMERS table.
Answer: A


View the Exhibit and evaluate the structure and data in the CUST_STATUS table.



You issue the following SQL statement:



Which statement is true regarding the execution of the above query?
A. It produces an error because the AMT_SPENT column contains a null value.
B. It displays a bonus of 1000 for all customers whose AMT_SPENT is less than CREDIT_LIMIT.
C. It displays a bonus of 1000 for all customers whose AMT_SPENT equals CREDIT_LIMIT, or AMT_SPENT is null.
D. It produces an error because the TO_NUMBER function must be used to convert the result of the NULLIF function before it can be used by the NVL2 function.
Answer: C


Which statement is true regarding the UNION operator?
A. By default, the output is not sorted.
B. Null values are not ignored during duplicate checking.
C. Names of all columns must be identical across all select statements.
D. The number of columns selected in all select statements need not be the same.
Answer: B


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 credit period.
2) The data in the column should be stored in a format such that it can be easily added and subtracted with date data type without using conversion functions.
3) The maximum period of the credit provision in the application is 30 days.
4) The interest has to be calculated for the number of days an individual has taken a credit for.
Which data type would you use for such a column in the table?
A. DATE
B. NUMBER
C. TIMESTAMP
D. INTERVAL DAY TO SECOND
E. INTERVAL YEAR TO MONTH
Answer: D


Examine the create table statements for the stores and sales tables.
SQL> CREATE TABLE stores (store_id NUMBER (4) CONSTRAINT store_id_pk PRIMARY KEY, store_name VARCHAR2 (12), store_address VARCHAR2 (20), start_date DATE);
SQL> CREATE TABLE sales (sales_id NUMBER (4) CONSTRAINT sales_id_pk PRIMARY
KEY, item_id NUMBER(4), quantity NUMBER(10), sales_date DATE, store_id NUMBER(4), CONSTRAINT store_id_fk FOREIGN KEY(store_id) REFERENCES stores(store_id));
You executed the following statement:
SQL> DELETE from stores
WHERE store_id=900;
The statement fails due to the integrity constraint error:
ORA-02292: integrity constraint (HR.STORE_ID_FK) violated
Which three options ensure that the statement will execute successfully?
A. Disable the primary key in the STORES table.
B. Use CASCADE keyword with DELETE statement.
C. DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
D. Disable the FOREIGN KEY in SALES table and then delete the rows.
E. Create the foreign key in the SALES table on SALES_ID column with on DELETE CASCADE option.
Answer: A,C,D

You want to create a sales table with the following column specifications and data types:
SALESID: Number
STOREID: Number
ITEMID: Number
QTY: Number, should be set to 1 when no value is specified
SLSDATE: Date, should be set to current date when no value is specified
PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified
Which statement would create the table?



A. Option A
B. Option B
C. Option C
D. Option D
Answer: B



Do you want to pass the Oracle 1Z0-061 exam better and faster? Then please select the Passcert. It can help you achieve your dreams. Passcert is a website that provide accurate OCA Oracle Database 12c 1Z0-061 Free Demo for people who want to participate in the IT certification. Passcert can help a lot of IT professionals to enhance their career blueprint. Our strength will make you incredible. You can try a part of the OCA Oracle Database 12c 1Z0-061 Free Demo about Oracle 1Z0-061 exam to test our reliability.