Database Management System 1 (Oracle) IT-6202 exam answers

Refer to table 10, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART (ID, NAME)VALUES (11,'YAMBAO,JUN');

The ORG and POSITION of YAMBAO will automatically sets to NULL Correct

Refer to table 10, suppose that user insert the following values using the statement below what would be the possible output?INSERT INTO ORGCHART VALUES (11,'YAMBAO,JUN', NULL, NULL);

The ORG and POSITION of YAMBAO will automatically sets to NULL Correct

Refer to table 10, suppose that user update the table using the statement below what would be the possible output?UPDATE ORGCHARTSET ORG = =E2=80=98PCS'WHERE ORG IS NULL;

1 row/s is updated Correct

Suppose that a user uses the DELETE statement as shown below: what is/are the possible output. DELETE from STUDENT;

0 rows are deleted
0 rows are updated
All rows are deleted including table structure
All rows are deleted but the table is still intact Correct

Suppose that a user wanted to add a new column name as CITY datatype set to char size 10. Which of the following is the correct sql statement?

ALTER TABLE STUDENTSADD CITY CHAR(10); Correct
ALTER TABLE STUDENTSADD COLUMN CITY VARCHAR(10);
ALTER TABLE STUDENTSADD COLUMN CITY CHAR(10);
ALTER TABLE STUDENTSADD CITY VARCHAR(10);

Suppose that a user wanted to change the datatype of column ADDRESS from Varchar to Char which of the following is the correct example.

ALTER TABLE STUDENTSSET ADDRESS VARCHAR(20);
ALTER STUDENTSSET ADDRESS VARCHAR(20);
ALTER TABLE STUDENTSMODIFY ADDRESS VARCHAR(20); Correct
ALTER STUDENTSMODIFY ADDRESS VARCHAR(20);

Suppose that a user wanted to insert a new value using the explicit method which of the following is the correct example.

INSERT INTO STUDENTS VALUES (USN_ID, FIRSTNAME)(10,=E2=80=99ELENA=E2=80=99)
INSERT INTO STUDENTS VALUES (10,=E2=80=99ELENA=E2=80=99)
INSERT INTO STUDENST(USN_ID, FIRSTNAME)VALUES(10,=E2=80=99ELENA=E2=80=99)
INSERT INTO STUDENTS VALUES (10, NULL,=E2=80=99ELENA=E2=80=99,NULL); Correct

Suppose that a user wanted to insert a new value using the implicit method which of the following is the correct example.

INSERT INTO STUDENTS VALUES (10,=E2=80=99ELENA=E2=80=99)
INSERT INTO STUDENTS VALUES (10, NULL,=E2=80=99ELENA=E2=80=99,NULL);
INSERT INTO STUDENST(USN_ID, FIRSTNAME)VALUES(10,=E2=80=99ELENA=E2=80=99) Correct
INSERT INTO STUDENTS VALUES (USN_ID, FIRSTNAME)(10,=E2=80=99ELENA=E2=80=99)

Suppose that the user wanted to add a new column name as CUST_NAME data type char size 6. What is the correct SQL statement to use?

ALTER PARTSSET CUST_NAME = CHAR(6);
ALTER TABLE PARTSSET CUST_NAME = CHAR(6);
ALTER TABLE PARTSADD CUST_NAME CHAR(6); Correct
ALTER PARTSADD CUST_NAME CHAR(6);

Suppose that the user wanted to add a new column name as CUST_NAME data type char size 6. What is the correct type of statement to use?

UPDATE
DELETE
INSERT
ALTER Correct

Supposed that the user uses the ff SELECT statement: what will be the possible output.SELECT GRADE AS STUDENT MARK FROM GRADE_REPORT;

Error because of missing =E2=80=9C=E2=80=9D mark Correct
Will display the column GRADE rename as STUDENT MARK
Error because of the keyword AS
Will display all rows and columns

This character is used to override the default precedence or to clarify the statement.

( ) Correct
*
AS
||

This is use to accept character input and can return both character and number values.

Multiple row function
Number function
Character function Correct
Case manipulation function

This is use to create expression with number and date values.

Arithmetic expression Correct
Logical Condition
MDAS operator
Numerical Values

This is use to find the numeric position of a named character starting at character position n.

INSTR Correct
Length
SUBSTR
Trim

This is use to return one result per group of row.

Single row
Dual table
Multiple row Correct
Number function

This is use to return one result per row.

Dual table
Single row Correct
Multiple row
Number function

This is use to Selects the columns in a table that are returned by a query. Selects a few or as many of the columns as required.

Projection Correct
Joins
Inclusion
Selection

