QUESTION 1 In contrast to the MAX function, the ________ function returns the sm

Question

QUESTION 1

In contrast to the MAX function, the ________ function returns the smallest value in a specified column.

AVG

SUM

LESS

MIN

QUESTION 2

Which of the following is not a type of collection:

graphical views

associative arrays

varrays

nested tables

QUESTION 3

Although rarely used outside a program, a user can explicitly lock a table in SHARE mode by issuing the ______ _______ command.

LOCK BOX

LOCK CODE

LOCK TABLE

SELECT LOCK

QUESTION 4

You can use the LOWER function to convert a table's data to lowercase letters temporarily during query execution.

True

False

QUESTION 5

The user_audit_statement displays the audit records for GRANT, REVOKE, AUDIT, NOAUDIT, and ALTER SYSTEM statements issued by a current user.

True

False

QUESTION 6

Which of the following is NOT a valid constraint type abbreviation?

_nn

_ee

_fk

_pk

QUESTION 7

A _______ function performs increasing levels of cumulative subtotals, based on the provided column list.

MAX

CUBE

STDDEV

ROLLUP

QUESTION 8

You can delete a constraint from a table with the _________ (constraintname) command.

COPY

DELETE

DROP

CUT

QUESTION 9

__________ relationships are rare in a relational database; usually you work with ________ relationships.

One-to-one, one-to-many

Many-to-one, many-to-many

One-to-many, one-to-one

One-to-one, many-to-one

QUESTION 10

A relational database was the earlier type of database, but is no longer used in modern computing.

True

False

QUESTION 11

There are two main tasks involved with the design of a database: developing an entity-relationship (ER) model and delete the records.

True

False

QUESTION 12

What is a default format for a DATE value?

MM/DD/YY

MM/DD/YY##

DD-YYYY

DD-MON-YY

QUESTION 13

You can nest subqueries inside all EXCEPT _______ clauses of other subqueries.  

HAVING

DISTINCT

WHERE

FROM

QUESTION 14

Oracle 11g also provides the RPAD function, which uses a symbol to pad the right side of a character string to a specific width.

True

False

  

QUESTION 15

You can specify multiple columns in a GROUP BY clause.

True

False

QUESTION 16

You can insert, update, and delete individual elements in a nested table.

True

False

QUESTION 17

The B-tree (balanced-tree) index is the most common index used in Oracle.

True

False

QUESTION 18

The associated FOREIGN KEY can be deleted along with the PRIMARY KEY deletion by using the _________ option.

CASCADE

CHECK

DELETE_UPON_EXIT

CLEAR_ALL

QUESTION 19

Which of the following is NOT an SQL command type?

Hypertext markup language (HTML)

Data manipulation language (DML)

Data definition language (DDL)

Data control language (DCL)

QUESTION 20

When you delete a record using the Remove Record button the record is deleted from the database immediately.

True

False

QUESTION 21

To remove privileges from a user, use the ___________ command.

REVOKE

LIMIT

DELETE

UNDO

QUESTION 22

Which of the following syntax is NOT considered a mulitple-row comparison operator?

<ALL

>ANY

>ALL

=SOME

QUESTION 23

Commands used to create or modify database tables are called data definition language (DDL) commands.

True

False

QUESTION 24

Which view type is based on a subquery that references only one table and does not include group functions, expressions, or GROUP BY causes?

Simple View

Materialized View

Complex View

Inline View

QUESTION 25

A view is a predefined query on one or more base tables.

True

False

QUESTION 26

What is the difference between deleting all records from a table and truncating the table?

Delete does not save roll back information while truncate does

Truncating does not save roll back information while delete does

Only a DBA can truncate, anyone can delete

Deleting is faster

QUESTION 27

A role is a group of privileges that you can assign to a user or another role.

True

False

QUESTION 28

The AUDIT SYSTEM privilege is for tracking operations on specific database objects not for high-level auditing operations.

True

False

QUESTION 29

The ______ text item property specifies whether the user can navigate to the item using the Tab key or mouse pointer.

Read-only

Enabled

Tabbable

View

  

QUESTION 30

In a _____ join (also called a cross join) each record in the first table is matched with each record in the second table.  

Canvas

Cartesian

Create

Capital

QUESTION 31

Which of the following are not a main type of single-row functions:

regular expression functions

numeric functions

description functions

conversion functions

QUESTION 32

A customer database table with columns first_name, last_name, and phone_number would probably need to use a surrogate key.

True

False

QUESTION 33

