Khoee

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

7) In APEX use Application Builder to assemble an ---------- interface. A) HTML B) CSS C) SLT D) GML

A

10) Write a query and change the status of a disabled trigger.

ALTER trigger triger_name enable;

33) The ---------------- is a low code, high productivity integrated development environment where you can develop applications on top of your data.

App Builder

18) ---------------is the tool you use to build the pages that comprise an application.

Application Builder

5) ------------------ includes a number of wizards you can use to create forms automatically.

Application Builder

35) APEX:

Application Express

8) ---------------------- shows how to change a logo in page.

Application Icon

1) APEX formerly called ............ A) XML DB B) HTML DB C) XSLT DB D) SGML DB

B

1) Which object is an optional structure in database? A) Table B) Index C) Column D) Primary key

B

3) APEX is ............... framework. A) Agile B) RAD C) Spiral D) Waterfall

B

3) Which of the following is not a trigger event? A) UPDATE B) SELECT C) DROP D) SERVERERROR

B

4) Triggers are stored programs, which are automatically executed or fired when some events like ---------- and ------- occur. A) DCL, DDL B) DML,DDL C) DCL,TCL D) TCL,DDL

B

10) All of the following are part of the coding structure for triggers EXCEPT: A) Event B) Condition C) Selection D) Action

C

11) A procedure is: A) Stored outside the database. B) Given a reserved SQL name. C) Called by name. D) Unable to be modified.

C

8) What are the three benefits of triggers?

Enforcing referential integrity, keep the values of foreign keys in line with those in primary keys. Event logging and storing information on table access. Auditing. Synchronous replication of tables. Imposing security authorizations. Preventing invalid transactions.

9) ---------------------------- control or modify how an application logs errors.

Error Handling

14) Composite indexes cannot speed retrieval of data for SELECT statements in which the WHERE clause references all or the leading portion of the columns in the composite index.

False

16) We cannot create templates through APEX.

False

TRUE/FALSE 14) Triggers can be used to ensure referential integrity, enforce business rules, create audit trails and replicate tables, but cannot call other triggers.

False

20) Redo reverts the previous update you made within Page Designer.

False Undo

24) Workspace administrators manage an entire hosted instance using the APEX Services application.

False cross out workspace for Oracle Application Express

21) End users create and edit applications.

False crossout create and edit applications for have no development privileges/Cannot create or edit.

14) APEX needs dedicated database connection.

False does not need

20) A single schema can be associated with only one workspace

False one or more workspaces.

23) IDE stands for --------------------.

Integrated Development Environment

3) What is an Interactive Grid in Oracle APEX application?

It presents users a set of data in a searchable, customizable report.

30) In APEX, ---------------tracks events associated with the development process.

Milestones

9) What are the NEW and OLD Pseudorecords?

OLD and NEW are pseudorecords that the PL/SQL runtime engine creates and populates whenever a row-level trigger fires. OLD and NEW store the original and new values, respectively, of the record being processed by the trigger. They are called pseudorecords because they do not have all properties of PL/SQL records.

20) Developers view and manage application in---------------.

Page Designer

28) The -------------------------displays at the top of the page and contains both buttons and menu options.

Page Designer toolbar

12) ------------------fetches the styles for your application and loads them in the editor.

Theme Roller

11) APEX is a Database-centric Web Application development tool.

True

52) Oracle left outer JOINS return all rows from multiple tables where the join condition is met.

False

54) The FULL OUTER JOIN can be written in the old syntax without using a UNION query.

False

55) Oracle JOINS are used to retrieve data from just one table.

False

57) Oracle left outer JOINS return all rows from multiple tables where the join condition is met.

False

59) The FULL OUTER JOIN can be written in the old syntax without using a UNION query.

False

True/False 11) CREATE INDEX emp_id_indx ON emp_id(employee) ;This command will create index emp_id_indx.

False employee(emp_id);

13) In Apex the area where you develop applications is called a schema.

False workspace

26) In APEX after the database processes the PL/SQL, the results are relayed back to your browser as ----------------------.

