Quiz Questions Over Oracle Software
Settings
Based on oracle concepts
- 1.Databases overall structure is maintained in a file called
- A.
Redolog file
- B.
Data file
- C.
Control file
- D.
All of the above
- 2.It is very difficult to grant and manage common privileges needed by different groups of database users using the roles
- A.
True
- B.
False
- 3.Why is it better to use an INTEGRITY CONSTRAINT to validate data in a table than to use a STORED PROCEDURE ?
- A.
Because an integrity constraint is automatically checked while data is inserted into or updated in a table while a stored procedure has to be specifically invoked
- B.
Because the stored procedure occupies more space in the database than a integrity constraint definition
- C.
Because a stored procedure creates more network traffic than a integrity constraint definition
- D.
All
- 4.All datafiles related to a Tablespace are removed when the Tablespace is dropped
- A.
True
- B.
False
- 5.Size of Tablespace can be increased by
- A.
Increasing the size of one of the Datafiles
- B.
Adding one or more Datafiles
- C.
Cannot be increased
- D.
None of the above
- 6.Which of the following is NOT VALID is PL/SQL
- A.
Bool boolean;
- B.
Deptname dept.dname%type;
- C.
NUM1, NUM2 number;
- D.
Date1 date := sysdate ;
- 7.
- There are two schema users A & B User A grants select privilege to user B on tables User A grants execute privilege to user B on packages Now, on executing package from user B, Execute below code from User B to retrieve the record from the table of
- A.
1
- B.
Error
- C.
No privileges
- D.
A must grant some more privileges
- 8.Is it not possible to use Transactional control statements in Database Triggers?
- A.
True
- B.
False
- 9.Which of the following is NOT VALID in PL/SQL ?
- A.
Select ? into
- B.
Update
- C.
Create
- D.
Delete
- 10.Which of the following is not correct about Cursor ?
- A.
Cursor is a named Private SQL area
- B.
Cursor is used for retrieving multiple rows
- C.
SQL uses implicit Cursors to retrieve rows
- D.
Cursor holds temporary results
- 11.Which of the following is not correct about a View ?
- A.
Ocuupies data storage space
- B.
To protect some of the columns of a table from other users
- C.
To hide complexity of a query
- D.
To hide complexity of a calculations
- 12.The table is ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- Kochhar 101 100 AD_VP Faviet 109 108 FI_ACCOUNT Chen 110 108 FI_ACCOUNT Sciarra 111 108 FI_ACCOUNT Urman 112 108 FI_ACCOUNT Popp 113 108 FI_ACCOUNT Whalen 200 101 AD_ASST King 100 116 AD_PRES Mavris 203 101 HR_REP Baer 204 101 PR_REP Higgins 205 101 AC_MGR Gietz 206 205 AC_ACCOUNT De Haan 102 100 AD_VP Hunold 103 102 IT_PROG The query is SELECT LPAD(' ',2*(LEVEL-1)) || org_chart, employee_id, manager_id, job_id FROM employees START WITH job_id = 'AD_PRES' CONNECT BY PRIOR employee_id = manager_id AND LEVEL <= 2; What is the output?
- A.
ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- Kochhar 101 100 AD_VP King 100 116 AD_PRES De Haan 102 100 AD_VP
- B.
ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- King 100 116 AD_PRES Kochhar 101 100 AD_VP De Haan 102 100 AD_VP
- C.
ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- De Haan 102 100 AD_VP King 100 116 AD_PRES Kochhar 101 100 AD_VP
- D.
ORG_CHART EMPLOYEE_ID MANAGER_ID JOB_ID ------------------ ----------- ---------- ---------- Kochhar 101 100 AD_VP De Haan 102 100 AD_VP King 100 116 AD_PRES
- 13.What is a Built_in subprogram ?
- A.
Library
- B.
Stored procedure & Function
- C.
Collection of Subprograms
- D.
None of the above
- 14.Which prefixes are available to Oracle triggers?
- A.
: new only
- B.
:old only
- C.
Both :new and :old
- D.
Neither :new nor :old
- 15.The syntax for creating a view is
- A.
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]];
- B.
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]];
- C.
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW view [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]]
- D.
CREATE [OR REPLACE] [FORCE|NOFORCE] VIEW [(alias)[,alias]…)] AS subquery [WITH CHECK OPTION [CONSTRAINT constraint]] [WITH READ ONLY [CONSTRAINT constraint]]
- 16.There is a table ddd(d date). Which of the given statement is correct?
- A.
Insert into ddd values(to_date('2003/05/03 21:02:44'));
- B.
Insert into ddd d values(to_date('2003/05/03 21:02:44', 'yyyy/mm/dd hh24:mi:ss'));
- C.
Insert into ddd values(to_date('2003/05/03 21:02:44', 'yyyy/mm/dd hh:mi:ss'));
- D.
None is correct
- 17.Consider that the following statements are executed. create table suppliers( supplier_id number, supplier_name varchar2(100)); insert into suppliers (supplier_id, supplier_name ) values ( 10565, null ); insert into suppliers (supplier_id, supplier_name ) values ( 10567, '' ); Then for the below query what will be the output? select * from suppliers where supplier_name = ' ';
- A.
SUPPLIER_ID SUPPLIER_NAME 10567
- B.
SUPPLIER_ID SUPPLIER_NAME 10565 10567
- C.
No rows selected
- D.
Error
- 18.For insertion of multiple rows into multiple tables which of the following is correct?
- A.
INSERT ALL INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM') INTO suppliers (supplier_id, supplier_name) VALUES (2000, 'Microsoft') INTO customers (customer_id, customer_name, city) VALUES (999999, 'Anderson Construction', 'New York');
- B.
INSERT ALL INTO suppliers (supplier_id, supplier_name) VALUES (1000, 'IBM') INTO suppliers (supplier_id, supplier_name) VALUES (2000, 'Microsoft') INTO customers (customer_id, customer_name, city) VALUES (999999, 'Anderson Construction', 'New York') SELECT * FROM dual;
- C.
Both
- D.
None
- 19.Does the view exist if the table is dropped from the database?
- A.
True
- B.
False
- 20.What will the below statement do? CREATE TABLE companies AS (SELECT * FROM suppliers WHERE 1=2);
- A.
This would create a new table called suppliers that included all columns from the companies table, but no data from the companies table.
- B.
This would create a new table called companies that included all columns from the suppliers table, with data from the suppliers table.
- C.
This would create a new table called companies that included all columns from the suppliers table, but no data from the suppliers table.
- D.
Error
Back to top