This is used to brings together data that is stored in different tables by specifying the link between them.

Projection
Joins Correct
Inclusion
Selection

This is used to converts the first letter of each word to uppercase and the remaining letters to lowercase.

Upper case
INITCAT Correct
Sentence case
lowercase

This is used to display rows based on a range of values.

Comparison
Like
Between Correct
IN

This is used to in conditions that compare one expression with another value or expression.

Comparison Correct
Add
Logical Condition
Subtraction

This is used to perform wildcard searches of valid search string values.

Comparison
Between
IN
Like Correct

This is used to restrict the rows that are returned by a query.

Select
Insert
Delete
Where Correct

This is used to selects the rows in a table that are returned by a query. Various criteria can be used to restrict the rows that are retrieved.

Projection
Joins
Inclusion
Selection Correct

This is used to test for values in a specified set of values.

Between
IN Correct
Like
Comparison

Trims leading or trailing characters (or both) from a character string.

Trim Correct
Length
INSTR
SUBSTR

What is the return value if the user try to do the following:SELECT TRUNC (65.73,-2) FROM DUAL;

600
0 Correct
00
60

Which of the following datatype is not being used in oracle?

NUMBER
VARCHAR
CHAR
INT Correct

Which of the following is not part of advantage of database?

Data integrity and security
Data independence
Database instance Correct
Efficient data access

Which of the following is not part of basic SELECT statement

Concat
Alias
Specific Column
Logical condition Correct

Which of the following is not part of characteristics of database?

Data Persistence
Transactions
Data Integrity
Data Processing Correct

Which of the following is not part of common Comparison operator?

>
!=
<
LIKE Correct

Which of the following is not part of data control language?

Insert Correct
Grant
Revoke

Which of the following is not part of data manipulation language?

merge
Insert
Alter Correct
Update

Which of the following is not part of DDL statement?

DELETE Correct
ALTER
CREATE
None of the choices

Which of the following is not part of disadvantage of database?

Data integrity Correct
Lower Efficiency
Costs
Qualified Personnel

Which of the following is not part of DML statement?

UPDATE
INSERT
MERGER
CREATE table Correct

Which of the following is not part of handling data?

Semi-Computerized Correct
File Oriented Approach
Data Management Systems
Data Processing

Which of the following is not part of other Comparison Operator?

<> Correct
IS NUL
IN
Between AND

Which of the following is not part of transaction control?

ROLLBACK
COMMIT
CREATE Correct
SAVEPOINT

Which of the following is not the correct example of entity?

EMPLOYEES
ORDERS
STUDENT
Phone_no Correct

Which of the following is not true about ALTER statement?

Define a default value for the new column
Drop a column
Modify an existing column definition
Insert new row in a table Correct

Which of the following is not true about writing SQL statements?

Keywords cannot be split across lines or abbreviated
SQL statements are case sensitive Correct
Clauses are usually placed on separate lines for readability and ease of editing
Indents should be used to make code more readable

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is 'CRUZ' and the rest of the column is set to NULL.

INSERT INTO STUDENTS TABLE VALUES (10,'CRUZ','NULL','NULL');
INSERT INTO STUDENTS VALUES (10,'CRUZ',NULL,NULL); Correct
INSERT INTO STUDENTS (10,'CRUZ',NULL,NULL);
INSERT INTO STUDENTS VALUES (10,'CRUZ','NULL','NULL');

Which of the following is the correct example inserting a new value to STUDENTS table that will only add new data to STUD_ID and LASTNAME? The stud_id is 10 and lastname is =E2=80=98CRUZ'

INSERT INTO STUDENTS VALUES (A0,=E2=80=99CRUZ=E2=80=99);
INSERT INTO STUDENTS(STUD_ID,LASTNAME)VALUES(10,=E2=80=99CRUZ=E2=80=99); Correct
INSERT INTO STUDENTS VALUES (STUD_ID,LASTNAME)(10,=E2=80=99CRUZ=E2=80=99);
INSERT INTO STUDENTS (A0,=E2=80=99CRUZ=E2=80=99);

Which of the following is the correct example of adding a new column ADDRESS datatypevarchar size 20 to EMPLOYEES table?

ALTER TABLE EMPLOYEESADD COLUMN ADDRESS VARCHAR(20);
ALTER TABLE EMPLOYEESADD ADDRESS VARCHAR(20); Correct
ALTER EMPLOYEESADD ADDRESS VARCHAR(20);
ALTER TABLE EMPLOYEESSET ADDRESS VARCHAR(20);

Which of the following is the correct example of adding a new column CONTACT_NOdatatypeNUMBER size 11 to EMPLOYEES table?