HTML

6) Single page master detail creates a form that displays a master row and multiple detail rows within a single --------- form.

HTML

22) HTML stands for-------------------.

Hypertext Markup Language

24) Developers view and manage application in ----------------------.

Page Designer

31) In APEX, install and run a ------------------------- from the Packaged Apps gallery.

Productivity application

Fill in the blanks 25) Oracle APEX is ------------------------------ framework for the Oracle database.

RAD

34) RAD:

Rapid Application Development

36) REST:

Representational State Transfer

13) The Theme Roller window is displayed in the -------------------.

Runtime Toolbar

Based on the following tables: 3) Write a query to return the total number of employees in each department where there is a matching depno value in both tables. The query should return the department numbers and names. Also pick a name for the column which holds the total.

SELECT count(*) totalnumber, dept.depno, dept.depname FROM emp JOIN dept ON dept.depno=emp.depno group by dept.depno, dept.depname;

4) Change the following non-ANSI format to ANSI join syntax: SELECT dept.depno, depname, min(empbonus) FROM dept, bonus WHERE dept.depno=bonus.depno group by dept.depno,depname;

SELECT dept.depno, depname, min(empbonus) FROM dept join bonus on dept.depno=bonus.depno group by dept.depno,depname;

6) By using Oracle join, write a query to list every employee number with their corresponding department information as well as department's city and state sorted by the department number.

SELECT emp.empno, dept.depno, dept.depname, city_state.city, city_state.state FROM emp JOIN dept ON dept.depno=emp.depno JOIN city_state ON emp.zip=city_state.zip order by dept.depno;

7) Create a program that outputs this message "Now I am a PL/SQL expert."

set serveroutput on; begin dbms_output.put_line (' Now I am a PL/SQL expert.'); end; / OR DECLARE a1 varchar2(40):='Now I am a PL/SQL expert '; BEGIN dbms_output.put_line(a1); END; /

11) Substitution defines ------------------ substitution strings for your application.

static

17) In Oracle APEX, we can create --------- to fire and assign a new number.

triggers

26) Clear unlocked padlock — Indicates the page is----------------.

unlocked

27) In APEX, the area where we develop applications is called a ----------------------.

workspace

6) What is an Oracle trigger?

Triggers are stored programs, which are automatically executed or fired when some events occur.

12) APEX is a browser based for development, deployment and runtime.

True

12) We can create an index on one or more columns of a table.

True

13) A composite index is an index on multiple columns in a table.

True

15) A procedure is run by calling it by its name.

True

15) Apex is consuming minimal CPU resources.

True

15) We can generate sequential numbers by using sequences.

True

16) A trigger is a named set of SQL statements that are considered when a data modification occurs.

True

16) Application Builder is the tool you use to build the pages that comprise an application.

True

18) Use 'ALTER PROCEDURE grading COMPILE;' to recompile the 'grading' procedure.

True

18) Use Application Builder to assemble an HTML interface (or application) on top of database objects such as tables and procedures.

True

18) Use SQL Workshop to browse your database objects and run SQL queries.

True

19) A schema is a logical container for database objects like tables, views, and stored procedures.

True

19) Red locked padlock — Indicates the page is locked by another user.

True

20) A PL/SQL function is same as a procedure except that it returns a value.

True

22) 23) Developers can have their own workspace or share a workspace.

True

23) Triggers are written to be executed in response to oracle DML statements.

True

25) Triggers can be written for preventing invalid transactions

True

29) A procedure is run by calling it by its name.

True

30) A trigger is a named set of SQL statements that are considered when a data modification occurs.

True

32) Use 'ALTER PROCEDURE grading COMPILE; ' to recompile the 'grading' procedure.

True

34) A PL/SQL function is same as a procedure except that it returns a value.

True

37) Triggers are written to be executed in response to oracle DML statements.

True

39) Triggers can be written for preventing invalid transactions

True

41) Indexes can be created on one or more than one columns of a table.

True

43) Indexes are optional structure, but adding them into tables increases the speed of accessing data.

True

44) Index 'ord_indx2' on columns 'ord_id, ord_desc' is a concatenated index.

True

46) The order of the columns used in the WHERE clause of a query is important while using a composite index.

True

47) An application is a collection of database-driven Web pages linked together using tabs, buttons, or hypertext links.

True

50) The Oracle INNER JOIN would return the records where table1 and table2 intersect.

True

51) A relational operation that causes two or more tables with a common domain to be combined into a single table or view.

True

53) FULL OUTER JOIN returns all rows from the LEFT-hand table and RIGHT-hand table.

True

56) The Oracle INNER JOIN would return the records where table1 and table2 intersect.

True

58) FULL OUTER JOIN returns all rows from the LEFT-hand table and RIGHT-hand table.

True

4) When do we use the Theme Roller?

We use the Theme Roller feature in Oracle Application Express to customize the style of our application during runtime.

32) RESTful Services helps you to create a RESTful --------------- declaratively.

WebService

48) User interface (UI) defaults enable you to assign default user interface properties to a table, column, or view within a specified schema.

\Tru\e 49) Oracle JOINS are used to retrieve data from just one table. //False

3) What is the command to run if you see the status of greeting procedure is INVALID?

alter procedure greetings compile;

10) Global Notification communicates system status to ------------------------.

application users

29) Use the Property Editor to update -------------- for the selected component.

attributes

Write a query to: Remove the 'get_min_emp_num' FUNCTION from database.

drop FUNCTION get_min_emp_num;

5) Write a command and remove the greetings procedure from the database.

drop procedure greetings;

27) Page Unlocked indicates the current page is unlocked and ---------------.

editable

30) Use the small triangle labeled Collapse in the center of each splitter in page designer to -----------or -------------------- each pane.

expand, collapse

16) A ----------- is a window on the screen that provides areas for entering or modifying data in a database.

form

1) Write a query and give permission to user Test to be able to create procedure.

grant create procedure to Test;

19) A ---------- is the basic building block of an application.

page

25) Enabling caching is an effective way to improve the------------------.

performance

15) In APEX, a ----------- retrieves and displays data.

report

28) A --------------- is a logical container for database objects.

schema

2) What is the command which set to show the result in SQL command prompt?

set serveroutput on

35) Functions cannot be called in the ORDER BY and GROUP BY clauses of SQL statements.

False

36) A standalone function is deleted with the DROP PROCEDURE statement.

False

38) Triggers can be written for event logging but not storing information on table access.

False

1) Create a function to return the minimum employee number from employee table. Name the funtion to "get_min_emp_num" 2) In 2 ways call "get_min_emp_num" function to return the result like the following statement: Minimum employee number is: 101 3) Then remove this function from database.

(1) CREATE or REPLACE FUNCTION get_min_emp_num RETURN number IS min_num NUMBER; BEGIN SELECT min(empno) INTO min_num FROM emp; RETURN min_num; END; / (2) set serveroutput on; select 'Minimum employee number is : ' || get_min_emp_num from dual; OR DECLARE num number(20):= get_min_emp_num; BEGIN dbms_output.put_line(chr(10)); dbms_output.put_line('Minimum employee number is: ' || num); END; / (3) drop FUNCTION get_min_emp_num;

21) APEX stands for --------------------.

(Oracle) Application Express

7) The wizard for creating report with form on a table does not support tables having more than ----- columns.

127

1) Which of the following is not a PL/SQL program? A) Library B) Trigger C) Function D) Procedure

A

10) Which lock option indicates the page is locked by you. A) Green locked padlock B) Red locked padlock C) Clear locked padlock D) None of the above

A

14) Which operator manipulates character strings? E) Concatenation Operator F) Comparison Operator G) Greater than Operator H) Less than Operator

A

6) Which is not true about APEX? A) Only one user can access APEX workspace using a Web browser. B) It enables a single database to become a shared workgroup database service. C) It is consuming minimal CPU resources. D) It does not use a dedicated database connection.

A

