Question 1

Which among the following is not considered a database transaction?

Accepted Answer

One data definition statement

Question 2

Using figure 7.2, what SQL statement will show the city and the highest salary of the salesman when they are grouped based on their city.

Accepted Answer

select city, max(salary) from salesman group by city;

Question 3

You can add multiple rows to a table using a single insert statement.

Accepted Answer

True

Question 4

A database transaction consists of one DCL statement.

Accepted Answer

False

Question 5

Using figure 7.1, what is the SQL code to insert a new record in the salesman table?

Accepted Answer

insert into salesman (salesman_id) values (6000);

Question 6

To create a marker in the current transaction, rollback is used.

Accepted Answer

False

Question 7

Using the syntax to insert a row below: INSERT INTO table [(column [, column...])] VALUES (value [, value...]); What is the column part?

Accepted Answer

it is the name of the column in the table to populated

Question 8

The check option command in creating a view works only for updateable views.

Accepted Answer

True

Question 9

Using figure 7.2, what SQL statement will show the name of the salesman and city whose city has an ‘I’ letter in between, capital letter or not.

Accepted Answer

select sname, city from salesman where city like '%i%' or city like '%I%';

select sname, city from salesman where city like '%i%';

Question 10

What is the clause of the select statement where in it indicates the tables or views from which data will be obtained?

Accepted Answer

from

Question 11

What is the clause of the select statement where in it indicates the conditions under which a row will be included in the result?

Accepted Answer

where

Question 12

Using figure 7.1, the SQL code: update salesman set commission = 0.25 where city = 5700; , will change all the commission of the city that is empty or null.

Accepted Answer

False

Question 13

In read consistency, changes made by one user do not conflict with the changes made by another user.

Accepted Answer

True

Question 14

The update statement modifies existing values in a table

Accepted Answer

True

Question 15

A database transaction consists of one DDL statement.

Accepted Answer

True

Question 16

Before the changes are committed to the database, only the user who is modifying the data sees the database with the alterations.

Accepted Answer

True

Question 17

Using figure 7.1, which among the SQL statement is going to change the salary to 19000 and commission to 0.15 of the salesman named Cambrault?

Accepted Answer

update salesman set salary = 19000, commission = 0.15 where sname = ‘Cambrault’;

Question 18

In the savepoint statement, all the locks of the affected rows are released.

Accepted Answer

False

Question 19

A DML statement is executed when adding rows, modifying existing rows, and removing existing rows from a table

Accepted Answer

True

Question 20

What is a type of privilege that can manipulate the contents of the database objects?

Accepted Answer

object privilege

Question 21

A user can have access to several roles, and several users can be assigned the same role.

Accepted Answer

True

Question 22

What are collection of objects such as tables, views and sequences?

Accepted Answer

schemas

Question 23

Fine tuning with group by and having clauses is needed in queries.

Accepted Answer

True

Question 24

select d.department_name,e.employee_id from departments d, cemployees e where d.department_id = e.department_id and e.commission_pct is not null order by e.EMPLOYEE_ID; will show the department name and the employee ids of the employees

Accepted Answer

False

Question 25

What is an equi-join in which one of the duplicate columns is eliminated in the result table?

Accepted Answer

natural join

Question 26

The DBA creates the user by executing the CREATE USER statement.

Accepted Answer

True

Question 27

Users require system privileges to gain access to the database.

Accepted Answer

True

Question 28

Oracle server database security cannot confirm given and received privileges with Oracle data dictionary.

Accepted Answer

False

Question 29

Instead of SELECT *, identify the specific attributes in the SELECT clause for query efficiency.

Accepted Answer

True

Question 30

Using figure 8.3, what SQL statement will show the department name and employee id of employee ids 101 and 102?

Accepted Answer

select dept.department_name, e.employee_id from departments dept inner join employees e on dept.department_id = e.department_id and e.employee_id in (101,102);

Question 31

A role is a named group of related privileges that can be granted to the user. This method makes it easier to revoke and maintain privileges.

Accepted Answer

True

Question 32

An object privilege provides the user the ability to perform a particular action on a specific schema object

Accepted Answer

True

Question 33

Users require object privileges to gain access to the database.

Accepted Answer

False

Question 34

Users can also be given the privilege to grant additional privileges to other users or to roles, which are named groups of related privileges.

Accepted Answer

True

Question 35

The left outer join returns all records from the outer table and the matching records returned from the joined table.

Accepted Answer

True

Question 36

Understanding how indexes are used in query processing makes a better query design.

Accepted Answer

True

Question 37

Which code will allow user A and B to make virtual tables?

Accepted Answer

GRANT CREATE VIEW TO A,B;

Question 38

Which among the following codes will create a user name Michelle_Admin with a password of MA_123

Accepted Answer

Create user Michelle_Admin identified by MA_123;

Question 39

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

Accepted Answer

Join

"Know" box contains:
Time elapsed:
Retries:

F4 IT0119