section 6

1.SQL

Commands is a component in the SQL Workshop of APEX that allows multiple SQL statements to be run simultaneously within the current application users assigned database schema.

Mark for Review (1) Points

rue False (*) Incorrect. Refer to Section 6 Lesson 1. 2. An

Application Program Program allows end users to buy and use fully developed, ready to use programs to accomplish various tasks.


rue (*) False Correct 3.

Oracle Application Express (APEX) is a web application platform used to develop and deploy SQL applications.


rue (*) False Correct 4. You

can use Oracle Oracle Application Express Express (APEX) to ...


Learn SQL using the SQL Workshop component Design and develop applications using the Application Builder component Both of these (*) None of these. Correct

5.

NOT NULL constraints can be created at the table as well as at the column level.


rue False (*) Incorrect. Refer to Section 6 Lesson 3.

6.When

you define a table, you can specify that a column should be given a default value by using the LITERAL option.


rue False (*) Correct 7. You

use the SET UNUSED option to mark one or more columns as unused.



Once you have created a table, you can run the DESCRIBE command to confirm that it was created.


rue (*) False Correct

9.

he command that removes all rows from a table, leaving the table empty and the table structure intact is ...


RUNCATE (*) DELETE Both None Correct 10.

he UPDATE statement modifies the values of a specific row or rows if the _______ clause is specified.


WHERE (*) VALUE MODIFY SET Correct

11.It

is not mandatory to specify the column list in the INSERT statement. rue or False?



Relational Database stores data in a two-dimensional matrix known as a table.



he stages of SQL Processing are Parsing, Optimization, Row Source Generation and _____________ .


Analyzing Execution (*) Both None Correct 14. A

table is the basic storage structure of an RDBMS.


rue (*) False Correct 15. An

alternate key is a column that defines how tables relate to each other.


rue False (*) Incorrect. Refer to Section 6 Lesson 2.

section 6

Recommend Documents