Oracle Introduction to Oracle9i SQL Set 2

1.

In which scenario would TOP N analysis be the best solution?

You want to identify the most senior employee in the company. You want to find the manager supervising the largest number of employees. You want to identify the person who makes the highest salary for all employees. You want to rank the top three sales representatives who have sold the maximum number of products.

2.

Which constraint can be defines only at the column level?

UNIQUE NOT NULL CHECK PRIMARY KEY FOREIGN KEY

3.

What is true about the WITH GRANT OPTION clause?

It allows a grantee DBA privileges. It is required syntax for object privileges. It allows privileges on specified columns of tables. It is used to grant an object privilege on a foreign key column. It allows the grantee to grant object privileges to other users and roles.

4.

Which substitution variable would you use if you want to reuse the variable without prompting the user each
time?

&

ACCEPT PROMPT

&&

5.

The EMPLOYEES table has these columns:

LAST NAME VARCHAR2(35)
SALARY NUMBER(8,2)
HIRE_DATE DATE

Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL
statement:

ALTER TABLE EMPLOYEES
MODIFY ( SALARY DEFAULT 5000);

What is true about your ALTER statement?

Column definitions cannot be altered to add DEFAULT values. A change to the DEFAULT value affects only subsequent insertions to the table. Column definitions cannot be altered at add DEFAULT values for columns with a NUMBER data type. All the rows that have a NULL value for the SALARY column will be updated with the value 5000.

6.

The DBA issues this SQL command:

CREATE USER scott
IDENTIFIES by tiger;

What privileges does the user Scott have at this point?

No privileges. Only the SELECT privilege. Only the CONNECT privilege. All the privileges of a default user.

7.

You need to produce a report for mailing labels for all customers. The mailing label must have only the
customer name and address. The CUSTOMERS table has these columns:

CUST_ID NUMBER(4) NOT NULL
CUST_NAME VARCHAR2(100) NOT NULL
CUST_ADDRESS VARCHAR2(150)
CUST_PHONE VARCHAR2(20)

Which SELECT statement accomplishes this task?

SELECT*
FROM customers;

SELECT name, addressFROM customers;

SELECT id, name, address, phoneFROM customers;

SELECT cust_name, cust_addressFROM customers;

SELECT cust_id, cust_name, cust_address, cust_phoneFROM customers;

8.

Which statement describes the ROWID data type?

Binary data up to 4 gigabytes. Character data up to 4 gigabytes. Raw binary data of variable length up to 2 gigabytes. Binary data stored in an external file, up to 4 gigabytes. A hexadecimal string representing the unique address of a row in its table.

9.

Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? (Choose four)

You cannot roll back this statement. All pending transactions are committed. All views based on the DEPT table are deleted. All indexes based on the DEPT table are dropped. All data in the table is deleted, and the table structure is also deleted.

10.

You are granted the CREATE VIEW privilege. What does this allow you to do?

Create a table view. Create a view in any schema. Create a view in your schema. Create a sequence view in any schema. Create a view that is accessible by everyone.

Oracle Introduction to Oracle9i SQL Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle Introduction to Oracle9i SQL Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner