1Z0-061 Exam Questions

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?

Which statement adds a column called salary to the employees table having 100 rows, which cannot contain null?

Which two statements are true regarding single row functions?

Which two statements are true regarding the count function?

Evaluate the following SQL statement: Which statement is true regarding the outcome of the above query?

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...

View the Exhibit for the structure of the student and faculty tables. You need to display the faculty name followed by the number of students handled by the faculty at the base loc...

View the Exhibits and examine products and sales tables. You issue the following query to display product name and the number of times the product has been sold: What happens when...

You want to create a table employees in which the values of columns EMPLOYEES_ID and LOGIN_ID must be unique and not null. Which two SQL statements would create the required table?

View the Exhibit and examine the structure of the products table. Using the products table, you issue the following query to generate the names, current list price, and discounted...

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?

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

You want to display 5 percent of the employees with the highest salaries in the EMPLOYEES table. Which query will generate the required result?

In the customers table, the CUST_CITY column contains the value 'Paris' for the CUST_FIRST_NAME 'Abigail'. Evaluate the following query: What would be the outcome?

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 q...

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 a) Teacher to students 2. One-to-many b) Employees to Manager 3. Many-to-one c) Person to SSN 4. Many-to-...

You execute the following commands: For which substitution variables are you prompted for the input?

You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE. Examine the sample output: Which query will provide the required output?

Which create table statement is valid?

Which two statements are true regarding constraints?

In which three situations does a transaction complete?

Examine the structure of the orders table: You want to find the total value of all the orders for each year and issue the following command: Which statement is true regarding the o...

View the Exhibit and examine the structure of the products table. All products have a list price. You issue the following command to display the total price of each product after a...

The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL p...

On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Wh...

You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

Evaluate the SQL statement: TRUNCATE TABLE DEPT; Which three are true about the SQL statement? (Choose three.)

You need to design a student registration database that contains several tables storing academic information. The STUDENTS table stores information about a student. The STUDENT_GRA...

Which two statements are true regarding savepoints? (Choose two.)

See the Exhibit and examine the structure and data in the INVOICE table: Which two SQL statements would executes successfully? (Choose two.)

Which three statements are true regarding sub queries? (Choose three.)

Evaluate these two SQL statements: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What...

Where can sub queries be used? (Choose all that apply)

Which statement correctly describes SQL and /SQL*Plus?

Which four are types of functions available in SQL? (Choose 4)

Examine the structure of the EMPLOYEES and NEW_EMPLOYEES tables: Which MERGE statement is valid?

Which view should a user query to display the columns associated with the constraints on a table owned by the user?

The COMMISSION column shows the monthly commission earned by the employee. Which two tasks would require sub queries or joins in order to be performed in a single step? (Choose two...

Examine the structure of the STUDENTS table: You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in t...

Evaluate the following SQL statements: The above command fails when executed. What could be the reason?

Evaluate the following SQL statements: DELETE FROM sales; There are no other uncommitted transactions on the SALES table. Which statement is true about the DELETE statement?

Examine the structure of the EMPLOYEES table: You want to create a SQL script file that contains an INSERT statement. When the script is run, the INSERT statement should insert a r...

Which two statements are true about sequences created in a single instance database? (Choose two.)

The ORDERS TABLE belongs to the user OE. OE has granted the SELECT privilege on the ORDERS table to the user HR. Which statement would create a synonym ORD so that HR can execute t...

Evaluate this SQL statement: SELECT e.emp_name, d.dept_name FROM employees e JOIN departments d USING (department_id) WHERE d.department_id NOT IN (10, 40) ORDER BY dept_name; The...

Examine the statement: Create synonym emp for hr.employees; What happens when you issue the statement?