oracle1

Which of the following are the five built-in functions provided by SQL? SUM, AVG, MIN, MAX, MULT SUM, AVG, MIN, MAX, NAME COUNT, SUM, AVG, MAX, MIN SUM, AVG, MULT, DIV, MIN

COUNT, SUM, AVG, MAX, MIN

Queries containing set operators are called ______ . Outer queries Compound queries Subqueries Inner queries

Compound queries

Queries containing set operators are called __________ . Outer queries Compound querires Subqueries Inner queries

Compound querires

The condition INSERT FIRST command evaluates the WHEN condition in order. For all conditions that are true a row is inserted into the appropriate table. True False

False

You can update only a single column at a time in a table. True False

False

Queries that return more than one row from the inner SELECT statement are called Single-row subqueries Multiple-row subqueries Sing-column subqueries Multiple-column subqueries

Multiple-row subqueries

Consider the SQL statement. Which of the following clauses does not sort the result rows by the salary values in the ascending order? SELECT last_name "Employee", salary "Salary" FROM employees ORDER BY 2 ORDER BY "Salary" ASC; ORDER BY salary; ORDER BY "Salary" DESC;

ORDER BY salary;

If there are schemas named USERA and USERB, and both have an EMPLOYEES table, then if USERA wants to access the EMPLOYEES table that belongs to USERB, USERA must write select statement as follows: SELECT * FROM employees.userb; SELECT * FROM employees; SELECT * FROM userb.employees; SELECT * FROM usera.employees;

SELECT * FROM userb.employees;

Which SQL statement is used to return only different values? SELECT DISTINCT SELECT DIFFERENT SELECT UNIQUE EXTRACT DESC

SELECT DISTINCT

With SQL, how do you select a column named "FirstName" from a table named "Persons"? EXTRACT FirstName FROM Persons SELECT Persons.FirstName EXTRACT FROM Persons SELECT FirstName FROM Persons

SELECT FirstName FROM Persons

Consider the EMPLOYEES table. Which of the following displays the maximum average salary for each department? SELECT MAX(AVG(salary)) FROM employees SELECT AVG(MAX(salary)) FROM employees GROUP BY department_id SELECT MAX(AVG(salary)) FROM employees GROUP BY department_id SELECT department_id, MAX(AVG(salary)) FROM employees GROUP BY department_id

SELECT MAX(AVG(salary)) FROM employees GROUP BY department_id

Consider the EMPLOYEES table. Which of the following statements displays the date in the 'January, 19 1998'? SELECT TO_DATE(hire_date,'fmMONTH, DD YYYY') FROM employees SELECT TO_DATE(hire_date,'fmMonth, DD YYYY') FROM employees SELECT TO_CHAR(hire_date,'fmMonth, DD YYYY') FROM employees SELECT TO_DATE(hire_date,'fmMON, DD YEAR') FROM employees

SELECT TO_CHAR(hire_date,'fmMonth, DD YYYY') FROM employees

A table can be created with or without data. True False

True

Privileges, roles, and synonyms are all used to implement security in an Oracle database. True False

True

The NOT NULL constraint enforces a column to not accept null values True False

True

The NUMBER data types is usually the best choice for a primary key. True False

True

The TRUNCATE command removes all data permanently from a table. True False

True

The data dictionary view USER_TAB_PRIVS_MADE lists details of table privilege grants performed by the current user. True False

True

Transaction control determines when data manipulates becomes permanent in a database. False True

True

You can not order the results of a set operation False True

True

You can rename a table with the RENAME or the ALTER TABLE command. True False

True

Use the _____ operator to return all rows from multiple tables and eliminate any duplicate rows. INTERSECT UNION UNION ALL MINUS

UNION

The ____ operator returns all rows that are selected by either query INTERSECT MINUS UNION UNION ALL

UNION ALL

The ____ operator compares a value to EACH value returned by a subquery ALL NOT SOME ANY

