databases Online Quiz - 32
|Description: databases Online Quiz - 32|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which are DML statements? (Choose all that apply.)
Which four are correct guidelines for naming database tables? (Choose four.)
Which SQL statement generates the alias Annual Salary for the calculated column SALARY*12?
Which operator can be used with a multiple-row subquery?
Which two are character manipulation functions? (Choose two.)
Which clause should you use to exclude group results?
Which is an /SQL*Plus command?
A subquery can be used to _________.
What does the TRUNCATE statement do?
Which substitution variable would you use if you want to reuse the variable value without prompting the user each time?
Which two statements about views are true? (Choose two)
Management has asked you to calculate the value 12*salary*commission_pct for all the employees in the EMP table. The EMP table contains these columns: LAST NAME VARCHAR2(35) NOT NULL SALARY NUMBER(9,2) NOT NULL COMMISSION_PCT NUMBER(4,2) Which statement ensures that a value is displayed in the calculated column for all employees?
Examine the description of the STUDENTS table: STD_ID NUMBER(4) COURSE_ID VARCHAR2(10) START_DATE DATE END_DATE DATE Which two aggregate functions are valid on the START_DATE column? (Choose two.)
Evaluate the SQL statement: SELECT ROUND (TRUNC (MOD (1600, 10),-1), 2) FROM dual; What will be displayed?
Examine the description of the MARKS table: STD_ID NUMBER(4) STUDENT_NAME VARCHAR2(30) SUBJ1 NUMBER(3) SUBJ2 NUMBER(3) SUBJ1 and SUBJ2 indicate the marks obtained by a student in two subjects. Examine this SELECT statement based on the MARKS table: SELECT subj1+subj2 total_marks, std_id FROM marks WHERE subj1 > AVG(subj1) AND subj2 > AVG(subj2) ORDER BY total_marks; What is the result of the SELECT statement?
What is necessary for your query on an existing view to execute successfully?
You define a multiple-row subquery in the WHERE clause of an SQL query with a comparison operator "=". What happens when the main query is executed?