Technology | Practice Questions | Aliensbrain

Multiple choice technology mainframe

Which is the formal relational term for the 'Number of Columns'?

Degree
Attribute
Cardinality
Domain

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

A trigger is a special type of stored procedure that is executed by the SQL Server when an Insert, Modify or Delete operation is performed Against a given table.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Stored procedures are the way to create routines and procedures that are run on the server.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

We can not execute a stored procedure on either local or remote SQL Server.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Stored procedures are compiled the first time they’re run but are not stored in a system table of the current database.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

'Select Into'Statement retrieves rows and columns from one source table to a target table.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

Which of the following options will allow you to drop the user david and all objects in the schema that are associated with that user?

DROP USER david all
DROP USER david schema
DROP USER david cascade
DROP USER david cascade schema

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

identify the meaning of the following SQL statement CREATE USER PETRIE IDENTIFIED EXTERNALLY DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMPS QUOTA 12M ON forms

The user is being validated by the enterprise directory service
The user has unlimited quota on the USERS tablespace.
The user’s quota will never exceed the size of the temporary tablespace.
All options are correct.

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

You are setting up two multiplexed online redo log file groups with three members in each group, how many disks are necessary at minimum?

3
0
1
no disk required

Reveal answer Fill a bubble to check yourself

Multiple choice technology programming languages

What can be said of the following SQL statement? CREATE GLOBAL TEMPORARY TABLE extra_area (startdate DATE, enddate DATE, class CHAR(15)) ON COMMIT DELETE ROWS

It is a session specific table.
It is an invalid SQL statement.
It is only available in Oracle 7
It is a transaction specific table.

Reveal answer Fill a bubble to check yourself

Tag: technology

Questions Related to technology