ALTER TABLE EMPLOYEESADD CONTACT_NO NUMBER;
ALTER EMPLOYEESADD CONTACT_NO NUMBER(11);
ALTER TABLE EMPLOYEESADD COLUMN CONTACT_NO NUMBER(11);
ALTER TABLE EMPLOYEESADD CONTACT_NO NUMBER(11); Correct

Which of the following is the correct example of creating a new table STUDENTS? The column STUD_ID is set to primary key.

CREATE TABLE STUDENTS( STUD_ID NUMBER(3) datatypePRIMARY KEY);
CREATE TABLE STUDENTS( STUD_ID NUMBER(3) PRIMARY KEY); Correct
CREATE TABLE STUDENTS( STUD_ID NUMBER(3) pk);
CREATE STUDENTS( STUD_ID NUMBER(3) PRIMARY KEY);

Which of the following is the correct example of deleting a student record from STUDENTS table whose COURSE is equal to NULL;

DELETE FROM STUDENTSWHERE COURSE = =E2=80=98NULL=E2=80=99;
DELETE FROM STUDENTSWHERE COURSE IS NULL; Correct
DELETE * FROM STUDENTSWHERE COURSE IS NULL;
DELETE FROM STUDENTSWHERE COURSE IS =NULL;

Which of the following is the correct example of deleting all records in STUDENTS table;

DROP TABLE STUDENTS;
DELETE FROM STUDENTS; Correct
DELETE * FROM STUDENTS;
DELETE TABLE STUDENTS;

Which of the following is the correct example of dropping the table EMPLOYEES?

DROP EMPLOYEES;
ALTER TABLE DROP TABLE EMPLOYEES;
ALTER TABLE DROP EMPLOYEES;
DROP TABLE EMPLOYEES; Correct

Which of the following is the correct example of inserting new values to STUDENTS table where the course is set to NULL;

INSERT INTO STUDENTS (1,'DELA CRUZ','JUANITO',NULL);
INSERT INTO STUDENTS VALUES(1,'DELA CRUZ','JUANITO',NULL); Correct
INSERT INTO STUDENTS VALUES(1,'DELA CRUZ','JUANITO','NULL');
INSERT INTO STUDENTS (1,'DELA CRUZ','JUANITO','NULL');

Which of the following is the correct example of inserting new values to STUDENTS table?

INSERT INTO STUDENTS VALUES(1,DELA CRUZ,JUANITO,BSIT);
INSERT INTO STUDENTS VALUES(1,'DELA CRUZ','JUANITO','BSIT'); Correct
INSERT INTO STUDENTS (1,'DELA CRUZ','JUANITO','BSIT');
INSERT INTO STUDENTSVALUES('1','DELA CRUZ','JUANITO','BSIT');

Which of the following is the correct example of modifying the column JOB_ID? Change the datatype size to 10.

ALTER TABLE EMPLOYEESMODIFY SET JOB_ID CHAR(10);
ALTER EMPLOYEESMODIFY SET JOB_ID CHAR(10);
ALTER TABLE EMPLOYEESMODIFY JOB_ID CHAR(10); Correct
ALTER EMPLOYEESMODIFY JOB_ID CHAR(10);

Which of the following is the correct example of modifying the column lastname? Change the datatype size to 20.

ALTER EMPLOYEESMODIFY LASTNAME VARCHAR(20);
ALTER EMPLOYEESSET LASTNAME = VARCHAR(20);
ALTER TABLE EMPLOYEESMODIFY LASTNAME VARCHAR(20); Correct
ALTER TABLE EMPLOYEESSETLASTNAME =VARCHAR(20);

Which of the following is the correct example of removing a column FIRSTNAME from EMPLOYEES table?

ALTER EMPLOYEESFROM COLUMN FIRSTNAME;
ALTER EMPLOYEESFROM N FIRSTNAME;
ALTER TABLE EMPLOYEESDROP COLUMN FIRSTNAME; Correct
ALTER TABLE EMPLOYEESDROP FIRSTNAME;

Which of the following is the correct example of removing a column SALARY from EMPLOYEES table?

ALTER EMPLOYEESDROP SALARY;
ALTER TABLE EMPLOYEESDROP COLUMN SALARY; Correct
ALTER EMPLOYEESDROP COLUMN SALARY;
ALTER TABLE EMPLOYEESDROP SALARY;

Which of the following is the correct example of renaming the table EMPLOYEES to WORKERS?

RENAME TABLE EMPLOYEES TO WORKERS;
RENAME EMPLOYEES AS WORKERS;
RENAME EMPLOYEES TO WORKERS; Correct
ALTER TABLE RENAME EMPLOYEES TO WORKERS;