6) Which operator manipulates character strings? A) Concatenation Operator B) Comparison Operator C) Greater than Operator D) Less than Operator

A

9) Which of the following is not a PL/SQL program? E) Library F) Trigger G) Function H) Procedure

A

9) Which option in APEX enables you to view object properties and create new objects? A) Object Browser B) App Builder C) Utilities D) None of the above

A

7) Name the events which can be executed by using triggers?

A database manipulation (DML) statement (DELETE, INSERT, or UPDATE). A database definition (DDL) statement (CREATE, ALTER, or DROP). A database operation (SERVERERROR, LOGON, LOGOFF, STARTUP, or SHUTDOWN).

1) What is a form in Oracle APEX application?

A form is a window on the screen that provides areas for entering or modifying data in a database.

2) What is a report in Oracle APEX application?

A report retrieves and displays data.

4) What is a sequence in Oracle database?

A sequence is an object in Oracle that is used to generate a number sequence.

40) An index is a mandatory structure which is associated with a table.

False

Write a query to: B) Recompile a procedure 'greetings'.

ALTER PROCEDURE greetings COMPILE;

1) Write a query to: Enable trigger 'trigg_no'.

ALTER TRIGGER trigg_no ENABLE;

29) In APEX, --------------------------- - creates dynamic database driven web applications.

App Builder

10) Which part of APEX is Gathering real-time comments, enhancement requests, and bugs from your application users? A) Features B) Feedback C) Milestones D) Browser

B

11) Which of the following is not a trigger event? E) UPDATE F) SELECT G) DROP H) SERVERERROR

B

16) A ....................... is a database object that generates unique numbers, mostly used for primary key values. A) Function B) Sequence C) Index D) Table

B

5) Create dynamic database driven web applications by using APEX ............... A) Application service B) Application builder C) Automation D) SQL builder

B

8) A ....................... is a database object that generates unique numbers, mostly used for primary key values. A) Function B) Sequence C) Index D) Table

B

8) Which one is not an option in left pane in page designer? A) Dynamic Actions B) Help C) Processing D) Shared Components

B

8) Which part of APEX contains installable Productivity Applications? A) SQL Workshop B) APP Gallery C) Object Browser D) Application Store

B

15) Triggers can be written for: E) Enforcing referential integrity F) Event logging G) Auditing H) All of the above

D

42) Index is associated with foreign key in a table.

False

45) Index 'cust_indx1' on column 'cust_name' is a composite index.

False

Based on the existing "dept" table, write a PL/SQL block and use "For Loop" to print the following statement for all departments when the id is greater than 40: "If department id is depno then department name is depname".

BEGIN FOR i IN (SELECT depno,depname FROM dept WHERE depno > 40 ) LOOP DBMS_OUTPUT.PUT_LINE('If department id is ' || i.depno || ' then department name is ' || i.depname || '. '); END LOOP; OR || chr(46) END; / Note: This is the result from my department table, you may have different depno, and depname. Department id in the following statement is greater than 40 in all statements. ||'. ' OR || chr(46) will create the period at the end of the statement. In order to create the period at the end of the sentence, you can use chr(46). If department id is 50 then department name is Manufacturing. If department id is 60 then department name is Billing. If department id is 70 then department name is Sales. PL/SQL procedure successfully completed.

12) Which type of PL/SQL program can be called in the select list or a SQL statement? E) Trigger F) Procedure G) Function H) None of the above

C

13) By default, SQL*PLUS doesn't display output from PL/SQL. What is the command to run to see the output of PL/SQL commands? E) Start serveroutput; F) Set serveroutput off; G) Set serveroutput on; H) Set server out put on;

C

2) Composite index, also called ---------------. A) Complex index B) Filtered index C) Concatenated index D) Clustered index

C

2) Which one is not an advantage of APEX? A) easy B) Secure C) High level programming experience D) Rapid and empowering

C

4) Which type of PL/SQL program can be called in the select list of a SQL statement? A) Trigger B) Procedure C) Function D) None of the above

C

5) APEX is a ------------- framework. A) XP B) Agile C) RAD D) Spiral

