If you run the ALTER SESSION SET NLS_DATE_FORMAT + ‘DDMMYY” statement, which dictionary view would - B. The NLS_SESSION _PARAMETERS view shows information about the NLS parameter values that are in effect in the session.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question:
If you run the ALTER SESSION SET NLS_DATE_FORMAT + ‘DDMMYY” statement, which dictionary view would you query to see the value of the parameter?
a. V$SESSION_PARAMETERS
b. NLS_SESSION_PARAMETERS
c. NLS_DATABASE_PARAMETERS
d. V$SESSION

Answer:
B. The NLS_SESSION _PARAMETERS view shows information about the NLS parameter values that are in effect in the session.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 9538 users
Added on	7/7/2010
Views	68276
Rate it!

Question:
If you run the ALTER SESSION SET NLS_DATE_FORMAT + ‘DDMMYY” statement, which dictionary view would you query to see the value of the parameter?
a. V$SESSION_PARAMETERS
b. NLS_SESSION_PARAMETERS
c. NLS_DATABASE_PARAMETERS
d. V$SESSION

Answer:

B. The NLS_SESSION _PARAMETERS view shows information about the NLS parameter values that are in effect in the session.
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Choose two reasons why you would use a direct –path load instead of a conventional-path load. a. To restrict users from performing b. To perform parallel loads c. To disable the generation of redo log entries if the database is in ARCHIVELOG mode. d. The table has many indexes, and the temporary tabelspace is small.	View Answer
	Which two parameters must you specify when importing the metadata information into the target database while transporting tablespaces? a. DATAFILES b. TABLESPACES c. TRANSPORT_TABLESPACE d. TTS_OWNERS	View Answer
	Choose two NLS parameters that cannot be modified using the ALTER SESSION statement. a. NLS_CHARACTERSET b. NLS_SORT c. NLS_NCHAR_CHARACTERSET d. NLS_TERRITORY	View Answer
	20. Which command is used to define CONNECT and RESOURCE as the default roles for user JAMES? a. ALTER USER b. ALTER ROLE c. SET ROLE d. SET PRIVILEGE	View Answer
	19. What is accomplished when you issue the following statement? ALTER USER JOHN DEFAULT ROLE ALL; a. John is assigned all the roles created in the database b. Future roles granted to John will not be default roles c. All of John’s roles are enabled, except the roles with passwords d. All of John’s roles are enabled when connecting to the database	View Answer
	18. How do you enable a role? a. ALTER ROLE b. ALTER USER c. SET ROLE d. ALTER SESSION	View Answer
	Which role in the following list is not a predefined role from Oracle? a. SYSDBA b. CONNECT c. IMP_FULL_DATABASE d. RESOURCE	View Answer
	16. To grant the SELECT privilege on the table CUSTOMER to all users in the database, which statement would you use? a. GRANT SELECT ON CUSTOMER TO ALL USERS; b. GRANT ALL ON CUSTOMER TO ALL; c. GRANT SELECT ON CUSTOMER TO ALL; d. GRANT SELECT ON CUSTOMER TO PUBLIC;	View Answer
	Which data dictionary view can be queried to see whether a user has the EXECUTE privilege on a procedure? a. DBA_SYS_PRIVS b. DBA_TAB_PRIVS c. DBA_PROC_PRIVS d. SESSION_PRIVS	View Answer
	Which is not a system privilege? a. SELECT b. UPDATE ANY c. EXECUTE ANY d. CREATE TABLE	View Answer
	Which clause should be specified to enable the grantee to grant the system privilege to other users? a. WITH GRANT OPTION b. WITH ADMIN OPTION c. CASCADE d. WITH MANAGE OPTION	View Answer
	Which view would you query to see whether John has the CREATE TABLE privilege? a. DBA_SYS_PRIVS b. DBA_USER_PRIVS c. DBA_ROLE_PRIVS d. DBA_TAB_PRIVS	View Answer
	User JAMES has a table named JOBS created on the tablespace USERS. When you issue the following statement, what effect will it have on the JOBS table? ALTER USER JAMES QUOTA 0 ON USERS; a. No more rows can be added to the JOBS table b. No blocks can be allocated to the JOBS table c. No new extents can be allocated to the JOBS table d. The table JOBS cannot be accessed	View Answer
	Which clause in the CREATE USER command can be used to specify no limits on the space allowed in tablespace APP_DATA?	View Answer
	Which dictionary view shows the password expiration date for a user?	View Answer
	Which password parameter in the profile definitions can restrict the user from using the old password for 90 days?	View Answer
	Which resource specifies the value in minutes?	View Answer
	6. When a new user is created, and you do not specify a profile, a. Oracle prompts you for a profile name. b. No profile is assigned to the user. c. THE DEFAULT profile is assigned.	View Answer
	What is the maximum number of profiles that can be assigned to a user?	View Answer
	4. Choose the option that is not true. a. Oracle creates a profile named DEFAULT when the database is created. b. Profiles cannot be renamed. c. DEFULT is a valid name for a profile resource. d. The SESSIONS_PER_USER resource in the DEFAULT profile initially has a value of 5.	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode