Oracle: Introduction & SQL Overview — Test 2
Page 1 of 3
Question 1
Which SQL*Plus command saves the output of your session to a file?
FPSC - Database Administrator Model Papers -2026
Question 2
Which symbol runs a SQL script file from SQL*Plus?
FPSC - Database Administrator Model Papers -2026
Question 3
The free, entry-level edition of Oracle Database is called:
FPSC - Database Administrator Model Papers -2026
Question 4
How does Oracle store an unquoted table name such as emp or Emp?
FPSC - Database Administrator Model Papers -2026
Question 5
In a LIKE pattern, what does the underscore (_) wildcard match?
FPSC - Database Administrator Model Papers -2026
Question 6
Which statement about BETWEEN 10 AND 20 is correct?
FPSC - Database Administrator Model Papers -2026
Question 7
What is the default sort order of ORDER BY?
FPSC - Database Administrator Model Papers -2026
Question 8
How do you create a column alias containing a space?
FPSC - Database Administrator Model Papers -2026
Question 9
What is a subquery?
FPSC - Database Administrator Model Papers -2026
Question 10
Which Oracle function works like IF-THEN-ELSE by comparing an expression with search values?
FPSC - Database Administrator Model Papers -2026