1Z0-061 - Oracle Database 12c: SQL Fundamentals Exam
Go back to Oracle
How many questions are there on the 1Z0-061 exam?
There are 75 questions on the 1Z0-061 exam to be completed in 120 minutes.
How long is the 1Z0-061 exam?
The 1Z0-061 exam is 120 minutes to complete 75 questions.
How much does the 1Z0-061 exam cost?
The 1Z0-061 exam is $125. The exam provider is Pearson Vue and you can register for the exam on their website.
What is the best way to study for the 1Z0-061 exam?
The best way to study for the 1Z0-061 exam is to practice at Exam.com.
Which two statements are true regarding the count function?
Count (*) returns the number of rows including duplicate rows and rows containing null value in any of the columns.
Count (distinct inv_amt) returns the number of rows excluding rows containing duplicates and NULL values in the INV_AMT column.
Evaluate the following query: SQL> SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL; What would be the outcome?
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?
INTERVAL DAY TO SECOND
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?
Second normal form
You issue the following command to drop the products table: SQL> DROP TABLE products; Which three statements are true about the implication of this command?
All data along with the table structure is deleted.
A pending transaction in the session is committed.
All views and synonyms remain but they are invalidated.
Which two statements are true regarding constraints?
A table can have only one primary key but multiple foreign keys.
Both primary key and foreign key constraints can be defined at both column and table levels.
Which statement is true regarding the default behavior of the order by clause?
In a character sort, the values are case-sensitive.
Which statement is true regarding the UNION operator?
The number of columns selected in all select statements need not be the same.
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?
Disable the primary key in the STORES table.
DELETE the rows with STORE_ID = 900 from the SALES table and then delete rows from STORES table.
Disable the FOREIGN KEY in SALES table and then delete the rows.
Which three tasks can be performed using SQL functions built into Oracle Database?
Displaying a date in a nondefault format
Finding the number of characters in an expression
Substituting a character string in a text expression with a specified string
In which three situations does a transaction complete?
When a ROLLBACK command is executed
When a data definition language (DDL) statement is executed
When a TRUNCATE statement is executed after the pending transaction