1z0-001 Oracle - Braindumps.com.ua: список вопросов для "Ineroduction to oracle:sql and pl/sql", страница: 5

Профиль

Бреиндампы

Получить последний дамп

Форумы

Продавец

Linux Prof Institute (LPI) (2)

Lotus (11)

Microsoft (2462)

Network Appliance (2)

Авторизация

Логин:
Пароль:
запомнить меня:

Контакты
Сайты по тематике
Cсылки

Авторизированые пользователи могут видеть ответы к вопросам.
Пожалуйста, авторизируйтесь или зарегистрируйтесь.

Список вопросов к экзамену:
Показать все комментарии

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]

ген. 0.075

Дата сервера 09:15 09-01-2009

Oracle 1z0-001