Question 1

In this method, source documents are manually prepared using equipment such as typewriter and calculator.

Accepted Answer

Mechanical Method

Answer

Manual Method

Answer

Electrical Method

Answer

ElectromechanicalMethod

Question 2

In this method, source documents are prepared using tools such as pens, pencils, ledgers, files, and folders, among others.

Accepted Answer

Manual Method

Answer

Mechanical Method

Answer

Electrical Method

Answer

D. Electromechanical Method

Question 3

This is the vertical entity in a table that constrains all information related to aspecific field in a table.

Accepted Answer

column

Answer

row

Answer

table

Answer

field

Question 4

It is considered to be a group of database objects such as tables, views, clusters, procedures, and package

Accepted Answer

Schema

Answer

User

Answer

Database security

Answer

user authentication

Question 5

It controls the actions of users who are accessing the database

Accepted Answer

user authentication

Answer

User

Answer

Schema

Answer

Database security

Question 6

Less than or equal to

Accepted Answer

<=

Answer

>=

Answer

<=>

Answer

><

Question 7

Not equal to operator

Accepted Answer

<>

Answer

NOT =

Answer

=!

Answer

><

Question 8

Checks a not null value test

Accepted Answer

IS NOT

Answer

LIKE NULL

Answer

IN()

Answer

IS NOT NULL

Question 9

Tests for a match, in a specified list of values

Accepted Answer

IN()

Answer

A. LIKE NULL

Answer

IS NOT NULL

Answer

IS NOT

Question 10

Searches a match in a string

Accepted Answer

LIKE NULL

Answer

IN()

Answer

IS NOT NULL

Answer

IS NOT

Question 11

This is used to make the name of the column headings shorter.

Accepted Answer

TABLE ALIAS

Answer

COLUMN ALIAS

Answer

ORACLE ALIAS

Question 12

This is used to alter the name of a given table.

Accepted Answer

COLUMN ALIAS

Answer

ORACLE ALIAS

Answer

TABLE ALIAS

Question 13

This is used as a substitute for a name of columns, rows, or tables.

Accepted Answer

ORACLE ALIAS

Answer

COLUMN ALIAS

Answer

TABLE ALIAS

Question 14

Creates a resultant column that is a character expression.

Accepted Answer

Concatenation operator

Answer

Literal character strings

Answer

Alternative quote operator

Question 15

Specifies your own quotation mark delimiter.

Accepted Answer

Alternative quote operator

Answer

Concatenation operator

Answer

Literal character strings

Question 16

It increases readability and usability.

Accepted Answer

Alternative quote operator

Answer

Concatenation operator

Answer

Literal character strings

Question 17

Date and character literal values must be enclosed within single quotation marks.

Accepted Answer

Literal character strings

Answer

Concatenation operator

Answer

Alternative quote operator

Question 18

It is represented by two vertical bars (||).

Accepted Answer

Concatenation operator

Answer

Literal character strings

Answer

Alternative quote operator

Question 19

If the value of X is 10 and the condition is X IS NULL, then the result will be a true value.

Accepted Answer

FALSE

Answer

TRUE

Question 20

If the value of X. is NULL and the condition is X! = 5, then the result will be UNKNOWN.

Accepted Answer

TRUE

Answer

FALSE

Question 21

If the value of X is null and the condition is X = 15,then the result will be UNKOWN.

Accepted Answer

TRUE

Answer

FALSE

Question 22

If the value of X is NULL and the condition is X= NULL, then the result will be a TRUE value.

Accepted Answer

FALSE

Answer

TRUE

Question 23

If the value of X is NULL and the condition is X IS NOT NULL, then the result will be a FALSE value.

Accepted Answer

TRUE

Answer

FALSE

Question 24

Character functions can return both character and numeric values even if the input accepted is just character values.

Accepted Answer

TRUE

Answer

FALSE

Question 25

Numeric functions accept numeric input and return numeric values.

Accepted Answer

TRUE

Answer

FALSE

Question 26

Single-Row functions return multiple results row for every row of a queried table or view.

Accepted Answer

FALSE

Answer

TRUE

Question 27

Multiple row function returns a single result row based on groups of rows rather than on single rows.

Accepted Answer

FALSE

Answer

TRUE

Question 28

The conversion function converts any data type to any form of data type.

Accepted Answer

