A.It can be accessed only by the SYS user

B.It consists of a single row and single column of VARCHAR2 data type

C.It can display multiple rows but only a single column

D.It can be used to display only constants or pseudo columns

E.It can be accessed by any user who has the SELECT privilege in any schema

F.It can display multiple rows and columns

A.It is available only when the database is open

B.It can be used to perform database recovery

C.The same port number can be used for Database Express configurations for databases on different hosts

D.It can be used to switch a database into ARCHIVELOGMODE

E.The same port number can be used for multiple Database Express configurations for multiple databases on the same host

A.SELECT TO_DATE(SYSDATE, `DD/MONTH/YYYY') ?`01/JANUARY/2019' FROM DUAL;

B.SELECT ROUND(SYSDATE ?'01-JAN-2019') FROM DUAL;

C.SELECT TO_CHAR(SYSDATE, `DD-MON-YYYY') ?'01-JAN-2019' FROM DUAL;

D.SELECT SYSDATE ?TO_DATE('01-JANUARY-2019') FROM DUAL;

E.SELECT ROUND(SYSDATE ?TO_DATE(`01/JANUARY/2019')) FROM DUAL;

A.Primary key and foreign key constraints can be defined at both the column and table level

B.It is possible for child rows that have a foreign key to remain in the child table at the time the parent row is deleted

C.The foreign key columns and parent table primary key columns must have the same names

D.A table can have only one primary key but multiple foreign keys

E.It is possible for child rows that have a foreign key to be deleted automatically from the child table at the time the parent row is deleted

F.A table can have only one primary key and foreign key

G.Only the primary key can be defined at the column and table level

A.The concatenation operator | | is always evaluated before addition and subtraction in an expression

B.NULLS influence the precedence of operators in an expression

C.The + binary operator has the highest precedence in an expression in a SQL statement

D.Arithmetic operators with equal precedence are evaluated from left to right within an expression

E.Multiple parentheses can be used to override the default precedence of operators in an expression