ANY

Which keyword is used to provide an alias to a column? COLUMN AS ALIAS IS

AS

Which command is used to view the structure of the table LOCATIONS? PRINT LOCATIONS SELECT * FROM LOCATIONS DESCRIBE LOCATIONS SHOW STRUCTURE LOCATIONS

DESCRIBE LOCATIONS

To remove duplicate rows from the results of an SQL SELECT statement, the ________ qualifier specified must be included. ONLY DISTINCT SINGLE UNIQUE

DISTINCT

Which keyword is used to eliminate duplicate rows in the result? HAVING DISTINCT DESCRIBE GROUP BY

DISTINCT

When executed, this statement cannot be rolled back ALTER TABLE DROP TABLE DELETE TABLE REMOVE TABLE

DROP TABLE

Which SQL statement is used to update data in a database? modify save update save as

update

Which of the following is a concatenation operator? * + || &

||

Which of the following statements about aliases is NOT true? Aliases immediately follows the column name The keyboard AS between an alias and a column name is optional Aliases always require double quotation marks Aliases rename column heading

Aliases always require double quotation marks

You can nor selectively delete rows a table. True False

False

What will be the result of the following SQL statement?SELECT SUBSTR ('Hello,World!!!',13) FROM DUAL !!! Hello, World! An error will occur, since SUBSTR function need to take 3 parameters Hello,World!!!13

!!!

What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'DD.MM.YY') FROM Dual; 31.May.2013 An error will occur 31.05.2013 31.05.13

31.05.13

What will be the result of the following query?SELECT ROUND (63.548, -1) FROM DUAL; 63 60 70 64

60

The ______ operator compares a value to every value returned by a subquery. Some All Not Any

All

The wildcard in a WHERE clause is useful when? An exact match is necessary in a SELECT statement. An exact match is necessary in a CREATE statement. An exact match is not possible in a SELECT statement. An exact match is not possible in a CREATE statement.

An exact match is not possible in a SELECT statement.

The ______ constraint defines a condition that each row must satisfy. FOREIGN KEY PRIMARY KEY CHECK UNIQUE

CHECK

Which SQL statement is used to create a database? NEW DATABASE CREATE DATABASE TEST CREATE DB CREATE TABLE

CREATE DATABASE TEST

Which SQL statement is used to create a table in a database? CREATE DATABASE TABLE CREATE DATABASE TAB CREATE TABLE CREATE DB

CREATE TABLE

Any user can grant or revoke ant type of system privileges to or from another user. True False

False

The UNION and UNION ALL set operator have the opposite effect other. True False

False

The data of a temporary table is visible to all session. True False

False

What will be the result of the following SQL statement? (SYSDATE is a date of your exam)SELECT TO_CHAR(SYSDATE, 'Day') FROM Dual; 31-05.2013 31.05.2013 Friday 31

Friday

You can place the subquery in a number of SQL clauses, including the following:I. WHERE clauseII. HAVING clauseIII. FROM clause I and III I,II and III I only I and II

I,II and III

Which of the following functions finds the numeric position of a named character? INSTR SUBSTR TRIM CONCAT

INSTR

Which of the following functions finds the numeric position of a named character? INSTR TRIM CONCAT SUBSTR

INSTR

The SQL WHERE clause: Both A and B are correct. Limits the row data are returned. Limits the column data that are returned. Neither A nor B are correct.

Limits the row data are returned.

What will be the result of the following SQL statement?SELECT INITCAP(SUBSTR(CONCAT('Hello',world),4,3)) FROM DUAL; LLO Llo LOW Low

Low

Which statement discards all pending data changes COMMIT ROLLBACK SAVEPOINT DISCARD

SAVEPOINT

Which SQL statement is used to extract data from a database? OPEN SELECT GET EXTRACT

SELECT

With SQL, how do you select all the columns from a table named "Persons"? SELECT [all] FROM Persons SELECT Persons SELECT *.Persons SELECT * FROM Persons

