41. Which three ways can the SQL buffer be terminated? (Choose three.)
Enter a slash (/).
Press [RETURN] once.
Enter an asterisk (*).
Enter a semicolon (
.
Press [RETURN] twice.
Press [ESC] twice.
42. evaluate this command:
select id_number,description, manufacturer_id
from inventory
where price >7.00
order by manufacturer_id;
all the columns of the invetory table have non_unique indexes, which
clause will most likely use an index?
A. select id_number,description,manufacture_id
B. from inventory
C. where price >7.00
D. order by manufacturer_id
43. which command would you use to remove the
manufacturer_contact_name_idx index?
A. drop manufacturer_contact_name_idx;
B. drop index manufacturer_contact_name_idx;
C. delete manufacturer_contact_name_idx;
D. delete index manufacturer_contact_name_idx;
44. You query the database with this command:
select id_number, [quantity + 100*.25-25-10]
from inventory;
which expression is evaluated first?
A. quantity + 100
B. 100*25
C. 25-25
D. 25-10
45. If you are writing a select statement to join three tables, what is the
minimum number of join conditions needed?
A. 3
B. 2
C. 1
D. 0
46. Which SELECT statement is an outer join?
A SELECT i.id_number, m.manufacturer_id
FROM inventory i, inventory m
WHERE i.manufactruer_id = m.id_number;
B SELECT i.id_number, m.manufacturer_name
FROM inventory i, manufacturer m
WHERE i.manufactruer_id (+) = m.id_number;
C SELECT i.id_number, m.manufacturer_name
FROM inventory i, manufactruer m
WHERE i.manufacturer_id = m.id_number;
D SELECT i.id_number, m.manufacturer_name
FROM inventory i, manufactruer m
WHERE i.price BETWEEN m.avg_price and m.max_price;
47. You need to create an elements table. The atomic weights of elements
have varying decimal places. For example, values could be 4, 4.35 or
4.3567. Which datatype would be most appropriate for the atomic weight
values?
A LONG
B NUMBER(p,s)
C NUMBER
48. Evaluate this clause:
SELECT i.id_number, m.id_number
FROM inventory i, manufacturer m
WHERE i.manufacturer_id = m.id_number
ORDER BY 1;
Eliminating which clause will cause all the rows in the inventory
table to be joined to all the rows in the manufacturer table?
A. SELECT i.id_number, m.id_number
B. From inventory i, manufacturer m
C. WHERE i.manufacturer_id = m.id_number
D. ORDER BY 1;
E. none
49. Evaluate this command:
CREATE FORCE VIEW id_number, description
AS SELECT id_number "Product Number", description
FROM inventory
WHERE price > 5.00
GROUP BY description
ORDER BY id_number;
Which clause will cause an error?
A. AS SELECT id_number "Product Number", description
B. FROM inventory
C. WHERE price > 5.00
D. GROUP BY description
E. ORDER by id_number;
50. Which date function returns a numeric value?
A. LAST_DAY
B. ROUND
C. TRUNC
D. ADD_MONTHS
E. MONTH_BETWEEN
51. Click on the EXHIBIT button and examine the table instance chart for the
inventory table.
You query the database with this command:
SELECT ROUND[ORDER_DATE, 'YEAR']
FROM INVENTORY;
A. 01-JAN-94
B. 01-JAN-95
C. 95
D. 96
52. Evaluate this command:
1. CREATE TABLE sale_price
2. [id_number$ NUMBER[35]
3. CONSTRAINT sale_proce_pk PRIMARY KEY,
4. description# VARCHAR2[200],
5. price& NUMBER(8,2)];
Which line contains an error?
A. 1
B. 2
C. 3
D. 4
E. 5
53. Cleck on the EXHIBIT button and examine the table instance chart for the
manufacturer table.
Which command would you use to create an index for the manufacturer_name
cloumn?
A. CREATE INDEX manufacturer[manufacturer_name];
B. CREATE INDEX manufacturer_manufacturer_name_idx'
On manufacturer[manufacturer_name];
C. CREAT INDEX manufacture[manufacturer_name]
manufacturer_manufacturer_name_idx;
D. CREAT INDEX manufacturer_manufacturer_name_idx
ON manufacturer;
54. What causes a PL/SQL WHILE loop to terminate?
A. A Boolean variable or expression evaluates to TRUE.
B. A Boolean variable or expression evaluates to FALSE.
C. A Boolean variable or expression evaluates to NULL.
D. Control is passed to the EXIT statement.
E. The specified number of iterations have been performed.
54. Which type of variable has a colom (
prefix in a PL/SQL satement?
A. declared PL/SQL variable
B. PL/SQL procefure variable
C. SQL*Plus global variable
D. PL/SQL function variable
55. Click on the EXHIBIT button and examine the table instance chart for the
inventory table.
Which SELECT statement could you use to display the id_number and
manufacturer_id values based on the description value entered at the
prompt,
regardless of case?
A. SELECT id_number, manufacturer_id
FROM inventory
WHERE description = LOWER ( '&description');
B. SELECT id_number, manufacturer_id
FROM inventory
WHERE LOWER(description) = '&description';
C. SELECT id_number, manufacturer_id
FROM inventory
WHERE UPPER(description) = UPPER ( '&description');
D. SELECT id_number, manufacturer_id
FROM inventory
WHERE description = '&description';
56. Your query the database with this command:
SELECT id_number, NVL(100/quantity, 0)
FROM inventory;
Which value is displayed when the quantity value is null?
A. 0
B. nothing
C. the keyword NULL
D. 100
57. You attempt to create a view with this command
CREATE VIEW parts_3456_vu
AS SELECT id_number, description
FROM inventory
WHERE id_number = 3456
ORDER BY description;
Which clause causes an error?
A. CREATE VIEW parts_3456_vu
B. AS SELECT id_number, description
C. FROM inventory
D. WHERE id_number = 3456
ORDER BY description;
58. Evaluate this command:
SELECT id_number, description
FROM inventory
WHERE id_number=
(SELECT id_number
FROM inventory
WHERE quantity> 500 OR price> 5.00);
Which clause will cause an error?
A. SELECT id_number, description
B. WHERE id_number=
C. SELECT id_number
D. WHERE quantity> 500 OR price> 5.00
none
59. Where is view stored:
a. A table in database
b. A SELECT statement in data dictionary
c. A SELECT statement in the first table in FROM list
d. A SELECT statement in the second table in FROM list
60. As a system user, you issue a command
COMMENT ON hr.doctor.doctor_id IS 'A...';
From which data dictionary you can view this comment:
a. User_objects
b. All_objects
c and d
61. Which of the following you can use to always validate the data
before insert it into the table?
a. Stored procedure
b. Ananymous block
c. Database trigger
d and e
62. Functionality of WHERE clause
63. Acme Sports Supply keeps tack of customer,order,supply and contacts.
Customers may have multiple phone number and address; Order has sales
id
and sales rep. id; Supply has order date and quantity; Customer must
have name and one phone number. So which is mandatory attribute:
a. customer
b. sales rep id
c. customer name
d. quantity
64. Customers book flights. One customer may book multiple flights, A
flight won't exist until a customer book it. Each flight has an unique
id. Choose one from the following ERD which represent the correct
relationship between customer and flight.(5 ERD, I cann't draw them
here)
65. Store number with known digits but vary length on the left side of
decimal point, use which datatype:
a. NUMBER
b. NUMBER(p)
c. LONG
LONGRAW
66. When you delete rows from a table, you get a data integrity error,
what could be the cause:
a. delete a foreign key
b. delete an unique value column
c and d
67. In PL/SQL block
PRAGMA EXCEPTION_INIT(employee_remaining,-2292)
what does this statement accomplish?
a. An exception is associated
b. An exception is declared
c. An exception is created
d and e
68. Pay attention to data dictionary
pay attention to cursor attributes
Use the '-' to continue a PL/SQL command in the next line.
71. Pay attention to the "Data Dictionary", because there are several
questions about Data Dictionary:
such as: which dictionary should you query to display the constraint on
the column? which dictionary should you query to display the constraint of the
table and schema you can access.?.
User_constraints, user_table, user_cons_columns, all_table ...
72. The syntax of create sequence.
73. Where to display the COMMENT on the table. (use SELECT in the data dictionary.)
74. CREATE ROLE
GRANT CREATE SESSION, CREATE TABLE, CREATE VIEW
TO ROLE
GRANT role
TO Sue, John;
which three commands are created?
1). A role is created.
2). Grant the system privileges to role.
3). Grant the object privileges to role.
4). Two users were granted a role.
5). a role was created for both Sue and John.
75. Which three single row functions can be used in the column name (
NAME,VARCHAR2 ,NN, length(9)).
1) ROUND
2) TRUNC
3) SUBSTR
4) SYSDATE
5) VAL
6) LENGTH
76. Which data was retrieved from the table.
SELECT NAME
FROM EMPLOYEE
WHERE NAME LIKE (((NAME LIKE '%S%' AND NAME LIKE '%T%)
AND NAME LIKE '%P%') OR NAME LIKE '%R%');
1. 'STOP' AND 'STROB' BUT NOT 'SDR..'
(Sorry, I cannot remember the answers).
77. In the declare section of a PROCEDURE, you declare a parameter v_name, the datatype is employee.name%TYPE , which the employee.name is NOT
NULL, what is the initialized value of the v_name when it is first executed?
1 NULL
2.0
3. The procedure will not complied successfully.
4. the v_name should be initialized.
What is the function of PL/SQL engine?
what conditions can COMMIT implicitly execute?
|
