9296997
Beschreibung
Quiz von Mylaisa McMullen, aktualisiert more than 1 year ago
|
Erstellt von Mylaisa McMullen
vor mehr als 7 Jahre
|
|
Frage 1
Frage
Identify the capabilities of SELECT statement.
Antworten
-
Projection
-
Selection
-
Data Control
-
Transaction
Frage 2
Frage
Determine the capability of the SELECT statement demonstrated in the given query.
SELECT e.ename, d.dname
FROM emp e, dept d
WHERE e.deptno = d.deptno
AND e.sal > 1000;
Antworten
-
Selection
-
Filtering
-
Joining
-
Projection
Frage 3
Frage
Which of the following clause is used to suppress duplicates in a SELECT statement?
Antworten
-
INTERSECT
-
DUPLICATE
-
DISTINCT
-
UNIQUE
Frage 4
Frage
Chose the statements which correctly specify a rule to write a SQL statement
Antworten
-
SQL statements are case sensitive
-
Keywords can be abbreviated to build a standard
-
SQL statements are case in-sensitive
-
clauses must be placed together
Frage 5
Frage
Determine the output of the below query
SELECT '5+7'
FROM dual;
Antworten
-
12
-
5+7
-
5
-
7
Frage 6
Frage
Write a query to display employee details (Name, Department, Salary and Job) from EMP table
Antworten
-
SELECT ename, deptno, sal, job FROM emp;
-
SELECT * FROM emp;
-
SELECT DISTINCT ename, deptno, sal, job FROM emp;
-
SELECT ename, deptno, sal FROM emp;
Frage 7
Frage
Which of the below queries displays employees' name and new salary after the increment of 1000?
Antworten
-
SELECT ename, sal FROM emp;
-
SELECT ename, sal=sal+1000 FROM emp;
-
SELECT ename, sal+1000 FROM emp;
-
SELECT ename, 1000 FROM emp;
Frage 8
Frage
Determine the output of the below query
SELECT 36/2-5*10 FROM dual;
Antworten
-
130
-
-32
-
-120
-
175
Frage 9
Frage
Determine the output of the below query
SELECT (100-25)/15*(20-3) FROM dual;
Antworten
-
0.294
-
-85
-
63.67
-
85
Frage 10
Frage
Chose the statements which correctly define a NULL value.
Antworten
-
NULL is a special value with zero bytes
-
NULL is no value or unknown value
-
NULL is represented by a blank space
-
NULL is not same as zero
Frage 11
Frage
Determine the output of the below query
SELECT sal + NULL
FROM emp
WHERE empno = 7369;
Antworten
-
sal + NULL
-
NULL
-
0
-
1250
Frage 12
Frage
Which of the below statements define column alias correctly?
Antworten
-
A column alias renames a column heading
-
A column alias is an alternate column in a table
-
A column alias can be specified during table definition
-
A column alias immediately follows the column or expression in the SELECT statement
Frage 13
Frage
Specify the column alias NEWSAL for the expression containing salary in the below SQL query
SELECT ename, job, sal + 100 FROM emp;
Antworten
-
(sal + 100) AS NEWSAL
-
(sal + 100) NEWSAL
-
(sal + 100) IS NEWSAL
-
sal + 100 IS NEWSAL
Frage 14
Frage
Specify the column alias "New Salary" for the expression containing salary in the below SQL query
SELECT ename, job, sal + 100 FROM emp;
Antworten
-
(sal + 100) AS New Salary
-
(sal + 100) "New Salary"
-
(sal + 100) IS New Salary .
-
sal + 100 as "New Salary"
Frage 15
Frage
Which command is used to display the structure of a table?
Antworten
-
LIST
-
SHOW
-
DESCRIBE
-
STRUCTURE
Frage 16
Frage
Predict the output when below statement is executed in SQL* Plus?
DESC emp
Antworten
-
Raises error "SP2-0042: unknown command "desc emp" - rest of line ignored."
-
Lists the columns of EMP table
-
Lists the EMP table columns, their data type and nullity
-
Lists the columns of EMP table along with their data types
Frage 17
Frage
Which of the below statements are true about the DESCRIBE command?
Antworten
-
It can be used in SQL*Plus only
-
It can be used in both SQL*Plus as well as SQL Developer
-
It doesn't works for object tables
-
It doesn't works for SYS owned tables
Frage 18
Frage
Which of the below alphanumeric characters are used to signify concatenation operator in SQL?
Antworten
-
+
-
||
-
-
-
::
Frage 19
Frage
Which of the below statements are correct about the usage of concatenation operator in SQL?
Antworten
-
It creates a virtual column in the table
-
It generates a character expression as the result of concatenation of one or more strings
-
It creates a link between two character columns
-
It can be used to concatenate date expressions with other column
Frage 20
Frage
Predict the output of the below query
SELECT ename || NULL
FROM emp
WHERE empno = 7369
Antworten
-
SMITH
-
SMITH NULL
-
SMITHNULL
-
ORA-00904: "NULL": invalid identifier
Frage 21
Frage
Predict the output of the below query
SELECT 50 || 0001
FROM dual
Antworten
-
500001
-
51
-
501
-
5001
Frage 22
Frage
You execute the below query
SELECT e.ename||' departments's name is:'|| d.dname
FROM emp e, dept d
where e.deptno=d.deptno;
And get the exception - ORA-01756: quoted string not properly terminated. Which of the following solutions can permanently resolve the problem?
Antworten
-
Use double quote marks for the literal character string
-
Use [q] operator to enquote the literal character string and selecting the delimiter of choice
-
Remove the single quote mark (apostrophe) from the literal character string
-
Use another delimiter to bypass the single quote apostrophe in the literal string
Frage 23
Frage
Which of the below SELECT statement shows the correct usage of [q] operator?
Antworten
-
SELECT e.ename || q'[department's name is]'|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;
-
SELECT e.ename || q['department's name is']|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;
-
SELECT e.ename || q[department's name is]|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;
-
SELECT e.ename || q'(department's name is)'|| d.dname FROM emp e, dept d WHERE e.deptno = d.deptno;
Frage 24
Frage
Which of the below SELECT statement is used to select all columns of EMP table?
Antworten
-
SELECT ALL FROM emp
-
SELECT # FROM emp
-
SELECT * FROM emp
-
ELECT empno,ename,deptno,sal,job,mgr,hiredate FROM emp
Frage 25
Frage
Which of the below SQL query will display employee names, department, and annual salary?
Antworten
-
SELECT ename, deptno, sal FROM emp;
-
SELECT ename, deptno, sal + comm FROM emp;
-
SELECT ename, deptno, (sal * 12) Annual_Sal FROM emp;
-
Annual salary cannot be queried since the column doesn't exists in the table
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.