SELECT * FROM Persons

With SQL, how can you return all the records from a table named "Persons" sorted descending by "FirstName"? SELECT * FROM Persons ORDER FirstName DESC SELECT * FROM Persons SORT OR 'FirstName' DESC SELECT * FROM Persons SORT BY 'FirstName' DESC SELECT * FROM Persons ORDER BY FirstName DESC

SELECT * FROM Persons ORDER BY FirstName DESC

With SQL, how do you select all the records from a table named "Persons" where the value of the column "FirstName" is "Peter"? SELECT [all] FROM Persons WHERE FirstName LIKE 'Peter' SELECT * FROM Persons WHERE FirstName='Peter' SELECT [all] FROM Persons WHERE FirstName='Peter' SELECT * FROM Persons WHERE FirstName<>'Peter'

SELECT * FROM Persons WHERE FirstName='Peter'

With SQL, how do you select all the records from a table named "Persons" where the "FirstName" is "Peter" and the "LastName" is "Jackson"? SELECT FirstName='Peter', LastName='Jackson' FROM Persons SELECT * FROM Persons WHERE FirstName<>'Peter' AND LastName<>'Jackson' SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson' SELECT * FROM Persons WHERE FirstName='Peter' OR LastName='Jackson'

SELECT * FROM Persons WHERE FirstName='Peter' AND LastName='Jackson'

With SQL, how can you return the number of records in the "Persons" table? SELECT NO(*) FROM Persons SELECT COUNT(*) FROM Persons SELECT COLUMNS(*) FROM Persons SELECT LEN(*) FROM Persons

SELECT COUNT(*) FROM Persons

Consider the EMPLOYEES table. Which of the following SQL statements is correct to provide the sentence in the format "King has been working since 01.01.1987" with "Employee Information" alias? SELECT last_name ||'has been working since' || hire_date "Employee Information" FROM employees; SELECT last_name || 'has been working since' || hire_date 'Employee Information' FROM employees; SELECT last_name || 'has been working since' || hire_date Employee Information FROM employees SELECT last_name || "has been working since" || hire_date "Employee Information" FROM employees;

SELECT last_name ||'has been working since' || hire_date "Employee Information" FROM employees;

What does SQL stand for? Structured Question Language Strong Question Language Structured Query Language Slow Query Language

Structured Query Language

The result of a SQL SELECT statement is a(n) ________ . Form Table File Report

Table

Which of the following statements about aliases is NOT true? The keyboard AS between an alias and a column name is optional Aliases rename column heading Aliases immediately follows the column name Aliases always require double quotation marks

The keyboard AS between an alias and a column name is optional

A parent table referenced by a child table may not be dropped. True False

True

By default, the foreign key restricts deletes of any parent row has a corresponding child row(s). True False

True

Privileges, roles, and synonyms are all used to implement security in an Oracle Database. True False

True

The OR operator displays a record if ANY conditions listed are true. The AND operator displays a record if ALL of the conditions listed are true True False

True

You can add and drop columns from a table using the ALTER TABLE command. True False

True

Which of the following clauses is used to limit the rows that are retrieved by the query? GROUP BY WHERE FROM ORDER BY

WHERE

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those who work in the department prompted by the user? WHERE department_id like '_Department' WHERE department_id = '%Department' WHERE department_id = '&Department' WHERE department_id LIKE '%Department'

WHERE department_id = '&Department'

Consider the EMPLOYEES table. Which condition in the WHERE clause limit the employees to those whose salary is greater than 5000 but less than 18000? WHERE salary > 5000 AND salary < 18000 WHERE salary > 5000 OR salary < 18000 WHERE salary < 5000 AND salary > 18000 WHERE salary >5000 AND salary > 18000

WHERE salary > 5000 AND salary < 18000

Which operator is used to search for a specified pattern in a column? get from set like

like