A datatype identifies the type of data Oracle is expected to store in a column.

True

False

QUESTION 34

Data in the Oracle database is stored in basic structures called data blocks.  

True

False

QUESTION 35

A foreign key value must exist in the table where it is a primary key.

True

False

QUESTION 36

Which of the following characterizes unnormalized data?

does not have a primary key identified and/or contains repeating groups

has transitive dependencies

does not have a foreign key identified

has partial dependencies

QUESTION 37

You must use the GROUP BY clause in a query if you are using a group function.

True

False

QUESTION 38

Which of the following declarations would be most appropriate for storing a dollar value up to $1000?

price NUMBER(5,2)

price NUMBER(2)

price NUMBER(5)

price NUMBER

QUESTION 39

Each SQL command is terminated with a(n) ____________.

question mark

exclamation mark

semicolon

period

QUESTION 40

When you declare a variable with data type NUMBER, what is the value before you assign a value?

1

-1

100

NULL

QUESTION 41

Which of the following statements is false?

An object type can contain attributes and methods.

An object reference can be used to access a row in a object table.

An object type marked as NOT INSTANTIABLE prevents objects from that type from being created.

Object type cannot be used to define a column object or object table.

QUESTION 42

Which of the following is NOT considered a Numeric Function?  

ROUND

TRUNC

INITCAP

ABS

QUESTION 43

In Oracle, if a JOIN type is not specified, the _________ type is used by default.

MULTI

BI

CROSS

INNER

QUESTION 44

Which of the following commands can be used to change a password for a user account?

DELETE

ALTER USER

EDIT PASSWORD

CHANGE PASSWORD

QUESTION 45

Which view type replicates data by physically storing the view query's results?

Complex View

Inline View

Simple View

Materialized View

QUESTION 46

When DDL operations are performed, Oracle places an ______ lock on the table so that no other user can alter the table or attempt adding to or updating the table's contents.

exclusive

biometric

executive

master

QUESTION 47

A shorthand method of identifying a table and its contents is to give the name of the table followed by a list of the column names and data types, separated by commas, within a set of square brackets.

True

False

QUESTION 48

A(n) _________ is an alternate name for a query column.

clause

alias

row

record

QUESTION 49

Once a window has been created the title cannot be changed.

True

False

  

QUESTION 50

The TO_DATE (x[, format]) function converts the x string to a datetime.

True

False

A.

AVG

B.

SUM

C.

LESS

D.

MIN

Explanation / Answer

Here are some of the answers given for the list of questions specified with explainations

1) D MIN(Min() returns smallest value of specified column)

2) A Graphical Views(sql collections are varray,associative array and nested tables)

3) C Lock table (eg:-The following statement locks the remote employees table that is accessible through the database link remote:

LOCK TABLE employees@remote

IN SHARE MODE;)

4)TRUE (converts the given string into lower case)

5) TRUE : USER_AUDIT_STATEMENT displays audit trail records for the same statements issued by the current user

6) ee (nn,fk,pk are constraint abbreviations)

7) cube (Performs increasing levels of cumulative subtotals, based on the provided column list.)

8) drop (to delete a constraint we use drop command)

9) A : Commonly we work on one-many relationship, we use one to one rarely. becuase in real world systems, we work with many multi dimensional data sets, that needs one-many rather one-one

10) B ; RDBMS plays a vital role in all traditional and current databases, now a days since unstructured databases are ruling, nosql databases are unstructured which does not need RDBMS.

11) FALSE : There are many tasks in designing database model they are ER-Model, Network Model, Object orinented Model, Hierarchical Model. ER Model is meant to specify relationship between entities.

12) DD-MON-YY : It is default date format which Oracle supports Eg : 12-DEC-2016

17) TRUE : B.Trees are good example of a data structure for external memory. It is commonly used in database and file systems

18) TRUE : A foriegn key with cascade using either a create table statement or an alter table statement

19) A : HTML is markup language, remaining all are SQL Languages definiton and Manipulation Languages

20) FALSE : Because we need to commit the record after we delete. Some databases support Auto Commit.

21) A : Revoke is the way to remove privileges from the user on databases.

23) TRUE : DDL Describes data definition language, it will be at physical level to create definitions rather manipulation. Others like ALTER, DROP, TRUNCATE too come in DDL

33) TRUE : Datatype explains about the type of data is to be stored in the column of each entity specified. Like number, varchar2, blob, lob, date etc

42) INITCAP : It is String method which is used to Convert each word of string initial letters into Capital letters

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.