Oracle Database Quiz Section 6 Quiz Answer

Image Source : dqindia.com

1.     In the APEX application a ______ is a collection of logical structures of data. A _______ is owned by a database user and has the same name as that user.
entity
table
schema (*)
file

2.     Application programs enable us to ________.
Check email.
Create documents
Edit photogrphs
All of the above. (*)

3.     Oracle Application Express is an application platform used to share and learn _____ and __________.
Java, PL/SQL
SQL, Java
SQL, PL/SQL (*)
SQL, Java Script

4.     The _________ clause in a query comes immediately after the SELECT and FROM.
WHERE (*)
ORDER BY
IF
GROUP BY

5.     To connect to an Oracle database you need to use a client program. True or False?
True (*)
False

6.     Which software is used to manage reading and manipulating a relational database?
Flat file software
DBMS software (*)

7.     ERD software
Spreadsheet software

8.     All of the following are tools to access a relational database except :
Oracle SQL Developer
Oracle Application Express
Oracle SQL Data Modeler (*)
SQL * Plus

9.     Functions of SQL are:
Inserting, updating, and deleting rows in a table
Querying data stored in the database
Both of the above options are functions of SQL (*)
Neither of the above options are functions of SQL

10.  When you have constraints in place on columns, an error is returned if you try to violate the constraint rule.
True (*)
False

11.  It is not mandatory to specify the column list in the INSERT statement. True or False?
True (*)
False

12.  Any column that is not listed explicitly obtains a null value in the new row unless we have _________ values for the missing columns that are used.
INSERT
DEFAULT (*)
BEGINNING
STANDARD

13.  Once you have created a table, you can use the ________________ command to confirm that it was created. (Choose 2)
LIST
SELECT (*)
DESCRIBE (*)
ORDER BY

14.  When you define a table, you can specify that a column should be given a default value by using the LITERAL option.
True
False (*)

15.  To issue a CREATE TABLE statement, you must have the __________ privilege.
DISTRIBUTE TABLE
CREATE TABLE (*)
Both
None

16.  To create a table you must identify all of the following except :
Field data types
Field values (*)
Field names
Table name

Share :