1z0-001 Oracle - Braindumps.com.ua: question list for "Ineroduction to oracle:sql and pl/sql", page: 5

Add to favorites

Profile

Registration

Braindumps

Master braindump list

Forums

Vendor

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2461)

Network Appliance (2)

Authorization

Login:
Password:
remember me:

Contacts
Certification links
Links

Authorized user can see question and answers.
Please log in or sign up.

Exam question list:
Show all comments

Oracle 1z0-001: Ineroduction to oracle:sql and pl/sql

#41. Evaluate these two SQL commands:

 1 SELECT DISTINCT object_type FROM user_objects; 
 2 SELECT object_type FROM all_objects;

How will the results differ?

#42. You have been granted UPDATE privileges on the last_name column of the employee table. Which data dictionary view would you query to display the column the privilege was granted on and the schema that owns the employee table?

#43. Examine the structure of the STUDENT table:

 Name           Null?          Type 
 STUD_ID        NOT NULL       NUMBER(3) 
 NAME           NOT NULL       VARCHAR2(25) 
 ADDRESS                       VARCHAR2(50) 
 GRADUATION                    DATE

Graduation column is a foreign key column to the GRADDATE table. Examine the data in the GRADDATE table: GRADUATION
____________
20-JAN-1999
12-MAY-1999
19-JAN-2000
25-MAY-2000
13-JAN-2001
29-MAY-2001
Which update statement produces the following error? ORA-02291: integrity constraint (SYS_C23) violated - parent key not found

#44. You are updating the employee table. Jane has been granted the same privileges as you on the employee table. You ask Jane to log on to the database to check your work before you issue a COMMIT command. What can Jane do to the employee table?

#45. Click on the EXHIBIT button and examine the table instance chart for the sales table.

You attempt to change the database with this command:

 INSERT INTO sales (purchase_no, customer_id, car_id) 
 VALUES (1234, 345, 6);

If this statement fails, which condition would explain the failure?

#46. Click on the EXHIBIT button and examine the table instance chart for the patient table.

Which script would you use to delete a patient from the table by prompting the user for the id_number of the patient?

#47. You want to display the details of all employees whose last name is Smith, but you are not sure in which case the last names are stored. Which statement will list all the employees whose last name is Smith?

#48. The EMP table contains columns to hold the birth date and hire date of employees. Both of these columns are defined with DATE as their datatype. You want to insert a row with the details of employee Smith who was born in 1944 and hired in 2004. Which statement will ensure that values are inserted into the table in the correct century?

#49. The EMPLOYEE table contains these columns:

 FIRST_NAME     VARCHAR2(25) 
 LAST_NAME      VARCHAR2(25)

Evaluate these two SQL statements:

 1. SELECT CONCAT(first_name, last_name), 
 LENGTH(CONCAT(first_name, last_name)) 
 FROM employee 
 WHERE UPPER(last_name) LIKE ‘%K’ 
 ORUPPER(last_name) LIKE ‘%K’ 
 ORUPPER(last_name) LIKE ‘%K’;

 2. SELECT INITCAP(first_name) || INITCAP(last_name), 
 LENSTH(last_name) + LENGTH(first_name) 
 FROM employee 
 WHERE INITCAP(SUBSTR(last_name, 1, 1)) IN (J’, ‘K’, ‘L’);

How will the results differ?

#50. You need to retrieve the employee names and salaries from your EMP table sorted by salary in descending order. If two names match for a salary, the names must be displayed in alphabetical order. Which statement produces the required results?

[1] [2] [3] [4] [5] [6] [7] [8] [9] [10] [11] ... [18]

gen. 0.398

Server date 10:58 22-11-2008

Oracle 1z0-001

Forum

Start online exam simulation

Master braindump

User braindumps