TRUE

Answer

FALSE

Question 29

CONCAT ('Hello', 'World')

Accepted Answer

HelloWorld

Answer

Helloworld

Answer

HELLOWORLD

Answer

helloworld

Question 30

UPPER ('character')

Accepted Answer

CHARACTER

Answer

character

Answer

Character

Answer

ChArAcTeR

Question 31

INSTR ('character', 'h')

Accepted Answer

2

Answer

6

Answer

4

Answer

8

Question 32

INITCAP (good morning)

Accepted Answer

Good Morning

Answer

GOOD MORNING

Answer

good morning

Answer

GoOd MoRnInG

Question 33

INSTR ('database', 'b')

Accepted Answer

5

Answer

1

Answer

4

Answer

2

Question 34

Nana wants to retrieve the information from column MID inside the table LANE.

Accepted Answer

SELECT MID FROM LANE

Answer

SELECT * MIDFROM LANE

Answer

SELECT LANE FROMMID

Answer

SELECT *LANE

Question 35

Aulus wants to retrieve the information from column MAGE and FIGHTER inside the table ROLE. She also wants to display the information in ascending order by the value of FIGHTER

Accepted Answer

SELECT MAGE, FIGHTER FROM ROLE ORDER BY FIGHTER;

Answer

SELECT MAGE,FIGHTER FROM ROLE ORDER BY FIGHTER?

Answer

SELECT MAGE,FIGHTER FROM ROLE ORDER BY FIGHTER DESC;

Answer

SELECT MAGE,FIGHTER FROM ROLE ORDER BY FIGHTER ACS;

Question 36

Karina wants to retrieve all the information from table JUNGLER.

Accepted Answer

SELECT * FROM JUNGLER

Answer

SELECT FROMJUNGLER

Answer

SELECT FROM ALL

Answer

SELECTJUNGLER

Question 37

Karrie wants to retrieve information from column GOLD and EXPERIENCE inside the table LANE. He also wants to display the information in ascending order by the value of GOLD.

Accepted Answer

SELECT GOLD, EXPERIENCE FROM LANE ORDER BY GOLD;

Answer

SELECT GOLD,EXPERIENCE FROM LANE ORDER BY GOLD?

Answer

SELECT GOLD,EXPERIENCE FROM LANE ORDER BY GOLD DESC;

Answer

SELECT GOLD,EXPERIENCE FROM LANE ORDER BY GOLD ACS

Question 38

Angela wants to retrieve all of the information from table SUPPORT.

Accepted Answer

SELECT * FROM SUPPORT

Answer

SELECT FROMSUPPORT

Answer

SELECT FROMALL

Answer

SELECT SUPPORT

Question 39

Create a select statement that would return all rows from column SALARY inside the table PRO_PLAYER where the values are less than 5000.

Accepted Answer

SELECT * FROM PRO_PLAYERS WHERE SALARY < ‘5000’;

Answer

SELECT FROM PRO_PLAYERS WHERE SALARY < ‘5000’;

Answer

SELECT *FROM PRO_PLAYERS WHERE SALARY > ‘5000’;

Answer

SELECT FROM PRO_PLAYERS WHERE SALARY > ‘5000’;

Question 40

Create a select statement that would return all rows from column LAST_NAME inside the table PRO_PLAYERS where the values are equals to VILLALUNA.

Accepted Answer

SELECT * FROM PRO_PLAYERS WHERE LAST_NAME = ‘VILLALUNA’;

Answer

SELECT *FROM PRO_PLAYERS WHERE LAST_NAME <> ‘VILLALUNA’;

Answer

SELECT *FROM PRO_PLAYERS WHERE LAST_NAME! = ‘VILLALUNA’;

Answer

SELECT FROM PRO_PLAYERSWHERE LAST_NAME = ‘VILLALUNA’;

Question 41

Create a select statement that would return all rows from column FIRST_NAME NAME inside the table PRO_PLAYER where the value is not equal to TRISTAN.

Accepted Answer

SELECT * FROM PRO_PLAYERS WHERE FIRST_NAME <> ‘TRISTAN’;

Answer

SELECT *FROM PRO_PLAYERS WHERE FIRST_NAME >< ‘TRISTAN’;

Answer

SELECT FROM PRO_PLAYERSWHERE FIRST_NAME <> ‘TRISTAN’;