C

5) By default, SQL*PLUS doesn't display output from PL/SQL. What is the command to run to see the output of PL/SQL commands? A) Start serveroutput; B) Set serveroutput off; C) Set serveroutput on; D) Set server out put on;

C

9) A named set of SQL statements that are considered when a data modification occurs are called: A) Stored procedures B) Treatments C) Triggers D) Transactions

C

5) Create a sequence and a trigger to fire before insert into department table to make the depno to autonumber field.

CREATE SEQUENCE depno_seq START WITH 1 INCREMENT BY 1; create or replace trigger trig_dep_no BEFORE INSERT ON dept FOR EACH ROW begin select depno_seq.nextval into :new.depno from dual; end; /

Create a sequence and a trigger to fire before insert into department table to make the depno to autonumber field.

CREATE SEQUENCE depno_seq START WITH 1 INCREMENT BY 1; create or replace trigger trig_dep_no BEFORE INSERT ON dept FOR EACH ROW begin select depno_seq.nextval into :new.depno from dual; end; /

14) ------------ are based on Oracle JavaScript Extension Toolkit (JET) Data Visualizations.

Charts

10) Why would you execute a CREATE OR REPLCAE PROCEDURE statement instead od a DROP PROCEDURE and CREATE PROCEDURE? E) It is less typing. F) There is no difference between the two. G) CREATE OR REPLACE PROCEDURE does not invalidate dependent objects H) DROP PROCEDURE and CREATE PROCEDURE require regranting of privileges.

D

12) Combining two character items using two vertical bars ( || ) is known as ...... A) Combining B) Character modification C) Casting D) Concatenation

D

13) Which of the following commands will display the errors while using PL/SQL? A) display error B) show error C) show errors D) both B and C

D

2) Why would you execute a CREATE OR REPLCAE PROCEDURE statement instead of a DROP PROCEDURE and CREATE PROCEDURE? A) It is less typing. B) There is no difference between the two. C) CREATE OR REPLACE PROCEDURE does not invalidate dependent objects D) DROP PROCEDURE and CREATE PROCEDURE require regranting of privileges.

D

26) Combining two character items using two vertical bars (||) is known as ...... E) Combing F) Character modification G) Casting H) Concatenation

D

27) Which of the following commands will display the errors while using PL/SQL? E) display error F) show error G) show errors H) both B and C

D

3) We can create an autonumber field by using ---------------. A) Primary key B) Index C) Function D) Sequences

D

4) Which one is an APEX feature? A) Reports B) Charts C) Templates D) All of the above

D

6) A ------------ is the basic building block of an application. A) Column B) Table C) List D) Page

D

7) Triggers can be written for: A) Enforcing referential integrity B) Event logging C) Auditing D) All of the above

D

7) Which one is a user in APEX environment? A) Workspace administrators B) Developers C) End users D) All of the above

D

9) Which one is an option in central pane in page designer? A) Layout B) Help C) None of the D) Both A and B

D

Write a query to: Delete trigger 'trigg_no'.

DROP TRIGGER trigg_no;

17) APEX is able to build professional applications which are fast but not secure.

False

17) By setting 'set server out put on;' command display output from PL/SQL.

False

17) Web and email services are not part of APEX.

False

19) DUAL is in the schema of the user SYS and accessible by SYS user.

False

21) Functions cannot be called in the ORDER BY and GROUP BY clauses of SQL statements.

False

22) A standalone function is deleted with the DROP PROCEDURE statement.

False

24) Triggers can be written for event logging but NOT storing information on table access.

False

28) Triggers can be used to ensure referential integrity, enforce business rules, create audit trails and replicate tables, but cannot call other triggers.

False

31) By setting 'set server out put on; ' command display output from PL/SQL.

False

33) DUAL is in the schema of the user SYS and accessible by SYS user.

False


Kaugnay na mga set ng pag-aaral

Chapter 29 Introduction to the Autonomic Nervous System

View Set

Inheritence, Abstract Classes, Interfaces

View Set