Which of the following is the correct example of truncating the table EMPLOYEES?

TRUNCATE EMPLOYEES;
ALTER TABLE TRUNCATE TABLE EMPLOYEES;
TRUNCATE TABLE EMPLOYEES; Correct
ALTER TABLE TRUNCATE EMPLOYEES;

Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all students from STUDENTS table whose course IS NULL;

UPDATE TABLE STUDENTSSET COURSE = =E2=80=98N/A=E2=80=99WHERE COURSE IS NULL;
UPDATE STUDENTSSET COURSE = =E2=80=98N/A=E2=80=99WHERE COURSE IS NULL; Correct
UPDATE STUDENTSSET COURSE = =E2=80=98N/A=E2=80=99WHERE COURSE = NULL;
UPDATE TABLE STUDENTSSET COURSE = =E2=80=98N/A=E2=80=99WHERE COURSE = NULL;

Which of the following is the correct example of updating the COURSE to =E2=80=98N/A' of all students from STUDENTS table whose course IS NULL;

UPDATE STUDENTSSET COURSE = =E2=80=98N/A'WHERE COURSE IS NULL; Correct

Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?

UPDATE TABLE STUDENTSSET STUD_ID = 01020564;WHERE LASTNAME = =E2=80=98REYES=E2=80=99;
UPDATE STUDENTSSET LASTNAME = =E2=80=98REYES=E2=80=99WHERE STUD_ID = 01020564; Correct
UPDATE TABLE STUDENTSSET LASTNAME = =E2=80=98REYES=E2=80=99WHERE STUD_ID = 01020564;
UPDATE STUDENTSSET STUD_ID = 01020564;WHERELASTNAME = =E2=80=98REYES=E2=80=99;

Which of the following is the correct example of updating the LASTNAME to =E2=80=98REYES' of all students from STUDENTS table whose STUD_ID is equal to 01020564?

UPDATE STUDENTSSET LASTNAME = =E2=80=98REYES'WHERE STUD_ID = 01020564; Correct

Which of the following is the correct example updating all student COURSE to =E2=80=98BSIT' from STUDENTS table?

UPDATE STUDENTSSET COURSE = =E2=80=98BSIT=E2=80=99; Correct
UPDATE TABLE STUDENTSSET COURSE = =E2=80=98BSIT=E2=80=99WHERE COURSE = =E2=80=98BSIT=E2=80=99;
UPDATE STUDENTSSET COURSE = =E2=80=98BSIT=E2=80=99WHERE COURSE = =E2=80=98BSIT=E2=80=99;
UPDATE TABLE STUDENTSSET COURSE = =E2=80=98BSIT=E2=80=99;

Which of the following is the correct example updating all student COURSE to =E2=80=98BSIT' from STUDENTS table?

UPDATE STUDENTSSET COURSE = =E2=80=98BSIT'; Correct

Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and course to =E2=80=98BSCS' whose STUD_ID is equal to 109?

UPDATE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS=E2=80=99, SET COURSE = =E2=80=98BSCS=E2=80=99WHERE STUD_ID = 109;
UPDATE TABLE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS=E2=80=99, SET COURSE = =E2=80=98BSCS=E2=80=99WHERE STUD_ID = 109;
UPDATE TABLE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS=E2=80=99, COURSE = =E2=80=98BSCS=E2=80=99WHERE STUD_ID = 109;
UPDATE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS=E2=80=99, COURSE = =E2=80=98BSCS=E2=80=99WHERE STUD_ID = 109; Correct

Which of the following is the correct example updating the student LASTNAME TO =E2=80=98SANTOS' and course to =E2=80=98BSCS' whose STUD_ID is equal to 109?

UPDATE EMPLOYEESSET LASTNAME = =E2=80=98SANTOS', COURSE = =E2=80=98BSCS'WHERE STUD_ID = 109; Correct

Which of the following query is correct which will display the same output as shown below?

SELECT COUNT(DISTINCT MANAGER_ID) AS "NO OF MANAGER_ID" FROM EMPLOYEES; Correct
SELECT COUNT *(DISTINCT MANAGER_ID) AS "NO OF MANAGER_ID" FROM EMPLOYEES;
SELECT COUNT(DISTINCT MANAGER_ID) AS NO OF MANAGER_ID FROM EMPLOYEES;
SELECT COUNT(MANAGER_ID) AS "NO OF MANAGER_ID" FROM EMPLOYEES;

Database Management System 1 (Oracle)

Showing 76-144 of 144 answers