Answer

SELECT *FROM PRO_PLAYERS WHERE FIRST_NAME NOT= ‘TRISTAN’;

Question 42

Create a select statement that would return all rows from column SALARY inside the table PRO_PLAYER where the values are less than or equal to 4735.

Accepted Answer

SELECT * FROM PRO_PLAYER WHERE SALARY <= ‘4735’;

Answer

SELECT *FROM PRO_PLAYER WHERE SALARY => ‘4735’;

Answer

SELECT *FROM PRO_PLAYER WHERE SALARY =< ‘4735’;

Answer

SELECT *FROM PRO_PLAYER WHERE SALARY >= ‘4735’;

Question 43

Create a select statement that would return all rows from column SALARY inside the table PRO_PLAYER where the values are less than 8000.

Accepted Answer

SELECT * FROM PRO_PLAYERS WHERE SALARY > ‘8000’;

Answer

SELECT *FROM PRO_PLAYERS WHERE SALARY < ‘8000;

Answer

SELECT FROM PRO_PLAYERSS WHERE SALARY < ‘8000’;

Answer

SELECT FROM PRO_PLAYERS WHERE SALARY > ‘8000’;

Question 44

As a result, MYNAME will display as substitute heading of column LAST_NAME from table EMPLOYEE.

Accepted Answer

SELECT LAST_NAME AS MYNAME FROM EMPLOYEE

Answer

SELECT MYNAME AS LAST_NAME FROM EMPLOYEE

Answer

SELECT EMPLOYEE AS MYNAME FROM LAST_NAME

Answer

SELECT AS MYNAME FROM EMPLOYEE LAST_NAME

Question 45

As a result, TELEPHONE will display as substitute heading of column TEL_NO from table COMMINUCATION.

Accepted Answer

SELECT TEL_NO AS TELEPHONE FROM COMMUNICATION

Answer

SELECT TELEPHONE AS TEL_NO FROMCOMMUNICATION

Answer

SELECT COMMUNICATION AS TEL_NO FROM TELEPHONE

Answer

SELECT COMMUNICATION FROM TEL_NO AS TELEPHONE

Question 46

As a result, ADDRESS will display as substitute heading of column HOMETOWN from table LOCATION.

Accepted Answer

SELECT HOMETOWN AS ADDRESS FROM LOCATION

Answer

SELECT HOMETOWN AS LOCATION FROM ADDRESS

Answer

SELECT ADDRESS AS HOMETOWN FROM LOCATION

Answer

SELECT LOCATION FROM HOMETOWN AS ADDRESS

Question 47

As a result, LAPTOP will display as substitute heading of column COMPUTER from table GADGETS.

Accepted Answer

SELECT COMPUTER AS LAPTOP FROM GADGETS

Answer

SELECT GADGETS AS COMPUTER FROM LAPTOP

Answer

SELECT LAPTOP AS GADGETS FROM COMPUTER

Answer

SELECT GADGETS FROM LAPTOP AS COMPUTER

Question 48

As a result, JOBDESCRIPTION will display as substitute heading of column JOBS from table DEPARTMENT.

Accepted Answer

SELECT JOBS AS JOBDESCRIPTION FROM DEPARTMENT

Answer

SELECT DEPARTMENT AS JOBS FROMJOBDESCRIPTION

Answer

SELECT JOBDESCRIPTION AS JOBS FROMDEPARTMENT

Answer

SELECT DEPARTMENT AS JOBDESCRIPTION FROMJOBS

Question 49

As a result, AIRCON will display as substitute heading of column FAN from table REFRESHMENT.

Accepted Answer

SELECT FAN AS AIRCON FROM REFRESHMENT

Answer

SELECT REFRESHMENT AS FAN FROM AIRCON

Answer

SELECT AIRCON AS FAN FROM REFRESHMENT

Answer

SELECT FAN AS REFRESHMENT FROM AIRCON

Question 50

As a result, CHAIR will display as substitute heading of column BENCH from table FURNITURE.

Accepted Answer

SELECT BENCH AS CHAIR FROM FURNITURE

Answer

SELECT CHAIR AS BENCH FROM FURNITURE

Answer

SELECT FURNITURE AS CHAIR FROM BENCH

Answer

SELECT BENCH AS FURNITURE FROM CHAIR

Related quizzes

Related quizzes