Databases - Upwork

Question: What interfaces are available in the base distribution of PostgreSQL?
A
Java

B
PHP

C
C

D
Ruby

E
Perl

Note: Not available
1. Report
Question: What is the default ordering when ORDER BY is not specified?
A
By ID

B
By insertion date

C
By name

D
The ordering is unknown if not specified

E
None of these above

Note: Not available
1. Report
Question: What command will correctly restore a backup made with the following command? pg_dump -Fc dbname > filename
A
psql -f filename dbname

B
psql -Fc filename dbname

C
pg_restore filename dbname

D
pg_restore -d dbname filename

E
None of these

Note: Not available
1. Report
Question: How do you select a single random row from a table?
A
SELECT random() * FROM tab LIMIT 1;

B
SELECT * FROM tab ORDER BY random() LIMIT 1;

C
SELECT * FROM tab RANDOM LIMIT 1 ;

D
SELECT RANDOM 1 from tab;

E
None of these

Note: Not available
1. Report
Question: Which of the following constitute the correct guidelines for naming database tables?
A
Must begin with either a number or letter

B
Must be 1-30 characters long

C
Should not be an Oracle Server reserved word

D
Must contain only A-Z, a-z, 0-9, _,*, and #

E
Must contain only A-Z, a-z, 0-9, _, $, and #

F
Must begin with a letter

Note: Not available
1. Report
Question: Which of the following are DML statements?
A
COMMIT

B
MERGE

C
UPDATE

D
DELETE

E
CREATE

F
DROP

Note: Not available
1. Report
Question: An outer join is used when:
A
The tables being joined have NOT NULL columns

B
The tables being joined have only matched data.

C
The columns being joined have NULL values

D
The tables being joined have only unmatched data

E
The tables being joined have both matched and unmatched data

Note: Not available
1. Report
Question: Which of the following components are required to run iSQL*plus on PC?
A
SQL*PLUS installed on the PC

B
HTTP Server

C
Oracle net on PC

D
iSQL*PLUS Server

Note: Not available
1. Report
Question: Which of the following constitute the attributes of /SQL*Plus?
A
/SQL*Plus commands cannot be abbreviated

B
/SQL*Plus commands are accessed from a browser

C
/SQL*Plus commands are used to manipulate data in tables

D
/SQL*Plus commands manipulate table definitions in the database

E
/SQL*Plus is the Oracle proprietary interface for executing SQL statements

Note: Not available
1. Report
Question: Which component is a literal in the following select statement? Select 'Emp name :'||ename from emp where deptno=20;
A
ename

B
20

C
Emp name:

D
||

Note: Not available
1. Report

First Prev 49 50 51 52 53 Next Last

Question: What interfaces are available in the base distribution of PostgreSQL?

Question: What is the default ordering when ORDER BY is not specified?

Question: What command will correctly restore a backup made with the following command? pg_dump -Fc dbname > filename

Question: How do you select a single random row from a table?

Question: Which of the following constitute the correct guidelines for naming database tables?

Question: Which of the following are DML statements?

Question: An outer join is used when:

Question: Which of the following components are required to run iSQL*plus on PC?

Question: Which of the following constitute the attributes of /SQL*Plus?

Question: Which component is a literal in the following select statement? Select 'Emp name :'||ename from emp where deptno=20;